/// <summary> /// Get list of all locations from db /// </summary> /// <returns></returns> public static List <tblLocation> GetAllLocations() { try { using (EmployeeEntities context = new EmployeeEntities()) { List <tblLocation> list = new List <tblLocation>(); list = (from x in context.tblLocations select x).ToList(); //return sorted list of location by fullLocation return(list.OrderBy(o => o.fullLocation).ToList()); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Get all managers when editing some employee. Do not allow employee to be himself an manager. /// </summary> public static List <tblEmployee> GetAllManagers(int empId) { try { using (EmployeeEntities context = new EmployeeEntities()) { tblEmployee employeeToDelete = (from u in context.tblEmployees where u.employeeId == empId select u).First(); List <tblEmployee> list = new List <tblEmployee>(); list = (from x in context.tblEmployees select x).ToList(); list.Remove(employeeToDelete); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Check if given string exists as jmbg in tblEmployee /// </summary> /// <param name="jmbg">string</param> /// <returns>existence of jmbg in db</returns> public static bool IsEmployeeJmbg(string jmbg) { try { using (EmployeeEntities context = new EmployeeEntities()) { string result = (from x in context.tblEmployees where x.jmbg == jmbg select x.jmbg).FirstOrDefault(); if (result != null) { return(true); } else { return(false); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString()); return(false); } }
/// <summary> /// Edit or Add new employee /// </summary> /// <param name="employee">added or edited employee</param> /// <returns></returns> public static vwEmployee AddNewEmployee(vwEmployee employee) { try { using (EmployeeEntities context = new EmployeeEntities()) { //update if (employee.employeeId != 0) { tblEmployee employeeToEdit = (from c in context.tblEmployees where c.employeeId == employee.employeeId select c).First(); employeeToEdit.fullname = employee.fullname; employeeToEdit.dateOfBirth = employee.dateOfBirth; employeeToEdit.genderId = employee.getTblGender.genderId; employeeToEdit.IdentityCardNumber = employee.IdentityCardNumber; employeeToEdit.jmbg = employee.jmbg; employeeToEdit.phone = employee.phone; employeeToEdit.locationId = employee.getTblLocation.locationId; if (employee.getTblManager != null) { employeeToEdit.managerId = employee.getTblManager.employeeId; } else { employeeToEdit.managerId = null; } //check existance of sector name. Add new one if sectorName do not exist tblSector s = AddNewSector(employee.sectorName); employeeToEdit.sectorId = s.sectorId; context.SaveChanges(); return(employee); } //add new else { tblEmployee newEmployee = new tblEmployee(); newEmployee.fullname = employee.fullname; newEmployee.dateOfBirth = employee.dateOfBirth; newEmployee.genderId = employee.getTblGender.genderId; newEmployee.IdentityCardNumber = employee.IdentityCardNumber; newEmployee.jmbg = employee.jmbg; newEmployee.phone = employee.phone; newEmployee.locationId = employee.getTblLocation.locationId; if (employee.getTblManager != null) { newEmployee.managerId = employee.getTblManager.employeeId; } else { newEmployee.managerId = null; } //check existance of sector name. Add new one if sectorName do not exist tblSector s = AddNewSector(employee.sectorName); newEmployee.sectorId = s.sectorId; context.tblEmployees.Add(newEmployee); context.SaveChanges(); employee.employeeId = newEmployee.employeeId; return(employee); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }