public List <Employee> ReadEmployee(int IDFrom, int IDTo, string fullname = null) { try { using (CRUDEFEntities dbContext = new CRUDEFEntities()) { IQueryable <Employee> query = dbContext.Employees.Where(x => x.ID >= IDFrom && x.ID <= IDTo); if (!String.IsNullOrWhiteSpace(fullname)) { query = query.Where(x => x.FullName == fullname); } return(query.OrderBy(x => x.ID).ToList()); } } catch (Exception) { throw; } }
public void CreateEmployee(int ID, string fullname) { try { using (CRUDEFEntities dbContext = new CRUDEFEntities()) { var emp = new Employee(); emp.ID = ID; emp.FullName = fullname; dbContext.Employees.Add(emp); dbContext.SaveChanges(); } } catch (Exception) { throw; } }
public bool UpdateEmployee(int ID, string newFullName) { using (var dbContext = new CRUDEFEntities()) { var query = dbContext.Employees.SingleOrDefault(x => x.ID == ID); if (query == null) { return(false); } if (!String.IsNullOrWhiteSpace(newFullName)) { query.FullName = newFullName; } dbContext.SaveChanges(); return(true); } }
public bool DeleteEmployee(int ID) { try { using (CRUDEFEntities dbContext = new CRUDEFEntities()) { var query = dbContext.Employees.SingleOrDefault(x => x.ID == ID); if (query == null) { return(false); } dbContext.Employees.Remove(query); dbContext.SaveChanges(); } } catch (Exception) { throw; } return(true); }