public ActionResult DeleteVisitEmployee(int employeeID) { int intVisitId = (int)Session["intVisitId"]; TVisitEmployee visitEmployee = db.TVisitEmployees.Where(x => x.intVisitID == intVisitId && x.intEmployeeID == employeeID).FirstOrDefault(); db.TVisitEmployees.Remove(visitEmployee); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddPetEmployee(int employeeID) { TVisitEmployee visitEmployee = new TVisitEmployee() { intEmployeeID = employeeID, intVisitID = (int)Session["intVisitId"] }; db.TVisitEmployees.Add(visitEmployee); db.SaveChanges(); return(RedirectToAction("Index")); }
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")); } }