/** * 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"); } } }