private void LogInButton_Click(object sender, EventArgs e)
{
UsernameLabelTxt = UsernameTxt.Text;
con.Open();
String query = "Select ArtistID, ArtistPassword FROM dbo.Artist WHERE ArtistID = '" + UsernameTxt.Text.Trim() + "' AND ArtistPassword = '******'";
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(query, con);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
String queryAdmin = "Select EmployeeID, EmployeePassword FROM dbo.Employee WHERE EmployeeID = '" + UsernameTxt.Text.Trim() + "' AND EmployeePassword = '******'";
SqlDataAdapter sqlDataAdapterAdmin = new SqlDataAdapter(queryAdmin, con);
DataTable dataTableAdmin = new DataTable();
sqlDataAdapterAdmin.Fill(dataTableAdmin);
if (dataTable.Rows.Count == 1)
{
this.Hide();
MainMenuForm TestMenu = new MainMenuForm();
TestMenu.Show();
}
else if (dataTableAdmin.Rows.Count == 1)
{
this.Hide();
AdminMenu NewMenu = new AdminMenu();
NewMenu.Show();
CreateReservationForm.adminCheck = true;
}
else
{
MessageBox.Show("Check your username and password.");
}
con.Close();
}
private void MainMenuButton_Click(object sender, EventArgs e)
{
this.Close();
if (CreateReservationForm.adminCheck == true)
{
AdminMenu adminMenu = new AdminMenu();
adminMenu.Show();
}
else
{
MainMenuForm MainMenu = new MainMenuForm();
MainMenu.Show();
}
}
private void MainMenu_Click(object sender, EventArgs e)
{
this.Close();
if (adminCheck == true)
{
AdminMenu adminMenu = new AdminMenu();
adminMenu.Show();
}
else
{
MainMenuForm MainMenu = new MainMenuForm();
MainMenu.Show();
}
}
