public ActionResult DeleteConfirmed(int id) { TVisit tVisit = db.TVisits.Find(id); db.TVisits.Remove(tVisit); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "intVisitID,intPetID,intVisitReasonID,dtmDateOfVist")] TVisit tVisit) { if (ModelState.IsValid) { db.Entry(tVisit).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.intVisitReasonID = new SelectList(db.TVisitReasons, "intVisitReasonID", "strVisitReason", tVisit.intVisitReasonID); return(View(tVisit)); }
public ActionResult Create(CreateVisit tVisit) { int petID = (int)Session["intPetID"]; if (ModelState.IsValid) { TVisit newPetVisit = new TVisit() { intPetID = petID, dtmDateOfVist = DateTime.Now, intVisitReasonID = tVisit.intVisitReasonID }; db.TVisits.Add(newPetVisit); db.SaveChanges(); int lastInsertedVisitID = db.TVisits.Max(v => v.intVisitID); Session["intVisitId"] = lastInsertedVisitID; TVisitEmployee newPetVisitEmployee = new TVisitEmployee() { intVisitID = lastInsertedVisitID, intEmployeeID = tVisit.intEmployeeID }; db.TVisitEmployees.Add(newPetVisitEmployee); db.SaveChanges(); //Remove existing data from session for pet id int wellnessExam = db.TVisitReasons.Where(x => x.strVisitReason == "Wellness Exam").Select(z => z.intVisitReasonID).FirstOrDefault(); int medicationExam = db.TVisitReasons.Where(x => x.strVisitReason == "Medication").Select(z => z.intVisitReasonID).FirstOrDefault(); if (newPetVisit.intVisitReasonID == wellnessExam) { return(RedirectToAction("Create", "THealthExam", new { id = petID })); } else if (newPetVisit.intVisitReasonID == medicationExam) { return(RedirectToAction("Index", "VisitMedications")); } else { return(RedirectToAction("Index", "VisitServices")); } } else { return(RedirectToAction("Index")); } }
// GET: TVisits/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TVisit tVisit = db.TVisits.Find(id); if (tVisit == null) { return(HttpNotFound()); } return(View(tVisit)); }
// GET: TVisits/PetProfileVisitDetails/5 public ActionResult PetProfileVisitDetails(int?id) { if (id == null) { return(new HttpStatusCodeResult((int)HttpStatusCode.BadRequest)); } TVisit tVisit = db.TVisits.Find(id); if (tVisit == null) { return(HttpNotFound()); } return(View(tVisit)); }
// GET: TVisits/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TVisit tVisit = db.TVisits.Find(id); if (tVisit == null) { return(HttpNotFound()); } ViewBag.intVisitReasonID = new SelectList(db.TVisitReasons, "intVisitReasonID", "strVisitReason", tVisit.intVisitReasonID); return(View(tVisit)); }