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(); }