public ActionResult Edit(int visitServiceId) { Session["intVisitServiceID"] = visitServiceId; THealthExam healthExam = db.THealthExams.Where(x => x.intVisitServiceID == visitServiceId).FirstOrDefault(); TEyeStatusInfo eyeStatusInfo = db.TEyeStatusInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TEarStatusInfo earStatusInfo = db.TEarStatusInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TSkinInfo skinInfo = db.TSkinInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TMouthInfo mouthInfo = db.TMouthInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TNoseThroatInfo noseThroatInfo = db.TNoseThroatInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TGIInfo gIInfo = db.TGIInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TNeurologicalInfo neurologicalInfo = db.TNeurologicalInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TAbdomenInfo abdomenInfo = db.TAbdomenInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TUrogenitalInfo urogenitalInfo = db.TUrogenitalInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TMusculoskeletalInfo musculoskeletalInfo = db.TMusculoskeletalInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); TLungInfo lungInfo = db.TLungInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); THeartInfo heartInfo = db.THeartInfos.Where(x => x.intHealthExamID == healthExam.intHealthExamID).FirstOrDefault(); HealthExam hExam = new HealthExam() { dblWeight = (float)healthExam.dblWeight, dblTemperature = (float)healthExam.dblTemperature, intHeartRate = healthExam.intHeartRate, intRespRate = healthExam.intRespRate, intCapillaryRefillTime = healthExam.intCapillaryRefillTime, strMucousMembrane = healthExam.strMucousMembrane, strNotes = healthExam.strNotes, isEyeNormal = eyeStatusInfo.isNormal, isDischarge = eyeStatusInfo.isDischarge, isInfection = eyeStatusInfo.isInfection, isSclerosisLeft = eyeStatusInfo.isSclerosisLeft, isSclerosisRight = eyeStatusInfo.isSclerosisRight, isCataractLeft = eyeStatusInfo.isCataractLeft, isCataractRight = eyeStatusInfo.isCataractRight, isEyeInflamed = eyeStatusInfo.isInflamed, isEyelidTumor = eyeStatusInfo.isEyelidTumor, isEarNormal = earStatusInfo.isNormal, isEarInflamed = earStatusInfo.isInflamed, isEarTumor = earStatusInfo.isTumor, isDirty = earStatusInfo.isDirty, isEarPainful = earStatusInfo.isPainful, isExcessiveHair = earStatusInfo.isExcessiveHair, isSkinNormal = skinInfo.isNormal, isScaly = skinInfo.isScaly, isInfected = skinInfo.isInfected, isMatted = skinInfo.isMatted, isSkinScrape = skinInfo.isSkinScrape, isPruritus = skinInfo.isPruritus, isHairLoss = skinInfo.isHairLoss, isMass = skinInfo.isMass, isSkinParasites = skinInfo.isParasites, isMouthNormal = mouthInfo.isNormal, isMouthTumor = mouthInfo.isTumor, isGingivitis = mouthInfo.isGingivitis, isPeriodontitis = mouthInfo.isPeriodontitis, isTartarBuildup = mouthInfo.isTartarBuildup, isLooseTeeth = mouthInfo.isLooseTeeth, isBiteOVerUnder = mouthInfo.isBiteOVerUnder, isNoseThroatNormal = noseThroatInfo.isNormal, isLargeLymphNodes = noseThroatInfo.isLargeLymphNodes, isInflamedThroat = noseThroatInfo.isInflamedThroat, isNasalDishcharge = noseThroatInfo.isNasalDishcharge, isInflamedTonsils = noseThroatInfo.isInflamedTonsils, isGINormal = gIInfo.isNormal, isExcessiveGas = gIInfo.isExcessiveGas, isGIParasites = gIInfo.isParasites, isAbnormalFeces = gIInfo.isAbnormalFeces, isAnorexia = gIInfo.isAnorexia, isNeurologicalNormal = neurologicalInfo.isNormal, isPLRL = neurologicalInfo.isPLRL, isPLRR = neurologicalInfo.isPLRR, isCPLF = neurologicalInfo.isCPLF, isCPRF = neurologicalInfo.isCPRF, isCPLR = neurologicalInfo.isCPLR, isCPRR = neurologicalInfo.isCPRR, isPalpebralL = neurologicalInfo.isPalpebralL, isPalpebralR = neurologicalInfo.isPalpebralR, isAbdomenNormal = abdomenInfo.isNormal, isAbnormalMass = abdomenInfo.isAbnormalMass, isAbdomenPainful = abdomenInfo.isPainful, isBloated = abdomenInfo.isBloated, isEnlarged = abdomenInfo.isEnlarged, isFluid = abdomenInfo.isFluid, isHernia = abdomenInfo.isHernia, isUrogenitalNormal = urogenitalInfo.isNormal, isUrogenAbnormalUrination = urogenitalInfo.isAbnormalUrination, isGenitalDischarge = urogenitalInfo.isGenitalDischarge, isAnalSacs = urogenitalInfo.isAnalSacs, isRectal = urogenitalInfo.isRectal, isMammaryTumors = urogenitalInfo.isMammaryTumors, isAbnormalTesticles = urogenitalInfo.isAbnormalTesticles, isBloodSeen = urogenitalInfo.isBloodSeen, isMusculoskeletalNormal = musculoskeletalInfo.isNormal, isJointProblems = musculoskeletalInfo.isJointProblems, isNailProblems = musculoskeletalInfo.isNailProblems, isLamenessLF = musculoskeletalInfo.isLamenessLF, isLamenessRF = musculoskeletalInfo.isLamenessRF, isLamenessLR = musculoskeletalInfo.isLamenessLR, isLamenessRR = musculoskeletalInfo.isLamenessRR, isLigaments = musculoskeletalInfo.isLigaments, isLungNormal = lungInfo.isNormal, isBreathingDifficulty = lungInfo.isBreathingDifficulty, isRapidRespiration = lungInfo.isRapidRespiration, isTrachealPinchPositive = lungInfo.isTrachealPinchPositive, isTrachealPinchNegative = lungInfo.isTrachealPinchNegative, isCongestion = lungInfo.isCongestion, isAbnormalSound = lungInfo.isAbnormalSound, isHeartNormal = heartInfo.isNormal, isMurMur = heartInfo.isMurMur, isFast = heartInfo.isFast, isSlow = heartInfo.isSlow, isMuffled = heartInfo.isMuffled }; int id = (int)Session["intPetID"]; ViewBag.Name = db.TPets.Where(x => x.intPetID == id).Select(z => z.strPetName).FirstOrDefault(); return(View(hExam)); }
public ActionResult Edit(HealthExam healthExam) { int visitServiceId = (int)Session["intVisitServiceID"]; int healthExamId = db.THealthExams.Where(x => x.intVisitServiceID == visitServiceId).Select(z => z.intHealthExamID).FirstOrDefault(); //Health Exam THealthExam exam = new THealthExam() { intHealthExamID = healthExamId, dblWeight = (float)healthExam.dblWeight, dblTemperature = (float)healthExam.dblTemperature, intHeartRate = healthExam.intHeartRate, intRespRate = healthExam.intRespRate, intCapillaryRefillTime = healthExam.intCapillaryRefillTime, strMucousMembrane = healthExam.strMucousMembrane, intVisitServiceID = visitServiceId, strNotes = healthExam.strNotes }; db.Entry(exam).State = EntityState.Modified; db.SaveChanges(); //Eye Status Information int eyestatusId = db.TEyeStatusInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intEyeStatusInfoID).FirstOrDefault(); TEyeStatusInfo eyeStatus = new TEyeStatusInfo() { intEyeStatusInfoID = eyestatusId, isNormal = healthExam.isEyeNormal, isDischarge = healthExam.isDischarge, isInfection = healthExam.isInfection, isSclerosisLeft = healthExam.isSclerosisLeft, isSclerosisRight = healthExam.isSclerosisRight, isCataractLeft = healthExam.isCataractLeft, isCataractRight = healthExam.isCataractRight, isInflamed = healthExam.isEyeInflamed, isEyelidTumor = healthExam.isEyelidTumor, intHealthExamID = healthExamId }; db.Entry(eyeStatus).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Ear Status Information int earstatusId = db.TEarStatusInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intEarStatusInfoID).FirstOrDefault(); TEarStatusInfo earStatus = new TEarStatusInfo() { intEarStatusInfoID = earstatusId, isNormal = healthExam.isEarNormal, isInflamed = healthExam.isEarInflamed, isTumor = healthExam.isEarTumor, isDirty = healthExam.isDirty, isPainful = healthExam.isEarPainful, isExcessiveHair = healthExam.isExcessiveHair, intHealthExamID = healthExamId }; db.Entry(earStatus).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Skin Status Information int skinstatusId = db.TSkinInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intSkinInfoID).FirstOrDefault(); TSkinInfo skinInfo = new TSkinInfo() { intSkinInfoID = earstatusId, isNormal = healthExam.isSkinNormal, isScaly = healthExam.isScaly, isInfected = healthExam.isInfected, isMatted = healthExam.isMatted, isSkinScrape = healthExam.isSkinScrape, isPruritus = healthExam.isPruritus, isHairLoss = healthExam.isHairLoss, isMass = healthExam.isMass, isParasites = healthExam.isSkinParasites, intHealthExamID = healthExamId }; db.Entry(skinInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Mouth Status Infomration int mouthstatusId = db.TMouthInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intMouthInfoID).FirstOrDefault(); TMouthInfo mouthInfo = new TMouthInfo() { intMouthInfoID = mouthstatusId, isNormal = healthExam.isMouthNormal, isTumor = healthExam.isMouthTumor, isGingivitis = healthExam.isGingivitis, isPeriodontitis = healthExam.isPeriodontitis, isTartarBuildup = healthExam.isTartarBuildup, isLooseTeeth = healthExam.isLooseTeeth, isBiteOVerUnder = healthExam.isBiteOVerUnder, intHealthExamID = healthExamId }; db.Entry(mouthInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Nose and Throat Status Information int nosethroatstatusId = db.TNoseThroatInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intNoseThroatInfoID).FirstOrDefault(); TNoseThroatInfo noseThroatInfo = new TNoseThroatInfo() { intNoseThroatInfoID = nosethroatstatusId, isNormal = healthExam.isNoseThroatNormal, isLargeLymphNodes = healthExam.isLargeLymphNodes, isInflamedThroat = healthExam.isInflamedThroat, isNasalDishcharge = healthExam.isNasalDishcharge, isInflamedTonsils = healthExam.isInflamedTonsils, intHealthExamID = healthExamId }; db.Entry(noseThroatInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //GI Status Information int gistatusId = db.TGIInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intGIInfoID).FirstOrDefault(); TGIInfo gIInfo = new TGIInfo() { intGIInfoID = nosethroatstatusId, isNormal = healthExam.isGINormal, isExcessiveGas = healthExam.isExcessiveGas, isParasites = healthExam.isGIParasites, isAbnormalFeces = healthExam.isAbnormalFeces, isAnorexia = healthExam.isAnorexia, intHealthExamID = healthExamId }; db.Entry(gIInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Nuerological Status Information int neurologicalStatusInfo = db.TNeurologicalInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intNeurologicalInfoID).FirstOrDefault(); TNeurologicalInfo neurologicalInfo = new TNeurologicalInfo() { intNeurologicalInfoID = nosethroatstatusId, isNormal = healthExam.isNeurologicalNormal, isPLRL = healthExam.isPLRL, isPLRR = healthExam.isPLRR, isCPLF = healthExam.isCPLF, isCPRF = healthExam.isCPRF, isCPLR = healthExam.isCPLR, isCPRR = healthExam.isCPRR, isPalpebralL = healthExam.isPalpebralL, isPalpebralR = healthExam.isPalpebralR, intHealthExamID = healthExamId }; db.Entry(neurologicalInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Abdomen Status Information int abdomenstatusId = db.TAbdomenInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intAbdomenInfoID).FirstOrDefault(); TAbdomenInfo abdomenInfo = new TAbdomenInfo() { intAbdomenInfoID = abdomenstatusId, isNormal = healthExam.isAbdomenNormal, isAbnormalMass = healthExam.isAbnormalMass, isPainful = healthExam.isAbdomenPainful, isBloated = healthExam.isBloated, isEnlarged = healthExam.isEnlarged, isFluid = healthExam.isFluid, isHernia = healthExam.isHernia, intHealthExamID = healthExamId }; db.Entry(abdomenInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Urogenital Status Information int urogenitalstatusId = db.TUrogenitalInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intUrogenitalInfoID).FirstOrDefault(); TUrogenitalInfo urogenitalInfo = new TUrogenitalInfo() { intUrogenitalInfoID = urogenitalstatusId, isNormal = healthExam.isUrogenitalNormal, isAbnormalUrination = healthExam.isUrogenAbnormalUrination, isGenitalDischarge = healthExam.isGenitalDischarge, isAnalSacs = healthExam.isAnalSacs, isRectal = healthExam.isRectal, isMammaryTumors = healthExam.isMammaryTumors, isAbnormalTesticles = healthExam.isAbnormalTesticles, isBloodSeen = healthExam.isBloodSeen, intHealthExamID = healthExamId }; db.Entry(urogenitalInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Musculoskeletal Status Information int musculoskeletalstatusId = db.TMusculoskeletalInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intMusculoskeletalInfoID).FirstOrDefault(); TMusculoskeletalInfo musculoskeletalInfo = new TMusculoskeletalInfo() { intMusculoskeletalInfoID = musculoskeletalstatusId, isNormal = healthExam.isMusculoskeletalNormal, isJointProblems = healthExam.isJointProblems, isNailProblems = healthExam.isNailProblems, isLamenessLF = healthExam.isLamenessLF, isLamenessRF = healthExam.isLamenessRF, isLamenessLR = healthExam.isLamenessLR, isLamenessRR = healthExam.isLamenessRR, isLigaments = healthExam.isLigaments, intHealthExamID = healthExamId }; db.Entry(musculoskeletalInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Lung Status Information int lungstatusId = db.TLungInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intLungInfoID).FirstOrDefault(); TLungInfo lungInfo = new TLungInfo() { intLungInfoID = lungstatusId, isNormal = healthExam.isLungNormal, isBreathingDifficulty = healthExam.isBreathingDifficulty, isRapidRespiration = healthExam.isRapidRespiration, isTrachealPinchPositive = healthExam.isTrachealPinchPositive, isTrachealPinchNegative = healthExam.isTrachealPinchNegative, isCongestion = healthExam.isCongestion, isAbnormalSound = healthExam.isAbnormalSound, intHealthExamID = healthExamId }; db.Entry(lungInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //Heart Status Information int heartstatusId = db.THeartInfos.Where(x => x.intHealthExamID == healthExamId).Select(z => z.intHeartInfoID).FirstOrDefault(); THeartInfo heartInfo = new THeartInfo() { intHeartInfoID = heartstatusId, isNormal = healthExam.isHeartNormal, isMurMur = healthExam.isMurMur, isFast = healthExam.isFast, isSlow = healthExam.isSlow, isMuffled = healthExam.isMuffled, intHealthExamID = healthExamId }; db.Entry(heartInfo).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "VisitServices")); }
public ActionResult Create(HealthExam healthExam) { int healthExamService = db.TServices.Where(x => x.strServiceDesc == "Health Exam").Select(z => z.intServiceID).FirstOrDefault(); int lastInsertedVisitID = (int)Session["intVisitId"]; TVisitService visitService = new TVisitService() { intVisitID = lastInsertedVisitID, intServiceID = healthExamService }; db.TVisitServices.Add(visitService); db.SaveChanges(); int lastInsertedVisitServiceID = db.TVisitServices.Max(v => v.intVisitServiceID); SqlParameter[] param = new SqlParameter[] { //Health exam parameters new SqlParameter("@dblWeight", healthExam.dblWeight), new SqlParameter("@dblTemperature", healthExam.dblTemperature), new SqlParameter("@intHeartRate", healthExam.intHeartRate), new SqlParameter("@intRespRate", healthExam.intRespRate), new SqlParameter("@intCapillaryRefillTime", healthExam.intCapillaryRefillTime), new SqlParameter("@strMucousMembrane", healthExam.strMucousMembrane), new SqlParameter("@intVisitServiceID", lastInsertedVisitServiceID), new SqlParameter("@strNotes", healthExam.strNotes), //Eye status parameters new SqlParameter("@isEyeNormal", SqlDbType.Bit) { Value = healthExam.isEyeNormal }, new SqlParameter("@isDischarge", SqlDbType.Bit) { Value = healthExam.isDischarge }, new SqlParameter("@isInfection", SqlDbType.Bit) { Value = healthExam.isInfection }, new SqlParameter("@isSclerosisLeft", SqlDbType.Bit) { Value = healthExam.isSclerosisLeft }, new SqlParameter("@isSclerosisRight", SqlDbType.Bit) { Value = healthExam.isSclerosisRight }, new SqlParameter("@isCataractLeft", SqlDbType.Bit) { Value = healthExam.isCataractLeft }, new SqlParameter("@isCataractRight", SqlDbType.Bit) { Value = healthExam.isCataractRight }, new SqlParameter("@isEyeInflamed", SqlDbType.Bit) { Value = healthExam.isEyeInflamed }, new SqlParameter("@isEyelidTumor", SqlDbType.Bit) { Value = healthExam.isEyelidTumor }, //Ear status information new SqlParameter("@isEarNormal", SqlDbType.Bit) { Value = healthExam.isEarNormal }, new SqlParameter("@isEarInflamed", SqlDbType.Bit) { Value = healthExam.isEarInflamed }, new SqlParameter("@isEarTumor", SqlDbType.Bit) { Value = healthExam.isEarTumor }, new SqlParameter("@isDirty", SqlDbType.Bit) { Value = healthExam.isDirty }, new SqlParameter("@isEarPainful", SqlDbType.Bit) { Value = healthExam.isEarPainful }, new SqlParameter("@isExcessiveHair", SqlDbType.Bit) { Value = healthExam.isExcessiveHair }, //Skin status information new SqlParameter("@isSkinNormal", SqlDbType.Bit) { Value = healthExam.isSkinNormal }, new SqlParameter("@isScaly", SqlDbType.Bit) { Value = healthExam.isScaly }, new SqlParameter("@isInfected", SqlDbType.Bit) { Value = healthExam.isInfected }, new SqlParameter("@isMatted", SqlDbType.Bit) { Value = healthExam.isMatted }, new SqlParameter("@isSkinScrape", SqlDbType.Bit) { Value = healthExam.isSkinScrape }, new SqlParameter("@isPruritus", SqlDbType.Bit) { Value = healthExam.isPruritus }, new SqlParameter("@isHairLoss", SqlDbType.Bit) { Value = healthExam.isHairLoss }, new SqlParameter("@isMass", SqlDbType.Bit) { Value = healthExam.isMass }, new SqlParameter("@isSkinParasites", SqlDbType.Bit) { Value = healthExam.isSkinParasites }, //Mouth status information new SqlParameter("@isMouthNormal", SqlDbType.Bit) { Value = healthExam.isMouthNormal }, new SqlParameter("@isMouthTumor", SqlDbType.Bit) { Value = healthExam.isMouthTumor }, new SqlParameter("@isGingivitis", SqlDbType.Bit) { Value = healthExam.isGingivitis }, new SqlParameter("@isPeriodontitis", SqlDbType.Bit) { Value = healthExam.isPeriodontitis }, new SqlParameter("@isTartarBuildup", SqlDbType.Bit) { Value = healthExam.isTartarBuildup }, new SqlParameter("@isLooseTeeth", SqlDbType.Bit) { Value = healthExam.isLooseTeeth }, new SqlParameter("@isBiteOVerUnder", SqlDbType.Bit) { Value = healthExam.isBiteOVerUnder }, //Nose and Throat status information new SqlParameter("@isNoseThroatNormal", SqlDbType.Bit) { Value = healthExam.isNoseThroatNormal }, new SqlParameter("@isLargeLymphNodes", SqlDbType.Bit) { Value = healthExam.isLargeLymphNodes }, new SqlParameter("@isInflamedThroat", SqlDbType.Bit) { Value = healthExam.isInflamedThroat }, new SqlParameter("@isNasalDishcharge", SqlDbType.Bit) { Value = healthExam.isNasalDishcharge }, new SqlParameter("@isInflamedTonsils", SqlDbType.Bit) { Value = healthExam.isInflamedTonsils }, //GI status information new SqlParameter("@isGINormal", SqlDbType.Bit) { Value = healthExam.isGINormal }, new SqlParameter("@isExcessiveGas", SqlDbType.Bit) { Value = healthExam.isExcessiveGas }, new SqlParameter("@isGIParasites", SqlDbType.Bit) { Value = healthExam.isGIParasites }, new SqlParameter("@isAbnormalFeces", SqlDbType.Bit) { Value = healthExam.isAbnormalFeces }, new SqlParameter("@isAnorexia", SqlDbType.Bit) { Value = healthExam.isAnorexia }, //Neurological status information new SqlParameter("@isNeurologicalNormal", SqlDbType.Bit) { Value = healthExam.isNeurologicalNormal }, new SqlParameter("@isPLRL", SqlDbType.Bit) { Value = healthExam.isPLRL }, new SqlParameter("@isPLRR", SqlDbType.Bit) { Value = healthExam.isPLRR }, new SqlParameter("@isCPLF", SqlDbType.Bit) { Value = healthExam.isCPLF }, new SqlParameter("@isCPRF", SqlDbType.Bit) { Value = healthExam.isCPRF }, new SqlParameter("@isCPLR", SqlDbType.Bit) { Value = healthExam.isCPLR }, new SqlParameter("@isCPRR", SqlDbType.Bit) { Value = healthExam.isCPRR }, new SqlParameter("@isPalpebralL", SqlDbType.Bit) { Value = healthExam.isPalpebralL }, new SqlParameter("@isPalpebralR", SqlDbType.Bit) { Value = healthExam.isPalpebralR }, //Abdomen status information new SqlParameter("@isAbdomenNormal", SqlDbType.Bit) { Value = healthExam.isAbdomenNormal }, new SqlParameter("@isAbnormalMass", SqlDbType.Bit) { Value = healthExam.isAbnormalMass }, new SqlParameter("@isAbdomenPainful", SqlDbType.Bit) { Value = healthExam.isAbdomenPainful }, new SqlParameter("@isBloated", SqlDbType.Bit) { Value = healthExam.isBloated }, new SqlParameter("@isEnlarged", SqlDbType.Bit) { Value = healthExam.isEnlarged }, new SqlParameter("@isFluid", SqlDbType.Bit) { Value = healthExam.isFluid }, new SqlParameter("@isHernia", SqlDbType.Bit) { Value = healthExam.isHernia }, //Urogenital status information new SqlParameter("@isUrogenitalNormal", SqlDbType.Bit) { Value = healthExam.isUrogenitalNormal }, new SqlParameter("@isUrogenAbnormalUrination", SqlDbType.Bit) { Value = healthExam.isUrogenAbnormalUrination }, new SqlParameter("@isGenitalDischarge", SqlDbType.Bit) { Value = healthExam.isGenitalDischarge }, new SqlParameter("@isAnalSacs", SqlDbType.Bit) { Value = healthExam.isAnalSacs }, new SqlParameter("@isRectal", SqlDbType.Bit) { Value = healthExam.isRectal }, new SqlParameter("@isMammaryTumors", SqlDbType.Bit) { Value = healthExam.isMammaryTumors }, new SqlParameter("@isAbnormalTesticles", SqlDbType.Bit) { Value = healthExam.isAbnormalTesticles }, new SqlParameter("@isBloodSeen", SqlDbType.Bit) { Value = healthExam.isBloodSeen }, //Musculoskeletal status information new SqlParameter("@isMusculoskeletalNormal", SqlDbType.Bit) { Value = healthExam.isMusculoskeletalNormal }, new SqlParameter("@isJointProblems", SqlDbType.Bit) { Value = healthExam.isJointProblems }, new SqlParameter("@isNailProblems", SqlDbType.Bit) { Value = healthExam.isNailProblems }, new SqlParameter("@isLamenessLF", SqlDbType.Bit) { Value = healthExam.isLamenessLF }, new SqlParameter("@isLamenessRF", SqlDbType.Bit) { Value = healthExam.isLamenessRF }, new SqlParameter("@isLamenessLR", SqlDbType.Bit) { Value = healthExam.isLamenessLR }, new SqlParameter("@isLamenessRR", SqlDbType.Bit) { Value = healthExam.isLamenessRR }, new SqlParameter("@isLigaments", SqlDbType.Bit) { Value = healthExam.isLigaments }, //Lung status information new SqlParameter("@isLungNormal", SqlDbType.Bit) { Value = healthExam.isLungNormal }, new SqlParameter("@isBreathingDifficulty", SqlDbType.Bit) { Value = healthExam.isBreathingDifficulty }, new SqlParameter("@isRapidRespiration", SqlDbType.Bit) { Value = healthExam.isRapidRespiration }, new SqlParameter("@isTrachealPinchPositive", SqlDbType.Bit) { Value = healthExam.isTrachealPinchPositive }, new SqlParameter("@isTrachealPinchNegative", SqlDbType.Bit) { Value = healthExam.isTrachealPinchNegative }, new SqlParameter("@isCongestion", SqlDbType.Bit) { Value = healthExam.isCongestion }, new SqlParameter("@isAbnormalSound", SqlDbType.Bit) { Value = healthExam.isAbnormalSound }, //Heart status information new SqlParameter("@isHeartNormal", SqlDbType.Bit) { Value = healthExam.isHeartNormal }, new SqlParameter("@isMurMur", SqlDbType.Bit) { Value = healthExam.isMurMur }, new SqlParameter("@isFast", SqlDbType.Bit) { Value = healthExam.isFast }, new SqlParameter("@isSlow", SqlDbType.Bit) { Value = healthExam.isSlow }, new SqlParameter("@isMuffled", SqlDbType.Bit) { Value = healthExam.isMuffled } }; db.Database.ExecuteSqlCommand("uspAddPetVisit @dblWeight, @dblTemperature,@intHeartRate,@intRespRate,@intCapillaryRefillTime,@strMucousMembrane,@intVisitServiceID,@strNotes,@isEyeNormal, @isDischarge, @isInfection,@isSclerosisLeft, @isSclerosisRight, @isCataractLeft, @isCataractRight, @isEyeInflamed, @isEyelidTumor,@isEarNormal,@isEarInflamed,@isEarTumor,@isDirty,@isEarPainful,@isExcessiveHair,@isSkinNormal,@isScaly,@isInfected,@isMatted,@isSkinScrape,@isPruritus,@isHairLoss,@isMass,@isSkinParasites,@isMouthNormal,@isMouthTumor,@isGingivitis,@isPeriodontitis,@isTartarBuildup,@isLooseTeeth,@isBiteOVerUnder,@isNoseThroatNormal,@isLargeLymphNodes,@isInflamedThroat,@isNasalDishcharge,@isInflamedTonsils,@isGINormal,@isExcessiveGas,@isGIParasites,@isAbnormalFeces,@isAnorexia,@isNeurologicalNormal,@isPLRL,@isPLRR,@isCPLF,@isCPRF,@isCPLR,@isCPRR,@isPalpebralL,@isPalpebralR,@isAbdomenNormal, @isAbnormalMass,@isAbdomenPainful,@isBloated, @isEnlarged,@isFluid,@isHernia,@isUrogenitalNormal, @isUrogenAbnormalUrination, @isGenitalDischarge, @isAnalSacs, @isRectal, @isMammaryTumors, @isAbnormalTesticles, @isBloodSeen,@isMusculoskeletalNormal,@isJointProblems,@isNailProblems,@isLamenessLF,@isLamenessRF,@isLamenessLR,@isLamenessRR,@isLigaments,@isLungNormal, @isBreathingDifficulty, @isRapidRespiration,@isTrachealPinchPositive,@isTrachealPinchNegative,@isCongestion,@isAbnormalSound,@isHeartNormal,@isMurMur,@isFast,@isSlow,@isMuffled" , param ); int lastInsertedHealthExamId = db.THealthExams.Max(v => v.intHealthExamID); Session["intHealthExamId"] = lastInsertedHealthExamId; return(RedirectToAction("Index", "VisitServices")); }