public Department GetDept(int deptId) { using (var _deptContext = new DataContext()) { return _deptContext.Department.Where(x => x.DeptID == deptId).SingleOrDefault(); } }
public void SaveDept(Department dept) { using (var _deptContext = new DataContext()) { _deptContext.Department.Add(dept); _deptContext.SaveChanges(); } }
public void EditDept(Department deptToEdit) { using (var _deptContext = new DataContext()) { var selectedDEpt = _deptContext.Department.Where(x => x.DeptID == deptToEdit.DeptID).SingleOrDefault(); selectedDEpt.DeptName = deptToEdit.DeptName; _deptContext.SaveChanges(); } }
public IEnumerable<Department> DeptRepo() { using (var _deptContext = new DataContext()) { var data = _deptContext.Department; var retVal = data.ToList(); return retVal; } }
public void DeleteDept(int deptId) { var deptToDelete = GetDept(deptId); if (null != deptToDelete) { using (var _deptContext = new DataContext()) { _deptContext.Department.Remove(deptToDelete); _deptContext.SaveChanges(); } } }
public EmployeeManager() { empContext = new DataContext(); }