/**
* Method to login based on valid credentials
*/
private void btnLogin_Click(object sender, EventArgs e)
{
Contract contract;
String email = txtBoxEmail.Text;
String password = txtBoxPassword.Text;
dataBase = new DatabaseHelper();
MySqlDataReader reader = dataBase.StaffLogin(email, password);
try
{
if (reader.Read())
{
// Variables
int ID = ( int )reader.GetValue(0);
String firstName = reader.GetString(1);
String lastName = reader.GetString(2);
DateTime birthDateWithTime = ( DateTime )reader.GetValue(3);
DateTime birthDate = birthDateWithTime.Date;
String address = reader.GetString(4);
String toDecryptPassword = reader.GetString(6);
double salary = reader.GetDouble(7);
int hoursavailable = ( int )reader.GetValue(9);
int role = ( int )reader.GetValue(11);
//Calculate age
int age = DateTime.Now.Year - birthDate.Year - 1;
if (birthDate.Month > DateTime.Now.Month)
{
age++;
}
else if (birthDate.Month == DateTime.Now.Month)
{
if (birthDate.Day >= DateTime.Now.Day)
{
age++;
}
}
//Department
String depName = reader.GetString(12);
int depID = ( int )reader.GetValue(13);
Department department = new Department(depName, depID);
// Get the contract
int dbContract = ( int )reader.GetValue(14);
if (dbContract == 1)
{
contract = Contract.FullTime;
}
else
{
contract = Contract.PartTime;
}
// Decrypt password and check if password is equal to the password user filled in
if (Cryptography.Decrypt(toDecryptPassword) == password)
{
if (role == 1) // Manager
{
Manager manager = new Manager(ID, firstName, lastName, birthDate, address, salary, hoursavailable, email, contract);
AdministrationSystem administrationSystem = new AdministrationSystem(department, manager);
administrationSystem.Show();
}
else if (role == 2) // Employee
{
Employee employee = new Employee(ID, firstName, lastName, birthDate, address, salary, hoursavailable, email, contract);
EmployeeSystem employeeSystem = new EmployeeSystem(department, employee);
employeeSystem.Show();
}
this.Hide();
}
else if ((Cryptography.Decrypt(toDecryptPassword) != password) || (password == null))
{
MessageBox.Show("Email or password is incorrect. Please try again.");
}
}
else
{
MessageBox.Show("Unable to connect to the database. Please contact your administrator.");
}
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message);
}
}