public void Insert(MaterialBindingModel model)
{
using (var context = new AutoServiceDatabase())
{
context.Materials.Add(CreateModel(model, new Material()));
context.SaveChanges();
}
}
private Material CreateModel(MaterialBindingModel model, Material material)
{
material.Name = model.Name;
material.Info = model.Info;
material.Price = model.Price;
material.WorktypeId = model.WorktypeId;
return(material);
}
public void Delete(MaterialBindingModel model)
{
var element = _materialStorage.GetElement(new MaterialBindingModel {
Id = model.Id
});
if (element == null)
{
throw new Exception("Материал не найден");
}
_materialStorage.Delete(model);
}
public ActionResult Edit(int id)
{
var viewModel = _service.GetElement(id);
var bindingModel = new MaterialBindingModel
{
Id = id,
Name = viewModel.Name,
Count = viewModel.Count
};
return(View(bindingModel));
}
public void Update(MaterialBindingModel model)
{
using (var context = new AutoServiceDatabase())
{
var element = context.Materials.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Материал не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public List <MaterialViewModel> Read(MaterialBindingModel model)
{
if (model == null)
{
return(_materialStorage.GetFullList());
}
if (model.Id.HasValue)
{
return(new List <MaterialViewModel> {
_materialStorage.GetElement(model)
});
}
return(_materialStorage.GetFilteredList(model));
}
public MaterialViewModel GetElement(MaterialBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoServiceDatabase())
{
var material = context.Materials
.Include(rec => rec.Worktype)
.FirstOrDefault(rec => rec.Name.Equals(model.Name) || rec.Id == model.Id);
return(material != null?CreateModel(material) : null);
}
}
public List <MaterialViewModel> GetFilteredList(MaterialBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoServiceDatabase())
{
return(context.Materials
.Include(rec => rec.Worktype)
.Where(rec => rec.Worktype.Id == model.WorktypeId)
.Select(CreateModel).ToList());
}
}
public void AddElement(MaterialBindingModel model)
{
Material element = context.Materials.FirstOrDefault(rec => rec.Name == model.Name);
if (element != null)
{
throw new Exception("Уже есть материал с таким названием");
}
context.Materials.Add(new Material
{
Name = model.Name,
Count = model.Count
});
context.SaveChanges();
}
public void UpdElement(MaterialBindingModel model)
{
Material element = context.Materials.FirstOrDefault(rec => rec.Name == model.Name && rec.Id != model.Id);
if (element != null)
{
throw new Exception("Уже есть материал с таким названием");
}
element = context.Materials.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
element.Name = model.Name;
element.Count = model.Count;
context.SaveChanges();
}
public void Delete(MaterialBindingModel model)
{
using (var context = new MebelDatabase())
{
Material element = context.Materials.FirstOrDefault(rec => rec.Id ==
model.Id);
if (element != null)
{
context.Materials.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Материал не найден");
}
}
}
public void CreateOrUpdate(MaterialBindingModel model)
{
var element = _materialStorage.GetElement(new MaterialBindingModel {
Name = model.Name, Info = model.Info
});
if (element != null && element.Id != model.Id)
{
throw new Exception("Уже есть такой материал");
}
if (model.Id.HasValue)
{
_materialStorage.Update(model);
}
else
{
_materialStorage.Insert(model);
}
}
public List <MaterialViewModel> GetFilteredList(MaterialBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new MebelDatabase())
{
return(context.Materials
.Where(rec => rec.Name.Contains(model.Name))
.Select(rec => new MaterialViewModel
{
Id = rec.Id,
Name = rec.Name,
Price = rec.Price
})
.ToList());
}
}
public void CreateOrUpdate(MaterialBindingModel model)
{
var element = _materialStorage.GetElement(new MaterialBindingModel
{
Name = model.Name
});
if (element != null && element.Id != model.Id)
{
throw new Exception("Уже есть компонент с таким названием");
}
if (model.Id.HasValue)
{
_materialStorage.Update(model);
}
else
{
_materialStorage.Insert(model);
}
}
public MaterialViewModel GetElement(MaterialBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new MebelDatabase())
{
var component = context.Materials
.FirstOrDefault(rec => rec.Name == model.Name ||
rec.Id == model.Id);
return(component != null ?
new MaterialViewModel
{
Id = component.Id,
Name = component.Name,
Price = component.Price
} :
null);
}
}
private Material CreateModel(MaterialBindingModel model, Material material)
{
material.Name = model.Name;
material.Price = model.Price;
return(material);
}
