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); }