public void Insert(ProcedureBindingModel model) { using (var context = new BeautySaloonDatabase()) { context.Procedures.Add(CreateModel(model, new Procedure())); context.SaveChanges(); } }
private Procedure CreateModel(ProcedureBindingModel model, Procedure procedure) { procedure.ProcedureName = model.ProcedureName; procedure.Price = model.Price; procedure.Duration = model.Duration; procedure.ClientId = model.ClientId.Value; return(procedure); }
public void Update(ProcedureBindingModel model) { using (var context = new BeautySaloonDatabase()) { var element = context.Procedures.FirstOrDefault(rec => rec.Id == model.Id); if (element == null) { throw new Exception("Элемент не найден"); } CreateModel(model, element); context.SaveChanges(); } }
public void Delete(ProcedureBindingModel model) { var element = _procedureStorage.GetElement(new ProcedureBindingModel { Id = model.Id }); if (element == null) { throw new Exception("Процедура не найдена"); } _procedureStorage.Delete(model); }
public List <ProcedureViewModel> Read(ProcedureBindingModel model) { if (model == null) { return(_procedureStorage.GetFullList()); } if (model.Id.HasValue) { return(new List <ProcedureViewModel> { _procedureStorage.GetElement(model) }); } return(_procedureStorage.GetFilteredList(model)); }
public List <ProcedureViewModel> GetFilteredList(ProcedureBindingModel model) { if (model == null) { return(null); } using (var context = new BeautySaloonDatabase()) { return(context.Procedures .Where(rec => rec.ClientId == model.ClientId || rec.ProcedureName.Contains(model.ProcedureName)) .Select(CreateModel) .ToList()); } }
public ProcedureViewModel GetElement(ProcedureBindingModel model) { if (model == null) { return(null); } using (var context = new BeautySaloonDatabase()) { var procedure = context.Procedures .FirstOrDefault(rec => rec.ProcedureName == model.ProcedureName || rec.Id == model.Id); return(procedure != null? CreateModel(procedure) : null); } }
public void Delete(ProcedureBindingModel model) { using (var context = new BeautySaloonDatabase()) { Procedure element = context.Procedures.FirstOrDefault(rec => rec.Id == model.Id); if (element != null) { context.Procedures.Remove(element); context.SaveChanges(); } else { throw new Exception("Элемент не найден"); } } }
public void CreateOrUpdate(ProcedureBindingModel model) { var element = _procedureStorage.GetElement(new ProcedureBindingModel { ProcedureName = model.ProcedureName }); if (element != null && element.Id != model.Id) { throw new Exception("Уже есть процедура с таким названием"); } if (model.Id.HasValue) { _procedureStorage.Update(model); } else { _procedureStorage.Insert(model); } }