private void button2_Click(object sender, EventArgs e)
{
LibrarianHome h = new LibrarianHome();
h.Show();
this.Close();
}
//navigate back
private void btn_back_Click(object sender, EventArgs e)
{
this.Hide();
LibrarianHome home = new LibrarianHome();
home.Show();
}
//Login
private void btn_login_Click(object sender, EventArgs e)
{
if (tb_username.Text == "" || tb_password.Text == "")
{
MessageBox.Show("Username and Password cannot be empty!");
}
else
{
try
{
con = DatabaseConnection.connectDB();
con.Open();
//librarian data
SqlDataAdapter da = new SqlDataAdapter("select * from librarian where username ='******' and password ='******' ", con);
DataTable dt = new DataTable();
da.Fill(dt);
//approval data
SqlDataAdapter da1 = new SqlDataAdapter("select * from admin_approval where username ='******' and password ='******' ", con);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
//rejected data
SqlDataAdapter da2 = new SqlDataAdapter("select * from rejected_accounts where username ='******' and password ='******' ", con);
DataTable dt2 = new DataTable();
da2.Fill(dt2);
if (dt.Rows.Count != 0)
{
global.user = dt.Rows[0]["name"].ToString();
this.Hide();
LibrarianHome home = new LibrarianHome();
home.Show();
}
else if (dt1.Rows.Count != 0)
{
MessageBox.Show("Account is not yet approved by the admin!");
}
else if (dt2.Rows.Count != 0)
{
MessageBox.Show("Your Account approval request has been rejected!");
}
else
{
MessageBox.Show("Incorrect Username or Password!");
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//navigate back
private void btn_back_Click(object sender, EventArgs e)
{
if (global.user == "admin")
{
this.Hide();
AdminHome Adminhome = new AdminHome();
Adminhome.Show();
}
else
{
this.Hide();
LibrarianHome home = new LibrarianHome();
home.Show();
}
}