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