private void Main_Click(object sender, EventArgs e)
{
Main_Menu cMDI = new Main_Menu(true, false, true);
//Opens Clerical form
cMDI.Show();
this.Hide();
}
private void loginButton_Click(object sender, EventArgs e)
{
string username = usernameBox.Text;
string password = passwordBox.Text;
try
{
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandText = "SELECT PermissionType FROM Logins WHERE Username= '******' and Password= '******'";
OleDbDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
permission = (reader["PermissionType"].ToString());
}
switch (permission)
{
//Medical Assistant
case "7":
Main_Menu mMDI = new Main_Menu(false, true, false);
mMDI.Show();
usernameBox.Text = username = passwordBox.Text = password = permission = "";
break;
//Clerical login page 2 is Clerical groupID
case "2":
//Creates and opens the MDI and sets Clerical form to true
Main_Menu cMDI = new Main_Menu(true, false, true);
//Opens Clerical form
cMDI.Show();
//Clears username, password, and permission in Login menu for variables and text fields
usernameBox.Text = username = passwordBox.Text = password = permission = "";
break;
case "1":
Main_Menu aMDI = new Main_Menu(true, true, true);
aMDI.Show();
usernameBox.Text = username = passwordBox.Text = password = permission = "";
break;
/* If permissionType is not found for passed in credentials the user does not exist because
* permissionType is a required field for every user
*/
default:
MessageBox.Show("Invalid username or password.", "Invalid Login Credentials", MessageBoxButtons.OK, MessageBoxIcon.Information);
break;
}
conn.Close();
}
//Message that is displayed if user is unable to access DB.
catch (Exception)
{
MessageBox.Show("Unable to access DB. Please check your DB connectivity settings.", "Unable to connect to DB", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}