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));
        }