private void Login_Load(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
// Gets the accesslevels from the database and binds them to department combobox.
var accesslist = ctx.Accesses.ToList();
cbDepartment.DisplayMember = "AccessName";
cbDepartment.ValueMember = "AccessID";
cbDepartment.DataSource = accesslist;
}
}
private void cbDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
// Fetches all employees for the selected department.
var selectedAccess = Convert.ToInt32(cbDepartment.SelectedValue);
var employeelist = ctx.Employees.Where(x => x.AccessID == selectedAccess).Select(x => new { Name = x.Firstname + " " + x.Lastname, Id = x.EmployeeID }).ToList();
if (employeelist != null)
{
cbUsers.DisplayMember = "Name";
cbUsers.ValueMember = "Id";
cbUsers.DataSource = employeelist;
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
using (var ctx = new WarehouseDataEntity())
{
// Gets the employee ID and references the databases. Lets you choose a password if no previous logins are found.
var employeeId = Convert.ToInt32(cbUsers.SelectedValue);
var employee = ctx.Employees.Single(x => x.EmployeeID == employeeId);
var loginQuery = ctx.Logins.Where(x => x.EmployeeID == employeeId).ToList();
if (loginQuery.Count == 0)
{
ChoosePassword f = new ChoosePassword(employee);
f.ShowDialog();
}
// Checks if the hashed passwords match, if so log the user in and create and save a new login.
else if (!string.IsNullOrEmpty(tbPassword.Text))
{
var hasher = new Hashing();
var storedpassword = employee.Password;
var storedsalt = employee.Salt;
bool passwordsmatch = hasher.VerifyHash(tbPassword.Text, storedsalt, storedpassword);
if (passwordsmatch)
{
var login = new Login()
{
EmployeeID = employeeId,
LastLoggedIn = DateTime.Now
};
ctx.Logins.Add(login);
ctx.SaveChanges();
var f = new UserMenu(employee);
f.ShowDialog();
Close();
}
else
{
MessageBox.Show("Passwords do not match.");
}
}
}
}