public bool ExistClient(string clientName) { using (BaseContext ctx = new BaseContext()) { int notExistClient = 0; return ctx.Clients.Where(x => x.Name == clientName).Count() != notExistClient; } }
public void RenameClient(string oldNameClient, string newNameClient) { using (BaseContext ctx = new BaseContext()) { if (ExistClient(oldNameClient)) { ctx.Clients.Where(x => x.Name == oldNameClient).FirstOrDefault().Name = newNameClient; } ctx.SaveChanges(); } }
public void DeleteClient(string clientName) { using (BaseContext ctx = new BaseContext()) { if (ExistClient(clientName)) { ctx.Clients.Remove(ctx.Clients.Where(x => x.Name == clientName).FirstOrDefault()); ctx.SaveChanges(); } } }
public void AddClient(string clientName) { if (!ExistClient(clientName)) { using (BaseContext ctx = new BaseContext()) { Client client = new Client() { Name = clientName }; ctx.Clients.Add(client); ctx.SaveChanges(); } } }
public IList<Order> ConvertWievToOrder(IList<OrderWievModel> listOrderWM) { using (BaseContext ctx = new BaseContext()) { ClientHelper clientHelper = new ClientHelper(); List<Order> result = listOrderWM.Select(x => new Order() { DateOrder = x.DateOrder, IdClient = clientHelper.GetIdClient(x.NameClient), Product = x.Product, Cost = x.CostProduct }).ToList(); return result; } }
public int GetIdClient(string nameClient) { using (BaseContext ctx = new BaseContext()) { if (ExistClient(nameClient)) { return ctx.Clients.Where(x => x.Name == nameClient).FirstOrDefault().Id; } else { AddClient(nameClient); return ctx.Clients.Where(x => x.Name == nameClient).FirstOrDefault().Id; } } }
public void AddOrder(OrderWievModel orderWM) { using (BaseContext ctx = new BaseContext()) { ClientHelper clientHelper = new ClientHelper(); Order order = new Order() { DateOrder = orderWM.DateOrder, IdClient = clientHelper.GetIdClient(orderWM.NameClient), Product = orderWM.Product, Cost = orderWM.CostProduct }; ctx.Orders.Add(order); ctx.SaveChanges(); } }
public Client GetClient(string nameClient) { using (BaseContext ctx = new BaseContext()) { if (ExistClient(nameClient)) { var temper = ctx.Clients.Where(x => x.Name == nameClient).FirstOrDefault(); return temper; } else { Client client = new Client() { Id = 00, Name = "Клиент не найден" }; return client; } } }
public void AddInputFile(InputFileWievModel inputWM, IList<OrderWievModel> ordersWM) { using (var ctx = new BaseContext()) { ManagerHelper managerHelper = new ManagerHelper(); OrderHelper orderHelper = new OrderHelper(); InputFile inputFile = new InputFile() { DateFile = inputWM.DateFile, IdManager = managerHelper.GetIdManager(inputWM.NameManager), Orders = orderHelper.ConvertWievToOrder(ordersWM) }; ctx.InputFiles.Add(inputFile); ctx.SaveChanges(); } }