public int checkLogin(LoginSdi loginSdi) { StringBuilder sql = new StringBuilder(); sql.Append(" SELECT roleType,Eusername,Epassword FROM Employee"); sql.Append(" WHERE Eusername = @username AND Epassword = @password"); con.Open(); SqlCommand command = new SqlCommand(sql.ToString(), con); command.Parameters.AddWithValue("username", loginSdi.Username); command.Parameters.AddWithValue("password", loginSdi.Password); SqlDataReader reader = command.ExecuteReader(); String roleType = null; while (reader.Read()) { roleType = (String)reader["roleType"]; } reader.Close(); con.Close(); if (roleType == null) { StringBuilder sql1 = new StringBuilder(); sql1.Append(" SELECT Pusername,Ppassword FROM Patron"); sql1.Append(" WHERE Pusername = @username AND Ppassword = @password"); con.Open(); SqlCommand command1 = new SqlCommand(sql1.ToString(), con); command1.Parameters.AddWithValue("username", loginSdi.Username); command1.Parameters.AddWithValue("password", loginSdi.Password); SqlDataReader reader1 = command1.ExecuteReader(); if (reader1.Read()) { reader1.Close(); con.Close(); return(0); } else { reader1.Close(); con.Close(); return(-1); } } if ("Librian".Equals(roleType)) { return(2); } return(1); }
private void button1_Click(object sender, EventArgs e) { LoginSdi loginSdi = new LoginSdi(); loginSdi.Username = username.Text.Trim(); loginSdi.Password = password.Text.Trim(); int check = loginService.checkLogin(loginSdi); if (check == -1) { errorLogin.Text = "Password or username is incorrect"; return; } else if (check == 0) { this.Visible = false; mainForm = new MainForm(); Information.Username = username.Text.Trim(); Information.Type = "P"; mainForm.FormLogin = this; mainForm.Show(); } else if (check == 1) { this.Visible = false; Information.Username = username.Text.Trim(); Information.Type = "E"; mainForm = new MainForm(); mainForm.FormLogin = this; mainForm.Show(); } else { this.Visible = false; mainForm = new MainForm(); mainForm.FormLogin = this; Information.Username = username.Text.Trim(); Information.Type = "L"; mainForm.Show(); } }
public int checkLogin(LoginSdi loginSdi) { if (loginSdi.Username == null || "".Equals(loginSdi.Username)) { MessageBox.Show("Username is required", "Error", MessageBoxButtons.OK); } else if (loginSdi.Password == null || "".Equals(loginSdi.Password)) { MessageBox.Show("Password is required", "Error", MessageBoxButtons.OK); } else if (loginSdi.Username.Length > 20) { MessageBox.Show("Max Length of Username is 20", "Error", MessageBoxButtons.OK); } else if (loginSdi.Password.Length > 20) { MessageBox.Show("Max Length of Password is 20", "Error", MessageBoxButtons.OK); } return(loginRepoService.checkLogin(loginSdi)); }