public void Delete(DiseaseBindingModel model) { using (var context = new ClinicDataBase()) { using (var transaction = context.Database.BeginTransaction()) { try { Disease element = context.Diseases.FirstOrDefault(rec => rec.Id == model.Id); if (element != null) { context.Diseases.Remove(element); context.SaveChanges(); } else { throw new Exception("Элемент не найден"); } transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
private Disease CreateModel(DiseaseBindingModel model, Disease disease) { disease.DiseaseName = model.DiseaseName; disease.Difficulty = model.Difficulty; disease.Class = model.Class; disease.DoctorId = (int)model.DoctorId; return(disease); }
public void Delete(DiseaseBindingModel model) { var element = _diseaseStorage.GetElement(new DiseaseBindingModel { Id = model.Id }); if (element == null) { throw new Exception("Косметика не найдена"); } _diseaseStorage.Delete(model); }
public List <DiseaseViewModel> Read(DiseaseBindingModel model) { if (model == null) { return(_diseaseStorage.GetFullList()); } if (model.Id.HasValue) { return(new List <DiseaseViewModel> { _diseaseStorage.GetElement(model) }); } return(_diseaseStorage.GetFilteredList(model)); }
public void CreateOrUpdate(DiseaseBindingModel model) { var element = _diseaseStorage.GetElement(new DiseaseBindingModel { DiseaseName = model.DiseaseName }); if (element != null && element.Id != model.Id) { throw new Exception("Уже есть болезнь с таким названием"); } if (model.Id.HasValue) { _diseaseStorage.Update(model); } else { _diseaseStorage.Insert(model); } }
public void Insert(DiseaseBindingModel model) { using (var context = new ClinicDataBase()) { using (var transaction = context.Database.BeginTransaction()) { try { context.Diseases.Add(CreateModel(model, new Disease())); context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } }
public List <DiseaseViewModel> GetFilteredList(DiseaseBindingModel model) { if (model == null) { return(null); } using (var context = new ClinicDataBase()) { return(context.Diseases .Include(rec => rec.Doctor) .Where(rec => rec.DoctorId == model.DoctorId || rec.DiseaseName.Contains(model.DiseaseName)) .ToList() .Select(rec => new DiseaseViewModel { Id = rec.Id, DiseaseName = rec.DiseaseName, Class = rec.Class, Difficulty = rec.Difficulty, DoctorId = rec.DoctorId }) .ToList()); } }
public DiseaseViewModel GetElement(DiseaseBindingModel model) { if (model == null) { return(null); } using (var context = new ClinicDataBase()) { var tmp = model.DoctorId; var disease = context.Diseases .Include(rec => rec.Doctor) .FirstOrDefault(rec => rec.DiseaseName == model.DiseaseName || rec.Id == model.Id); return(disease != null ? new DiseaseViewModel { Id = disease.Id, DiseaseName = disease.DiseaseName, Difficulty = disease.Difficulty, Class = disease.Class, DoctorId = disease.DoctorId } : null); } }