public Employee GetEmployee(string empName) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { return(_dbContext.Employees.Where(m => m.Name.Equals(empName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault()); } }
public bool IsEmployeeExist(string empName) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { return(_dbContext.Employees.Any(m => m.Name.Equals(empName, StringComparison.OrdinalIgnoreCase))); } }
public List <MaritalStatus> GetMaritalStatusList() { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { return(_dbContext.MaritalStatus1.ToList()); } }
public void AddEmployee(Employee emp) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { _dbContext.Employees.Add(emp); _dbContext.SaveChanges(); } }
public void AddLocation(Location location) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { _dbContext.Locations.Add(location); _dbContext.SaveChanges(); } }
public void Delete(int id) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { Employee emp = _dbContext.Employees.Find(id); _dbContext.Employees.Remove(emp); _dbContext.SaveChanges(); } }
public void Delete(int empId) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { Location location = _dbContext.Locations.Where(p => p.EmployeeId == empId).FirstOrDefault(); _dbContext.Locations.Remove(location); _dbContext.SaveChanges(); } }
public IEnumerable <EmployeeListViewModel> GetEmployeeList() { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { var res = (from emp in _dbContext.Employees select new EmployeeListViewModel { Age = emp.Age, Id = emp.Id, Name = emp.Name, Salary = emp.Salary, MaritalStatus = emp.MaritalStatu.Status, Street = emp.Locations.FirstOrDefault().Street, State = emp.Locations.FirstOrDefault().State, City = emp.Locations.FirstOrDefault().City } ); return(res.ToList()); } }
public IEnumerable <EmployeeListViewModel> GetEmployeeList(CustomFilter customFilter, out int totalCount) { using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities()) { var res = (from emp in _dbContext.Employees select new EmployeeListViewModel { Age = emp.Age, Id = emp.Id, Name = emp.Name, Salary = emp.Salary, MaritalStatus = emp.MaritalStatu.Status, Street = emp.Locations.FirstOrDefault().Street, State = emp.Locations.FirstOrDefault().State, City = emp.Locations.FirstOrDefault().City } ); if (!string.IsNullOrEmpty(customFilter.salarySearchValue)) { res = res.Where( p => p.Salary.ToString().Trim().Contains(customFilter.salarySearchValue)); } if (!string.IsNullOrEmpty(customFilter.ageSearchValue)) { res = res.Where(p => p.Age.ToString().Contains(customFilter.ageSearchValue)); } if (!string.IsNullOrEmpty(customFilter.streetSearchValue)) { res = res.Where(p => p.Street.Trim().ToLower().Contains(customFilter.streetSearchValue) || p.City.Trim().ToLower().Contains(customFilter.streetSearchValue) || p.State.Trim().ToLower().Contains(customFilter.streetSearchValue)); } totalCount = res.Count(); return(res.OrderBy(p => p.Id) .Skip(customFilter.skip).Take(customFilter.pageSize).ToList()); } }