private string GetClinicalSummaryData(int ptn_pk, int visitPK, int locationId) { string result = string.Empty; try { IClinicalSummaryForm ipatientClinicalSummary; ipatientClinicalSummary = (IClinicalSummaryForm)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BClinicalSummary, BusinessProcess.Clinical"); ClinicalSummary patientClinicalSummary = ipatientClinicalSummary.GetClinicalSummaryData(ptn_pk, visitPK, locationId); result = SerializerUtil.ConverToJson <ClinicalSummary>(patientClinicalSummary); } catch (Exception ex) { string str = "ptn_pk: " + ptn_pk.ToString() + ",visitPK: " + visitPK.ToString() + ",locationId:" + locationId.ToString(); CLogger.WriteLog(ELogLevel.ERROR, "GetClinicalSummaryData() exception: " + str + "-" + ex.ToString()); ResponseType response = new ResponseType() { Success = EnumUtil.GetEnumDescription(Success.False) }; result = SerializerUtil.ConverToJson <ResponseType>(response); } finally { } return(result); }
public int SaveUpdateClinicalSummaryData(ClinicalSummary obj, int userID) { CLogger.WriteLog(ELogLevel.INFO, "BPatientAdherence.SaveUpdateClinicalSummaryData() method called"); bool flag = true; int visitId = 0; ClsObject clsObjTP = new ClsObject(); try { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, obj.Ptn_pk.ToString()); ClsUtility.AddParameters("@Visit_Id", SqlDbType.Int, obj.Visit_Id.ToString()); ClsUtility.AddParameters("@location_id", SqlDbType.Int, obj.location_id.ToString()); ClsUtility.AddParameters("@Form_filling_date", SqlDbType.Int, obj.Form_filling_date); ClsUtility.AddParameters("@CliniciansName", SqlDbType.VarChar, obj.CliniciansName.ToString()); ClsUtility.AddParameters("@Telephone", SqlDbType.VarChar, obj.Telephone.ToString()); ClsUtility.AddParameters("@Email", SqlDbType.VarChar, obj.Email.ToString()); ClsUtility.AddParameters("@PrimaryReason", SqlDbType.VarChar, obj.PrimaryReason.ToString()); ClsUtility.AddParameters("@ClinicalEvaluation", SqlDbType.VarChar, obj.ClinicalEvaluation.ToString()); ClsUtility.AddParameters("@NumberOfAdherence", SqlDbType.Int, obj.NumberOfAdherence.ToString()); ClsUtility.AddParameters("@NumberOfHomeVisit", SqlDbType.Int, obj.NumberOfHomeVisit.ToString()); ClsUtility.AddParameters("@SupportStructures", SqlDbType.VarChar, obj.SupportStructures.ToString()); ClsUtility.AddParameters("@EvidenceOfAdherence", SqlDbType.VarChar, obj.EvidenceOfAdherence.ToString()); ClsUtility.AddParameters("@NumberOfDOTS", SqlDbType.Int, obj.NumberOfDOTS.ToString()); ClsUtility.AddParameters("@PoorAdherence", SqlDbType.VarChar, obj.PoorAdherence.ToString()); ClsUtility.AddParameters("@EvaluationForOtherText", SqlDbType.VarChar, obj.EvaluationForOtherText.ToString()); ClsUtility.AddParameters("@EvaluationForOtherVal", SqlDbType.VarChar, obj.EvaluationForOtherVal.ToString()); ClsUtility.AddParameters("@CommentOnTreatment", SqlDbType.VarChar, obj.CommentOnTreatment.ToString()); ClsUtility.AddParameters("@HasDrugResistance", SqlDbType.VarChar, obj.HasDrugResistance.ToString()); ClsUtility.AddParameters("@HasFacilityMultidisciplinary", SqlDbType.VarChar, obj.HasFacilityMultidisciplinary.ToString()); ClsUtility.AddParameters("@MDTMembers", SqlDbType.VarChar, obj.MDTMembers.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, userID.ToString()); visitId = (int)clsObjTP.ReturnObject(ClsUtility.theParams, "Pr_SaveUpdateClinicalSummaryData", ClsDBUtility.ObjectEnum.ExecuteNonQuery); return(visitId); } catch (Exception ex) { flag = false; CLogger.WriteLog(ELogLevel.ERROR, "BPatientAdherence.SaveUpdateClinicalSummaryData() Method:" + ex.ToString()); throw ex; } finally { clsObjTP = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
private string SaveUpdateClinicalSummaryData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { ClinicalSummary clinicalsummarydata = SerializerUtil.ConverToObject <ClinicalSummary>(nodeJson); IClinicalSummaryForm iclinicalsummarydata; iclinicalsummarydata = (IClinicalSummaryForm)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BClinicalSummary, BusinessProcess.Clinical"); clinicalsummarydata.Ptn_pk = ptn_pk; clinicalsummarydata.Visit_Id = visitPK; clinicalsummarydata.location_id = locationId; int i = iclinicalsummarydata.SaveUpdateClinicalSummaryData(clinicalsummarydata, userId); //Session["PatientVisitId"] = visitId.ToString(); //this.hidVId.Value = visitId.ToString(); if (i > 0) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { if (ex.Message.ToLower().Contains("visit already exists")) { ObjResponse.ErrorMessage = ex.Message; } ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); CLogger.WriteLog(ELogLevel.ERROR, "SavePatientAdherenceBarriersData() exception: " + ex.ToString()); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
public ClinicalSummary GetClinicalSummaryData(int ptn_pk, int Visit_Id, int LocationID) { // oUtility = new ClsDBUtility(); oUtility.Init_Hashtable(); oUtility.AddParameters("@Ptn_pk", SqlDbType.Int, ConverTotValue.NullToInt(ptn_pk).ToString()); oUtility.AddParameters("@Visit_Id", SqlDbType.Int, ConverTotValue.NullToInt(Visit_Id).ToString()); oUtility.AddParameters("@LocationID", SqlDbType.Int, ConverTotValue.NullToInt(LocationID).ToString()); ClsObject GetRecs = new ClsObject(); DataSet dsClinicalSummary = (DataSet)GetRecs.ReturnObject(oUtility.theParams, "pr_GetClinicalSummaryData", ClsDBUtility.ObjectEnum.DataSet); ClinicalSummary objClinicalSummary = new ClinicalSummary(); try { if (dsClinicalSummary != null) { if (dsClinicalSummary.Tables[0].Rows.Count > 0) { objClinicalSummary.MFLName = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["MFLName"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["MFLName"]) : "0"; objClinicalSummary.PatientEnrollmentID = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["PatientEnrollmentID"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["PatientEnrollmentID"]) : "0"; objClinicalSummary.DOB = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["DOB"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["DOB"]) : "0"; objClinicalSummary.EnrollmentDate = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["EnrollmentDate"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["EnrollmentDate"]) : "0"; objClinicalSummary.Sex = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["Sex"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["Sex"]) : "0"; objClinicalSummary.CurrentWeight = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["CurrentWeight"].ToString()) == false ? Convert.ToDecimal(dsClinicalSummary.Tables[0].Rows[0]["CurrentWeight"]) : 0; objClinicalSummary.CurrentHeight = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["CurrentHeight"].ToString()) == false ? Convert.ToDecimal(dsClinicalSummary.Tables[0].Rows[0]["CurrentHeight"]) : 0; objClinicalSummary.Form_filling_date = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["Form_filling_date"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["Form_filling_date"]) : ""; objClinicalSummary.CliniciansName = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["CliniciansName"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["CliniciansName"]) : "0"; objClinicalSummary.Telephone = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["Telephone"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["Telephone"]) : "0"; objClinicalSummary.Email = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["Email"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["Email"]) : "0"; objClinicalSummary.PrimaryReason = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["PrimaryReason"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["PrimaryReason"]) : "0"; objClinicalSummary.ClinicalEvaluation = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["ClinicalEvaluation"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["ClinicalEvaluation"]) : "0"; objClinicalSummary.NumberOfAdherence = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["NumberOfAdherence"].ToString()) == false ? Convert.ToInt32(dsClinicalSummary.Tables[0].Rows[0]["NumberOfAdherence"]) : 0; objClinicalSummary.NumberOfHomeVisit = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["NumberOfHomeVisit"].ToString()) == false ? Convert.ToInt32(dsClinicalSummary.Tables[0].Rows[0]["NumberOfHomeVisit"]) : 0; objClinicalSummary.SupportStructures = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["SupportStructures"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["SupportStructures"]) : "0"; objClinicalSummary.EvidenceOfAdherence = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["EvidenceOfAdherence"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["EvidenceOfAdherence"]) : "0"; objClinicalSummary.NumberOfDOTS = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["NumberOfDOTS"].ToString()) == false ? Convert.ToInt32(dsClinicalSummary.Tables[0].Rows[0]["NumberOfDOTS"]) : 0; objClinicalSummary.PoorAdherence = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["PoorAdherence"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["PoorAdherence"]) : "0"; objClinicalSummary.EvaluationForOtherText = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["EvaluationForOtherText"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["EvaluationForOtherText"]) : "0"; objClinicalSummary.EvaluationForOtherVal = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["EvaluationForOtherVal"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["EvaluationForOtherVal"]) : "0"; objClinicalSummary.CommentOnTreatment = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["CommentOnTreatment"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["CommentOnTreatment"]) : "0"; objClinicalSummary.HasDrugResistance = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["HasDrugResistance"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["HasDrugResistance"]) : "0"; objClinicalSummary.HasFacilityMultidisciplinary = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["HasFacilityMultidisciplinary"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["HasFacilityMultidisciplinary"]) : "0"; objClinicalSummary.MDTMembers = string.IsNullOrEmpty(dsClinicalSummary.Tables[0].Rows[0]["MDTMembers"].ToString()) == false ? Convert.ToString(dsClinicalSummary.Tables[0].Rows[0]["MDTMembers"]) : "0"; } if (dsClinicalSummary.Tables[1].Rows.Count > 0) { objClinicalSummary.AllARTRegimensLaboratory = new List <ARTRegimensLaboratory>(); foreach (DataRow row in dsClinicalSummary.Tables[1].Rows) { ARTRegimensLaboratory ObjArtRegimen = new ARTRegimensLaboratory(); ObjArtRegimen.Date = Convert.ToString(row["ReportDate"]); ObjArtRegimen.CD4 = Convert.ToString(row["CD4"]); ObjArtRegimen.HB = Convert.ToString(row["HB"]); ObjArtRegimen.EGFR = Convert.ToString(row["GFR"]); ObjArtRegimen.ViralLoad = Convert.ToString(row["ViralLoad"]); objClinicalSummary.AllARTRegimensLaboratory.Add(ObjArtRegimen); } } if (dsClinicalSummary.Tables[2].Rows.Count > 0) { objClinicalSummary.AllRegimenChanges = new List <RegimenChanges>(); foreach (DataRow row in dsClinicalSummary.Tables[2].Rows) { RegimenChanges ObjRegimenChange = new RegimenChanges(); ObjRegimenChange.Date = Convert.ToString(row["Date"]); ObjRegimenChange.Regimen = Convert.ToString(row["Regimen"]); ObjRegimenChange.Switch = Convert.ToString(row["Switch"]); objClinicalSummary.AllRegimenChanges.Add(ObjRegimenChange); } } if (dsClinicalSummary.Tables[3].Rows.Count > 0) { objClinicalSummary.AllOIS = new List <OIS>(); foreach (DataRow row in dsClinicalSummary.Tables[3].Rows) { OIS ObjOIS = new OIS(); ObjOIS.Date = Convert.ToString(row["Date"]); ObjOIS.OISData = Convert.ToString(row["OIS"]); objClinicalSummary.AllOIS.Add(ObjOIS); } } if (dsClinicalSummary.Tables[4].Rows.Count > 0) { objClinicalSummary.AllChronicConditions = new List <ChronicConditions>(); foreach (DataRow row in dsClinicalSummary.Tables[4].Rows) { ChronicConditions ObjChronicConditions = new ChronicConditions(); ObjChronicConditions.Date = Convert.ToString(row["Date"]); ObjChronicConditions.Condition = Convert.ToString(row["Condition"]); objClinicalSummary.AllChronicConditions.Add(ObjChronicConditions); } } if (dsClinicalSummary.Tables[5].Rows.Count > 0) { objClinicalSummary.AllAnthropoemetric = new List <Anthropoemetric>(); foreach (DataRow row in dsClinicalSummary.Tables[5].Rows) { Anthropoemetric ObjChronicConditions = new Anthropoemetric(); ObjChronicConditions.Date = Convert.ToString(row["Date"]); ObjChronicConditions.Height = Convert.ToString(row["Height"]); ObjChronicConditions.Weight = Convert.ToString(row["Weight"]); ObjChronicConditions.BMIZ = Convert.ToString(row["BMIZ"]); objClinicalSummary.AllAnthropoemetric.Add(ObjChronicConditions); } } } } catch (Exception ex) { CLogger.WriteLog(ELogLevel.ERROR, "BClinicalSummary.GetClinicalSummaryData() Method:" + ex.ToString()); } return(objClinicalSummary); }