private Work CreateModel(WorkBindingModel model, Work work)
{
work.WorkerId = model.WorkerId;
work.WorkName = model.WorkName;
work.WorkPrice = model.WorkPrice;
return(work);
}
public void Insert(WorkBindingModel model)
{
using (var context = new CTODatabase())
{
context.Works.Add(CreateModel(model, new Work()));
context.SaveChanges();
}
}
public void CreateWork(WorkBindingModel model)
{
var element = _workStorage.GetElement(new WorkBindingModel
{
WorkName = model.WorkName
});
_workStorage.Insert(model);
}
public void Update(WorkBindingModel model)
{
using (var context = new CTODatabase())
{
var element = context.Works.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Такого ремонта нет");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public WorkViewModel GetElement(WorkBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new CTODatabase())
{
var work = context.Works.Include(rec => rec.Worker)
.FirstOrDefault(rec => rec.Id == model.Id || rec.WorkName == model.WorkName);
return(work != null?CreateViewModel(work) : null);
}
}
public void Delete(WorkBindingModel model)
{
var element = _workStorage.GetElement(new WorkBindingModel
{
Id = model.Id
});
if (element == null)
{
throw new Exception("Работа не найдена");
}
_workStorage.Delete(model);
}
public List <WorkViewModel> Read(WorkBindingModel model)
{
if (model == null)
{
return(_workStorage.GetFullList());
}
if (model.Id.HasValue || model.WorkName != null)
{
return(new List <WorkViewModel> {
_workStorage.GetElement(model)
});
}
return(_workStorage.GetFilteredList(model));
}
public void Delete(WorkBindingModel model)
{
using (var context = new CTODatabase())
{
Work element = context.Works.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.Works.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Такого ремонта нет");
}
}
}
public List <WorkViewModel> GetFilteredList(WorkBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new CTODatabase())
{
return(context.Works.Include(rec => rec.Worker)
.Select(rec => new WorkViewModel
{
Id = rec.Id,
WorkerId = rec.WorkerId,
WorkName = rec.WorkName,
WorkPrice = rec.WorkPrice
})
.ToList());
}
}
public void DeleteWork(WorkBindingModel model) => _work.Delete(model);
public void UpdateWork(WorkBindingModel model) => _work.UpdateWork(model);
public void CreateWork(WorkBindingModel model) => _work.CreateWork(model);
public void UpdateWork(WorkBindingModel model)
{
_workStorage.Update(model);
}