internal static void RunEmployeeQueries(Employee employee, string updated)
{
HumaneSocietyDataContext db = new HumaneSocietyDataContext();
Employee findEmployee;
switch (updated)
{
case "create":
db.Employees.InsertOnSubmit(employee);
break;
case "delete":
db.Employees.DeleteOnSubmit(db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber && e.LastName == employee.LastName).Single());
break;
case "read":
findEmployee = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).Single();
UserInterface.DisplayEmployee(findEmployee);
break;
case "update":
findEmployee = db.Employees.Where(e => e.EmployeeNumber == employee.EmployeeNumber).Single();
findEmployee = employee;
break;
default:
break;
}
db.SubmitChanges();
}
internal static void UpdateEmployee(int employeeNumber)
{
Employee target = db.Employees.Where(e => e.EmployeeNumber == employeeNumber).Single();
UserInterface.DisplayEmployee(target);
UserInterface.DisplayUserOptions("Which field would you like to change?");
UserInterface.UpdateEmployee_MenuSelection(target);
}
internal static void ReadEmployee(int?employeeId)
{
Employee employee = db.Employees.Where(e => e.EmployeeNumber == employeeId).Single();
UserInterface.DisplayEmployee(employee);
UserInterface.DisplayUserOptions("Press any key to continue.");
Console.ReadKey();
}
internal static void EmployeeDisplayInfo(int?employeeNumber)
{
UserInterface.DisplayEmployee(db.Employees.Where(e => e.EmployeeNumber == employeeNumber).FirstOrDefault());
}