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