public void Insert(MaterialsBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
context.Materials.Add(CreateModel(model, new Materials()));
context.SaveChanges();
}
}
public List <MaterialsViewModel> Read(MaterialsBindingModel model)
{
if (model.Id.HasValue)
{
return(new List <MaterialsViewModel> {
_materialStorage.GetElement(model)
});
}
return(_materialStorage.GetFullList());
}
public void Delete(MaterialsBindingModel model)
{
var element = _materialStorage.GetElement(new MaterialsBindingModel
{
Id = model.Id
});
if (element == null)
{
throw new Exception("Элемент не найден");
}
_materialStorage.Delete(model);
}
public void Update(MaterialsBindingModel model)
{
using (var context = new ComputerRepairDatabase())
{
var element = context.Materials.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public MaterialsViewModel GetElement(MaterialsBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new ComputerRepairDatabase())
{
var material = context.Materials.FirstOrDefault(rec => rec.Id == model.Id);
return(material != null ? new MaterialsViewModel
{
Id = material.Id,
Name = material.Name,
Price = material.Price
} : null);
}
}
public void CreateOrUpdate(MaterialsBindingModel model)
{
var element = _materialStorage.GetElement(new MaterialsBindingModel
{
Name = model.Name
});
if (element != null && element.Id != model.Id)
{
throw new Exception("Уже есть материал с таким названием");
}
if (model.Id.HasValue)
{
_materialStorage.Update(model);
}
else
{
_materialStorage.Insert(model);
}
}
private Materials CreateModel(MaterialsBindingModel model, Materials materials)
{
materials.Name = model.Name;
materials.Price = model.Price;
return(materials);
}
