private void btn_ChangePassword_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.UserName = label1.Text; cDB.UserType = label2.Text; cDB.Password = txt_OldPassword.Text; if (cDB.Authenticate(cDB)) { if (txt_NewPassword.Text == txt_Confirmpassword.Text) { cDB.Password = txt_NewPassword.Text; cDB.changemypassword(cDB); MessageBox.Show("Password Changed Successfully"); } else { MessageBox.Show("Password doesnot match"); } } else { MessageBox.Show("old password is incorrect"); } }
private void btn_login_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.Name = txt_name.Text; cDB.UserName = txt_username.Text; cDB.Password = txt_password.Text; if (rbtn_owner.Checked) { cDB.UserType = "Owner"; } else if (rbtn_staff.Checked) { cDB.UserType = "Staff"; } if (cDB.Authenticate(cDB)) { Home hform = new Home(); hform.lbl_GetIDhere.Text = txt_username.Text; hform.lbl_GetUsertype.Text = cDB.UserType; txt_password.Text = ""; hform.Show(); MessageBox.Show("Login Successfully"); } else { MessageBox.Show("Login Failed"); } }
private void btn_submit_Click(object sender, EventArgs e) { Login lgn = new Login(); Credential_DB cDB = new Credential_DB(); cDB.Name = A; cDB.UserName = B; if (C == txt_confirmpassword.Text) { cDB.Password = C; } if (D == true) { cDB.UserType = "Owner"; } else if (E == true) { cDB.UserType = "Staff"; } if (C == txt_confirmpassword.Text) { cDB.createnewuser(cDB); MessageBox.Show("New User Created"); } else { MessageBox.Show("Re-Enter! Password Does Not Match"); } this.Dispose(); }
public void deleteuser(Credential_DB cDB) { string query = String.Format("delete from UserDetails where username = '******'", cDB.UserName); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void changemypassword(Credential_DB cDB) { string query = String.Format("UPDATE [UserDetails] SET [PASSWORD] = '{0}' WHERE [USERNAME] = '{1}' AND [USERTYPE] = '{2}' ", cDB.Password, cDB.UserName, cDB.UserType); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void createnewuser(Credential_DB cDB) { string query = String.Format("Insert into UserDetails Values('{0}','{1}','{2}', '{3}')", cDB.Name, cDB.UserName, cDB.Password, cDB.UserType); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
private void ViewUser_Load(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); dataGridView1.AutoGenerateColumns = true; cDB.FillGrid(dataGridView1); }
private void btn_Delete_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.UserName = cBox_SelectUser.Text; cDB.deleteuser(cDB); lbl_message.Text = "User Deleted"; }
public bool Authenticate(Credential_DB cDB) { string query = String.Format("select * from UserDetails where name = '{0}' and username = '******' and password ='******' and usertype ='{3}'", cDB.Name, cDB.UserName, cDB.Password, cDB.UserType); Business_Logic BL = new Business_Logic(); OleDbDataReader rec = BL.SelectQuery(query); if (rec.Read()) { return(true); } else { return(false); } }
private void button1_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.UserName = txt_UserName.Text; if (txt_Password.Text == txt_ConfirmPassword.Text) { cDB.Password = txt_Password.Text; } cDB.UserType = cBox_UserType.Text; if (txt_Password.Text == txt_ConfirmPassword.Text) { cDB.createnewuser(cDB); MessageBox.Show("New User Created"); } else { MessageBox.Show("Re-Enter! Password Does Not Match"); } }
private void DeleteUser_Load(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.fillcombobox(cBox_SelectUser); }