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));
}
