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 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 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();
            }
        }