using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Anu.PCMS.DLL.DataBaseManager;


namespace PCMS.Pages
{
	/// <summary>
	/// Summary description for Display.
	/// </summary>
	public class Add : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.TextBox txtHome;
		protected System.Web.UI.WebControls.TextBox txtAddress;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.TextBox txtMobile;
		protected System.Web.UI.WebControls.TextBox txtOffice;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.TextBox txtEmail;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.HyperLink Hyperlink6;
		protected System.Web.UI.WebControls.HyperLink Hyperlink5;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.HyperLink Hyperlink4;
		protected BasicFrame.WebControls.BasicDatePicker datePicker1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator4;
		protected System.Data.SqlClient.SqlConnection addSQL;
	
		
		#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.addSQL = new System.Data.SqlClient.SqlConnection();
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			// 
			// addSQL
			// 
			this.addSQL.ConnectionString = "data source=AV;initial catalog=PCM;integrated security=SSPI;persist security info" +
				"=False;workstation id=AV;packet size=4096";
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button2_Click(object sender, System.EventArgs e)
		{
			
			Response.Redirect("../main.aspx");
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			try
			{
				
				DataBaseManager pcmsDB=new DataBaseManager(addSQL.ConnectionString);
				pcmsDB.ID=RowCounter()+1;
				pcmsDB.Name=txtName.Text.Trim();
				pcmsDB.Address=txtAddress.Text.Trim();
				if(txtHome.Text.Length>0)
					pcmsDB.HomePhone=Int32.Parse(txtHome.Text.Trim());
				else
					pcmsDB.HomePhone=0;
				if(txtOffice.Text.Length>0)
					pcmsDB.OfficePhone=Int32.Parse(txtOffice.Text.Trim());
				else
					pcmsDB.OfficePhone=0;
				if(txtMobile.Text.Length>0)
					pcmsDB.Mobile=Int32.Parse(txtMobile.Text.Trim());
				else
					pcmsDB.Mobile=0;
				if(datePicker1.IsNull)
					pcmsDB.DOB="";
				else
					pcmsDB.DOB=datePicker1.SelectedDate.ToString();

				pcmsDB.Email=txtEmail.Text;
				pcmsDB.InsertNew();
				ReloadAll();
			}
			catch (Exception ex)
			{
				Response.Redirect("Error.aspx?Error="+ex);
			}

		
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			
			if(!IsPostBack)
			{
//				Label8.Visible=false;
			}
		}
		public void ReloadAll()
		{
			txtName.Text="";
			txtAddress.Text="";
			txtOffice.Text="";
			txtMobile.Text="";
			txtHome.Text="";
			txtEmail.Text="";
//			Label8.Visible=true;					
		}

		public int RowCounter()
		{
			int ret;
			SqlCommand cmd=new SqlCommand("PCMSCounter",addSQL);
			cmd.CommandType=CommandType.StoredProcedure;
			SqlParameter param=cmd.Parameters.Add("ReturnValue",SqlDbType.Int);
			param.Direction=ParameterDirection.ReturnValue;
			addSQL.Open();
			cmd.ExecuteNonQuery();
			ret=Int32.Parse(cmd.Parameters["ReturnValue"].Value.ToString());
			addSQL.Close();
			return ret;

		}

		
	}
}