public void Insert(CustomerBaseBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
context.CustomerBase.Add(CreateModel(model, new CustomerBase()));
context.SaveChanges();
}
}
public void Insert(ServicesBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
context.Services.Add(CreateModel(model, new Services()));
context.SaveChanges();
}
}
public void Insert(EmployeeBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
context.Employee.Add(CreateModel(model, new Employee()));
context.SaveChanges();
}
}
public void Insert(PaymentBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
context.Payment.Add(CreateModel(model, new Payment()));
context.SaveChanges();
}
}
public void Update(ServicesBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
var element = context.Services.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
private Contract CreateModel(ContractBindingModel model, Contract contract, ComputerRepairDatabase context)
{
contract.CustomerBaseid = model.CustomerBaseId;
contract.Employeeid = model.EmployeeId;
contract.Paymentid = model.PaymentId;
contract.DateOfConclusion = model.DateOfConclusion;
if (contract.Id == 0)
{
context.Contract.Add(contract);
context.SaveChanges();
}
if (model.Id.HasValue)
{
List <ServicesContract> servicesContract = context.ServicesContract.Where(rec => rec.Contractid == model.Id.Value).ToList();
// удалили те, которых нет в модели
context.ServicesContract.RemoveRange(servicesContract.Where(rec => !model.ServicesContract.Contains(rec.Servicesid)).ToList());
context.SaveChanges();
// обновили количество у существующих записей
foreach (var updateServices in servicesContract)
{
model.ServicesContract.Remove(updateServices.Servicesid);
}
List <MaterialsContract> materialsContract = context.MaterialsContract.Where(rec => rec.Contractid == model.Id.Value).ToList();
// удалили те, которых нет в модели
context.MaterialsContract.RemoveRange(materialsContract.Where(rec => !model.MaterialsContract.Contains(rec.Materialsid)).ToList());
context.SaveChanges();
// обновили количество у существующих записей
foreach (var updateMaterials in materialsContract)
{
model.MaterialsContract.Remove(updateMaterials.Materialsid);
}
context.SaveChanges();
}
// добавили новые
foreach (var pc in model.ServicesContract)
{
context.ServicesContract.Add(new ServicesContract
{
Contractid = contract.Id,
Servicesid = pc
});
context.SaveChanges();
}
foreach (var pc in model.MaterialsContract)
{
context.MaterialsContract.Add(new MaterialsContract
{
Contractid = contract.Id,
Materialsid = pc
});
context.SaveChanges();
}
return(contract);
}
public void Delete(ContractBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
var contract = context.Contract.FirstOrDefault(rec => rec.Id == model.Id);
if (contract != null)
{
context.Contract.Remove(contract);
context.SaveChanges();
}
else
{
throw new Exception("Заказ не найден");
}
}
}
public void Delete(CustomerBaseBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
var element = context.CustomerBase.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.CustomerBase.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
}
}
