private void button1_Click(object sender, EventArgs e)
{
{
if (txtbox_username.Text != "" && txtbox_password.Text != "")
{
SqlConnection con = new SqlConnection(constring);
con.Open();
string sql = "select * from User_detail where username =@user and password =@pass";
SqlCommand cmd = new SqlCommand(sql, con);
byte[] pass = System.Text.Encoding.UTF8.GetBytes(txtbox_password.Text.ToString());
cmd.Parameters.AddWithValue("@user", txtbox_username.Text);
cmd.Parameters.AddWithValue("@pass", Md5hash(pass));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
con.Close();
da.Fill(ds, "checkuser");
if (ds.Tables["checkuser"].Rows.Count == 1)
{
usrid(); /// to get userid
con.Open();
SqlDataReader dr1 = cmd.ExecuteReader();
if (dr1.Read())
{
string usrtyp = (dr1["usertype"].ToString());
if (usrtyp == "Admin")
{
MessageBox.Show("WELCOME TO ADMINISTRATOR PANEL");
this.Hide();
admin.Administrator_Dasboard adm = new admin.Administrator_Dasboard(id);
adm.Show();
}
else
{
MessageBox.Show("WELCOME TO EMPLOYEE PANEL");
this.Hide();
emp.Employee_dash employeedash = new emp.Employee_dash(id);
employeedash.Show();
}
}
con.Close();
}
else
{
MessageBox.Show("User Not Found");
}
}
else
{
MessageBox.Show("You must fill credential to login!");
}
}
}
private void Start_Load(object sender, EventArgs e)
{
admin.Administrator_Dasboard bla = new admin.Administrator_Dasboard();
bla.Show();
}
