public void Insert(MaterialBindingModel model)
{
using (var context = new AutoServiceDatabase())
{
context.Materials.Add(CreateModel(model, new Material()));
context.SaveChanges();
}
}
public void Insert(VisitBindingModel model)
{
using (var context = new AutoServiceDatabase())
{
CreateModel(model, new Visit(), context);
context.SaveChanges();
}
}
public List <MaterialViewModel> GetFullList()
{
using (var context = new AutoServiceDatabase())
{
return(context.Materials
.Include(rec => rec.Worktype)
.Select(CreateModel).ToList());
}
}
public List <VisitViewModel> GetFullList()
{
using (var context = new AutoServiceDatabase())
{
return(context.Visits
.Include(rec => rec.Transport)
.Include(rec => rec.VisitWorktypes)
.ThenInclude(rec => rec.Worktype)
.Include(rec => rec.UsedMaterials)
.ThenInclude(rec => rec.Material)
.Select(CreateModel).ToList());
}
}
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 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 VisitViewModel GetElement(VisitBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoServiceDatabase())
{
var material = context.Visits
.Include(rec => rec.Transport)
.Include(rec => rec.VisitWorktypes)
.ThenInclude(rec => rec.Worktype)
.Include(rec => rec.UsedMaterials)
.ThenInclude(rec => rec.Material).FirstOrDefault(rec => rec.Date.Equals(model.Date) || rec.Id == model.Id);
return(material != null?CreateModel(material) : null);
}
}
public List <VisitViewModel> GetFilteredList(VisitBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AutoServiceDatabase())
{
return(context.Visits
.Include(rec => rec.Transport)
.Include(rec => rec.VisitWorktypes)
.ThenInclude(rec => rec.Worktype)
.Include(rec => rec.UsedMaterials)
.ThenInclude(rec => rec.Material)
.Where(rec => (model.DateFrom.HasValue && model.DateTo.HasValue &&
rec.Date.Date >= model.DateFrom.Value.Date &&
rec.Date.Date <= model.DateTo.Value.Date))
.Select(CreateModel).ToList());
}
}
