//Navigate Back
private void btn_back_Click(object sender, EventArgs e)
{
this.Hide();
LibrarianLogin Librarian = new LibrarianLogin();
Librarian.Show();
}
//create librarian account
private void btn_create_Click(object sender, EventArgs e)
{
if (tb_name.Text == "" || tb_username.Text == "" || tb_password.Text == "" || tb_ans.Text == "")
{
MessageBox.Show("All fields are mandatory");
}
else
{
SqlDataAdapter da = new SqlDataAdapter("select * from librarian where username='******'", con);
DataTable dt = new DataTable();
da.Fill(dt);
SqlDataAdapter da1 = new SqlDataAdapter("select * from admin_approval where username='******'", con);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt.Rows.Count != 0)
{
MessageBox.Show("Username already taken! Select another username!");
}
else if (dt1.Rows.Count != 0)
{
MessageBox.Show("Username already taken! Select another username!");
}
else
{
try
{
int id = Increment.signUpIncrement();
SqlCommand cmd = new SqlCommand("Insert into admin_approval values('" + id + "','" + tb_name.Text + "','" + tb_username.Text + "','" + tb_password.Text + "','" + cb_question.Text + "','" + tb_ans.Text + "')", con);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
MessageBox.Show("Account is being processed!! Account will be activated after approval!");
this.Hide();
LibrarianLogin login = new LibrarianLogin();
login.Show();
}
else
{
MessageBox.Show("Account Creation Failed!!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}