/// <summary>
/// Удаление сотрудника из БД.
/// </summary>
/// <param name="id">ID удаляемого сотрудника.</param>
public void DeleteEmployee(int id)
{
WpfLessonDataEntities db = new WpfLessonDataEntities();
var emp = db.Employers.FirstOrDefault(e => e.Id_Employee == id);
db.Employers.Remove(emp);
db.SaveChanges();
}
/// <summary>
/// Удаление отделения из БД.
/// </summary>
/// <param name="id">ID удаляемого отделения.</param>
public void DeleteDepartment(int id)
{
WpfLessonDataEntities db = new WpfLessonDataEntities();
var dpt = db.Departments.FirstOrDefault(e => e.Id_Department == id);
db.Departments.Remove(dpt);
db.SaveChanges();
}
/// <summary>
/// Обновление данных отделения.
/// </summary>
/// <param name="department">отделение, данные которого требуется обновить.</param>
public void UpdateDepartment(Department department)
{
WpfLessonDataEntities db = new WpfLessonDataEntities();
var dpt = db.Departments.FirstOrDefault(e => e.Id_Department == department.ID);
dpt.DeptName = department.DeptName;
dpt.DeptInfo = department.DeptInfo;
db.SaveChanges();
}
/// <summary>
/// Добавление нового отделения в БД.
/// </summary>
/// <param name="department">Отделение, которое следует добавить в БД.</param>
public void InsertDepartment(Department department)
{
WpfLessonDataEntities db = new WpfLessonDataEntities();
var dpt = new Departments();
dpt.DeptName = department.DeptName;
dpt.DeptInfo = department.DeptInfo;
db.Departments.Add(dpt);
db.SaveChanges();
}
/// <summary>
/// Получение списка отделений.
/// </summary>
/// <returns>Список отделений.</returns>
public IList <Department> GetDepartments()
{
List <Department> departments = new List <Department>();
WpfLessonDataEntities db = new WpfLessonDataEntities();
foreach (Departments d in db.Departments)
{
departments.Add(new Department(d.Id_Department, d.DeptName, d.DeptInfo));
}
return(departments);
}
/// <summary>
/// Получение списка сотрудников.
/// </summary>
/// <returns>Список сотрудников.</returns>
public IList <Employee> GetEmployers()
{
List <Employee> employers = new List <Employee>();
WpfLessonDataEntities db = new WpfLessonDataEntities();
foreach (Employers e in db.Employers)
{
employers.Add(new Employee(e.Id_Employee, e.EmpSurname, e.EmpName, e.EmpSecondName, e.Birthday.Value, e.Departments.Id_Department, e.Salary.Value));
}
return(employers);
}
/// <summary>
/// Обновление данных сотрудника.
/// </summary>
/// <param name="employee">Сотрудник, данные которого требуется обновить.</param>
public void UpdateEmployee(Employee employee)
{
WpfLessonDataEntities db = new WpfLessonDataEntities();
var emp = db.Employers.FirstOrDefault(e => e.Id_Employee == employee.ID);
emp.EmpSurname = employee.Surname;
emp.EmpName = employee.Name;
emp.EmpSecondName = employee.SecondName;
if (employee.Birthday.HasValue)
{
emp.Birthday = employee.Birthday;
}
emp.Departments = db.Departments.FirstOrDefault(d => d.Id_Department == employee.Id_Department);
if (employee.Salary.HasValue)
{
emp.Salary = employee.Salary;
}
db.SaveChanges();
}