private void btn_back_Click(object sender, EventArgs e) { User_Home ah = new User_Home(true); ah.Show(); this.Visible = false; }
private void button1_Click(object sender, EventArgs e) { if ((txt_username.Text == "" || txt_username.Text == "Enter Your Username") && (txt_password.Text == "" || txt_password.Text == "Enter Your Password")) { MessageBox.Show("Please Enter Username and Password"); } else if (txt_username.Text == "" || txt_username.Text == "Enter Your Username") { MessageBox.Show("Please Enter Username"); } else if (txt_password.Text == "" || txt_password.Text == "Enter Your Password") { MessageBox.Show("Please Enter Password"); } else if (txt_username.Text != "Enter Your Username" && txt_password.Text != "Enter Your Password") { SqlCommand cmd; Boolean isAdmin = false; try { cmd = new SqlCommand("Select * from Login_Details where username = @username and password = @password and designation = 'admin' ", con); isAdmin = true; } catch (Exception err) { Console.WriteLine(err.Message); cmd = new SqlCommand("Select * from Login_Details where username = @username and password = @password ", con); isAdmin = false; } cmd.Parameters.AddWithValue("@username", txt_username.Text); cmd.Parameters.AddWithValue("@password", txt_password.Text); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); if (chkbx_isAdmin.Checked == true && isAdmin == false) { MessageBox.Show("You are not Admin !!!"); } else if (dr.HasRows) { //MessageBox.Show(isAdmin.ToString()); User_Home ah = new User_Home(isAdmin); this.Visible = false; ah.Show(); } else { MessageBox.Show("Invalid Username or Password !!!"); } con.Close(); } else { MessageBox.Show("Please Enter Username and Password"); } }