private void button1_Click(object sender, EventArgs e)
{
this.Hide(); //Hides Form 1/ Login screen
Administator f2 = new Administator(); //Create form2 object
f2.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
//Admin Login
connection.Open();
//Create command to validate database
OleDbCommand command = new OleDbCommand();
command.Connection = connection; //Give "command" the conncection
//Create a query
command.CommandText = "select * from LogIn where Username= '******' and Pass= '******' and Privilege = 'administrator'";
//Excecute query
command.ExecuteNonQuery(); //Do non-query when want to get data from database (Don't want a return)
OleDbDataReader reader = command.ExecuteReader(); //Read data from a dabase
int count = 0; //Variable to count values in command
while (reader.Read())
{
count++; //Finds number of found results for the query executed
}
if (count == 1)
{
//MessageBox.Show("Username and Password is correct for admin");
connection.Close(); //Close database
connection.Dispose(); //Releases memory*/
this.Hide(); //Hides Form 1/ Login screen
Administator f5 = new Administator(); //Create form2 object
f5.ShowDialog(); //Opens Form 2
}
else if (count > 1) //Finds duplicate entry
{
MessageBox.Show("Duplicate Username and Password ");
}
else
{
MessageBox.Show("Username and Password NOT correct");
}
connection.Close();
}
