internal tblManager LoadManagerById(int managerId) { using (var conn = new HotelManagementEntities()) { return(conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerId)); } }
internal bool IsManagerOnTheFloor(string floorNumber) { using (var conn = new HotelManagementEntities()) { return(conn.tblManagers.Any(x => x.FloorNumber == floorNumber)); } }
internal bool IsUniqueUsername(string username) { using (var conn = new HotelManagementEntities()) { return(!conn.tblUserDatas.Any(x => x.Username == username)); } }
internal tblEmployee LoadEmployeeByUsername(string userName) { using (var conn = new HotelManagementEntities()) { var user = conn.tblUserDatas.FirstOrDefault(x => x.Username == userName); if (user != null) { return(conn.tblEmployees.FirstOrDefault(x => x.UserDataID == user.UserDataID)); } return(null); } }
internal bool TryAddNewManager(tblManager manager) { try { using (var conn = new HotelManagementEntities()) { conn.tblManagers.Add(manager); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
internal bool TryAddNewEmployee(tblEmployee employee) { try { using (var conn = new HotelManagementEntities()) { conn.tblEmployees.Add(employee); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
internal bool TryAddNewUserData(tblUserData userData) { try { using (var conn = new HotelManagementEntities()) { conn.tblUserDatas.Add(userData); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
internal List <vwEmployee> LoadEmployees(string floor) { try { using (var conn = new HotelManagementEntities()) { if (conn.tblEmployees.Any(x => x.FloorNumber == floor)) { return(conn.vwEmployees.Where(x => x.FloorNumber == floor).ToList()); } return(new List <vwEmployee>()); } } catch (Exception) { return(new List <vwEmployee>()); } }
internal List <string> LoadFloorNumbers() { try { using (var conn = new HotelManagementEntities()) { if (conn.tblManagers.Any()) { return(conn.tblManagers.Select(x => x.FloorNumber).ToList()); } return(new List <string>()); } } catch (Exception) { return(new List <string>()); } }
internal string LoadEmployeeSex(int employeeId) { try { using (var conn = new HotelManagementEntities()) { var user = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeId); if (user != null) { return(user.Sex); } return(null); } } catch (Exception) { return(null); } }
internal int GetUserDataId(string username) { try { using (var conn = new HotelManagementEntities()) { var user = conn.tblUserDatas.FirstOrDefault(x => x.Username == username); if (user != null) { return(user.UserDataID); } return(0); } } catch (Exception) { return(0); } }
internal bool TryUpdateEmloyeeSalary(int employeeId, string salary) { try { using (var conn = new HotelManagementEntities()) { var user = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeId); if (user != null) { user.Salary = salary; conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public bool IsCorrectUser(string userName, string password) { try { using (var conn = new HotelManagementEntities()) { var user = conn.tblUserDatas.FirstOrDefault(x => x.Username == userName); if (user != null) { var passwordFromDb = conn.tblUserDatas.First(x => x.Username == userName).Password; return(SecurePasswordHasher.Verify(password, passwordFromDb)); } return(false); } } catch (Exception) { return(false); } }
internal string GetTypeOfUser(int userDataId) { try { using (var conn = new HotelManagementEntities()) { if (conn.tblManagers.Any(x => x.UserDataID == userDataId)) { return(nameof(tblManager)); } if (conn.tblEmployees.Any(x => x.UserDataID == userDataId)) { return(nameof(tblEmployee)); } return(null); } } catch (Exception) { return(null); } }
internal bool TryRemoveUserData(int userId) { try { using (var conn = new HotelManagementEntities()) { var userToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == userId); if (userToRemove != null) { conn.tblUserDatas.Remove(userToRemove); conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }