/**
* Checks Login creditials to determine if you can login
*/
private void loginButton_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(passwordEntryTextBox.Text) && !string.IsNullOrEmpty(emailEntryTextBox.Text))
{
tooltip();
}
else
{
Engine.Login.logincomplete(emailEntryTextBox.Text, passwordEntryTextBox.Text);
if (Engine.Login.success == true)
{
MessageBox.Show("Login Successful");
this.Hide();
if (Engine.ActiveUser.usertype == "occupant" || Engine.ActiveUser.usertype == "office worker")
{
WorkOrderForm invoice = new WorkOrderForm();
invoice.Show();
}
else if (Engine.ActiveUser.usertype == "administrator")
{
AdminForm admin = new AdminForm();
admin.Show();
}
else if (Engine.ActiveUser.usertype == "contractor")
{
ContractorWorkOrderForm contractor = new ContractorWorkOrderForm();
contractor.Show();
}
}
else
{
MessageBox.Show(Engine.Login.message);
}
}
}
private void showContractorWorkOrderFormButton_Click(object sender, EventArgs e)
{
cwof.Show();
this.Close();
}
/**
* Checks Login creditials to determine if you can login
*/
private void loginButton_Click(object sender, EventArgs e)
{
string confirmed; // will be used to store the result when we check whether the user's account has been confirmed by the admin or not
string usertype; // will be used to hold the user's account type
/**
* If the email field is empty then a tooltip informs you that you need to enter an email address.
*/
if (string.IsNullOrEmpty(emailEntryTextBox.Text))
{
ToolTip tip = new ToolTip();
tip.Show("Please Enter An Email Address", emailEntryTextBox, 10000);
}
/**
* If the password field is empty then a tooltip informs you that you need to enter a password.
*/
if (string.IsNullOrEmpty(passwordEntryTextBox.Text))
{
ToolTip tip2 = new ToolTip();
tip2.Show("Please Enter A Passwords", passwordEntryTextBox, 10000);
}
/**
* If both fields are filled then a connection to the invoicelogin will be established.
*/
else if (!string.IsNullOrEmpty(passwordEntryTextBox.Text) && !string.IsNullOrEmpty(emailEntryTextBox.Text))
{
OleDbConnection connection = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = ProjectDB.accdb; Persist Security Info = True");
connection.Open();
/**
* MySQLCommand that will be used to query the database using the entered email and password
*/
OleDbCommand command = new OleDbCommand("Select Email, Password, UserType, Confirmed from UserAccounts where Email='" + emailEntryTextBox.Text.ToLower() + "'and Password='******'", connection);
/**
* Fill the DataTable with results from the query.
* If the table has at least one row then that means the login information entered was that of a registered user and login was successful.
* In the future logging successfully will result in you being taken to another form. For now you are only informed of your successful login.
* If the table has no rows, then either your email-password combination could not be found in our records and the login was unsuccessful.
* */
OleDbDataAdapter data = new OleDbDataAdapter(command);
DataTable table = new DataTable();
data.Fill(table);
if (table.Rows.Count > 0)
{
usertype = table.Rows[0]["usertype"].ToString(); // Store the usertype item from your dataTable into the usertype variable
confirmed = table.Rows[0]["confirmed"].ToString(); // store the confirmed item from your dataTable
/**
* Checks to see if the administrator has confirmed the account and if not then inform the user that it has yet to be confirmed/activated
*/
if (confirmed == "False")
{
MessageBox.Show("Your account has not been confirmed by the adminstrator yet");
}
/**
* If the adminstrator has confirmed the user's account then next the usertype is checked to determine which form the user should see.
* For now the occupant, contractor and office worker all see the same form but eventually all three will have different level's of access.
*/
else if (confirmed == "True")
{
if (usertype == "Occupant" || usertype == "Office Worker")
{
MessageBox.Show("Login Successful!");
WorkOrderForm invoice = new WorkOrderForm();
invoice.Show();
}
else if (usertype == "Administrator")
{
MessageBox.Show("Login Successful!");
AdminForm invoice = new AdminForm();
invoice.Show();
}
else if (usertype == "Contractor")
{
MessageBox.Show("Login Successful!");
ContractorWorkOrderForm workOrder = new ContractorWorkOrderForm();
workOrder.Show();
}
}
}
else
{
MessageBox.Show("Invalid username or password");
}
}
}