ISEbd-22_Antonova_D.V._VeterinaryClinic/VetClinic/VetClinicDatabaseImplement/Implement/ClientStorage.cs

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 ClientStorage: IClientStorage
    {
        public List<ClientViewModel> GetFullList()
        {
            using var context = new VetClinicDatabase();
            return context.Clients
            .Select(CreateModel)
            .ToList();
        }
        public List<ClientViewModel> GetFilteredList(ClientBindingModel model)
        {
            if (model == null)
            {
                return null;
            }
            using var context = new VetClinicDatabase();
            return context.Clients
            .Where(rec => rec.Name.Contains(model.Name))
            .Select(CreateModel)
            .ToList();
        }
        public ClientViewModel GetElement(ClientBindingModel model)
        {
            if (model == null)
            {
                return null;
            }
            using var context = new VetClinicDatabase();
            var client = context.Clients
            .FirstOrDefault(rec => rec.Phone == model.Phone);
            if (client == null)
            {
                return null;
            }
            return client.Password == model.Password ? CreateModel(client) : null;
        }
        public void Insert(ClientBindingModel model)
        {
            using var context = new VetClinicDatabase();
            Client element = context.Clients.FirstOrDefault(rec => rec.Phone ==
           model.Phone);
            if (element != null)
            {
                throw new Exception("Телефон уже зарегистрирован");
            }
            context.Clients.Add(CreateModel(model, new Client()));
            context.SaveChanges();
        }
        public void Update(ClientBindingModel model)
        {
            using var context = new VetClinicDatabase();
            var element = context.Clients.FirstOrDefault(rec => rec.Id == model.Id);
            if (element == null)
            {
                throw new Exception("Элемент не найден");
            }
            CreateModel(model, element);
            context.SaveChanges();
        }
        public void Delete(ClientBindingModel model)
        {
            using var context = new VetClinicDatabase();
            Client element = context.Clients.FirstOrDefault(rec => rec.Id ==
           model.Id);
            if (element != null)
            {
                context.Clients.Remove(element);
                context.SaveChanges();
            }
            else
            {
                throw new Exception("Элемент не найден");
            }
        }
        private static Client CreateModel(ClientBindingModel model, Client
       client)
        {
            client.Password = model.Password;
            client.Mail = model.Email;
            client.Name = model.Name;
            client.Pet = model.Pet;
            client.Phone = model.Phone;
            client.PetName = model.PetName;
            return client;
        }
        private static ClientViewModel CreateModel(Client client)
        {
            return new ClientViewModel
            {
                Id = client.Id,
                Name = client.Name,
                Email = client.Mail,
                Pet = client.Pet,
                PetName = client.PetName,
                Phone = client.Phone
            };
        }
    }
}