internal bool IsExistingEmployee(int employeeID) { using (var context = new EmployeeRecordsEntities()) { return(context.tblEmployees.Any(e => e.EmployeeID == employeeID)); } }
internal void AddNewEmployee(tblEmployee employee) { using (var context = new EmployeeRecordsEntities()) { context.tblEmployees.Add(employee); context.SaveChanges(); } }
public void AddNewLocation(tblLocation location) { using (var context = new EmployeeRecordsEntities()) { context.tblLocations.Add(location); context.SaveChanges(); } }
internal void AddNewSector(tblSector newSector) { using (var context = new EmployeeRecordsEntities()) { context.tblSectors.Add(newSector); context.SaveChanges(); } }
internal tblEmployee LoadEmployee(int employeeID) { using (var context = new EmployeeRecordsEntities()) { if (context.tblEmployees.Any(e => e.EmployeeID == employeeID)) { return(context.tblEmployees.First(e => e.EmployeeID == employeeID)); } return(new tblEmployee()); } }
internal void DeleteEmployee(int employeeID) { using (var context = new EmployeeRecordsEntities()) { var employeeToRemove = context.tblEmployees.FirstOrDefault(e => e.EmployeeID == employeeID); if (employeeToRemove != null) { context.tblEmployees.Remove(employeeToRemove); context.SaveChanges(); } } }
internal List <string> LoadRegistrationNumbers() { using (var context = new EmployeeRecordsEntities()) { var registrationNumbers = new List <string>(); if (context.tblEmployees.Any()) { foreach (var item in context.tblEmployees) { registrationNumbers.Add(item.RegistrationNumber); } return(registrationNumbers); } return(registrationNumbers); } }
internal List <string> LoadPersonalNumbers() { using (var context = new EmployeeRecordsEntities()) { var personalNumbers = new List <string>(); if (context.tblEmployees.Any()) { foreach (var item in context.tblEmployees) { personalNumbers.Add(item.PersonalNo); } return(personalNumbers); } return(personalNumbers); } }
public List <tblLocation> LoadLocations() { using (var context = new EmployeeRecordsEntities()) { var locations = new List <tblLocation>(); if (context.tblLocations.Any()) { foreach (var item in context.tblLocations) { locations.Add(item); } return(locations.OrderBy(o => o.Adress).ToList()); } return(locations); } }
internal List <tblSector> LoadSectors() { using (var context = new EmployeeRecordsEntities()) { var sectors = new List <tblSector>(); if (context.tblSectors.Any()) { foreach (var item in context.tblSectors) { sectors.Add(item); } return(sectors); } return(sectors); } }
public List <vwEmployee> LoadEmployees() { using (var context = new EmployeeRecordsEntities()) { var employees = new List <vwEmployee>(); if (context.vwEmployees.Any()) { foreach (var item in context.vwEmployees) { employees.Add(item); } return(employees); } return(employees); } }
internal List <string> LoadManagers(int employeeID) { using (var context = new EmployeeRecordsEntities()) { var managers = new List <string>(); if (context.tblEmployees.Any()) { foreach (var item in context.tblEmployees) { if (item.EmployeeID != employeeID) { managers.Add(item.GivenName + " " + item.Surname); } } return(managers); } return(managers); } }
internal void UpdateEmployee(int employeeID, tblEmployee employee) { using (var context = new EmployeeRecordsEntities()) { if (context.tblEmployees.Any(e => e.EmployeeID == employeeID)) { var employeeToUpdate = context.tblEmployees.First(e => e.EmployeeID == employeeID); employeeToUpdate.GivenName = employee.GivenName; employeeToUpdate.Surname = employee.Surname; employeeToUpdate.Sex = employee.Sex; employeeToUpdate.PersonalNo = employee.PersonalNo; employeeToUpdate.RegistrationNumber = employee.RegistrationNumber; employeeToUpdate.Telephone = employee.Telephone; employeeToUpdate.LocationID = employee.LocationID; employeeToUpdate.Manager = employee.Manager; employeeToUpdate.SectorID = employee.SectorID; context.SaveChanges(); } } }