public IEnumerable <DepartmentWrapper> GetDepartments()
{
List <DepartmentWrapper> departments = new List <DepartmentWrapper>();
using (Context = new DepartmentsDataContext())
{
Context.Departments.ToList().ForEach(d => departments.Add(new DepartmentWrapper(d)));
}
return(departments);
}
public void UpdateDepartment(int id, string name, string groupName)
{
using (Context = new DepartmentsDataContext())
{
Department department = Context.Departments.Single(x => x.DepartmentID == id);
department.Name = name;
department.GroupName = groupName;
department.ModifiedDate = DateTime.Now;
Context.SubmitChanges();
}
}
public void RemoveDepartment(int id)
{
using (Context = new DepartmentsDataContext())
{
Department department = Context.Departments
.Where(d => d.DepartmentID == id)
.FirstOrDefault();
Context.Departments.DeleteOnSubmit(department);
Context.SubmitChanges();
}
}
public void AddDepartment(string name, string groupName)
{
Department department = new Department();
department.Name = name;
department.GroupName = groupName;
department.ModifiedDate = DateTime.Now;
using (Context = new DepartmentsDataContext())
{
Context.Departments.InsertOnSubmit(department);
Context.SubmitChanges();
}
}
