111 lines
3.6 KiB
C#
111 lines
3.6 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using VetClinicBusinessLogic.BindingModels;
|
|
using VetClinicBusinessLogic.Interfaces;
|
|
using VetClinicBusinessLogic.ViewModels;
|
|
using VetClinicDatabaseImplement.Models;
|
|
|
|
|
|
namespace VetClinicDatabaseImplement.Implement
|
|
{
|
|
public class EmployeeStorage : IEmployeeStorage
|
|
{
|
|
public List<EmployeeViewModel> GetFullList()
|
|
{
|
|
using var context = new VetClinicDatabase();
|
|
return context.Employees
|
|
.Select(CreateModel)
|
|
.ToList();
|
|
}
|
|
public List<EmployeeViewModel> GetFilteredList(EmployeeBindingModel model)
|
|
{
|
|
if (model == null)
|
|
{
|
|
return null;
|
|
}
|
|
using var context = new VetClinicDatabase();
|
|
return context.Employees
|
|
.Where(rec => rec.Name.Contains(model.Name))
|
|
.Select(CreateModel)
|
|
.ToList();
|
|
}
|
|
public EmployeeViewModel GetElement(EmployeeBindingModel model)
|
|
{
|
|
if (model == null)
|
|
{
|
|
return null;
|
|
}
|
|
using var context = new VetClinicDatabase();
|
|
var employee = context.Employees
|
|
.FirstOrDefault(rec => rec.Phone == model.Phone);
|
|
if (employee == null)
|
|
{
|
|
return null;
|
|
}
|
|
return employee.Password == model.Password ? CreateModel(employee) : null;
|
|
}
|
|
public void Insert(EmployeeBindingModel model)
|
|
{
|
|
using var context = new VetClinicDatabase();
|
|
Employee element = context.Employees.FirstOrDefault(rec => rec.Phone ==
|
|
model.Phone);
|
|
if (element != null)
|
|
{
|
|
throw new Exception("Телефон уже зарегистрирован");
|
|
}
|
|
context.Employees.Add(CreateModel(model, new Employee()));
|
|
context.SaveChanges();
|
|
}
|
|
public void Update(EmployeeBindingModel model)
|
|
{
|
|
using var context = new VetClinicDatabase();
|
|
var element = context.Employees.FirstOrDefault(rec => rec.Id == model.Id);
|
|
if (element == null)
|
|
{
|
|
throw new Exception("Элемент не найден");
|
|
}
|
|
CreateModel(model, element);
|
|
context.SaveChanges();
|
|
}
|
|
public void Delete(EmployeeBindingModel model)
|
|
{
|
|
using var context = new VetClinicDatabase();
|
|
Employee element = context.Employees.FirstOrDefault(rec => rec.Id ==
|
|
model.Id);
|
|
if (element != null)
|
|
{
|
|
context.Employees.Remove(element);
|
|
context.SaveChanges();
|
|
}
|
|
else
|
|
{
|
|
throw new Exception("Элемент не найден");
|
|
}
|
|
}
|
|
private static Employee CreateModel(EmployeeBindingModel model, Employee
|
|
employee)
|
|
{
|
|
employee.Password = model.Password;
|
|
employee.Name = model.Name;
|
|
employee.Mail = model.Email;
|
|
employee.Specialization = model.Specialization;
|
|
employee.Phone = model.Phone;
|
|
return employee;
|
|
}
|
|
private static EmployeeViewModel CreateModel(Employee employee)
|
|
{
|
|
return new EmployeeViewModel
|
|
{
|
|
Id = employee.Id,
|
|
Email = employee.Mail,
|
|
Name = employee.Name,
|
|
Specialization = employee.Specialization,
|
|
Phone = employee.Phone
|
|
};
|
|
}
|
|
}
|
|
}
|