using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient; 
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace AeroNet
{
	/// <summary>
	///   Описание страницы: Регистрационная форма сайт www.aerotechnics.ru
	///   Дата             : 26.10.2004
	/// </summary>
	public class RegForm : Subscribe
	{
		int action = 0;
		public int Action
		{
			get{return action;}
			set{action = value;}  
		}

		// Для новых пользователей
		protected System.Web.UI.WebControls.TextBox Name1;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvName1;
		protected System.Web.UI.WebControls.TextBox Name2;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvName2;
		protected System.Web.UI.WebControls.TextBox Name3;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvName3;
		protected System.Web.UI.WebControls.TextBox EMail;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvEmail;
		protected System.Web.UI.WebControls.RegularExpressionValidator revEmail;
		protected System.Web.UI.WebControls.TextBox PWD;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvPass;
		protected System.Web.UI.WebControls.CompareValidator cmvPass;
		protected System.Web.UI.WebControls.TextBox PWD2;
		protected System.Web.UI.WebControls.RequiredFieldValidator rfvPwd2;
		protected System.Web.UI.WebControls.Button btnSend;
		protected System.Web.UI.WebControls.Label lblError;

		/// <summary>
		/// Получение данных пользователя 
		/// </summary>
		/// <param name="uid">Идентификационный номер пользователя</param>
		public void GetUser(int uid)
		{
			string strSQL = "SELECT Name1,Name2,Name3,email FROM V_Users WHERE userID="+uid; 
			SqlConnection Conn = new SqlConnection(connString);
			SqlCommand Command = new SqlCommand(strSQL,Conn);
			Conn.Open();
			try
			{
				SqlDataReader Reader;
				Reader = Command.ExecuteReader();
				if (Reader.Read())
				{
					Name1.Text  = Reader.GetString(0);
					Name2.Text = Reader.GetString(1);
					Name3.Text = Reader.GetString(2);
					EMail.Text = Reader.GetString(3);
				} 
				Reader.Close();  
			}
			catch
			{
				Response.Redirect("error.aspx",true); 
			}
			finally
			{
				Conn.Close(); 
			}    
		}



		private void Page_Load(object sender, System.EventArgs e)
		{
			//Загрузить верхнее меню
			TopMenu();

			Exit = Request.QueryString["exit"];
			Action = (Session["UserID"] == null)?0:1;
			//0 - insert , 1 - update

			if (Page.IsPostBack) 
			{
				Page.Validate();
				if (Page.IsValid)
				{
					System.Collections.Specialized.NameValueCollection colForm = Request.Form; 
					SqlConnection myConn = new SqlConnection(connString); 
					SqlCommand myCommand  =new SqlCommand();
					myCommand.CommandText = "sp_RegUser1";
					myCommand.CommandType = CommandType.StoredProcedure;
					myCommand.Connection = myConn;  
					myCommand.Parameters.Add("@Name1",SqlDbType.VarChar,50).Value = Name1.Text;
					myCommand.Parameters.Add("@Name2",SqlDbType.VarChar,50).Value = Name2.Text;
					myCommand.Parameters.Add("@Name3",SqlDbType.VarChar,50).Value = Name3.Text;
					myCommand.Parameters.Add("@email",SqlDbType.VarChar,50).Value = EMail.Text;
					myCommand.Parameters.Add("@password",SqlDbType.VarChar,50).Value = PWD.Text;
					myCommand.Parameters.Add("@action",SqlDbType.TinyInt,1).Value = Action.ToString();   
					SqlParameter  uid = new SqlParameter("@userID",SqlDbType.Int,4);
					uid.Value = UserID;
					uid.Direction = ParameterDirection.InputOutput;   
					myCommand.Parameters.Add(uid);
					myConn.Open();
					try
					{
						myCommand.ExecuteNonQuery();
					}
					catch
					{
						Response.Redirect("error.aspx",true); 
					}
					finally
					{
						myConn.Close(); 
					}	 
					UserID = Convert.ToInt32(uid.Value);
					if (UserID != 0)
					{ 
						Response.Redirect(Exit+"?uid="+UserID,true);  
					}
					else
					{ 
						lblError.Text = "Пользователь с таким логином уже существует.";   
					}
				}
			}
			else
			{
				if (Action == 1) GetUser(UserID);   
			}
		
		
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	
	}
}