public static void DeleteSector(tblSector sector) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblSector sectorToDelete = (from u in context.tblSectors where u.sectorId == sector.sectorId select u).First(); //check if some employee uses this sector. Get list of all employees with this sectorId List <tblEmployee> list = UsedSector(sector); //if list is not empty, update users with default sector if (list.Count > 0) { tblEmployee employeeToEdit; for (int i = 0; i < list.Count; i++) { employeeToEdit = list[i]; employeeToEdit.sectorId = 1; AddEmployee(employeeToEdit); } } context.tblSectors.Remove(sectorToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public static tblSector AddSector(tblSector sector) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (sector.sectorId == 0) { //add tblSector newSector = new tblSector(); newSector.name = sector.name; newSector.description = sector.description; context.tblSectors.Add(newSector); context.SaveChanges(); sector.sectorId = newSector.sectorId; } return(sector); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblPosition AddPosition(tblPosition position) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (position.positionId == 0) { //add tblPosition newPosition = new tblPosition(); newPosition.name = position.name; newPosition.description = position.description; context.tblPositions.Add(newPosition); context.SaveChanges(); position.positionId = newPosition.positionId; } return(position); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblEmployee GetEmployeeById(int id) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblEmployee result = (from x in context.tblEmployees where x.employeeId == id select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static string TypeOfAdmin(tblAdministrator a) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblAdminType result = (from x in context.tblAdminTypes where x.adminTypeId == a.adminTypeId select x).FirstOrDefault(); return(result.name); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
//null or return administrator public static tblAdministrator isAdministrator(tblUser e) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblAdministrator result = (from x in context.tblAdministrators where x.userId == e.userId select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static tblUser GetUser(string username, string password) { try { using (dbFirmEntities context = new dbFirmEntities()) { tblUser result = (from x in context.tblUsers where x.username == username && x.password == password select x).FirstOrDefault(); return(result); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static List <tblEmployee> UsedSector(tblSector sector) { try { using (dbFirmEntities context = new dbFirmEntities()) { List <tblEmployee> list = (from x in context.tblEmployees where x.sectorId == sector.sectorId select x).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(null); } }
public static bool UsedEmail(string mail) { try { using (dbFirmEntities context = new dbFirmEntities()) { bool b = (from x in context.tblManagers where x.email == mail select x).Any(); return(b); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(true); } }
public static bool UsedUsername(string username) { try { using (dbFirmEntities context = new dbFirmEntities()) { bool b = (from x in context.tblUsers where x.username == username select x).Any(); return(b); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(true); } }
public static List <tblGender> GetGenderList() { try { using (dbFirmEntities context = new dbFirmEntities()) { List <tblGender> list = new List <tblGender>(); list = (from x in context.tblGenders select x).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public static tblEmployee AddEmployee(tblEmployee employee) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (employee.employeeId == 0) { //add tblEmployee newEmployee = new tblEmployee(); newEmployee.qualificationsId = employee.qualificationsId; newEmployee.sectorId = employee.sectorId; if (employee.positionID != 0) { newEmployee.positionID = employee.positionID; } newEmployee.yearsOfService = employee.yearsOfService; newEmployee.managerId = employee.managerId; newEmployee.userID = employee.userID; context.tblEmployees.Add(newEmployee); context.SaveChanges(); employee.employeeId = newEmployee.employeeId; return(employee); } else { tblEmployee employeeToEdit = (from x in context.tblEmployees where x.employeeId == employee.employeeId select x).FirstOrDefault(); employeeToEdit.Salary = employee.Salary; employeeToEdit.positionID = employee.positionID; employeeToEdit.sectorId = employee.sectorId; employeeToEdit.managerId = employee.managerId; employeeToEdit.yearsOfService = employee.yearsOfService; employeeToEdit.qualificationsId = employee.qualificationsId; employeeToEdit.userID = employee.userID; context.SaveChanges(); return(employee); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblUser AddUser(tblUser user) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (user.userId == 0) { //add tblUser newUser = new tblUser(); newUser.username = user.username; newUser.password = user.password; newUser.jmbg = user.jmbg; newUser.genderId = user.genderId; newUser.residence = user.residence; newUser.marriageStatusId = user.marriageStatusId; newUser.firstname = user.firstname; newUser.lastname = user.lastname; context.tblUsers.Add(newUser); context.SaveChanges(); user.userId = newUser.userId; return(user); } else { tblUser userToEdit = (from x in context.tblUsers where x.userId == user.userId select x).FirstOrDefault(); userToEdit.username = user.username; userToEdit.lastname = user.lastname; userToEdit.firstname = user.username; userToEdit.residence = user.residence; userToEdit.password = user.password; userToEdit.marriageStatusId = user.marriageStatusId; userToEdit.genderId = user.genderId; userToEdit.jmbg = user.jmbg; context.SaveChanges(); return(user); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblManager AddManager(tblManager manager) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (manager.managerId == 0) { //add tblManager newManager = new tblManager(); newManager.officeNumber = manager.officeNumber; newManager.successfulProjects = manager.successfulProjects; newManager.email = manager.email; newManager.backupPassword = manager.backupPassword; newManager.userId = manager.userId; context.tblManagers.Add(newManager); context.SaveChanges(); manager.managerId = newManager.managerId; return(manager); } else { tblManager managerToEdit = (from x in context.tblManagers where x.managerId == manager.managerId select x).FirstOrDefault(); managerToEdit.officeNumber = manager.officeNumber; managerToEdit.levelOfResponsibility = manager.levelOfResponsibility; managerToEdit.salary = manager.salary; managerToEdit.successfulProjects = manager.successfulProjects; managerToEdit.backupPassword = manager.backupPassword; managerToEdit.email = manager.email; managerToEdit.userId = manager.userId; context.SaveChanges(); return(manager); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }
public static tblAdministrator AddAdministrator(tblAdministrator admin) { try { using (dbFirmEntities context = new dbFirmEntities()) { if (admin.administratorId == 0) { //add tblAdministrator newAdmin = new tblAdministrator(); newAdmin.adminTypeId = admin.adminTypeId; //exipry date +7days DateTime d = DateTime.Now; d = d.AddDays(7); newAdmin.expiryDate = d.Date; newAdmin.userId = admin.userId; context.tblAdministrators.Add(newAdmin); context.SaveChanges(); admin.administratorId = newAdmin.administratorId; return(admin); } else { tblAdministrator adminToEdit = (from x in context.tblAdministrators where x.administratorId == admin.administratorId select x).FirstOrDefault(); adminToEdit.expiryDate = admin.expiryDate; adminToEdit.adminTypeId = admin.adminTypeId; adminToEdit.userId = admin.userId; context.SaveChanges(); return(admin); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }