public ActionResult EditRecept(Guid id) { using (ClinicEntities entities = new ClinicEntities()) { Прием model = entities.Прием.Where(a => a.ID_приема == id).First(); return(View(model)); } }
public ActionResult EditRecept(Прием myP) { using (ClinicEntities entities = new ClinicEntities()) { entities.Entry(myP).State = EntityState.Modified; entities.SaveChanges(); return(RedirectToAction("Index", "Home")); } }
public ActionResult AddReception() { if (Request.IsAjaxRequest()) { using (ClinicEntities entities = new ClinicEntities()) { try { Прием newRecept = new Прием(); newRecept.ID_приема = Guid.NewGuid(); newRecept.ID_врача = Guid.Parse(Request["ID_врача"]); newRecept.ID_пациента = Guid.Parse(Request["ID_пациента"]); newRecept.Дата = DateTime.Parse(Request["Дата"]); string week; if (newRecept.Дата.DayOfYear / 7 % 2 == 0) { week = "чет"; } else { week = "нечет"; } int count = entities.Прием.Where(a => a.ID_врача == newRecept.ID_врача && a.Дата == newRecept.Дата).Count(); int count2 = entities.асписание.Where(a => a.ID_врача == newRecept.ID_врача && a.Код_дня == (int)newRecept.Дата.DayOfWeek && a.Неделя == week).Count(); entities.Прием.Add(newRecept); if (count < 4 && count2 > 0) { entities.SaveChanges(); } else { return(Json(new { message = "Ошибка" })); } } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors) { System.Diagnostics.Debug.Write("Object: " + validationError.Entry.Entity.ToString()); System.Diagnostics.Debug.Write(" "); foreach (DbValidationError err in validationError.ValidationErrors) { System.Diagnostics.Debug.Write(err.ErrorMessage + " "); } } } return(Json(new { message = "Все гуд" })); } } else { return(View()); } }