public DataTable IQTouchGetKnhExpressData(BIQTouchExpressFields expressFrmFields) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Flag", SqlDbType.Int, ConverTotValue.NullToInt(expressFrmFields.Flag).ToString()); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, ConverTotValue.NullToInt(expressFrmFields.PtnPk).ToString()); ClsUtility.AddParameters("@LocationId", SqlDbType.Int, ConverTotValue.NullToInt(expressFrmFields.LocationId).ToString()); ClsUtility.AddParameters("@VisitPk", SqlDbType.Int, ConverTotValue.NullToInt(expressFrmFields.ID).ToString()); // ID here Visit PK ClsObject GetRecs = new ClsObject(); DataTable regDT = (DataTable)GetRecs.ReturnObject(ClsUtility.theParams, "Pr_IQTouch_Clinical_GetKNHExpress", ClsDBUtility.ObjectEnum.DataTable); return(regDT); }
protected DataTable GetDataTable(string flag) { BIQTouchExpressFields objExpressFields = new BIQTouchExpressFields(); objExpressFields.Flag = flag; objExpressFields.PtnPk = Convert.ToInt32(Session["PatientID"].ToString()); objExpressFields.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); objExpressFields.ID = 0; IQTouchKNHExpress theExpressManager; theExpressManager = (IQTouchKNHExpress)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BIQTouchKNHExpress, BusinessProcess.Clinical"); DataTable dt = theExpressManager.IQTouchGetKnhExpressData(objExpressFields); return(dt); }
protected void SaveForm() { List <BIQTouchExpressFields> list = new List <BIQTouchExpressFields>(); BIQTouchExpressFields objExpressFields = new BIQTouchExpressFields(); var checkedItemMedicalCondition = rcbmedicalCondition.CheckedItems; var checkedItemTBScreening = rcbTBAassessment.CheckedItems; var checkedItemLabEvaluation = rcbLabEvalution.CheckedItems; try { if (ValidateForm()) { if (Session["Visit_pk"] != null) { objExpressFields.ID = Convert.ToInt32(Session["Visit_pk"]); } // Asigning value to Property Triage Tab objExpressFields.PtnPk = Convert.ToInt32(Session["PatientID"].ToString()); objExpressFields.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); objExpressFields.UserId = Int32.Parse(Session["AppUserId"].ToString()); objExpressFields.ChildAccompaniedByCaregiver = CheckedVaue(btnChildAccompaniedByCaregiver.SelectedToggleState.Text.ToString()); objExpressFields.TreatmentSupporterRelationship = Convert.ToInt32(rcbcareGiverRelationship.SelectedValue.ToString()); objExpressFields.Temperature = Decimal.Parse(txtRadTemperature.Text.ToString()); objExpressFields.RespirationRate = Decimal.Parse(txtRadRespirationRate.Text.ToString()); objExpressFields.HeartRate = Decimal.Parse(txtRadHeartRate.Text.ToString()); objExpressFields.SystolicBloodPressure = Decimal.Parse(txtRadSystollicBloodPressure.Text.ToString()); objExpressFields.DiastolicBloodPressure = Decimal.Parse(txtRadDiastolicBloodPressure.Text.ToString()); objExpressFields.Height = Decimal.Parse(txtRadHeight.Text.ToString()); objExpressFields.Weight = Decimal.Parse(txtRadWeight.Text.ToString()); objExpressFields.MedicalCondition = CheckedVaue(radbtnMedicalCondition.SelectedToggleState.Text.ToString()); objExpressFields.SpecificMedicalCondition = 0; objExpressFields.OnFollowUp = CheckedVaue(radbtnFollowup.SelectedToggleState.Text.ToString()); objExpressFields.LastFollowUpDate = DateGiven(RadDateLastFolowup.DbSelectedDate.ToString()); objExpressFields.PreviousAdmission = CheckedVaue(RadBtnAdmitted.SelectedToggleState.Text.ToString()); objExpressFields.PreviousAdmissionDiagnosis = txtradDiagnosis.Text.ToString(); objExpressFields.PreviousAdmissionStart = DateGiven(RadDateAdmissionDate.DbSelectedDate.ToString()); objExpressFields.PreviousAdmissionEnd = DateGiven(RadDateAdmissionEnd.DbSelectedDate.ToString()); objExpressFields.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); objExpressFields.Signature = Int32.Parse(rcbSignature.SelectedValue.ToString()); // Asigning value top property Clinical assessment //rcbTBAassessment Multi value //SpecifyLabEvaluation Multi value objExpressFields.TBFindings = Int32.Parse(rcbTBFindings.SelectedValue.ToString()); objExpressFields.RegimenPrescribed = Int32.Parse(rcbRegimenPrescribed.SelectedValue.ToString()); objExpressFields.OtherRegimenPrescribed = txtradOtherRegimen.Text.ToString(); objExpressFields.LabEvaluationPeads = CheckedVaue(RadbtnLabEvalution.SelectedToggleState.Text.ToString()); objExpressFields.OIProphylaxis = Int32.Parse(rcbProphylaxis.SelectedValue.ToString()); objExpressFields.OtherOIProphylaxis = txtOtherSpecify.Text.ToString(); objExpressFields.TreatmentPlan = txtTreatmentplan.Text.ToString(); objExpressFields.PwPMessagesGiven = CheckedVaue(radpwpmessagegiven.SelectedToggleState.Text.ToString()); objExpressFields.CondomsIssued = CheckedVaue(radbtnissueCondoms.SelectedToggleState.Text.ToString()); objExpressFields.ReasonfornotIssuingCondoms = txtReasonforCondomNotIssued.Text.ToString(); objExpressFields.IntentionOfPregnancy = CheckedVaue(radbtnPregncyIntfnxtvisit.SelectedToggleState.Text.ToString()); objExpressFields.DiscussedDualContraception = CheckedVaue(radbtnNoDualconta.SelectedToggleState.Text.ToString()); objExpressFields.DiscussedFertilityOption = CheckedVaue(radbtnddiscussferti.SelectedToggleState.Text.ToString()); objExpressFields.OnFP = CheckedVaue(radbtnfpmethord.SelectedToggleState.Text.ToString()); objExpressFields.FPmethod = Int32.Parse(rcbFpMethord.SelectedValue.ToString()); objExpressFields.CervicalCancerScreened = CheckedVaue(radbtncervicalcancer.SelectedToggleState.Text.ToString()); objExpressFields.CervicalCancerScreeningResults = Int32.Parse(rcbCCScreeningResults.SelectedValue.ToString()); objExpressFields.ReferredForCervicalCancerScreening = CheckedVaue(radbtnccscreeningref.SelectedToggleState.Text.ToString()); objExpressFields.Flag = "1"; list.Add(objExpressFields); } // Adding MultiSelect value Pre-Existing Medical Value if (checkedItemMedicalCondition.Count > 0) { foreach (var item in checkedItemMedicalCondition) { BIQTouchExpressFields obj = new BIQTouchExpressFields(); obj.PtnPk = Convert.ToInt32(Session["PatientID"].ToString()); obj.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); obj.UserId = Int32.Parse(Session["AppUserId"].ToString()); obj.MedicalCondition = CheckedVaue(radbtnMedicalCondition.SelectedToggleState.Text.ToString()); obj.SpecificMedicalCondition = Int32.Parse(item.Value); obj.LastFollowUpDate = DateGiven(""); obj.PreviousAdmissionStart = DateGiven(""); obj.PreviousAdmissionEnd = DateGiven(""); obj.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); obj.Flag = "2"; list.Add(obj); } } // Adding MultiSelect value TBScreening if (checkedItemTBScreening.Count > 0) { foreach (var item in checkedItemTBScreening) { BIQTouchExpressFields obj = new BIQTouchExpressFields(); obj.PtnPk = Convert.ToInt32(Session["PatientID"].ToString()); obj.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); obj.UserId = Int32.Parse(Session["AppUserId"].ToString()); obj.TBAssessmentIcf = Int32.Parse(item.Value); obj.LastFollowUpDate = DateGiven(""); obj.PreviousAdmissionStart = DateGiven(""); obj.PreviousAdmissionEnd = DateGiven(""); obj.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); obj.Flag = "2"; list.Add(obj); } } // Adding MultiSelect value LAB Evaluation if (checkedItemLabEvaluation.Count > 0) { foreach (var item in checkedItemLabEvaluation) { BIQTouchExpressFields obj = new BIQTouchExpressFields(); obj.PtnPk = Convert.ToInt32(Session["PatientID"].ToString()); obj.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); obj.UserId = Int32.Parse(Session["AppUserId"].ToString()); obj.LabEvaluationPeads = CheckedVaue(RadbtnLabEvalution.SelectedToggleState.Text.ToString()); obj.SpecifyLabEvaluation = Int32.Parse(item.Value); obj.LastFollowUpDate = DateGiven(""); obj.PreviousAdmissionStart = DateGiven(""); obj.PreviousAdmissionEnd = DateGiven(""); obj.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); obj.Flag = "2"; list.Add(obj); } } IQTouchKNHExpress theExpressManager; theExpressManager = (IQTouchKNHExpress)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BIQTouchKNHExpress, BusinessProcess.Clinical"); int result = theExpressManager.IQTouchSaveExpressDetails(list); if (result > 0) { lblerr.Text = "Record Updated Successfully"; } } catch (Exception ex) { lblerr.Text = ex.Message.ToString(); lblerr.ForeColor = System.Drawing.Color.Red; lblerr.Font.Bold = true; } //finally //{ // lblerr.Text = "Error"; //} }
protected void SaveForm() { List <BIQTouchExpressFields> list = new List <BIQTouchExpressFields>(); BIQTouchExpressFields objExpressFields = new BIQTouchExpressFields(); var checkedItemMedicalCondition = rcbmedicalCondition.CheckedItems; var checkedItemTBScreening = rcbTBAassessment.CheckedItems; var checkedItemLabEvaluation = rcbLabEvalution.CheckedItems; try { if (HiddVisit_pk.Value != "") { objExpressFields.ID = Convert.ToInt32(HiddVisit_pk.Value); } else { objExpressFields.ID = 0; } // Asigning value to Property Triage Tab objExpressFields.PtnPk = Convert.ToInt32(Request.QueryString["PatientID"]); objExpressFields.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); objExpressFields.UserId = Int32.Parse(Session["AppUserId"].ToString()); objExpressFields.ChildAccompaniedByCaregiver = CheckedVaue(btnChildAccompaniedByCaregiver.SelectedToggleState.Text.ToString()); if (btnChildAccompaniedByCaregiver.SelectedToggleState.Text.ToString() == "Yes") { objExpressFields.TreatmentSupporterRelationship = Convert.ToInt32(rcbcareGiverRelationship.SelectedValue.ToString()); } objExpressFields.Temperature = Decimal.Parse(HiddRadTemperature.Value.ToString()); objExpressFields.RespirationRate = Decimal.Parse(HiddRadRespirationRate.Value.ToString()); objExpressFields.HeartRate = Decimal.Parse(HiddRadHeartRate.Value.ToString()); objExpressFields.SystolicBloodPressure = Decimal.Parse(HiddRadSystollicBloodPressure.Value.ToString()); objExpressFields.DiastolicBloodPressure = Decimal.Parse(HiddRadDiastolicBloodPressure.Value.ToString()); objExpressFields.Height = Decimal.Parse(HiddRadHeight.Value.ToString()); objExpressFields.Weight = Decimal.Parse(HiddRadWeight.Value.ToString()); objExpressFields.MedicalCondition = CheckedVaue(radbtnMedicalCondition.SelectedToggleState.Text.ToString()); objExpressFields.SpecificMedicalCondition = 0; objExpressFields.OnFollowUp = CheckedVaue(radbtnFollowup.SelectedToggleState.Text.ToString()); if (radbtnFollowup.SelectedToggleState.Text.ToString() == "Yes") { objExpressFields.LastFollowUpDate = DateGiven(RadDateLastFolowup.DbSelectedDate.ToString()); } else { objExpressFields.LastFollowUpDate = DateGiven(""); } objExpressFields.PreviousAdmission = CheckedVaue(RadBtnAdmitted.SelectedToggleState.Text.ToString()); objExpressFields.PreviousAdmissionDiagnosis = txtradDiagnosis.Text.ToString(); if (RadDateAdmissionDate.DbSelectedDate != null && RadDateAdmissionEnd.DbSelectedDate != null) { objExpressFields.PreviousAdmissionStart = DateGiven(RadDateAdmissionDate.DbSelectedDate.ToString()); objExpressFields.PreviousAdmissionEnd = DateGiven(RadDateAdmissionEnd.DbSelectedDate.ToString()); } else { objExpressFields.PreviousAdmissionStart = DateGiven(""); objExpressFields.PreviousAdmissionEnd = DateGiven(""); } objExpressFields.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); if (rcbSignature.SelectedValue != "") { objExpressFields.Signature = Int32.Parse(rcbSignature.SelectedValue.ToString()); } else { objExpressFields.Signature = 0; } // Asigning value top property Clinical assessment //rcbTBAassessment Multi value //SpecifyLabEvaluation Multi value if (rcbTBFindings.SelectedValue != "") { objExpressFields.TBFindings = Int32.Parse(rcbTBFindings.SelectedValue.ToString()); } if (rcbRegimenPrescribed.SelectedValue != "") { objExpressFields.RegimenPrescribed = Int32.Parse(rcbRegimenPrescribed.SelectedValue.ToString()); } objExpressFields.OtherRegimenPrescribed = txtradOtherRegimen.Text.ToString(); objExpressFields.LabEvaluationPeads = CheckedVaue(RadbtnLabEvalution.SelectedToggleState.Text.ToString()); if (rcbProphylaxis.SelectedValue != "") { objExpressFields.OIProphylaxis = Int32.Parse(rcbProphylaxis.SelectedValue.ToString()); } objExpressFields.OtherOIProphylaxis = txtOtherSpecify.Text.ToString(); objExpressFields.TreatmentPlan = txtTreatmentplan.Text.ToString(); objExpressFields.PwPMessagesGiven = CheckedVaue(radpwpmessagegiven.SelectedToggleState.Text.ToString()); objExpressFields.CondomsIssued = CheckedVaue(radbtnissueCondoms.SelectedToggleState.Text.ToString()); objExpressFields.ReasonfornotIssuingCondoms = txtReasonforCondomNotIssued.Text.ToString(); objExpressFields.IntentionOfPregnancy = CheckedVaue(radbtnPregncyIntfnxtvisit.SelectedToggleState.Text.ToString()); objExpressFields.DiscussedDualContraception = CheckedVaue(radbtnNoDualconta.SelectedToggleState.Text.ToString()); objExpressFields.DiscussedFertilityOption = CheckedVaue(radbtnddiscussferti.SelectedToggleState.Text.ToString()); objExpressFields.OnFP = CheckedVaue(radbtnfpmethord.SelectedToggleState.Text.ToString()); if (radbtnfpmethord.SelectedToggleState.Text.ToString() == "Yes") { objExpressFields.FPmethod = Int32.Parse(rcbFpMethord.SelectedValue.ToString()); } objExpressFields.CervicalCancerScreened = CheckedVaue(radbtncervicalcancer.SelectedToggleState.Text.ToString()); if (radbtncervicalcancer.SelectedToggleState.Text.ToString() == "Yes") { objExpressFields.CervicalCancerScreeningResults = Int32.Parse(rcbCCScreeningResults.SelectedValue.ToString()); } objExpressFields.ReferredForCervicalCancerScreening = CheckedVaue(radbtnccscreeningref.SelectedToggleState.Text.ToString()); objExpressFields.Flag = "1"; list.Add(objExpressFields); // Adding MultiSelect value Pre-Existing Medical Value if (checkedItemMedicalCondition.Count > 0 && radbtnMedicalCondition.SelectedToggleState.Text.ToString() == "Yes") { foreach (var item in checkedItemMedicalCondition) { BIQTouchExpressFields obj = new BIQTouchExpressFields(); obj.PtnPk = Convert.ToInt32(Request.QueryString["PatientID"]); obj.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); obj.UserId = Int32.Parse(Session["AppUserId"].ToString()); obj.MedicalCondition = CheckedVaue(radbtnMedicalCondition.SelectedToggleState.Text.ToString()); obj.SpecificMedicalCondition = Int32.Parse(item.Value); obj.LastFollowUpDate = DateGiven(""); obj.PreviousAdmissionStart = DateGiven(""); obj.PreviousAdmissionEnd = DateGiven(""); obj.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); obj.Flag = "2"; obj.ID = objExp.ID; list.Add(obj); } } // Adding MultiSelect value TBScreening if (checkedItemTBScreening.Count > 0) { foreach (var item in checkedItemTBScreening) { BIQTouchExpressFields obj = new BIQTouchExpressFields(); obj.PtnPk = Convert.ToInt32(Session["PatientID"].ToString()); obj.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); obj.UserId = Int32.Parse(Session["AppUserId"].ToString()); obj.TBAssessmentIcf = Int32.Parse(item.Value); obj.LastFollowUpDate = DateGiven(""); obj.PreviousAdmissionStart = DateGiven(""); obj.PreviousAdmissionEnd = DateGiven(""); obj.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); obj.Flag = "2"; obj.ID = objExp.ID; list.Add(obj); } } // Adding MultiSelect value LAB Evaluation if (checkedItemLabEvaluation.Count > 0 && RadbtnLabEvalution.SelectedToggleState.Text.ToString() == "Yes") { foreach (var item in checkedItemLabEvaluation) { BIQTouchExpressFields obj = new BIQTouchExpressFields(); obj.PtnPk = Convert.ToInt32(Request.QueryString["PatientID"]); obj.LocationId = Int32.Parse(Session["AppLocationId"].ToString()); obj.UserId = Int32.Parse(Session["AppUserId"].ToString()); obj.LabEvaluationPeads = CheckedVaue(RadbtnLabEvalution.SelectedToggleState.Text.ToString()); obj.SpecifyLabEvaluation = Int32.Parse(item.Value); obj.LastFollowUpDate = DateGiven(""); obj.PreviousAdmissionStart = DateGiven(""); obj.PreviousAdmissionEnd = DateGiven(""); obj.VisitDate = DateGiven(dtVisit.DbSelectedDate.ToString()); obj.Flag = "2"; obj.ID = objExp.ID; list.Add(obj); } } IQTouchKNHExpress theExpressManager; theExpressManager = (IQTouchKNHExpress)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BIQTouchKNHExpress, BusinessProcess.Clinical"); int result = theExpressManager.IQTouchSaveExpressDetails(list); if (result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "saveSuc", "alert('Form saved successfully')", true); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "goBack", "BackBtnClick();", true); } } catch (Exception ex) { IsError = true; } if (IsError) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "saveFail", "alert('An errror occured please contact your Administrator')", true); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "clsLoadingPanelDueToError", "parent.CloseLoading();", true); } }