public bool TryUpdateManager(int managerID, tblManager manager) { try { using (var conn = new CompanyManagementEntities()) { var managerToUpdate = conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerID); if (managerToUpdate != null) { managerToUpdate.LevelOfResponsibility = manager.LevelOfResponsibility; managerToUpdate.OfficeNumber = manager.OfficeNumber; managerToUpdate.PasswordHint = manager.PasswordHint; managerToUpdate.ProjectsCount = manager.ProjectsCount; managerToUpdate.Salary = manager.Salary; conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public bool TryDeleteSector(int sectorID) { try { using (var conn = new CompanyManagementEntities()) { var sectorToRemove = conn.tblSectors.FirstOrDefault(x => x.SectorID == sectorID); if (sectorToRemove != null) { if (conn.tblEmployees.Any(x => x.SectorID == sectorID)) { ChangeEmployeesSectorToDefault(sectorID); conn.tblSectors.Remove(sectorToRemove); conn.SaveChanges(); return(true); } else { conn.tblSectors.Remove(sectorToRemove); conn.SaveChanges(); return(true); } } return(false); } } catch (Exception) { return(false); } }
public bool TryUpdateUserData(int userDataID, tblUserData userData) { try { using (var conn = new CompanyManagementEntities()) { var userDataToUpdate = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == userDataID); if (userDataToUpdate != null) { userDataToUpdate.Username = userData.Username; userDataToUpdate.GivenName = userData.GivenName; userDataToUpdate.MaritalStatus = userData.MaritalStatus; userDataToUpdate.PersonalNo = userData.PersonalNo; userDataToUpdate.PlaceOfResidence = userData.PlaceOfResidence; userDataToUpdate.Sex = userData.Sex; userDataToUpdate.Surname = userData.Surname; conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public bool TryUpdateEmployee(int employeeID, tblEmployee employee) { try { using (var conn = new CompanyManagementEntities()) { var employeeToUpdate = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeID); if (employeeToUpdate != null) { employeeToUpdate.Position = employee.Position; employeeToUpdate.ProfessionalQualificationsLevel = employee.ProfessionalQualificationsLevel; employeeToUpdate.Salary = employee.Salary; employeeToUpdate.SectorID = employee.SectorID; employeeToUpdate.YearsOfService = employee.YearsOfService; conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public string GetUserType(int userDataId) { try { using (var conn = new CompanyManagementEntities()) { if (conn.tblManagers.Any(x => x.UserDataID == userDataId)) { return(nameof(tblManager)); } if (conn.tblEmployees.Any(x => x.UserDataID == userDataId)) { return(nameof(tblEmployee)); } if (conn.tblAdministrators.Any(x => x.UserDataID == userDataId)) { return(nameof(tblAdministrator)); } return(null); } } catch (Exception) { return(null); } }
public tblAdministrator LoadAdministrator(int administratorID) { try { using (var conn = new CompanyManagementEntities()) { return(conn.tblAdministrators.FirstOrDefault(x => x.AdministratorID == administratorID)); } } catch (Exception) { return(null); } }
public tblManager LoadManager(int managerID) { try { using (var conn = new CompanyManagementEntities()) { return(conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerID)); } } catch (Exception) { return(null); } }
public string GetAdministratorType(int userDataId) { try { using (var conn = new CompanyManagementEntities()) { return(conn.tblAdministrators.First(x => x.UserDataID == userDataId).AdministratorTeam); } } catch (Exception) { return(null); } }
public bool IsUniqueSectorName(string name) { try { using (var conn = new CompanyManagementEntities()) { return(!conn.tblSectors.Any(x => x.SectorName == name)); } } catch (Exception) { return(false); } }
public bool IsUniquePersonalNo(string personalNo) { try { using (var conn = new CompanyManagementEntities()) { return(!conn.tblUserDatas.Any(x => x.PersonalNo == personalNo)); } } catch (Exception) { return(false); } }
public tblEmployee LoadEmployee(int employeeID) { try { using (var conn = new CompanyManagementEntities()) { return(conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeID)); } } catch (Exception) { return(null); } }
public bool IsUniqueUsername(string username) { try { using (var conn = new CompanyManagementEntities()) { return(!conn.tblUserDatas.Any(x => x.Username == username)); } } catch (Exception) { return(false); } }
public bool TryAddNewEmployee(tblEmployee employee) { try { using (var conn = new CompanyManagementEntities()) { conn.tblEmployees.Add(employee); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public bool TryAddNewAdministrator(tblAdministrator administrator) { try { using (var conn = new CompanyManagementEntities()) { conn.tblAdministrators.Add(administrator); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public bool TryAddNewManager(tblManager manager) { try { using (var conn = new CompanyManagementEntities()) { conn.tblManagers.Add(manager); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public bool TryAddNewUserData(tblUserData userData) { try { using (var conn = new CompanyManagementEntities()) { conn.tblUserDatas.Add(userData); conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public int GetUserDataId(string userName) { try { using (var conn = new CompanyManagementEntities()) { var user = conn.tblUserDatas.FirstOrDefault(x => x.Username == userName); if (user != null) { return(user.UserDataID); } return(0); } } catch (Exception) { return(0); } }
private bool ChangeEmployeesSectorToDefault(int sectorID) { try { using (var conn = new CompanyManagementEntities()) { var employees = conn.tblEmployees.Where(x => x.SectorID == sectorID).ToList(); int id = GetIdofDefaultSector(); foreach (var item in employees) { item.SectorID = id; } conn.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public bool IsCorrectUser(string userName, string password) { try { using (var conn = new CompanyManagementEntities()) { 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); } }
public List <vwEmployee> LoadEmployees() { try { using (var conn = new CompanyManagementEntities()) { var employees = new List <vwEmployee>(); if (conn.vwEmployees.Any()) { foreach (var item in conn.vwEmployees) { employees.Add(item); } } return(employees); } } catch (Exception) { return(null); } }
public bool TryDeleteEmployee(int employeeID) { try { using (var conn = new CompanyManagementEntities()) { var employeeToRemove = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeID); if (employeeToRemove != null) { var userDataToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == employeeToRemove.UserDataID); conn.tblEmployees.Remove(employeeToRemove); conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public bool TryDeleteAdministrator(int administratorID) { try { using (var conn = new CompanyManagementEntities()) { var adminToRemove = conn.tblAdministrators.FirstOrDefault(x => x.AdministratorID == administratorID); if (adminToRemove != null) { var userDataToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == adminToRemove.UserDataID); conn.tblAdministrators.Remove(adminToRemove); conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public List <vwAdministrator> LoadAdministrators() { try { using (var conn = new CompanyManagementEntities()) { var administrators = new List <vwAdministrator>(); if (conn.vwAdministrators.Any()) { foreach (var item in conn.vwAdministrators) { administrators.Add(item); } } return(administrators); } } catch (Exception) { return(null); } }
public bool IsLevelOfResponsibilityAssigned(int managerId) { try { using (var conn = new CompanyManagementEntities()) { var manager = conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerId); if (manager != null) { if (manager.LevelOfResponsibility == null) { return(false); } return(true); } return(false); } } catch (Exception) { return(false); } }
public bool TryUpdateAdministrator(int administratorID, tblAdministrator administrator) { try { using (var conn = new CompanyManagementEntities()) { var adminToUpdate = conn.tblAdministrators.FirstOrDefault(x => x.AdministratorID == administratorID); if (adminToUpdate != null) { adminToUpdate.AdministratorTeam = administrator.AdministratorTeam; adminToUpdate.ExpirationAccountDate = administrator.ExpirationAccountDate; conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
private int GetIdofDefaultSector() { try { using (var conn = new CompanyManagementEntities()) { var sector = conn.tblSectors.FirstOrDefault(x => x.SectorName == "Default"); if (sector != null) { return(sector.SectorID); } conn.tblSectors.Add(new tblSector() { SectorName = "Default" }); conn.SaveChanges(); return(1); } } catch (Exception) { return(0); } }
public bool TryDeleteManager(int managerID) { try { using (var conn = new CompanyManagementEntities()) { var managerToDelete = conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerID); if (managerToDelete != null) { var userDataToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == managerToDelete.UserDataID); conn.tblManagers.Remove(managerToDelete); conn.tblUserDatas.Remove(userDataToRemove); conn.SaveChanges(); return(true); } return(false); } } catch (Exception) { return(false); } }
public List <tblSector> LoadSectors() { try { using (var conn = new CompanyManagementEntities()) { var sectors = new List <tblSector>(); if (conn.tblSectors.Any()) { if (conn.tblSectors.Any(x => x.SectorName != "Default")) { foreach (var item in conn.tblSectors) { if (item.SectorName == "Default") { continue; } sectors.Add(item); } } } else { conn.tblSectors.Add(new tblSector() { SectorName = "Default" }); } return(sectors); } } catch (Exception) { return(null); } }