// GET: TVaccinations/Create public ActionResult Create(int serviceID) { int intVisitId = (int)Session["intVisitId"]; int intPetId = (int)Session["intPetID"]; Session["intServiceId"] = serviceID; int rabiesVaccineServiceId = db.TServices.Where(x => x.strServiceDesc == "Rabies Vaccine").Select(z => z.intServiceID).FirstOrDefault(); string strServiceDesc = db.TServices.Where(x => x.intServiceID == serviceID).Select(z => z.strServiceDesc).FirstOrDefault(); Session["isRabiesVaccine"] = null; ViewBag.Name = db.TPets.Where(x => x.intPetID == intPetId).Select(z => z.strPetName).FirstOrDefault(); if (serviceID == rabiesVaccineServiceId) { Session["isRabiesVaccine"] = true; } DateTime today = DateTime.Now; VisitVaccination visitVaccination = new VisitVaccination() { intServiceId = serviceID, intVisitServiceId = serviceID, strServiceName = strServiceDesc, dtmDateofVaccination = today.Month + "/" + today.Day + "/" + today.Year, dtmDateOfExpiration = today.Month + "/" + today.Day + "/" + (today.Year + 1), strVaccineNotes = " ", strRabiesNumber = " " }; return(View(visitVaccination)); }
// GET: TVaccinations/Details/5 public ActionResult Details(int visitServiceId) { TVaccination tVaccination = db.TVaccinations.Where(x => x.intVisitServiceID == visitServiceId).FirstOrDefault(); if (tVaccination == null) { return(HttpNotFound()); } int intPetId = (int)Session["intPetID"]; int serviceId = db.TVisitServices.Where(x => x.intVisitServiceID == visitServiceId).Select(z => z.intServiceID).FirstOrDefault(); int intVisitId = db.TVisitServices.Where(x => x.intVisitServiceID == visitServiceId).Select(z => z.intVisitID).FirstOrDefault(); int rabiesVaccineServiceId = db.TServices.Where(x => x.strServiceDesc == "Rabies Vaccine").Select(z => z.intServiceID).FirstOrDefault(); string serviceName = db.TVisitServices.Where(x => x.intVisitServiceID == visitServiceId).Select(z => z.TService.strServiceDesc).FirstOrDefault(); Session["intVisitServiceId"] = visitServiceId; Session["isRabiesVaccine"] = null; DateTime dateOfVaccination = tVaccination.dtmDateOfVaccination; DateTime dateOfExpiration = tVaccination.dtmDateOfExpiration; if (serviceId == rabiesVaccineServiceId) { Session["isRabiesVaccine"] = true; } Session["isFromSummary"] = null; Session["intVisitId"] = intVisitId; bool isSummary = (bool)Session["isSummary"]; if (isSummary == true) { Session["isFromSummary"] = true; } VisitVaccination visitVaccination = new VisitVaccination() { intServiceId = serviceId, intVisitServiceId = (int)visitServiceId, strServiceName = serviceName, dtmDateofVaccination = dateOfVaccination.Month + "/" + dateOfVaccination.Day + "/" + dateOfVaccination.Year, dtmDateOfExpiration = dateOfExpiration.Month + "/" + dateOfExpiration.Day + "/" + dateOfExpiration.Year, strVaccineNotes = tVaccination.strVaccineDesc, strRabiesNumber = tVaccination.strRabiesNumber }; ViewBag.Name = db.TPets.Where(x => x.intPetID == intPetId).Select(z => z.strPetName).FirstOrDefault(); return(View(visitVaccination)); }
public ActionResult VisitVaccinationEdit(VisitVaccination visitVaccination) { int intPetId = (int)Session["intPetID"]; int vaccinationId = db.TVaccinations.Where(x => x.intVisitServiceID == visitVaccination.intVisitServiceId).Select(z => z.intVaccinationID).FirstOrDefault(); if (ModelState.IsValid) { if (visitVaccination.strRabiesNumber == null) { visitVaccination.strRabiesNumber = string.Empty; } ; TVaccination vaccination = new TVaccination() { intVaccinationID = vaccinationId, intVisitServiceID = visitVaccination.intVisitServiceId, dtmDateOfVaccination = Convert.ToDateTime(visitVaccination.dtmDateofVaccination), dtmDateOfExpiration = Convert.ToDateTime(visitVaccination.dtmDateOfExpiration), strVaccineDesc = visitVaccination.strVaccineNotes, strRabiesNumber = visitVaccination.strRabiesNumber }; db.Entry(vaccination).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("PetVaccinations", "TVaccinations", new { id = Session["intPetID"] })); } ; int serviceId = db.TVisitServices.Where(x => x.intVisitServiceID == visitVaccination.intVisitServiceId).Select(z => z.intServiceID).FirstOrDefault(); int rabiesVaccineServiceId = db.TServices.Where(x => x.strServiceDesc == "Rabies Vaccine").Select(z => z.intServiceID).FirstOrDefault(); Session["isRabiesVaccine"] = null; if (serviceId == rabiesVaccineServiceId) { Session["isRabiesVaccine"] = true; } ViewBag.Name = db.TPets.Where(x => x.intPetID == intPetId).Select(z => z.strPetName).FirstOrDefault(); return(View(visitVaccination)); }
public ActionResult Create(VisitVaccination vaccination) { int intVisitId = (int)Session["intVisitId"]; int intPetId = (int)Session["intPetID"]; int serviceID = (int)Session["intServiceId"]; if (ModelState.IsValid) { TVisitService newVisitService = new TVisitService() { intVisitID = intVisitId, intServiceID = serviceID }; db.TVisitServices.Add(newVisitService); db.SaveChanges(); int lastInsertedVisitServiceID = db.TVisitServices.Max(v => v.intVisitServiceID); if (vaccination.strRabiesNumber == null) { vaccination.strRabiesNumber = string.Empty; } TVaccination newVisitVaccination = new TVaccination() { intVisitServiceID = lastInsertedVisitServiceID, dtmDateOfVaccination = Convert.ToDateTime(vaccination.dtmDateofVaccination), dtmDateOfExpiration = Convert.ToDateTime(vaccination.dtmDateOfExpiration), strVaccineDesc = vaccination.strVaccineNotes, strRabiesNumber = vaccination.strRabiesNumber }; db.TVaccinations.Add(newVisitVaccination); db.SaveChanges(); return(RedirectToAction("Index", "VisitServices")); } return(View(vaccination)); }