private string GetPatientAdherenceBarriers(int ptn_pk, int visitPK, int locationId) { string result = string.Empty; try { IPatientAdherence ipatientadherence; ipatientadherence = (IPatientAdherence)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientAdherence, BusinessProcess.Clinical"); PatientAdherenceBarrier patientadherencebarrier = ipatientadherence.GetPatientAdherenceBarriers(ptn_pk, visitPK, locationId); result = SerializerUtil.ConverToJson <PatientAdherenceBarrier>(patientadherencebarrier); } catch (Exception ex) { string str = "ptn_pk: " + ptn_pk.ToString() + ",visitPK: " + visitPK.ToString() + ",locationId:" + locationId.ToString(); CLogger.WriteLog(ELogLevel.ERROR, "GetPatientAdherenceBarriers() exception: " + str + "-" + ex.ToString()); ResponseType response = new ResponseType() { Success = EnumUtil.GetEnumDescription(Success.False) }; result = SerializerUtil.ConverToJson <ResponseType>(response); } finally { } return(result); }
private string SavePatientAdherenceBarriersData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { PatientAdherenceBarrier patientadherencebarrier = SerializerUtil.ConverToObject <PatientAdherenceBarrier>(nodeJson); IPatientAdherence ipatientadherence; ipatientadherence = (IPatientAdherence)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientAdherence, BusinessProcess.Clinical"); patientadherencebarrier.Ptn_Pk = ptn_pk; patientadherencebarrier.Visit_Id = visitPK; patientadherencebarrier.LocationId = locationId; //result = SerializerUtil.ConverToJson<Triage>(triage); bool flag = true; int visitId; flag = ipatientadherence.SaveUpdatePatientAdherenceBarriers(patientadherencebarrier, userId, out visitId); Session["PatientVisitId"] = visitId.ToString(); this.hidVId.Value = visitId.ToString(); if (flag) { 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 bool SaveUpdatePatientAdherenceBarriers(PatientAdherenceBarrier obj, int userId, out int visitId) { CLogger.WriteLog(ELogLevel.INFO, "BPatientAdherence.SaveUpdatePatientAdherenceBarriers() method called"); bool flag = true; visitId = 0; ClsObject clsObjTP = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); clsObjTP.Connection = this.Connection; clsObjTP.Transaction = this.Transaction; 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.LocationId.ToString()); ClsUtility.AddParameters("@AcceptedHIVStatus", SqlDbType.Int, obj.AcceptedHIVStatus.ToString()); ClsUtility.AddParameters("@IsAgeAppropriate", SqlDbType.Int, obj.IsAgeAppropriate.ToString()); ClsUtility.AddParameters("@RiskOfTransmission", SqlDbType.Int, obj.RiskOfTransmission.ToString()); ClsUtility.AddParameters("@UnderstandART", SqlDbType.Int, obj.UnderstandART.ToString()); ClsUtility.AddParameters("@ARTSideEffect", SqlDbType.Int, obj.ARTSideEffect.ToString()); ClsUtility.AddParameters("@AdherenceBenefits", SqlDbType.Int, obj.AdherenceBenefits.ToString()); ClsUtility.AddParameters("@ConsequencesNonAdherence", SqlDbType.Int, obj.ConsequencesNonAdherence.ToString()); ClsUtility.AddParameters("@TypicalDay", SqlDbType.VarChar, obj.TypicalDay.ToString()); ClsUtility.AddParameters("@MedicinesIntake", SqlDbType.VarChar, obj.MedicinesIntake.ToString()); ClsUtility.AddParameters("@TravelVisitDescription", SqlDbType.VarChar, obj.TravelVisitDescription.ToString()); ClsUtility.AddParameters("@PrimartCareGiver", SqlDbType.VarChar, obj.PrimartCareGiver.ToString()); ClsUtility.AddParameters("@LiveWith", SqlDbType.VarChar, obj.LiveWith.ToString()); ClsUtility.AddParameters("@HIVStatusArtDiscussion", SqlDbType.VarChar, obj.HIVStatusArtDiscussion.ToString()); ClsUtility.AddParameters("@SupportSystem", SqlDbType.Int, obj.SupportSystem.ToString()); ClsUtility.AddParameters("@SupportSystemDetails", SqlDbType.VarChar, obj.SupportSystemDetails.ToString()); ClsUtility.AddParameters("@ChangesInRelationship", SqlDbType.VarChar, obj.ChangesInRelationship.ToString()); ClsUtility.AddParameters("@HIVStatusBotherDetails", SqlDbType.VarChar, obj.HIVStatusBotherDetails.ToString()); ClsUtility.AddParameters("@PeopleTreatmentDetails", SqlDbType.VarChar, obj.PeopleTreatmentDetails.ToString()); ClsUtility.AddParameters("@StigmaInterfering", SqlDbType.VarChar, obj.StigmaInterfering.ToString()); ClsUtility.AddParameters("@ReligiousBeliefs", SqlDbType.VarChar, obj.ReligiousBeliefs.ToString()); ClsUtility.AddParameters("@ReferredOtherServices", SqlDbType.Int, obj.ReferredOtherServices.ToString()); ClsUtility.AddParameters("@AppointmentsAttend", SqlDbType.Int, obj.AppointmentsAttend.ToString()); ClsUtility.AddParameters("@ExperienceAppointReorganized", SqlDbType.VarChar, obj.ExperienceAppointReorganized.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, userId.ToString()); DataTable ReturnDT = new DataTable(); ReturnDT = (DataTable)clsObjTP.ReturnObject(ClsUtility.theParams, "Pr_Adherence_UpdatePatientAdherenceBarriers", ClsDBUtility.ObjectEnum.DataTable); DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); visitId = (int)ReturnDT.Rows[0]["VisitId"]; if (visitId > 0) { flag = true; } else { flag = false; } } catch (Exception ex) { flag = false; CLogger.WriteLog(ELogLevel.ERROR, "BPatientAdherence.SaveUpdatePatientAdherenceBarriers() Method:" + ex.ToString()); throw ex; } finally { clsObjTP = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(flag); }
public PatientAdherenceBarrier GetPatientAdherenceBarriers(int ptn_pk, int visitPK, int locationId) { CLogger.WriteLog(ELogLevel.INFO, "BPatientAdherence.GetPatientAdherenceBarriers() Method Called."); PatientAdherenceBarrier patientadherencebarrier = new PatientAdherenceBarrier(); ClsObject clsObjTP = new ClsObject(); try { DataTable dt = new DataTable(); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, ptn_pk.ToString()); ClsUtility.AddParameters("@Visit_Id", SqlDbType.Int, visitPK.ToString()); ClsUtility.AddParameters("@Locationid", SqlDbType.Int, locationId.ToString()); dt = (DataTable)clsObjTP.ReturnObject(ClsUtility.theParams, "Pr_Adherence_GetPatientAdherenceBarriers", ClsDBUtility.ObjectEnum.DataTable); if (dt.Rows.Count > 0) { //string.IsNullOrEmpty(dt.Rows[0]["UserId"].ToString()) == false ? Convert.ToInt32(dt.Rows[0]["UserId"].ToString()) : 0; patientadherencebarrier.PAM_Id = string.IsNullOrEmpty(dt.Rows[0]["PAM_Id"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["PAM_Id"].ToString()) : 0; patientadherencebarrier.Ptn_Pk = string.IsNullOrEmpty(dt.Rows[0]["Ptn_pk"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["Ptn_pk"].ToString()) : 0; patientadherencebarrier.Visit_Id = string.IsNullOrEmpty(dt.Rows[0]["Visit_Id"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["Visit_Id"].ToString()) : 0; patientadherencebarrier.LocationId = string.IsNullOrEmpty(dt.Rows[0]["Location_Id"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["Location_Id"].ToString()) : 0; patientadherencebarrier.AcceptedHIVStatus = string.IsNullOrEmpty(dt.Rows[0]["AcceptedHIVStatus"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["AcceptedHIVStatus"].ToString()) : 0; patientadherencebarrier.IsAgeAppropriate = string.IsNullOrEmpty(dt.Rows[0]["IsAgeAppropriate"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["IsAgeAppropriate"].ToString()) : 0; patientadherencebarrier.RiskOfTransmission = string.IsNullOrEmpty(dt.Rows[0]["RiskOfTransmission"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["RiskOfTransmission"].ToString()) : 0; patientadherencebarrier.UnderstandART = string.IsNullOrEmpty(dt.Rows[0]["UnderstandART"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["UnderstandART"].ToString()) : 0; patientadherencebarrier.ARTSideEffect = string.IsNullOrEmpty(dt.Rows[0]["ARTSideEffect"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["ARTSideEffect"].ToString()) : 0; patientadherencebarrier.AdherenceBenefits = string.IsNullOrEmpty(dt.Rows[0]["AdherenceBenefits"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["AdherenceBenefits"].ToString()) : 0; patientadherencebarrier.ConsequencesNonAdherence = string.IsNullOrEmpty(dt.Rows[0]["ConsequencesNonAdherence"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["ConsequencesNonAdherence"].ToString()) : 0; patientadherencebarrier.TypicalDay = dt.Rows[0]["TypicalDay"].ToString(); patientadherencebarrier.MedicinesIntake = dt.Rows[0]["MedicinesIntake"].ToString(); patientadherencebarrier.TravelVisitDescription = dt.Rows[0]["TravelVisitDescription"].ToString(); patientadherencebarrier.PrimartCareGiver = dt.Rows[0]["PrimartCareGiver"].ToString(); patientadherencebarrier.LiveWith = dt.Rows[0]["LiveWith"].ToString(); patientadherencebarrier.HIVStatusArtDiscussion = dt.Rows[0]["HIVStatusArtDiscussion"].ToString(); patientadherencebarrier.SupportSystem = string.IsNullOrEmpty(dt.Rows[0]["SupportSystem"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["SupportSystem"].ToString()) : 0; patientadherencebarrier.SupportSystemDetails = dt.Rows[0]["SupportSystemDetails"].ToString(); patientadherencebarrier.ChangesInRelationship = dt.Rows[0]["ChangesInRelationship"].ToString(); patientadherencebarrier.HIVStatusBotherDetails = dt.Rows[0]["HIVStatusBotherDetails"].ToString(); patientadherencebarrier.PeopleTreatmentDetails = dt.Rows[0]["PeopleTreatmentDetails"].ToString(); patientadherencebarrier.StigmaInterfering = dt.Rows[0]["StigmaInterfering"].ToString(); patientadherencebarrier.ReligiousBeliefs = dt.Rows[0]["ReligiousBeliefs"].ToString(); patientadherencebarrier.ReferredOtherServices = string.IsNullOrEmpty(dt.Rows[0]["ReferredOtherServices"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["ReferredOtherServices"].ToString()) : 0; patientadherencebarrier.AppointmentsAttend = string.IsNullOrEmpty(dt.Rows[0]["AppointmentsAttend"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["AppointmentsAttend"].ToString()) : 0; patientadherencebarrier.ExperienceAppointReorganized = dt.Rows[0]["ExperienceAppointReorganized"].ToString(); patientadherencebarrier.Total = string.IsNullOrEmpty(dt.Rows[0]["Total"].ToString()) == false?Convert.ToInt32(dt.Rows[0]["Total"].ToString()) : 0; patientadherencebarrier.DepressionSeverity = dt.Rows[0]["DepressionSeverity"].ToString(); patientadherencebarrier.Recommended = dt.Rows[0]["Recommended"].ToString(); /* * patientadherencebarrier = (from row in dt.AsEnumerable() * select new PatientAdherenceBarrier() * { * PAM_Id = row.Field<int>("PAM_Id"), * Ptn_Pk = row.Field<int>("Ptn_pk"), * Visit_Id = row.Field<int>("Visit_Id"), * LocationId = row.Field<int>("Location_Id"), * * AcceptedHIVStatus = row.Field<int>("AcceptedHIVStatus"), * IsAgeAppropriate = row.Field<int>("IsAgeAppropriate"), * RiskOfTransmission = row.Field<int>("RiskOfTransmission"), * UnderstandART = row.Field<int>("UnderstandART"), * ARTSideEffect = row.Field<int>("ARTSideEffect"), * AdherenceBenefits = row.Field<int>("AdherenceBenefits"), * ConsequencesNonAdherence = row.Field<int>("ConsequencesNonAdherence"), * TypicalDay = row.Field<string>("TypicalDay"), * MedicinesIntake = row.Field<string>("MedicinesIntake"), * TravelVisitDescription = row.Field<string>("TravelVisitDescription"), * PrimartCareGiver = row.Field<string>("PrimartCareGiver"), * LiveWith = row.Field<string>("LiveWith"), * HIVStatusArtDiscussion = row.Field<string>("HIVStatusArtDiscussion"), * SupportSystem = row.Field<int?>("SupportSystem"), * SupportSystemDetails = row.Field<string>("SupportSystemDetails"), * ChangesInRelationship = row.Field<string>("ChangesInRelationship"), * HIVStatusBotherDetails = row.Field<string>("HIVStatusBotherDetails"), * PeopleTreatmentDetails = row.Field<string>("PeopleTreatmentDetails"), * StigmaInterfering = row.Field<string>("StigmaInterfering"), * ReligiousBeliefs = row.Field<string>("ReligiousBeliefs"), * ReferredOtherServices = row.Field<int?>("ReferredOtherServices"), * AppointmentsAttend = row.Field<int?>("AppointmentsAttend"), * ExperienceAppointReorganized = row.Field<string>("ExperienceAppointReorganized"), * Total = row.Field<int>("Total"), * DepressionSeverity = row.Field<string>("DepressionSeverity"), * Recommended = row.Field<string>("Recommended") * }).FirstOrDefault(); * */ } } catch (Exception ex) { CLogger.WriteLog(ELogLevel.ERROR, "BPatientAdherence.GetPatientAdherenceBarriers() Method:" + ex.ToString()); } finally { clsObjTP = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(patientadherencebarrier); }