internal static Employee EmployeeLogin(string userName, string password)
{
Employee employeeFromDb = db.Employees.Where(e => e.UserName == userName && e.Password == password).FirstOrDefault();
return employeeFromDb;
}
internal static bool CheckEmployeeUserNameExist(string userName)
{
Employee employeeWithUserName = db.Employees.Where(e => e.UserName == userName).FirstOrDefault();
return employeeWithUserName == null;
}
//// TODO Items: ////
// TODO: Allow any of the CRUD operations to occur here
internal static void RunEmployeeQueries(Employee employee, string crudOperation)
{
switch (crudOperation)
{
case "create":
var checkEmployeeNumber = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).FirstOrDefault();
if (checkEmployeeNumber == null)
{
var checkEmployeeEmail = db.Employees.Where(e => e.Email == employee.Email).FirstOrDefault();
if (checkEmployeeEmail == null)
{
db.Employees.InsertOnSubmit(employee);
db.SubmitChanges();
}
else
{
UserInterface.DisplayUserOptions("Employee ID number already exists.");
}
}
else
{
UserInterface.DisplayUserOptions("Employee e-mail already exists.");
}
break;
case "delete":
employee = db.Employees.Where(e => e.UserName == employee.UserName && e.EmployeeId == employee.EmployeeId).SingleOrDefault();
db.Employees.DeleteOnSubmit(employee);
db.SubmitChanges();
break;
case "read":
employee = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).FirstOrDefault();
List <string> employeeRead = new List <string>()
{
"Employee name: " + employee.FirstName + "" + employee.LastName,
"Employee username: "******"Employee number: " + employee.EmployeeNumber,
"Employee e-mail" + employee.Email,
};
UserInterface.DisplayUserOptions(employeeRead);
break;
case "update":
employee = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).FirstOrDefault();
List <string> employeeUpdate = new List <string>()
{
"Employee name: " + employee.FirstName + "" + employee.LastName,
"Employee username: "******"Employee number: " + employee.EmployeeNumber,
"Employee e-mail" + employee.Email,
"Employee password: "******"first name", "the employee's");
employee.LastName = UserInterface.GetStringData("last name", "the employee's");
employee.EmployeeNumber = int.Parse(UserInterface.GetStringData("employee number", "the employee's"));
employee.Email = UserInterface.GetStringData("email", "the employee's");
break;
}
//throw new NotImplementedException();
}
internal static void AddUsernameAndPassword(Employee employee)
{
throw new NotImplementedException();
}
private static void SubmitDictionaryToDB(Dictionary <string, string> keyValues, Employee employeeToUpdate)
{
if (keyValues.ContainsKey("FirstName"))
{
employeeToUpdate.FirstName = keyValues["FirstName"];
}
if (keyValues.ContainsKey("LastName"))
{
employeeToUpdate.LastName = keyValues["LastName"];
}
if (keyValues.ContainsKey("EmployeeNumber"))
{
employeeToUpdate.EmployeeNumber = int.Parse(keyValues["EmployeeNumber"]);
}
if (keyValues.ContainsKey("Email"))
{
employeeToUpdate.Email = keyValues["Email"];
}
if (keyValues.ContainsKey("Username"))
{
employeeToUpdate.UserName = keyValues["Username"];
}
if (keyValues.ContainsKey("Password"))
{
employeeToUpdate.Password = keyValues["Password"];
}
db.SubmitChanges();
}
private static void ReadEmployee(Employee employee)
{
Employee foundEmployee = db.Employees.FirstOrDefault(a => a.EmployeeNumber == employee.EmployeeNumber);
UserInterface.DisplayEmployeeInfo(foundEmployee);
}
private static void CreateEmployee(Employee employee)
{
db.Employees.InsertOnSubmit(employee);
db.SubmitChanges();
}
