private string SaveData(string nodeJson, int ptn_pk) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.TreatmentPreparation treatmentpreparation = SerializerUtil.ConverToObject <HIVCE.Common.Entities.TreatmentPreparation>(nodeJson); BLTreatmentPreparation blTP = new BLTreatmentPreparation(); treatmentpreparation.Ptn_pk = ptn_pk; bool flag = blTP.SaveUpdateTreatmentPreparation(treatmentpreparation); if (flag) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveData(string nodeJson, int ptn_pk, int visitPK) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.ARTReadinessAssessment treatmentpreparation = SerializerUtil.ConverToObject <HIVCE.Common.Entities.ARTReadinessAssessment>(nodeJson); IARTReadinessAssessment blObj = (IARTReadinessAssessment)ObjectFactory.CreateInstance("HIVCE.BusinessLayer.BLARTReadinessAssessment, HIVCE.BusinessLayer"); treatmentpreparation.Ptn_pk = ptn_pk; treatmentpreparation.Visit_Id = visitPK; bool flag = blObj.SaveUpdateARTReadinessAssessment(treatmentpreparation); if (flag) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { ObjResponse.ErrorMessage = ex.Message; ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SavePresentingComplaintsData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.PresentingComplaint obj = SerializerUtil.ConverToObject <HIVCE.Common.Entities.PresentingComplaint>(nodeJson); BLClinicalEncounter blTP = new BLClinicalEncounter(); obj.Ptn_pk = ptn_pk; obj.Visit_Id = visitPK; obj.LocationId = locationId; bool flag = blTP.SaveUpdatePresentingComplaintsData(obj, userId, locationId); if (flag) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveData(string nodeJson, int ptn_pk, int visitPK) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.AlcoholDepressionScreeningObj adcObj = SerializerUtil.ConverToObject <HIVCE.Common.Entities.AlcoholDepressionScreeningObj>(nodeJson); IAlcoholDepressionScreening blObj = (IAlcoholDepressionScreening)ObjectFactory.CreateInstance("HIVCE.BusinessLayer.BLAlcoholDepressionScreening, HIVCE.BusinessLayer"); adcObj.Ptn_pk = ptn_pk; adcObj.Visit_Id = visitPK; bool flag = blObj.SaveUpdateAlcoholDepressionScreening(adcObj); if (flag) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveData(string nodeJson, int ptn_pk, int visitPK) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { MAdherence adcObj = SerializerUtil.ConverToObject <MAdherence>(nodeJson); IClinicalEncounter blObj = (IClinicalEncounter)ObjectFactory.CreateInstance("HIVCE.BusinessLayer.BLClinicalEncounter, HIVCE.BusinessLayer"); adcObj.Ptn_pk = ptn_pk; adcObj.Visit_Id = visitPK; int flag = blObj.SaveUpdateMoriskyData(adcObj, ptn_pk, visitPK, userId, locationId, DateTime.Now); if (flag == 1) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveManagementxData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.ManagementDB obj = SerializerUtil.ConverToObject <HIVCE.Common.Entities.ManagementDB>(nodeJson); IClinicalEncounter clinicalencounter = (IClinicalEncounter)ObjectFactory.CreateInstance("HIVCE.BusinessLayer.BLClinicalEncounter, HIVCE.BusinessLayer"); obj.Ptn_pk = ptn_pk; obj.Visit_Id = visitPK; obj.LocationId = locationId; bool flag = clinicalencounter.SaveUpdateManagementxData(obj, userId, locationId); if (flag) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } } catch (Exception ex) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveSession(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId, int sessionId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { PatientAdherenceCounseling patientAdherenceCounselling = SerializerUtil.ConverToObject <PatientAdherenceCounseling>(nodeJson); IPatientAdherence ipatientadherence; ipatientadherence = (IPatientAdherence)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPatientAdherence,BusinessProcess.Clinical"); patientAdherenceCounselling.Ptn_Pk = ptn_pk; patientAdherenceCounselling.Visit_Id = visitPK; patientAdherenceCounselling.LocationId = locationId; patientAdherenceCounselling.CurrentSession = sessionId; bool flag = true; int visitId = 0; visitId = ipatientadherence.SaveUpdateEnhanceAdherenceCounsellingSessions(patientAdherenceCounselling, userId); if (visitId > 0) { flag = true; } else { flag = false; } 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); }
private string SavePrEPTriage(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { Entities.Common.PrEPTriage triage = SerializerUtil.ConverToObject <Entities.Common.PrEPTriage>(nodeJson); IPrEP iPrep = (IPrEP)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPrEP, BusinessProcess.Clinical"); triage.Ptn_pk = ptn_pk; triage.LocationId = locationId; triage.Visit_Id = visitPK; //result = SerializerUtil.ConverToJson<Triage>(triage); int flag = 0; int visitId; flag = iPrep.SaveUpdatePrEPTriage(triage, visitPK, locationId, userId); Session["PatientVisitId"] = visitPK.ToString(); this.hidVId.Value = visitPK.ToString(); if (flag != 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); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveRefillEncounterData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.RefillEncounterDB obj = SerializerUtil.ConverToObject <HIVCE.Common.Entities.RefillEncounterDB>(nodeJson); IClinicalEncounter clinicalencounter = (IClinicalEncounter)ObjectFactory.CreateInstance("HIVCE.BusinessLayer.BLClinicalEncounter, HIVCE.BusinessLayer"); obj.Ptn_pk = ptn_pk; obj.Visit_Id = visitPK; obj.LocationId = locationId; bool flag = clinicalencounter.SaveRefillEncounterData(obj, userId, locationId); if (flag) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.True); } else { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } try { IinitialFollowupVisit tbscreenManager = (IinitialFollowupVisit)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BInitialFollowupVisit, BusinessProcess.Clinical"); tbscreenManager.SaveTBScreeningDetails(ptn_pk, visitPK, null, Convert.ToInt32(ddlTBFindings.SelectedItem.Value), locationId, userId); } catch { } } catch (Exception ex) { if (ex.Message.ToLower().Contains("visit already exists")) { ObjResponse.ErrorMessage = ex.Message; } ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveProfileData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { Entities.Common.ANC anc = SerializerUtil.ConverToObject <Entities.Common.ANC>(nodeJson); IKNHMEI iknhmei = (IKNHMEI)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BKNHMEI, BusinessProcess.Clinical"); anc.Ptn_pk = ptn_pk; anc.Visit_Id = visitPK; anc.LocationId = locationId; //result = SerializerUtil.ConverToJson<Triage>(triage); bool flag = true; int visitId; flag = iknhmei.SaveUpdateProfile(anc, userId, locationId, 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); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
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); }
private string SaveInitiationData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { Entities.Common.PrEPInitiation PrEPdata = SerializerUtil.ConverToObject <Entities.Common.PrEPInitiation>(nodeJson); IPrEP iPrEPdata; iPrEPdata = (IPrEP)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BPrEP, BusinessProcess.Clinical"); PrEPdata.Ptn_pk = ptn_pk; PrEPdata.Visit_Id = visitPK; PrEPdata.LocationId = locationId; int i = iPrEPdata.SaveUpdatePrEPInitiationData(PrEPdata, userId, visitPK, locationId); //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, "SaveUpdatePrEPInitiationData() exception: " + ex.ToString()); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
private string SaveTriageData(string nodeJson, int ptn_pk, int visitPK, int locationId, int userId) { string result = string.Empty; ResponseType ObjResponse = new ResponseType(); try { HIVCE.Common.Entities.Triage triage = SerializerUtil.ConverToObject <HIVCE.Common.Entities.Triage>(nodeJson); IClinicalEncounter clinicalencounter = (IClinicalEncounter)ObjectFactory.CreateInstance("HIVCE.BusinessLayer.BLClinicalEncounter, HIVCE.BusinessLayer"); triage.Ptn_pk = ptn_pk; triage.Visit_Id = visitPK; triage.LocationId = locationId; //result = SerializerUtil.ConverToJson<Triage>(triage); bool flag = true; int visitId; flag = clinicalencounter.SaveUpdateTriage(triage, 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) { ObjResponse.Success = EnumUtil.GetEnumDescription(Success.False); } finally { } result = SerializerUtil.ConverToJson <ResponseType>(ObjResponse); return(result); }
public bool SaveClientIntakeFormData(string nodeJson, int patientID, int UserID) { //return true; CLogger.WriteLog(ELogLevel.INFO, "HTSClientIntakeForm SaveClientIntakeFormData() method called"); bool flag = true; HTSClientIntake obj = SerializerUtil.ConverToObject <HTSClientIntake>(nodeJson); //DataTable dt = new DataTable(); ClsObject clsObjTP = new ClsObject(); try { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@PatientID ", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@CIFID ", SqlDbType.Int, obj.CIFID.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@PatientCode", SqlDbType.VarChar, obj.PatientCode.ToString()); ClsUtility.AddParameters("@FirstTimeVisit", SqlDbType.Int, obj.FirstTimeVisit.ToString()); ClsUtility.AddParameters("@StateOfResidence ", SqlDbType.Int, obj.PatientState.ToString()); ClsUtility.AddParameters("@LGAOfResidence ", SqlDbType.Int, obj.PatientLga.ToString()); ClsUtility.AddParameters("@TypeOfSession ", SqlDbType.Int, obj.TypeOfSession.ToString()); ClsUtility.AddParameters("@ClientIndexID ", SqlDbType.VarChar, obj.IndexClientID.ToString()); ClsUtility.AddParameters("@IsClientIsIndex", SqlDbType.Int, obj.IsClientIsIndex.ToString()); ClsUtility.AddParameters("@IndexTestingType", SqlDbType.Int, obj.IndexTestingType.ToString()); ClsUtility.AddParameters("@PrevTestedHIVNeg", SqlDbType.Int, obj.PrevTestedHivNeg.ToString()); ClsUtility.AddParameters("@ClientPreg", SqlDbType.Int, obj.ClientPregnant.ToString()); ClsUtility.AddParameters("@InformHivTransRiskFactor", SqlDbType.Int, obj.InformHivTransRiskFactor.ToString()); ClsUtility.AddParameters("@InformHivTransRoute", SqlDbType.Int, obj.InformHivTransRoute.ToString()); ClsUtility.AddParameters("@InformHivTransMethod", SqlDbType.Int, obj.InformHivTransMethod.ToString()); ClsUtility.AddParameters("@InformHivPossiResults", SqlDbType.Int, obj.InformHivPossiResults.ToString()); ClsUtility.AddParameters("@InformConsentHIVTesting", SqlDbType.Int, obj.InformConsentHIVTesting.ToString()); ClsUtility.AddParameters("@EvrHadSex", SqlDbType.Int, obj.EvrHadSex.ToString()); ClsUtility.AddParameters("@BlodTransIn3Mnth", SqlDbType.Int, obj.BlodTransIn3Mnth.ToString()); ClsUtility.AddParameters("@SexWithCasPartnr", SqlDbType.Int, obj.SexWithCasPartnr.ToString()); ClsUtility.AddParameters("@SexWithRegPartnr", SqlDbType.Int, obj.SexWithRegPartnr.ToString()); ClsUtility.AddParameters("@LastStiDone", SqlDbType.Int, obj.LastStiDone.ToString()); ClsUtility.AddParameters("@OnceAMonthSex", SqlDbType.Int, obj.OnceAMonthSex.ToString()); ClsUtility.AddParameters("@CurrentCough", SqlDbType.Int, obj.CurrentCough.ToString()); ClsUtility.AddParameters("@WeightLoss", SqlDbType.Int, obj.WeightLoss.ToString()); ClsUtility.AddParameters("@Fever", SqlDbType.Int, obj.Fever.ToString()); ClsUtility.AddParameters("@NightSweats", SqlDbType.Int, obj.NightSweats.ToString()); ClsUtility.AddParameters("@FemaleVaginalDischarge", SqlDbType.Int, obj.FemaleVaginalDischarge.ToString()); ClsUtility.AddParameters("@FemaleAbdominalPain", SqlDbType.Int, obj.FemaleAbdominalPain.ToString()); ClsUtility.AddParameters("@MaleUrethalDischarge", SqlDbType.Int, obj.MaleUrethalDischarge.ToString()); ClsUtility.AddParameters("@MaleScrotalSweling", SqlDbType.Int, obj.MaleScrotalSweling.ToString()); ClsUtility.AddParameters("@GenitalSore", SqlDbType.Int, obj.GenitalSore.ToString()); ClsUtility.AddParameters("@InitialHivTest", SqlDbType.Int, obj.InitialHivTest.ToString()); ClsUtility.AddParameters("@ConfirmatoryHivTest", SqlDbType.Int, obj.ConfirmatoryHivTest.ToString()); ClsUtility.AddParameters("@SyphilisTest", SqlDbType.Int, obj.SyphilisTest.ToString()); ClsUtility.AddParameters("@HepatitisB", SqlDbType.Int, obj.HepatitisB.ToString()); ClsUtility.AddParameters("@HepatitisC", SqlDbType.Int, obj.HepatitisC.ToString()); ClsUtility.AddParameters("@HivTestResult", SqlDbType.Int, obj.HivTestResult.ToString()); ClsUtility.AddParameters("@NotPrevTested", SqlDbType.Int, obj.NotPrevTested.ToString()); ClsUtility.AddParameters("@PrevTestNeg", SqlDbType.Int, obj.PrevTestNeg.ToString()); ClsUtility.AddParameters("@PrevTestPosInHivCare", SqlDbType.Int, obj.PrevTestPosInHivCare.ToString()); ClsUtility.AddParameters("@PrevTestPosNotInHivCare", SqlDbType.Int, obj.PrevTestPosNotInHivCare.ToString()); ClsUtility.AddParameters("@HivReqResFormSigned", SqlDbType.Int, obj.HIVReqResFormSigned.ToString()); ClsUtility.AddParameters("@HivReqResFormWithCi", SqlDbType.Int, obj.HIVReqResFormWithCI.ToString()); ClsUtility.AddParameters("@ClientRecHivTestResult", SqlDbType.Int, obj.ClientRecHivTestResult.ToString()); ClsUtility.AddParameters("@PostTestConslDone", SqlDbType.Int, obj.PostTestConslDone.ToString()); ClsUtility.AddParameters("@RiskReducPlan", SqlDbType.Int, obj.RiskReducPlan.ToString()); ClsUtility.AddParameters("@PostTestDiscloPlan", SqlDbType.Int, obj.PostTestDiscloPlan.ToString()); ClsUtility.AddParameters("@BringPartForHivTest", SqlDbType.Int, obj.BringPartForHIVTest.ToString()); ClsUtility.AddParameters("@BrngChildForHivTest", SqlDbType.Int, obj.BrngChildForHivTest.ToString()); ClsUtility.AddParameters("@FPAndDualConcInfo", SqlDbType.Int, obj.FPAndDualConcInfo.ToString()); ClsUtility.AddParameters("@PartnerUseFPMethd", SqlDbType.Int, obj.PartnerUseFPMethd.ToString()); ClsUtility.AddParameters("@PrntUseCondomAsFPM", SqlDbType.Int, obj.PrntUseCondomAsFPM.ToString()); ClsUtility.AddParameters("@CondomUseDemo", SqlDbType.Int, obj.CondomUseDemo.ToString()); ClsUtility.AddParameters("@CondomsProvided", SqlDbType.Int, obj.CondomsProvided.ToString()); ClsUtility.AddParameters("@ClientRefferedToOther", SqlDbType.Int, obj.ClientRefferedToOther.ToString()); ClsUtility.AddParameters("@SyphilisTestResults", SqlDbType.Int, obj.SyphilisTestResults.ToString()); ClsUtility.AddParameters("@RequestedBy", SqlDbType.Int, obj.RequestedBy.ToString()); ClsUtility.AddParameters("@TestedBy", SqlDbType.Int, obj.TestedBy.ToString()); ClsUtility.AddParameters("@CheckedBy", SqlDbType.Int, obj.CheckedBy.ToString()); ClsUtility.AddParameters("@RequestedDate", SqlDbType.DateTime, obj.RequestedDate.ToString()); ClsUtility.AddParameters("@TestedDate", SqlDbType.DateTime, obj.TestedDate.ToString()); ClsUtility.AddParameters("@CheckedDate", SqlDbType.DateTime, obj.CheckedDate.ToString()); ClsUtility.AddParameters("@ReferredFrom ", SqlDbType.Int, obj.ReferFrom.ToString()); ClsUtility.AddParameters("@Setting ", SqlDbType.Int, obj.Setting.ToString()); ClsUtility.AddParameters("@NoOfChildLessThan5 ", SqlDbType.Int, obj.NoOfChildLessThan5.ToString()); ClsUtility.AddParameters("@NoOfWives", SqlDbType.Int, obj.NoOfWives.ToString()); ClsUtility.AddParameters("@DateOfVisit", SqlDbType.DateTime, obj.DateOfVisit.ToString()); ClsUtility.AddParameters("@Comments", SqlDbType.VarChar, obj.Comments); ClsUtility.AddParameters("@PatientMaritalStat", SqlDbType.Int, obj.PatientMaritalStat.ToString()); DataTable dt = (DataTable)clsObjTP.ReturnObject(ClsUtility.theParams, "pr_UpdateHTSClientIntakeForPatient", ClsDBUtility.ObjectEnum.DataTable); } catch (Exception ex) { throw ex; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(flag); }