addstaff.aspx.cs

PURPOSE OF THE PROJECT: This Application would facilitate the huge process of managing the Ad detai

using System;
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 System.Configuration;

namespace MegaMartAudio
{
	/// <summary>
	/// Summary description for AddStaff.
	/// </summary>
	public class AddStaff : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtPwd1;
		protected System.Web.UI.WebControls.TextBox txtPwd2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label lblPwd;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.Button cmdReset;
		protected System.Web.UI.WebControls.Button BSubmit;
		protected System.Web.UI.WebControls.Label lblConfirm;
		protected System.Web.UI.WebControls.Label lblReset;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.DropDownList cboRole;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label lblReenter;
		protected System.Web.UI.WebControls.Label lblPassword;
		protected System.Web.UI.WebControls.Label lblName;
		protected System.Web.UI.WebControls.Label lblRole;
		protected System.Web.UI.WebControls.Label lblEnter;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
		
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(Session["sintID"] != null)
			{
				BSubmit.Visible=true;
				cmdReset.Visible=true;
				lblPwd.Visible=false;
				lblConfirm.Visible=false;
				lblReset.Visible=false;
			}

			else
			{
				Response.Redirect("Unauthorised.aspx");
			}
			
			
		}

		#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.BSubmit.Click += new System.EventHandler(this.btn_Click);
			this.cmdReset.Click += new System.EventHandler(this.cmdReset_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Advertisements.aspx");
		}

		private void cmdReset_Click(object sender, System.EventArgs e)
		{
			
			txtName.Text = "";
			txtPwd1.Text = "";
			txtPwd2.Text = "";
			lblPwd.Visible=false;
			lblReset.Visible=true;
			lblReset.Text="Fields have been reset";
            lblConfirm.Visible=false;
            
		}

		private void btn_Click(object sender, System.EventArgs e)
		{
			
			if(cboRole.SelectedIndex == 0)
			{
				lblPwd.Visible = true;
				lblPwd.Text = "Please select the role";
			}
			else
			{
			    
				if(txtPwd1.Text.Equals(txtPwd2.Text))
				{
					//string strCon=ConfigurationSettings.AppSettings["DB"];
					string conStr="Server=.;database=MegaMartAudio;uid=sa;pwd=sa";
					string strRole="";
					SqlConnection con = new SqlConnection(conStr);
					if(cboRole.SelectedIndex == 1)
					{
						SqlCommand cmd = new SqlCommand("insert into MMA_USERS_TB (USERS_NAME, USERS_PWD, USERS_ROLE) values(@uname,@upwd,'s')",con);
						
						cmd.Parameters.Add("@uname",SqlDbType.VarChar,30);
						cmd.Parameters.Add("@upwd",SqlDbType.VarChar,15);
						cmd.Parameters["@uname"].Value = txtName.Text;
						cmd.Parameters["@upwd"].Value = txtPwd1.Text;
						strRole="Staff";
						con.Open();
						cmd.ExecuteNonQuery();
						con.Close();
					}
					else if (cboRole.SelectedIndex == 2)
					{
						SqlCommand cmd = new SqlCommand("insert into MMA_USERS_TB (USERS_NAME, USERS_PWD, USERS_ROLE) values(@uname,@upwd,'m')",con);
						cmd.Parameters.Add("@uname",SqlDbType.VarChar,30);
						cmd.Parameters.Add("@upwd",SqlDbType.VarChar,15);
						cmd.Parameters["@uname"].Value = txtName.Text;
						cmd.Parameters["@upwd"].Value = txtPwd1.Text;
						strRole="Manager";
						con.Open();
						cmd.ExecuteNonQuery();
						con.Close();
				
					}

				    lblPwd.Visible=true;
					lblPwd.Text = strRole +" Added to the Database";
					
					txtName.Text = "";
					cboRole.SelectedIndex = 0;
				
				
				}
				else
				{
					lblPwd.Visible=true;
					lblPwd.Text = "Passwords mismatch";
					txtPwd1.Text = "";
					txtPwd2.Text = "";
				}
			}
			
            
		}

		private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
		{
			
			
		}

		private void Home_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Advertisements.aspx");
		}

		private void LogOut_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Login.aspx");
		}
	}
}