public int Save_Update_ARVTherapy(int patientID, int VisitID, int LocationID, Hashtable ht, int userID, int DataQualityFlag, DataTable theCustomFieldData) { int retval = 0; ClsObject FollowupManager = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); FollowupManager.Connection = this.Connection; FollowupManager.Transaction = this.Transaction; oUtility.Init_Hashtable(); oUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); oUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); oUtility.AddParameters("@Visit_ID", SqlDbType.Int, VisitID.ToString()); oUtility.AddParameters("@ARVDateEligible", SqlDbType.DateTime, ht["DateEligible"].ToString()); oUtility.AddParameters("@ARVEligibleThrough", SqlDbType.Int, ht["EligibleThru"].ToString()); oUtility.AddParameters("@EligibleWHOStage", SqlDbType.Int, ht["WHOStage"].ToString()); oUtility.AddParameters("@EligibleCD4", SqlDbType.VarChar, ht["CD4"].ToString()); oUtility.AddParameters("@EligibleCD4percent", SqlDbType.VarChar, ht["CD4Percent"].ToString()); oUtility.AddParameters("@ARVCohortMonth", SqlDbType.VarChar, ht["CohortMonth"].ToString()); oUtility.AddParameters("@ARVCohortYear", SqlDbType.Int, ht["CohortYear"].ToString()); oUtility.AddParameters("@AnotherRegimenStartDate", SqlDbType.DateTime, ht["AnotherRegimenStartDate"].ToString()); oUtility.AddParameters("@AnotherRegimen", SqlDbType.VarChar, ht["AnotherRegimen"].ToString()); oUtility.AddParameters("@AnotherWeight", SqlDbType.VarChar, ht["AnotherWeight"].ToString()); oUtility.AddParameters("@AnotherHeight", SqlDbType.VarChar, ht["AnotherHeight"].ToString()); oUtility.AddParameters("@AnotherWHOStage", SqlDbType.Int, ht["AnotherClinicalStage"].ToString()); oUtility.AddParameters("@dataquality", SqlDbType.Int, DataQualityFlag.ToString()); oUtility.AddParameters("@UserId", SqlDbType.Int, userID.ToString()); DataTable retvalother = (DataTable)FollowupManager.ReturnObject(oUtility.theParams, "pr_Clinical_SaveUpdateARVTherapy_Futures", ClsUtility.ObjectEnum.DataTable); for (Int32 i = 0; i < theCustomFieldData.Rows.Count; i++) { oUtility.Init_Hashtable(); string theQuery = theCustomFieldData.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", patientID.ToString()); theQuery = theQuery.Replace("#88#", LocationID.ToString()); theQuery = theQuery.Replace("#77#", retvalother.Rows[0]["Visit_ID"].ToString()); // theQuery = theQuery.Replace("#66#", "02/06/2013"); theQuery = theQuery.Replace("#66#", "'" + ht["visitdate"].ToString() + "'"); oUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)FollowupManager.ReturnObject(oUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery); } //////////////////////////////// DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(retval); }
public int SaveFormDetail(DataSet dsSaveFormData, DataTable dtFieldDetails, DataTable dtbusinessRules, DataSet DSFormVer) { //try //{ this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject FormDetail = new ClsObject(); FormDetail.Connection = this.Connection; FormDetail.Transaction = this.Transaction; int theRowAffected = 0; DataRow theDR; int iFeatureId; int iRegFlag; string Pharmacy = ""; string FeatureName = ""; int iSectionId; string strTableName = string.Empty; //save mst_feature data oUtility.Init_Hashtable(); if (dsSaveFormData.Tables[0].Rows[0]["InsertUpdateStatus"].ToString() == "I") { oUtility.AddParameters("@FeatureId", SqlDbType.Int, "0"); } else { oUtility.AddParameters("@FeatureId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["FeatureId"].ToString()); } oUtility.AddParameters("@FeatureName", SqlDbType.VarChar, dsSaveFormData.Tables[0].Rows[0]["FeatureName"].ToString().Replace("'", "")); oUtility.AddParameters("@ReportFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["ReportFlag"].ToString()); oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["DeleteFlag"].ToString()); oUtility.AddParameters("@AdminFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["AdminFlag"].ToString()); //oUtility.AddParameters("@OptionalFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["OptionalFlag"].ToString()); oUtility.AddParameters("@SystemId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["SystemId"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["UserID"].ToString()); oUtility.AddParameters("@Published", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["Published"].ToString()); oUtility.AddParameters("@CountryId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["CountryId"].ToString()); oUtility.AddParameters("@ModuleId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["ModuleId"].ToString()); oUtility.AddParameters("@MultiVisit", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["MultiVisit"].ToString()); //theDR = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_PMTCT_SaveMstFeature_Futures", ClsUtility.ObjectEnum.DataRow); theDR = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveMstFeature_Futures", ClsUtility.ObjectEnum.DataRow); iFeatureId = System.Convert.ToInt32(theDR[0].ToString()); iRegFlag = System.Convert.ToInt32(theDR[2].ToString()); Pharmacy = theDR[1].ToString(); if (iFeatureId != 0) { if (dtbusinessRules.Rows.Count == 0) { oUtility.Init_Hashtable(); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@BusRuleid", SqlDbType.Int, "1"); oUtility.AddParameters("@value", SqlDbType.Int, "1"); oUtility.AddParameters("@value1", SqlDbType.Int, "1"); oUtility.AddParameters("@UserID", SqlDbType.Int, "1"); oUtility.AddParameters("@setType", SqlDbType.Int, "1"); oUtility.AddParameters("@counter", SqlDbType.Int, "0"); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "pr_FormBuilder_DeleteFormBusinessRules", ClsUtility.ObjectEnum.ExecuteNonQuery); } for (int i = 0; i < dtbusinessRules.Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@BusRuleid", SqlDbType.Int, dtbusinessRules.Rows[i]["BusRuleId"].ToString()); oUtility.AddParameters("@value", SqlDbType.Int, dtbusinessRules.Rows[i]["Value"].ToString()); oUtility.AddParameters("@value1", SqlDbType.Int, dtbusinessRules.Rows[i]["Value1"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["UserID"].ToString()); oUtility.AddParameters("@setType", SqlDbType.Int, dtbusinessRules.Rows[i]["SetType"].ToString()); oUtility.AddParameters("@counter", SqlDbType.Int, i.ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "pr_FormBuilder_SaveUpdateFormBusinessRules", ClsUtility.ObjectEnum.ExecuteNonQuery); } } string[] strFeatureName = new string[10]; strFeatureName = dsSaveFormData.Tables[0].Rows[0]["FeatureName"].ToString().Split(' '); for (int j = 0; j < strFeatureName.Length; j++) { if (j > 0) { strTableName += "_" + strFeatureName[j]; } else { strTableName += strFeatureName[j]; } } FeatureName = strTableName; strTableName = "DTL_FBCUSTOMFIELD_" + strTableName; //save mst_section data //foreach (DataRow drFormData in dsSaveFormData.Tables[1]) for (int i = 0; i < dsSaveFormData.Tables[1].Rows.Count; i++) { if (dsSaveFormData.Tables[1].Rows[i]["DeleteFlag"].ToString() == "0") { oUtility.Init_Hashtable(); oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["SectionId"].ToString()); oUtility.AddParameters("@SectionName", SqlDbType.VarChar, dsSaveFormData.Tables[1].Rows[i]["SectionName"].ToString()); oUtility.AddParameters("@Seq", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["Sequence"].ToString()); oUtility.AddParameters("@CustomFlag", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["CustomFlag"].ToString()); oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["DeleteFlag"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["UserId"].ToString()); //oUtility.AddParameters("@FeatureId", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["FeatureId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@IsGridView", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["IsGridView"].ToString()); //theDR = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_PMTCT_SaveMstSection_Futures", ClsUtility.ObjectEnum.DataRow); theDR = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveMstSection_Futures", ClsUtility.ObjectEnum.DataRow); } } //save lnk_form data //foreach (DataRow drFormData in dsSaveFormData.Tables[2]) for (int i = 0; i < dsSaveFormData.Tables[2].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@Id", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Id"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); //oUtility.AddParameters("@FeatureId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FeatureId"].ToString()); if (Pharmacy.Contains("Pharmacy_") && iRegFlag == 2 && Convert.ToInt32(dsSaveFormData.Tables[2].Rows[i]["SectionId"]) == 0) { oUtility.AddParameters("@SectionId", SqlDbType.Int, theDR[0].ToString()); } else { oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["SectionId"].ToString()); } oUtility.AddParameters("@FieldId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString()); oUtility.AddParameters("@FieldLabel", SqlDbType.VarChar, dsSaveFormData.Tables[2].Rows[i]["FieldLabel"].ToString()); oUtility.AddParameters("@Seq", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Sequence"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["UserId"].ToString()); oUtility.AddParameters("@Predefined", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString()); //theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_PMTCT_SaveLnkForm_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveLnkForm_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); DataView dvFilteredRow = new DataView(); dvFilteredRow = dtFieldDetails.DefaultView; DataTable dtRow = new DataTable(); if (dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString() == "71" && dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString() == "1") { dvFilteredRow.RowFilter = "ID='71' and predefine=" + dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString(); } else { dvFilteredRow.RowFilter = "ID='" + dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString() + "' and predefine=" + dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString(); } dtRow = dvFilteredRow.ToTable(); /* ----------Added by Paritosh -Implementing Grid View------------*/ DataView dvFilteredRowGridView = new DataView(); dvFilteredRowGridView = dsSaveFormData.Tables[1].DefaultView; dvFilteredRowGridView.RowFilter = "SectionId = " + dsSaveFormData.Tables[2].Rows[i]["SectionId"].ToString(); if (dvFilteredRowGridView[0]["IsGridView"].ToString() == "1") { string strTableNameSection = "DTL_CUSTOMFORM_" + dvFilteredRowGridView[0]["SectionName"].ToString() + "_" + FeatureName; oUtility.Init_Hashtable(); oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableNameSection); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtRow.Rows[0]["FieldName"].ToString()); oUtility.AddParameters("@DataType", SqlDbType.Int, dtRow.Rows[0]["ControlId"].ToString()); oUtility.AddParameters("@FieldId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_CustomTableCreationGridView_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } /* ---------- end ------------*/ if (dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString() != "71" && dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString() != "1") { oUtility.Init_Hashtable(); oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableName); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtRow.Rows[0]["FieldName"].ToString()); oUtility.AddParameters("@DataType", SqlDbType.Int, dtRow.Rows[0]["ControlId"].ToString()); oUtility.AddParameters("@Predefined", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString()); oUtility.AddParameters("@FieldId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString()); //theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_PMTCT_CustomTableCreation_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_CustomTableCreation_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } /* if (dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString() != "71" && dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString() != "0") * { * oUtility.Init_Hashtable(); * oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableName); * oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtRow.Rows[0]["FieldName"].ToString()); * oUtility.AddParameters("@DataType", SqlDbType.Int, dtRow.Rows[0]["ControlId"].ToString()); * oUtility.AddParameters("@Predefined", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString()); * oUtility.AddParameters("@FieldId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString()); * theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_CustomTableCreation_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); * }*/ } //Delete fields selected from remove field in formbuilder while in update mode for (int i = 0; i < dsSaveFormData.Tables[3].Rows.Count; i++) { string Tblname; if (iFeatureId == 126) { Tblname = strTableName; } else if (iFeatureId == System.Convert.ToInt32(dsSaveFormData.Tables[0].Rows[0]["FeatureId"]) && iRegFlag == 2) { Tblname = strTableName; } else { if (dsSaveFormData.Tables[3].Rows[i]["IsGridView"].ToString() == "1") { Tblname = "DTL_CUSTOMFORM_" + dsSaveFormData.Tables[3].Rows[i]["SectionName"].ToString() + "_" + FeatureName; } else { Tblname = strTableName; } } oUtility.Init_Hashtable(); oUtility.AddParameters("@Id", SqlDbType.Int, dsSaveFormData.Tables[3].Rows[i]["Id"].ToString()); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dsSaveFormData.Tables[3].Rows[i]["FieldName"].ToString()); oUtility.AddParameters("@TableName", SqlDbType.VarChar, Tblname); //theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_PMTCT_RemoveFieldInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_RemoveFieldInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } //Delete sections selected from remove section in formbuilder while in update mode if (dsSaveFormData.Tables.Count > 4) { if (dsSaveFormData.Tables.Contains("MstTab")) // || dsSaveFormData.Tables[5].TableName == "MstTab") { for (int i = 0; i < dsSaveFormData.Tables["MstTab"].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@TabID", SqlDbType.Int, dsSaveFormData.Tables["MstTab"].Rows[i]["TabID"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@TabName", SqlDbType.VarChar, dsSaveFormData.Tables["MstTab"].Rows[i]["TabName"].ToString()); oUtility.AddParameters("@Seq", SqlDbType.Int, dsSaveFormData.Tables["MstTab"].Rows[i]["seq"].ToString()); oUtility.AddParameters("@Signature", SqlDbType.Int, dsSaveFormData.Tables["MstTab"].Rows[i]["Signature"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables["MstTab"].Rows[i]["UserId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveMstTab_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } if (dsSaveFormData.Tables.Contains("LnkSectionTab")) // || dsSaveFormData.Tables[6].TableName == "LnkSectionTab") { for (int i = 0; i < dsSaveFormData.Tables["LnkSectionTab"].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@ID", SqlDbType.Int, dsSaveFormData.Tables["LnkSectionTab"].Rows[i]["ID"].ToString()); oUtility.AddParameters("@TabID", SqlDbType.Int, dsSaveFormData.Tables["LnkSectionTab"].Rows[i]["TabID"].ToString()); oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables["LnkSectionTab"].Rows[i]["SectionId"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables["LnkSectionTab"].Rows[i]["UserId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveLnkTabSection_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } if (dsSaveFormData.Tables.Contains("DeleteSection")) { for (int i = 0; i < dsSaveFormData.Tables["DeleteSection"].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables["DeleteSection"].Rows[i]["SectionId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableName); //theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_PMTCT_RemoveSectionAndFieldInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_RemoveSectionAndFieldInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } if (dsSaveFormData.Tables.Contains("DeleteTab")) { for (int i = 0; i < dsSaveFormData.Tables["DeleteTab"].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@TabID", SqlDbType.Int, dsSaveFormData.Tables["DeleteTab"].Rows[i]["TabId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_RemoveTabInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } } if (DSFormVer.Tables.Count > 0) { ///Save Update Form Version Masters if (DSFormVer.Tables[0].Rows.Count > 0) { oUtility.Init_Hashtable(); oUtility.AddParameters("@VerId", SqlDbType.Int, DSFormVer.Tables[0].Rows[0]["VerId"].ToString()); oUtility.AddParameters("@VersionName", SqlDbType.Decimal, DSFormVer.Tables[0].Rows[0]["VersionName"].ToString()); oUtility.AddParameters("@VersionDate", SqlDbType.DateTime, DSFormVer.Tables[0].Rows[0]["VersionDate"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@UserId", SqlDbType.Int, DSFormVer.Tables[0].Rows[0]["UserId"].ToString()); DataRow theDRVer = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveFormVersion_Futures", ClsUtility.ObjectEnum.DataRow); if (DSFormVer.Tables[1].Rows.Count > 0 && theDRVer.ItemArray.Any()) { foreach (DataRow theDRdetails in DSFormVer.Tables[1].Rows) { oUtility.Init_Hashtable(); oUtility.AddParameters("@VerId", SqlDbType.Int, theDRVer["VersionId"].ToString()); oUtility.AddParameters("@TabId", SqlDbType.Decimal, theDRdetails["TabId"].ToString()); oUtility.AddParameters("@FunctionId", SqlDbType.Int, theDRdetails["FunctionId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@UserId", SqlDbType.Int, DSFormVer.Tables[0].Rows[0]["UserId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveFormVersionDetails_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } if (DSFormVer.Tables[2].Rows.Count > 0 && theDRVer.ItemArray.Any()) { foreach (DataRow theDRdetails in DSFormVer.Tables[2].Rows) { oUtility.Init_Hashtable(); oUtility.AddParameters("@VerId", SqlDbType.Int, theDRVer["VersionId"].ToString()); oUtility.AddParameters("@TabId", SqlDbType.Decimal, theDRdetails["TabId"].ToString()); oUtility.AddParameters("@SectionId", SqlDbType.Decimal, theDRdetails["SectionId"].ToString()); oUtility.AddParameters("@FunctionId", SqlDbType.Int, theDRdetails["FunctionId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@UserId", SqlDbType.Int, DSFormVer.Tables[0].Rows[0]["UserId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveFormVersionDetails_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } if (DSFormVer.Tables[3].Rows.Count > 0 && theDRVer.ItemArray.Any()) { foreach (DataRow theDRdetails in DSFormVer.Tables[3].Rows) { oUtility.Init_Hashtable(); oUtility.AddParameters("@VerId", SqlDbType.Int, theDRVer["VersionId"].ToString()); oUtility.AddParameters("@TabId", SqlDbType.Decimal, theDRdetails["TabId"].ToString()); oUtility.AddParameters("@SectionId", SqlDbType.Decimal, theDRdetails["SectionId"].ToString()); oUtility.AddParameters("@FieldId", SqlDbType.Decimal, theDRdetails["FieldId"].ToString()); oUtility.AddParameters("@FunctionId", SqlDbType.Int, theDRdetails["FunctionId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@UserId", SqlDbType.Int, DSFormVer.Tables[0].Rows[0]["UserId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveFormVersionDetails_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(iFeatureId); // } //catch //{ // DataMgr.RollBackTransation(this.Transaction); // throw; //} //finally //{ // if (this.Connection != null) // DataMgr.ReleaseConnection(this.Connection); //} }
public int SaveUpdateModuleDetail(Hashtable ht, DataTable dt, DataTable dtbusinessrules) { int ModuleID; try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject ModuleMgr = new ClsObject(); ModuleMgr.Connection = this.Connection; ModuleMgr.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ht["ModuleId"].ToString()); ClsUtility.AddParameters("@ModuleName", SqlDbType.VarChar, ht["ModuleName"].ToString()); ClsUtility.AddParameters("@Status", SqlDbType.Int, ht["Status"].ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, ht["DeleteFlag"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@PharmacyFlag", SqlDbType.Int, ht["PharmacyFlag"].ToString()); DataTable theDT = (DataTable)ModuleMgr.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_SaveUpdateModule_Constella", ClsUtility.ObjectEnum.DataTable); ModuleID = Convert.ToInt32(theDT.Rows[0][0]); if (ModuleID != 0) { for (int i = 0; i < dt.Rows.Count; i++) { //if (dt.Rows[i]["Selected"].ToString() == "True") //{ ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ModuleID.ToString()); ClsUtility.AddParameters("@FieldID", SqlDbType.Int, dt.Rows[i]["Id"].ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, dt.Rows[i]["IdentifierName"].ToString()); ClsUtility.AddParameters("@FieldType", SqlDbType.Int, dt.Rows[i]["FieldType"].ToString()); ClsUtility.AddParameters("@Identifierchecked", SqlDbType.VarChar, dt.Rows[i]["Selected"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Label", SqlDbType.VarChar, dt.Rows[i]["Label"].ToString()); ClsUtility.AddParameters("@autopopulatenumber", SqlDbType.Int, dt.Rows[i]["autopopulatenumber"].ToString()); Int32 NoRowsEffected = (Int32)ModuleMgr.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_SaveUpdateModuleIdentification_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); //} } } if (ModuleID != 0) { if (dtbusinessrules.Rows.Count == 0) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ModuleID.ToString()); ClsUtility.AddParameters("@BusRuleid", SqlDbType.Int, "1"); ClsUtility.AddParameters("@value", SqlDbType.Int, "1"); ClsUtility.AddParameters("@value1", SqlDbType.Int, "1"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, "1"); ClsUtility.AddParameters("@setType", SqlDbType.Int, "1"); ClsUtility.AddParameters("@counter", SqlDbType.Int, "0"); Int32 NoRowsEffected = (Int32)ModuleMgr.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_DeleteModuleBusinessRules", ClsUtility.ObjectEnum.ExecuteNonQuery); } for (int i = 0; i < dtbusinessrules.Rows.Count; i++) { //if (dt.Rows[i]["Selected"].ToString() == "True") //{ ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, ModuleID.ToString()); ClsUtility.AddParameters("@BusRuleid", SqlDbType.Int, dtbusinessrules.Rows[i]["BusRuleId"].ToString()); ClsUtility.AddParameters("@value", SqlDbType.Int, dtbusinessrules.Rows[i]["Value"].ToString()); ClsUtility.AddParameters("@value1", SqlDbType.Int, dtbusinessrules.Rows[i]["Value1"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@setType", SqlDbType.Int, dtbusinessrules.Rows[i]["SetType"].ToString()); ClsUtility.AddParameters("@counter", SqlDbType.Int, i.ToString()); Int32 NoRowsEffected = (Int32)ModuleMgr.ReturnObject(ClsUtility.theParams, "pr_FormBuilder_SaveUpdateModuleBusinessRules", ClsUtility.ObjectEnum.ExecuteNonQuery); //} } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(ModuleID); }
//Saving and Updating public int Save_Update_FollowUP(int patientID, int VisitID, int LocationID, Hashtable ht, DataSet theDS_ARTFU, int VisitIE, int rdoARVSideEffectsNone, int rdoARVSideEffectsNotDocumented, int rdoOIsAIDsIllnessNone, int rdoOIsAIDsIllnessNotDocumented, int userID, Boolean Save, Boolean Update, DateTime createDate, int DataQualityFlag, DataTable theCustomFieldData) { int retval = 0; ClsObject FollowupManager = new ClsObject(); if (createDate.Year.ToString() == "1") { createDate = Convert.ToDateTime("01-01-1900"); } try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); FollowupManager.Connection = this.Connection; FollowupManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVvisitdate", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@PrevARVsCD4", SqlDbType.Int, ht["txtpriorARVsFU"].ToString()); ClsUtility.AddParameters("@PrevARVsCD4Date", SqlDbType.DateTime, ht["txtpriorARVsCD4DateFU"].ToString()); ClsUtility.AddParameters("@VisitID_IE", SqlDbType.VarChar, VisitIE.ToString()); ClsUtility.AddParameters("@Visit_typeID", SqlDbType.Int, ht["VisittypeIDFU"].ToString()); ClsUtility.AddParameters("@Pregnant", SqlDbType.Int, ht["Pregnant"].ToString()); ClsUtility.AddParameters("@Delivered", SqlDbType.VarChar, ht["Delivered"].ToString()); ClsUtility.AddParameters("@DelDate", SqlDbType.DateTime, ht["DelDate"].ToString()); ClsUtility.AddParameters("@EDDDate", SqlDbType.DateTime, ht["EDDDate"].ToString()); ClsUtility.AddParameters("@lmp", SqlDbType.DateTime, ht["LMPdate"].ToString()); ClsUtility.AddParameters("@MissedLastWeek", SqlDbType.Int, ht["DosesMissedLastWeek"].ToString()); ClsUtility.AddParameters("@MissedLastMonth", SqlDbType.Int, ht["DosesMissedLastMonth"].ToString()); ClsUtility.AddParameters("@NumDOTPerWeek", SqlDbType.Int, ht["NumDOTPerWeek"].ToString()); ClsUtility.AddParameters("@NumHomeVisitsPerWeek", SqlDbType.Int, ht["NumHomeVisitsPerWeek"].ToString()); ClsUtility.AddParameters("@SupportGroup", SqlDbType.Bit, ht["SupportGroup"].ToString()); ClsUtility.AddParameters("@InterruptedDate", SqlDbType.DateTime, ht["InterruptedDate"].ToString()); ClsUtility.AddParameters("@InterruptedNumDays", SqlDbType.Int, ht["InterruptedNumDays"].ToString()); ClsUtility.AddParameters("@StoppedDate", SqlDbType.DateTime, ht["stoppedDate"].ToString()); ClsUtility.AddParameters("@StoppedNumDays", SqlDbType.Int, ht["stoppedNumDays"].ToString()); ClsUtility.AddParameters("@HerbalMeds", SqlDbType.Bit, ht["HerbalMeds"].ToString()); ClsUtility.AddParameters("@Temp", SqlDbType.Decimal, ht["physTemp"].ToString()); ClsUtility.AddParameters("@RR", SqlDbType.Decimal, ht["physRR"].ToString()); ClsUtility.AddParameters("@HR", SqlDbType.Decimal, ht["physHR"].ToString()); ClsUtility.AddParameters("@BPDiastolic", SqlDbType.Decimal, ht["physBPDiastolic"].ToString()); ClsUtility.AddParameters("@BPSystolic", SqlDbType.Decimal, ht["physBPSystolic"].ToString()); ClsUtility.AddParameters("@Height", SqlDbType.Int, ht["physHeight"].ToString()); ClsUtility.AddParameters("@Weight", SqlDbType.Decimal, ht["physWeight"].ToString()); ClsUtility.AddParameters("@Pain", SqlDbType.Int, ht["physExamPain"].ToString()); ClsUtility.AddParameters("@WHOStage", SqlDbType.Int, ht["phyWHOstage"].ToString()); ClsUtility.AddParameters("@WABStage", SqlDbType.Int, ht["physWABStage"].ToString()); ClsUtility.AddParameters("@ARVtherapyPlan", SqlDbType.Int, ht["ARVtherapyplan"].ToString()); ClsUtility.AddParameters("@ARTEnddate", SqlDbType.DateTime, ht["ARTEndDate"].ToString()); ClsUtility.AddParameters("@ARVTHerapyReasonCode", SqlDbType.Int, ht["ArvTherapyReasonCode"].ToString()); ClsUtility.AddParameters("@TherapyOther", SqlDbType.Int, ht["ARVTherapyReasonOther"].ToString()); ClsUtility.AddParameters("@AppExist", SqlDbType.VarChar, ht["AppExist"].ToString()); ClsUtility.AddParameters("@VisitIDApp", SqlDbType.VarChar, Convert.ToString(ht["VisitIDApp"])); ClsUtility.AddParameters("@appdate", SqlDbType.DateTime, Convert.ToString(ht["appdate"])); ClsUtility.AddParameters("@appreason", SqlDbType.VarChar, Convert.ToString(ht["appreason"])); ClsUtility.AddParameters("@employeeID", SqlDbType.BigInt, ht["Signatureid"].ToString()); ClsUtility.AddParameters("@signatureid", SqlDbType.BigInt, ht["Signatureid"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@dataquality", SqlDbType.Int, DataQualityFlag.ToString()); ClsUtility.AddParameters("@plannotes", SqlDbType.VarChar, ht["PlanNote"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //Ajay Kumar-05-Jan-2010 Begin //Clinical note added ClsUtility.AddParameters("@ClinicalNotes", SqlDbType.VarChar, ht["ClinicalNotes"].ToString()); //Ajay Kumar-05-Jan-2010 End ClsUtility.AddParameters("@Flag", SqlDbType.Int, ht["Flag"].ToString()); int retvalother = (int)FollowupManager.ReturnObjectNewImpl(ClsUtility.theParams, "pr_Clinical_SaveUpdateFollowUp_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //if (Save == true) //{ // int retvalother = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveFollowUp_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} //else if (Update == true) //{ // int retvalother = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateFollowUP_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} /*Appointment Status*/ //Updating Most Recent EmployeeID for appointment if (Convert.ToInt32(ht["AppExist"].ToString()) == 1) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Visit_pkAppID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@signatureid", SqlDbType.BigInt, ht["Signatureid"].ToString()); int RowsAffected = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateIEAppointmentSignature_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } /* Reason Missed */ if (Update == true) { ////////Delete Statement //////ClsUtility.Init_Hashtable(); //////ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //////ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); //////ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); //////int retvalmissed1 = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteMissedReason_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //Update Statement for (int i = 0; i < theDS_ARTFU.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@MissedReasonID", SqlDbType.Int, theDS_ARTFU.Tables[0].Rows[i]["MissedReasonID"].ToString()); ClsUtility.AddParameters("@OtherReason_Desc", SqlDbType.VarChar, theDS_ARTFU.Tables[0].Rows[i][1].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalmissed = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateMissedReason_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else if (Save == true) { for (int i = 0; i < theDS_ARTFU.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@MissedReasonID", SqlDbType.Int, theDS_ARTFU.Tables[0].Rows[i]["MissedReasonID"].ToString()); ClsUtility.AddParameters("@OtherReason_Desc", SqlDbType.VarChar, theDS_ARTFU.Tables[0].Rows[i][1].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalmissed = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveMissedReason_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } //Save and Update Complaints if (Save == true) { for (int i = 0; i < theDS_ARTFU.Tables[1].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[1].Rows[i]["PresentComplaintsID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalcomplaint = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else if (Update == true) {//pr_Clinical_DeleteFollowUP_PatientSymptoms_Constella //Delete Statement ////ClsUtility.Init_Hashtable(); ////ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ////ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ////ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ////int retvalcomplaint1 = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //Update Statement for (int i = 0; i < theDS_ARTFU.Tables[1].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[1].Rows[i]["PresentComplaintsID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, createDate.ToString()); int retvalcomplaint = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } //ARV Side Effects - Left if (Save == true) { if (rdoARVSideEffectsNone == 31) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, rdoARVSideEffectsNone.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalarvleft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoARVSideEffectsNotDocumented == 32) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, rdoARVSideEffectsNotDocumented.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalarvleft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoARVSideEffectsNone == 0 && rdoARVSideEffectsNotDocumented == 0) { for (int i = 0; i < theDS_ARTFU.Tables[2].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[2].Rows[i]["ARVSideEffectsID1"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalarvleft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } } else if (Update == true) { if (rdoARVSideEffectsNone == 31) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, rdoARVSideEffectsNone.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalarvleft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoARVSideEffectsNotDocumented == 32) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, rdoARVSideEffectsNotDocumented.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalarvleft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoARVSideEffectsNone == 0 && rdoARVSideEffectsNotDocumented == 0) { for (int i = 0; i < theDS_ARTFU.Tables[2].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[2].Rows[i]["ARVSideEffectsID1"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalarvleft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } } //ARV Side Effects Right if (Save == true) { for (int i = 0; i < theDS_ARTFU.Tables[3].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[3].Rows[i]["ARVSideEffectsID2"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalarvright = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else if (Update == true) { for (int i = 0; i < theDS_ARTFU.Tables[3].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[3].Rows[i]["ARVSideEffectsID2"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalarvright = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } //TBScreen if (Save == true) {//pr_Clinical_SaveComplaintsIEFU_Constella for (int i = 0; i < theDS_ARTFU.Tables[4].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[4].Rows[i]["TBScreenID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalTBScreen = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else if (Update == true) { for (int i = 0; i < theDS_ARTFU.Tables[4].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_ARTFU.Tables[4].Rows[i]["TBScreenID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalTBScreen = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } //Save OI & AIDS Defining Illness - left if (Save == true) { if (rdoOIsAIDsIllnessNone == 99) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, rdoOIsAIDsIllnessNone.ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, "Blank"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalAssocCondLeft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoOIsAIDsIllnessNotDocumented == 98) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, rdoOIsAIDsIllnessNotDocumented.ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, "Blank"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalAssocCondLeft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoOIsAIDsIllnessNone == 0 && rdoOIsAIDsIllnessNotDocumented == 0) { for (int i = 0; i < theDS_ARTFU.Tables[5].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS_ARTFU.Tables[5].Rows[i]["OI_AIDS_ID1"].ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS_ARTFU.Tables[5].Rows[i][1].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalAssocCondLeft = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } } else if (Update == true) { ////////Delete Statement ////ClsUtility.Init_Hashtable(); ////ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ////ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ////ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ////int retvalAssocCondLeft1 = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteFollowUP_PatientDisease_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (rdoOIsAIDsIllnessNone == 99) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, rdoOIsAIDsIllnessNone.ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, "Blank"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, createDate.ToString()); int retvalAssocCondLeft = (int)FollowupManager.ReturnObjectNewImpl(ClsUtility.theParams, "pr_Clinical_Update_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoOIsAIDsIllnessNotDocumented == 98) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, rdoOIsAIDsIllnessNotDocumented.ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, "Blank"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, createDate.ToString()); int retvalAssocCondLeft = (int)FollowupManager.ReturnObjectNewImpl(ClsUtility.theParams, "pr_Clinical_Update_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (rdoOIsAIDsIllnessNone == 0 && rdoOIsAIDsIllnessNotDocumented == 0) { for (int i = 0; i < theDS_ARTFU.Tables[5].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS_ARTFU.Tables[5].Rows[i]["OI_AIDS_ID1"].ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS_ARTFU.Tables[5].Rows[i][1].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, createDate.ToString()); int retvalAssocCondLeft = (int)FollowupManager.ReturnObjectNewImpl(ClsUtility.theParams, "pr_Clinical_Update_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } } //Save OI & AIDS Defining Illness - right if (Save == true) { for (int i = 0; i < theDS_ARTFU.Tables[6].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS_ARTFU.Tables[6].Rows[i]["OI_AIDS_ID2"].ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS_ARTFU.Tables[6].Rows[i][1].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalAssocCondright = (int)FollowupManager.ReturnObjectNewImpl(ClsUtility.theParams, "pr_Clinical_Save_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else if (Update == true) { for (int i = 0; i < theDS_ARTFU.Tables[6].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS_ARTFU.Tables[6].Rows[i]["OI_AIDS_ID2"].ToString()); ClsUtility.AddParameters("@DateofHIVAssocDisease", SqlDbType.DateTime, ht["Visitdate"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS_ARTFU.Tables[6].Rows[i][1].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, createDate.ToString()); int retvalAssocCondright = (int)FollowupManager.ReturnObjectNewImpl(ClsUtility.theParams, "pr_Clinical_Update_OI_AID_ILLNESS_FU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } //Saving Assessment if (Save == true) {//Save statement for (int i = 0; i < theDS_ARTFU.Tables[7].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@AssessmentID", SqlDbType.Int, theDS_ARTFU.Tables[7].Rows[i]["AssessmentID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalAssessment = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveAssessmentFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else if (Update == true) { //Delete Statement ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@plannotes", SqlDbType.VarChar, ht["PlanNote"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); int retvalAssessment1 = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteFollowUP_PatientAssessment_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //Update for (int i = 0; i < theDS_ARTFU.Tables[7].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@AssessmentID", SqlDbType.Int, theDS_ARTFU.Tables[7].Rows[i]["AssessmentID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, userID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.Int, createDate.ToString()); int retvalAssessment = (int)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateAssessmentFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } //// Custom Fields ////////////// ////////////PreSet Values Used///////////////// /// #99# --- Ptn_Pk /// #88# --- LocationId /// #77# --- Visit_Pk /// #66# --- Visit_Date /// #55# --- Ptn_Pharmacy_Pk /// #44# --- OrderedByDate /// #33# --- LabId /// #22# --- TrackingId /// #11# --- CareEndedId /// #00# --- HomeVisitId /////////////////////////////////////////////// //ClsObject theCustomManager = new ClsObject(); //Generating VisitID from ART Followup Form String VisitIDART = ""; if (Save == true) { string theSQL = string.Format("Select IDENT_CURRENT('ord_Visit')"); ClsUtility.Init_Hashtable(); DataTable DTVisitID = (DataTable)FollowupManager.ReturnObject(ClsUtility.theParams, theSQL, ClsDBUtility.ObjectEnum.DataTable); VisitIDART = DTVisitID.Rows[0][0].ToString(); } if (Update == true) { VisitIDART = VisitID.ToString(); } for (Int32 i = 0; i < theCustomFieldData.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomFieldData.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", patientID.ToString()); theQuery = theQuery.Replace("#88#", LocationID.ToString()); theQuery = theQuery.Replace("#77#", VisitIDART); theQuery = theQuery.Replace("#66#", "'" + ht["Visitdate"].ToString() + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //////////////////////////////// DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(retval); }
public DataTable SavePharmacyDispense_Web(Int32 PatientId, Int32 LocationId, Int32 StoreId, Int32 UserId, int dispensedBy, string DispDate, Int32 OrderType, Int32 ProgramId, string theRegimen, Int32 OrderId, DataTable theDT, string PharmacyRefillDate, Int32 DataStatus, int orderedBy, string orderDate, string deleteScript, int regimenLine = 0, int regimenCode = 0, int therapyPlan = 0 , int patientClassification = 0, int isEnrolDifferenciatedCare = 0) { string Morning, Midday, Evening, Night; DataTable thePharmacyDT = new DataTable(); //Added by VY for regimen #region "Regimen" //string theRegimen = ""; string thetmpRegimen = ""; for (int i = 0; i < theDT.Rows.Count; i++) { if (theDT.Rows[i]["GenericAbbrevation"].ToString() != "") { if (thetmpRegimen == "") { thetmpRegimen = theDT.Rows[i]["GenericAbbrevation"].ToString(); } else { thetmpRegimen = String.Format("{0}/{1}", thetmpRegimen, theDT.Rows[i]["GenericAbbrevation"]); } } thetmpRegimen = thetmpRegimen.Trim(); } foreach (string s in thetmpRegimen.Split('/')) { if (theRegimen == "" && s != "") { theRegimen = theRegimen + s; } else if (theRegimen != "" && s != "") { if (!theRegimen.Contains(s)) { theRegimen = theRegimen + "/" + s; } } } #endregion try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject theManager = new ClsObject(); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, PatientId.ToString()); ClsUtility.AddParameters("@LocationId", SqlDbType.Int, LocationId.ToString()); ClsUtility.AddParameters("@DispensedBy", SqlDbType.Int, dispensedBy.ToString()); if (DispDate.ToString() != "") { ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, DispDate.ToString()); } ClsUtility.AddParameters("@OrderType", SqlDbType.Int, OrderType.ToString()); ClsUtility.AddParameters("@ProgramId", SqlDbType.Int, ProgramId.ToString()); ClsUtility.AddParameters("@StoreId", SqlDbType.Int, StoreId.ToString()); ClsUtility.AddParameters("@Regimen", SqlDbType.VarChar, theRegimen); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@OrderId", SqlDbType.Int, OrderId.ToString()); ClsUtility.AddParameters("@AppointmentDate", SqlDbType.VarChar, PharmacyRefillDate.ToString()); ClsUtility.AddParameters("@OrderedBy", SqlDbType.Int, orderedBy.ToString()); if (orderDate.ToString() != "") { ClsUtility.AddParameters("@OrderDate", SqlDbType.VarChar, orderDate.ToString()); } if (deleteScript != "") { ClsUtility.AddParameters("@deleteScript", SqlDbType.VarChar, deleteScript); } ClsUtility.AddParameters("@RegimenLine", SqlDbType.Int, regimenLine.ToString()); ClsUtility.AddParameters("@RegimenCode", SqlDbType.Int, regimenCode.ToString()); ClsUtility.AddParameters("@TherapyPlan", SqlDbType.Int, therapyPlan.ToString()); ClsUtility.AddParameters("@PatientClassification", SqlDbType.Int, patientClassification.ToString()); ClsUtility.AddParameters("@IsEnrolDifferenciatedCare", SqlDbType.Int, isEnrolDifferenciatedCare.ToString()); thePharmacyDT = (DataTable)theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyDispenseOrder_Web", ClsDBUtility.ObjectEnum.DataTable); foreach (DataRow theDR in theDT.Rows) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, PatientId.ToString()); ClsUtility.AddParameters("@StoreId", SqlDbType.Int, StoreId.ToString()); ClsUtility.AddParameters("@VisitId", SqlDbType.Int, thePharmacyDT.Rows[0]["VisitId"].ToString()); ClsUtility.AddParameters("@Ptn_Pharmacy_Pk", SqlDbType.Int, thePharmacyDT.Rows[0]["Ptn_Pharmacy_Pk"].ToString()); ClsUtility.AddParameters("@Drug_Pk", SqlDbType.Int, theDR["DrugId"].ToString()); ClsUtility.AddParameters("@MorningDose", SqlDbType.Decimal, Morning = (theDR["Morning"].ToString() == "") ? "0" : theDR["Morning"].ToString()); ClsUtility.AddParameters("@MiddayDose", SqlDbType.Decimal, Midday = (theDR["Midday"].ToString() == "") ? "0" : theDR["Midday"].ToString()); ClsUtility.AddParameters("@EveningDose", SqlDbType.Decimal, Evening = (theDR["Evening"].ToString() == "") ? "0" : theDR["Evening"].ToString()); ClsUtility.AddParameters("@NightDose", SqlDbType.Decimal, Night = (theDR["Night"].ToString() == "") ? "0" : theDR["Night"].ToString()); ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Int, "0"); ClsUtility.AddParameters("@Prophylaxis", SqlDbType.Int, theDR["Prophylaxis"].ToString() == "True" ? "1" : "0"); ClsUtility.AddParameters("@BatchId", SqlDbType.Int, theDR["BatchId"].ToString()); if (theDR["BatchNo"].ToString().Contains("(")) { ClsUtility.AddParameters("@BatchNo", SqlDbType.VarChar, theDR["BatchNo"].ToString().Substring(0, theDR["BatchNo"].ToString().IndexOf('('))); } else { ClsUtility.AddParameters("@BatchNo", SqlDbType.VarChar, theDR["BatchNo"].ToString()); } ClsUtility.AddParameters("@ExpiryDate", SqlDbType.VarChar, theDR["ExpiryDate"].ToString()); ClsUtility.AddParameters("@DispensingUnit", SqlDbType.Int, theDR["DispensingUnitId"].ToString()); if (DispDate.ToString() != "") { ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, DispDate.ToString()); } ClsUtility.AddParameters("@LocationId", SqlDbType.Int, LocationId.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@DataStatus", SqlDbType.Int, DataStatus.ToString()); ClsUtility.AddParameters("@Duration", SqlDbType.Decimal, theDR["Duration"].ToString() != "" ? theDR["Duration"].ToString() : "0"); ClsUtility.AddParameters("@PrescribeOrderedQuantity", SqlDbType.Decimal, theDR["QtyPrescribed"].ToString() != "" ? theDR["QtyPrescribed"].ToString() : "0"); ClsUtility.AddParameters("@PillCount", SqlDbType.VarChar, theDR["PillCount"].ToString() == "" ? "0" : theDR["PillCount"].ToString()); ClsUtility.AddParameters("@PrintPrescriptionStatus", SqlDbType.Int, theDR["PrintPrescriptionStatus"].ToString() == "True" ? "1" : "0"); ClsUtility.AddParameters("@PatientInstructions", SqlDbType.VarChar, theDR["Instructions"].ToString()); ClsUtility.AddParameters("@Comments", SqlDbType.VarChar, theDR["Comments"].ToString()); Int32 theRowCount = (Int32)theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyDispenseOrderDetail_Web", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //Save details to dtl_PatientPharmacyOrderpartialDispense table ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, PatientId.ToString()); ClsUtility.AddParameters("@StoreId", SqlDbType.Int, StoreId.ToString()); ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, thePharmacyDT.Rows[0]["Ptn_Pharmacy_Pk"].ToString()); ClsUtility.AddParameters("@drug_pk", SqlDbType.Int, theDR["DrugId"].ToString()); ClsUtility.AddParameters("@batchid", SqlDbType.Int, theDR["BatchId"].ToString()); ClsUtility.AddParameters("@ExpiryDate", SqlDbType.VarChar, theDR["ExpiryDate"].ToString()); ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Int, theDR["QtyDispensed"].ToString() == "" ? "0" : theDR["QtyDispensed"].ToString()); //ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Decimal, theDR["RefillQty"].ToString() == "" ? "0" : theDR["RefillQty"].ToString()); ClsUtility.AddParameters("@DispensedBy", SqlDbType.Int, dispensedBy.ToString()); if (DispDate.ToString() != "") { ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, DispDate.ToString()); } ClsUtility.AddParameters("@PrintPrescriptionStatus", SqlDbType.Int, theDR["PrintPrescriptionStatus"].ToString() == "True" ? "1" : "0"); ClsUtility.AddParameters("@comments", SqlDbType.Int, theDR["comments"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); DataTable dt = (DataTable)theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyPartialDispense_Web", ClsDBUtility.ObjectEnum.DataTable); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(thePharmacyDT); }
public DataSet SaveUpdateKNHPeadraticFollowupData_CATab(Hashtable hashTable, DataTable dtMultiSelectValues, int DataQuality, int signature, int UserId) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["visitDate"].ToString())); ClsUtility.AddParameters("@MedicalHistory", SqlDbType.Int, hashTable["MedicalHistory"].ToString()); ClsUtility.AddParameters("@OtherChronicCondition", SqlDbType.VarChar, hashTable["OtherChronicCondition"].ToString()); ClsUtility.AddParameters("@OtherMedicalHistorySpecify", SqlDbType.VarChar, hashTable["OtherMedicalHistorySpecify"].ToString()); ClsUtility.AddParameters("@PresentingComplaintsAdditionalNotes", SqlDbType.VarChar, hashTable["PresentingComplaintsAdditionalNotes"].ToString()); ClsUtility.AddParameters("@SchoolPerfomance", SqlDbType.Int, hashTable["SchoolPerfomance"].ToString()); ClsUtility.AddParameters("@ImmunisationStatus", SqlDbType.Int, hashTable["ImmunisationStatus"].ToString()); ClsUtility.AddParameters("@TBHistory", SqlDbType.Int, hashTable["TBHistory"].ToString()); ClsUtility.AddParameters("@TBrxCompleteDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["TBrxCompleteDate"].ToString())); ClsUtility.AddParameters("@TBRetreatmentDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["TBRetreatmentDate"].ToString())); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@DataQlty", SqlDbType.Int, DataQuality.ToString()); ClsUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); ClsUtility.AddParameters("@StartTime", SqlDbType.VarChar, hashTable["starttime"].ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdate_KNH_PaediatricFollowup_FORM_CATab", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { if (dtMultiSelectValues.Rows[i]["ID"].ToString() != "") { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); ClsUtility.AddParameters("@OtherNotes", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["Other_Notes"].ToString()); ClsUtility.AddParameters("@DateField1", SqlDbType.DateTime, dtMultiSelectValues.Rows[i]["DateField1"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveUpdateKNHPeadraticFollowupData_MgtTab(Hashtable hashTable, DataTable dtMultiSelectValues, int DataQuality, int signature, int UserId) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["visitDate"].ToString())); ClsUtility.AddParameters("@MissedDosesFUP", SqlDbType.Int, hashTable["MissedDosesFUP"].ToString()); ClsUtility.AddParameters("@MissedDosesFUPspecify", SqlDbType.VarChar, hashTable["MissedDosesFUPspecify"].ToString()); ClsUtility.AddParameters("@DelaysInTakingMedication", SqlDbType.Int, hashTable["DelaysInTakingMedication"].ToString()); ClsUtility.AddParameters("@OtherShortTermEffects", SqlDbType.VarChar, hashTable["Specifyothershorttermeffects"].ToString()); ClsUtility.AddParameters("@OtherLongtermEffects", SqlDbType.VarChar, hashTable["OtherLongtermEffects"].ToString()); ClsUtility.AddParameters("@SpecifyLabEvaluation", SqlDbType.VarChar, hashTable["SpecifyLabEvaluation"].ToString()); ClsUtility.AddParameters("@ARTTreatmentPlan", SqlDbType.Int, hashTable["ARTTreatmentPlan"].ToString()); ClsUtility.AddParameters("@OtherARTStopCode", SqlDbType.VarChar, hashTable["OtherARTStopCode"].ToString()); ClsUtility.AddParameters("@OtherEligiblethorugh", SqlDbType.VarChar, hashTable["OtherEligiblethorugh"].ToString()); ClsUtility.AddParameters("@NumberDrugsSubstituted", SqlDbType.Int, hashTable["NumberDrugsSubstituted"].ToString()); ClsUtility.AddParameters("@SpecifyotherARTchangereason", SqlDbType.VarChar, hashTable["SpecifyotherARTchangereason"].ToString()); ClsUtility.AddParameters("@2ndLineRegimenSwitch", SqlDbType.Int, hashTable["2ndLineRegimenSwitch"].ToString()); ClsUtility.AddParameters("@OIProphylaxis", SqlDbType.Int, hashTable["OIProphylaxis"].ToString()); ClsUtility.AddParameters("@ReasonCTXpresribed", SqlDbType.Int, hashTable["ReasonCTXpresribed"].ToString()); ClsUtility.AddParameters("@OtherOIProphylaxis", SqlDbType.VarChar, hashTable["OtherOIProphylaxis"].ToString()); ClsUtility.AddParameters("@OtherTreatment", SqlDbType.VarChar, hashTable["OtherTreatment"].ToString()); ClsUtility.AddParameters("@Fluconazole", SqlDbType.Int, hashTable["Fluconazole"].ToString()); ClsUtility.AddParameters("@StartTime", SqlDbType.VarChar, hashTable["starttime"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@DataQlty", SqlDbType.Int, DataQuality.ToString()); ClsUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdate_KNH_PaediatricFollowup_FORM_MgtTab", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@TherapyPlan", SqlDbType.Int, hashTable["ARTTreatmentPlan"].ToString()); ClsUtility.AddParameters("@Noofdrugssubstituted", SqlDbType.Int, hashTable["NumberDrugsSubstituted"].ToString()); ClsUtility.AddParameters("@reasonforswitchto2ndlineregimen", SqlDbType.Int, hashTable["2ndLineRegimenSwitch"].ToString()); ClsUtility.AddParameters("@specifyOtherEligibility", SqlDbType.Int, hashTable["OtherEligiblethorugh"].ToString()); ClsUtility.AddParameters("@specifyotherARTchangereason", SqlDbType.Int, hashTable["SpecifyotherARTchangereason"].ToString()); ClsUtility.AddParameters("@specifyOtherStopCode", SqlDbType.Int, hashTable["OtherARTStopCode"].ToString()); DataSet theARTDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdate_ARVTherapy", ClsUtility.ObjectEnum.DataSet); //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { if (dtMultiSelectValues.Rows[i]["ID"].ToString() != "") { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); ClsUtility.AddParameters("@OtherNotes", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["Other_Notes"].ToString()); ClsUtility.AddParameters("@DateField1", SqlDbType.DateTime, dtMultiSelectValues.Rows[i]["DateField1"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
/// <summary> /// Save_s the update_ arv therapy. /// </summary> /// <param name="patientId">The patient identifier.</param> /// <param name="visitId">The visit identifier.</param> /// <param name="locationId">The location identifier.</param> /// <param name="ht">The ht.</param> /// <param name="userId">The user identifier.</param> /// <param name="dqFlag">The data quality flag.</param> /// <param name="theCustomFieldData">The custom field data.</param> /// <returns></returns> public int Save_Update_ARVTherapy(int patientId, int visitId, int locationId, Hashtable ht, int userId, int dqFlag, DataTable theCustomFieldData) { int retval = 0; ClsObject obj = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); obj.Connection = this.Connection; obj.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientId.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, locationId.ToString()); ClsUtility.AddParameters("@Visit_ID", SqlDbType.Int, visitId.ToString()); ClsUtility.AddParameters("@ARVDateEligible", SqlDbType.DateTime, ht["DateEligible"].ToString()); ClsUtility.AddParameters("@ARVEligibleThrough", SqlDbType.Int, ht["EligibleThru"].ToString()); ClsUtility.AddParameters("@EligibleWHOStage", SqlDbType.Int, ht["WHOStage"].ToString()); ClsUtility.AddParameters("@EligibleCD4", SqlDbType.VarChar, ht["CD4"].ToString()); ClsUtility.AddParameters("@EligibleCD4percent", SqlDbType.VarChar, ht["CD4Percent"].ToString()); ClsUtility.AddParameters("@ARVCohortMonth", SqlDbType.VarChar, ht["CohortMonth"].ToString()); ClsUtility.AddParameters("@ARVCohortYear", SqlDbType.Int, ht["CohortYear"].ToString()); ClsUtility.AddParameters("@AnotherRegimenStartDate", SqlDbType.DateTime, ht["AnotherRegimenStartDate"].ToString()); ClsUtility.AddParameters("@AnotherRegimen", SqlDbType.VarChar, ht["AnotherRegimen"].ToString()); ClsUtility.AddParameters("@AnotherWeight", SqlDbType.VarChar, ht["AnotherWeight"].ToString()); ClsUtility.AddParameters("@AnotherHeight", SqlDbType.VarChar, ht["AnotherHeight"].ToString()); ClsUtility.AddParameters("@AnotherWHOStage", SqlDbType.Int, ht["AnotherClinicalStage"].ToString()); ClsUtility.AddParameters("@dataquality", SqlDbType.Int, dqFlag.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, userId.ToString()); if (ht.ContainsKey("MUAC") && ht["MUAC"].ToString() != "") { ClsUtility.AddParameters("@MUAC", SqlDbType.Decimal, ht["MUAC"].ToString()); } if (ht.ContainsKey("OtherCriteria") && ht["OtherCriteria"].ToString() != "") { ClsUtility.AddParameters("@OtherEligibleCriteria", SqlDbType.VarChar, ht["OtherCriteria"].ToString()); } if (ht.ContainsKey("ModuleId")) { ClsUtility.AddExtendedParameters("@ModuleId", SqlDbType.Int, Convert.ToInt32(ht["ModuleId"])); } DataTable retvalother = (DataTable)obj.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdateARVTherapy_Futures", ClsUtility.ObjectEnum.DataTable); for (int i = 0; i < theCustomFieldData.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomFieldData.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", patientId.ToString()); theQuery = theQuery.Replace("#88#", locationId.ToString()); theQuery = theQuery.Replace("#77#", retvalother.Rows[0]["Visit_ID"].ToString()); // theQuery = theQuery.Replace("#66#", "02/06/2013"); theQuery = theQuery.Replace("#66#", "'" + ht["visitdate"].ToString() + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)obj.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery); } //////////////////////////////// DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(retval); }
//Saving and Updating /// <summary> /// Save_s the update_ art care. /// </summary> /// <param name="patientId">The patient identifier.</param> /// <param name="visitId">The visit identifier.</param> /// <param name="locationId">The location identifier.</param> /// <param name="ht">The ht.</param> /// <param name="userId">The user identifier.</param> /// <param name="dqFlag">The data quality flag.</param> /// <param name="theCustomDataDT">The custom data dt.</param> /// <returns></returns> public int Save_Update_ARTCare(int patientId, int visitId, int locationId, Hashtable ht, int userId, int dqFlag, DataTable theCustomDataDT) { int retval = 0; DataSet theDS; ClsObject FollowupManager = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); FollowupManager.Connection = this.Connection; FollowupManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, patientId.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, locationId.ToString()); ClsUtility.AddParameters("@Visit_ID", SqlDbType.Int, visitId.ToString()); ClsUtility.AddParameters("@ARTTransferindate", SqlDbType.DateTime, ht["ARTTransferindate"].ToString()); ClsUtility.AddParameters("@ARTTransferinfrom", SqlDbType.VarChar, ht["ARTTransferinfrom"].ToString()); ClsUtility.AddParameters("@transferARVs", SqlDbType.VarChar, ht["transferARVs"].ToString()); ClsUtility.AddParameters("@AnotherRegimennStartdt", SqlDbType.DateTime, ht["AnotherRegimennStartdt"].ToString()); ClsUtility.AddParameters("@AotherRegimen", SqlDbType.VarChar, ht["AotherRegimen"].ToString()); ClsUtility.AddParameters("@AnotherWeight", SqlDbType.VarChar, ht["AnotherWeight"].ToString()); ClsUtility.AddParameters("@AnotherClinicalStage", SqlDbType.Int, ht["AnotherClinicalStage"].ToString()); ClsUtility.AddParameters("@AotherCD4", SqlDbType.VarChar, ht["AotherCD4"].ToString()); ClsUtility.AddParameters("@AnotherCD4Percent", SqlDbType.VarChar, ht["AnotherCD4Percent"].ToString()); ClsUtility.AddParameters("@pregnant", SqlDbType.Int, ht["pregnant"].ToString()); ClsUtility.AddParameters("@dataquality", SqlDbType.Int, dqFlag.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, userId.ToString()); theDS = (DataSet)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdateARTCare_Futures", ClsUtility.ObjectEnum.DataSet); for (int i = 0; i < theCustomDataDT.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomDataDT.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", patientId.ToString()); theQuery = theQuery.Replace("#88#", locationId.ToString()); theQuery = theQuery.Replace("#77#", theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); theQuery = theQuery.Replace("#66#", "'" + System.DateTime.Now.ToString("dd-MMM-yyyy") + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)FollowupManager.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsUtility.ObjectEnum.ExecuteNonQuery); } //////////////////////////////// DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(retval); }
public object ReturnObject(Hashtable Params, string CommandText, ClsDBUtility.ObjectEnum Obj, bool IQTools) { int i; string cmdpara, cmddbtype; object cmdvalue; SqlCommand theCmd = new SqlCommand(); SqlTransaction theTran = (SqlTransaction)this.Transaction; SqlConnection cnn; if (null == this.Connection) { cnn = (SqlConnection)DataMgr.GetConnection(); } else { cnn = (SqlConnection)this.Connection; } if (null == this.Transaction) { theCmd = new SqlCommand(CommandText, cnn); } else { theCmd = new SqlCommand(CommandText, cnn, theTran); } for (i = 1; i < Params.Count;) { cmdpara = Params[i].ToString(); cmddbtype = Params[i + 1].ToString(); //if (cmddbtype.Contains("binary")) cmdvalue = Params[i + 2]; //else // cmdvalue = Params[i + 2].ToString(); // theCmd.Parameters.Add(cmdpara, cmddbtype).Value = cmdvalue; theCmd.Parameters.AddWithValue(cmdpara, cmdvalue);//.Value = cmdvalue; i = i + 3; } theCmd.CommandType = CommandType.StoredProcedure; theCmd.CommandTimeout = DataMgr.CommandTimeOut(); string theSubstring = CommandText.Substring(0, 6).ToUpper(); switch (theSubstring) { case "SELECT": theCmd.CommandType = CommandType.Text; break; case "UPDATE": theCmd.CommandType = CommandType.Text; break; case "INSERT": theCmd.CommandType = CommandType.Text; break; case "DELETE": theCmd.CommandType = CommandType.Text; break; case "TRUNCA": theCmd.CommandType = CommandType.Text; break; } theCmd.Connection = cnn; try { if (Obj == ClsDBUtility.ObjectEnum.DataSet) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataSet theDS = new DataSet(); theAdpt.Fill(theDS); theAdpt.Dispose(); return(theDS); } if (Obj == ClsDBUtility.ObjectEnum.DataTable) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataTable theDT = new DataTable(); theAdpt.Fill(theDT); theAdpt.Dispose(); return(theDT); } if (Obj == ClsDBUtility.ObjectEnum.DataRow) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataTable theDT = new DataTable(); theAdpt.Fill(theDT); theAdpt.Dispose(); return(theDT.Rows[0]); } if (Obj == ClsDBUtility.ObjectEnum.ExecuteNonQuery) { int NoRowsAffected = theCmd.ExecuteNonQuery(); return(NoRowsAffected); } return(0); } catch (Exception err) { throw err; } finally { if (null != cnn) { if (null == this.Connection) { DataMgr.ReleaseConnection(cnn); } } } }
public DataSet SaveUpdateInitialFollowupVisitData(Hashtable hashTable, DataSet dataSet, bool isUpdate, DataTable theCustomDataDT) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@dataQuality", SqlDbType.Int, hashTable["dataQuality"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, hashTable["UserID"].ToString()); //Appointment Scheduling ClsUtility.AddParameters("@visitDate", SqlDbType.DateTime, hashTable["visitDate"].ToString()); ClsUtility.AddParameters("@TypeofVisit", SqlDbType.Int, hashTable["TypeofVisit"].ToString()); ClsUtility.AddParameters("@Scheduled", SqlDbType.Int, hashTable["Scheduled"].ToString()); ClsUtility.AddParameters("@treatmentSupporterName", SqlDbType.VarChar, hashTable["treatmentSupporterName"].ToString()); ClsUtility.AddParameters("@treatmentSupporterContact", SqlDbType.VarChar, hashTable["treatmentSupporterContact"].ToString()); //Clinical Status ClsUtility.AddParameters("@Temp", SqlDbType.Decimal, hashTable["physTemp"].ToString()); ClsUtility.AddParameters("@height", SqlDbType.Decimal, hashTable["height"].ToString()); ClsUtility.AddParameters("@weight", SqlDbType.Decimal, hashTable["weight"].ToString()); ClsUtility.AddParameters("@BPSystolic", SqlDbType.Decimal, hashTable["BPSystolic"].ToString()); ClsUtility.AddParameters("@BPDiastolic", SqlDbType.Decimal, hashTable["BPDiastolic"].ToString()); //Pegnancy ClsUtility.AddParameters("@pregnant", SqlDbType.Int, hashTable["pregnant"].ToString()); if (hashTable["pregnant"].ToString() == "89") { ClsUtility.AddParameters("@EDD", SqlDbType.DateTime, hashTable["EDD"].ToString()); ClsUtility.AddParameters("@ANCNo", SqlDbType.Int, hashTable["ANCNo"].ToString()); ClsUtility.AddParameters("@ReferredtoPMTCT", SqlDbType.Int, hashTable["ReferredtoPMTCT"].ToString()); } if (hashTable["pregnant"].ToString() == "91") { ClsUtility.AddParameters("@DateofInducedAbortion", SqlDbType.DateTime, hashTable["DateofInducedAbortion"].ToString()); } if (hashTable["pregnant"].ToString() == "92") { ClsUtility.AddParameters("@DateofMiscarriage", SqlDbType.DateTime, hashTable["DateofMiscarriage"].ToString()); } //Family planning ClsUtility.AddParameters("@familyPlanningStatus", SqlDbType.Int, hashTable["familyPlanningStatus"].ToString()); if (hashTable.ContainsKey("NoFamilyPlanning")) { ClsUtility.AddParameters("@NoFamilyPlanning", SqlDbType.Int, hashTable["NoFamilyPlanning"].ToString()); } //TB ClsUtility.AddParameters("@TBStatus", SqlDbType.Int, hashTable["TBStatus"].ToString()); if (hashTable.ContainsKey("TBStartDate")) { ClsUtility.AddParameters("@TBRxStart", SqlDbType.DateTime, hashTable["TBStartDate"].ToString()); } if (hashTable.ContainsKey("TBTreatmentNo")) { ClsUtility.AddParameters("@TBRegNumber", SqlDbType.VarChar, hashTable["TBTreatmentNo"].ToString()); } //Nutritional Problems ClsUtility.AddParameters("@nutritionalProblem", SqlDbType.Int, hashTable["nutritionalProblem"].ToString()); //WHO Stage ClsUtility.AddParameters("@WHOStage", SqlDbType.Int, hashTable["WHOStage"].ToString()); //pharmacy ClsUtility.AddParameters("@CotrimoxazoleAdhere", SqlDbType.Int, hashTable["CotrimoxazoleAdhere"].ToString()); ClsUtility.AddParameters("@ARVDrugsAdhere", SqlDbType.Int, hashTable["ARVDrugsAdhere"].ToString()); ClsUtility.AddParameters("@WhyPooFair", SqlDbType.Int, hashTable["WhyPooFair"].ToString()); if (hashTable.ContainsKey("reasonARVDrugsPoorFairOther")) { ClsUtility.AddParameters("@reasonARVDrugsPoorFairOther", SqlDbType.VarChar, hashTable["reasonARVDrugsPoorFairOther"].ToString()); } //Subsitutions/Interruption ClsUtility.AddParameters("@TherapyPlan", SqlDbType.Int, hashTable["TherapyPlan"].ToString()); ClsUtility.AddParameters("@TherapyReasonCode", SqlDbType.Int, hashTable["TherapyReasonCode"].ToString()); ClsUtility.AddParameters("@TherapyOther", SqlDbType.VarChar, hashTable["TherapyOther"].ToString()); ClsUtility.AddParameters("@PrescribedARVStartDate", SqlDbType.DateTime, hashTable["PrescribedARVStartDate"].ToString()); ClsUtility.AddParameters("@numOfDaysHospitalized", SqlDbType.VarChar, hashTable["numOfDaysHospitalized"].ToString()); ClsUtility.AddParameters("@nutritionalSupport", SqlDbType.Int, hashTable["nutritionalSupport"].ToString()); ClsUtility.AddParameters("@infantFeedingOption", SqlDbType.Int, hashTable["infantFeedingOption"].ToString()); ClsUtility.AddParameters("@attendingClinician", SqlDbType.Int, hashTable["attendingClinician"].ToString()); ClsUtility.AddParameters("@Datenextappointment", SqlDbType.DateTime, hashTable["Datenextappointment"].ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; if (!isUpdate) { // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveInitialFollowupVisit", ClsDBUtility.ObjectEnum.DataSet); // visitID = (int)tempDataSet.Tables[0].Rows[0]["visitID"]; visitID = (int)theDS.Tables[0].Rows[0]["visitID"]; //Family Planning Methods for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, hashTable["UserID"].ToString()); ClsUtility.AddParameters("@familyPlanningMethodID", SqlDbType.Int, dataSet.Tables[0].Rows[i]["familyPlanningMethodID"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareFamilyPlanning", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Potential Side Effects for (int i = 0; i < dataSet.Tables[1].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@potentialSideEffectID", SqlDbType.Int, dataSet.Tables[1].Rows[i]["potentialSideEffectID"].ToString()); ClsUtility.AddParameters("@potentialSideEffectOther", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[1].Rows[i]["potentialSideEffect_Other"]))) ? "" : dataSet.Tables[1].Rows[i]["potentialSideEffect_Other"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCarePotentialSideEffect", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //New OIs Problems for (int i = 0; i < dataSet.Tables[2].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@newOIsProblemID", SqlDbType.Int, dataSet.Tables[2].Rows[i]["newOIsProblemID"].ToString()); ClsUtility.AddParameters("@TBStatus", SqlDbType.Int, hashTable["TBStatus"].ToString()); if (hashTable.ContainsKey("TBTreatmentNo")) { ClsUtility.AddParameters("@TBRegNumber", SqlDbType.VarChar, hashTable["TBTreatmentNo"].ToString()); } ClsUtility.AddParameters("@newOIsProblemIDOther", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[2].Rows[i]["newOIsProblemID_Other"]))) ? "" : dataSet.Tables[2].Rows[i]["newOIsProblemID_Other"].ToString()); ClsUtility.AddParameters("@nutritionalProblem", SqlDbType.Int, hashTable["nutritionalProblem"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareNewOIsProblem", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Referred To for (int i = 0; i < dataSet.Tables[3].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@referredTo", SqlDbType.Int, dataSet.Tables[3].Rows[i]["referredToID"].ToString()); ClsUtility.AddParameters("@referredToOther", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[3].Rows[i]["referredToOtherID_Other"]))) ? "" : dataSet.Tables[3].Rows[i]["referredToOtherID_Other"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareARTReferredTo", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Positive Prevention At Risk Population for (int i = 0; i < dataSet.Tables[4].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@RiskPopulationID", SqlDbType.Int, dataSet.Tables[4].Rows[i]["RiskPopulationID"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareAtRiskPopulation", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Positive Prevention At Risk Population Services for (int i = 0; i < dataSet.Tables[5].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@PopulationServiceID", SqlDbType.Int, dataSet.Tables[5].Rows[i]["PopulationServiceID"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareAtRiskPopulationServices", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Prevention with positives (PwP) for (int i = 0; i < dataSet.Tables[6].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@pwpID", SqlDbType.Int, dataSet.Tables[6].Rows[i]["pwpID"].ToString()); ClsUtility.AddParameters("@pwpID_Other", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[6].Rows[i]["pwpID_Other"]))) ? "" : dataSet.Tables[6].Rows[i]["pwpID_Other"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCarePreventionwithpositives", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } for (Int32 i = 0; i < theCustomDataDT.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomDataDT.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", hashTable["patientID"].ToString()); theQuery = theQuery.Replace("#88#", hashTable["locationID"].ToString()); theQuery = theQuery.Replace("#77#", visitID.ToString()); theQuery = theQuery.Replace("#66#", "'" + hashTable["visitDate"].ToString() + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)VisitManager.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } else { visitID = Convert.ToInt32(hashTable["visitID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, hashTable["visitID"].ToString()); //ClsUtility.AddParameters("@createDate", SqlDbType.DateTime, hashTable["createDate"].ToString()); theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateInitialFollowupVisit", ClsDBUtility.ObjectEnum.DataSet); for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, hashTable["UserID"].ToString()); ClsUtility.AddParameters("@familyPlanningMethodID", SqlDbType.Int, dataSet.Tables[0].Rows[i]["familyPlanningMethodID"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareFamilyPlanning", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Potential Side Effects for (int i = 0; i < dataSet.Tables[1].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@potentialSideEffectID", SqlDbType.Int, dataSet.Tables[1].Rows[i]["potentialSideEffectID"].ToString()); ClsUtility.AddParameters("@potentialSideEffectOther", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[1].Rows[i]["potentialSideEffect_Other"]))) ? "" : dataSet.Tables[1].Rows[i]["potentialSideEffect_Other"].ToString()); //ClsUtility.AddParameters("@createDate", SqlDbType.DateTime, hashTable["createDate"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCarePotentialSideEffect", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //New OIs Problems for (int i = 0; i < dataSet.Tables[2].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@newOIsProblemID", SqlDbType.Int, dataSet.Tables[2].Rows[i]["newOIsProblemID"].ToString()); ClsUtility.AddParameters("@TBStatus", SqlDbType.Int, hashTable["TBStatus"].ToString()); if (hashTable.ContainsKey("TBTreatmentNo")) { ClsUtility.AddParameters("@TBRegNumber", SqlDbType.VarChar, hashTable["TBTreatmentNo"].ToString()); } ClsUtility.AddParameters("@newOIsProblemIDOther", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[2].Rows[i]["newOIsProblemID_Other"]))) ? "" : dataSet.Tables[2].Rows[i]["newOIsProblemID_Other"].ToString()); ClsUtility.AddParameters("@nutritionalProblem", SqlDbType.Int, hashTable["nutritionalProblem"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareNewOIsProblem", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Referred To for (int i = 0; i < dataSet.Tables[3].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@referredTo", SqlDbType.Int, dataSet.Tables[3].Rows[i]["referredToID"].ToString()); ClsUtility.AddParameters("@referredToOther", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[3].Rows[i]["referredToOtherID_Other"]))) ? "" : dataSet.Tables[3].Rows[i]["referredToOtherID_Other"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareARTReferredTo", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Positive Prevention At Risk Population for (int i = 0; i < dataSet.Tables[4].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@RiskPopulationID", SqlDbType.Int, dataSet.Tables[4].Rows[i]["RiskPopulationID"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareAtRiskPopulation", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Positive Prevention At Risk Population Services for (int i = 0; i < dataSet.Tables[5].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@PopulationServiceID", SqlDbType.Int, dataSet.Tables[5].Rows[i]["PopulationServiceID"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCareAtRiskPopulationServices", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Prevention with positives (PwP) for (int i = 0; i < dataSet.Tables[6].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitID", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@pwpID", SqlDbType.Int, dataSet.Tables[6].Rows[i]["pwpID"].ToString()); ClsUtility.AddParameters("@pwpID_Other", SqlDbType.VarChar, (string.IsNullOrEmpty(Convert.ToString(dataSet.Tables[6].Rows[i]["pwpID_Other"]))) ? "" : dataSet.Tables[6].Rows[i]["pwpID_Other"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVCarePreventionwithpositives", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } for (Int32 i = 0; i < theCustomDataDT.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomDataDT.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", hashTable["patientID"].ToString()); theQuery = theQuery.Replace("#88#", hashTable["locationID"].ToString()); theQuery = theQuery.Replace("#77#", visitID.ToString()); theQuery = theQuery.Replace("#66#", "'" + hashTable["visitDate"].ToString() + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)VisitManager.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveCustomFields(string Lblfield, string lbldesc, int FeatureID, int SectionID, int ControlID, int UserID, int UnitFlag, int MinValue, int MaxValue, string UnitsNum, int CodeID, string DataType, string OldLabel, int multiSelect, int iSize, string decodeValues, string deleteValues, int SystemId, int rowcount) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject CustomFields = new ClsObject(); CustomFields.Connection = this.Connection; CustomFields.Transaction = this.Transaction; oUtility.Init_Hashtable(); oUtility.AddParameters("@Label", SqlDbType.VarChar, Lblfield); oUtility.AddParameters("@flddesc", SqlDbType.VarChar, lbldesc); oUtility.AddParameters("@FeatureID", SqlDbType.Int, FeatureID.ToString() == "3" ? "4" : FeatureID.ToString()); oUtility.AddParameters("@SectionID", SqlDbType.Int, SectionID.ToString()); oUtility.AddParameters("@ControlID", SqlDbType.Int, ControlID.ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); oUtility.AddParameters("@UnitFlag", SqlDbType.Int, UnitFlag.ToString()); oUtility.AddParameters("@Min", SqlDbType.Int, MinValue.ToString()); oUtility.AddParameters("@Max", SqlDbType.Int, MaxValue.ToString()); oUtility.AddParameters("@Units", SqlDbType.VarChar, UnitsNum); oUtility.AddParameters("@DataType", SqlDbType.VarChar, DataType.ToString()); oUtility.AddParameters("@OldLabel", SqlDbType.VarChar, OldLabel.ToString()); oUtility.AddParameters("@Size", SqlDbType.Int, iSize.ToString()); oUtility.AddParameters("@decodeValues", SqlDbType.VarChar, decodeValues.ToString()); oUtility.AddParameters("@deleteValues", SqlDbType.VarChar, deleteValues.ToString()); oUtility.AddParameters("@SystemId", SqlDbType.Int, SystemId.ToString()); oUtility.AddParameters("@rowcount", SqlDbType.Int, rowcount.ToString()); int RowsAffected = (Int32)CustomFields.ReturnObject(oUtility.theParams, "pr_Admin_CreateCustomField_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); //oUtility.Init_Hashtable(); //RowsAffected = (Int32)CustomFields.ReturnObject(oUtility.theParams, "pr_CustomFieldResults_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); /* * if (RowsAffected == 0) * { * MsgBuilder theBL = new MsgBuilder(); * theBL.DataElements["MessageText"] = "Error in Saving Custom Fields record. Try Again.."; * AppException.Create("#C1", theBL); * } * else * { * MsgBuilder theBL = new MsgBuilder(); * theBL.DataElements["MessageText"] = "Saved Custom Fields record..."; * AppException.Create("#C1", theBL); * } */ DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(RowsAffected); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveUpdateCusomtField(int ID, string FieldName, int ControlID, int DeleteFlag, int UserID, int CareEnd, int flag, string SelectList, DataTable business, int Predefined, int SystemID, DataTable dtconditionalFields, DataTable dtICD10Fields, DataSet dsFormVersionFields, int FacilityId) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject CustomField = new ClsObject(); CustomField.Connection = this.Connection; CustomField.Transaction = this.Transaction; int theRowAffected = 0; DataRow theDR; /************ Delete Previous Business Rule **********/ if (ID != 0 && flag != 4) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ID", SqlDbType.Int, ID.ToString()); ClsUtility.AddParameters("@Predefined", SqlDbType.Int, Predefined.ToString()); if (ControlID == 19) { theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_Delete_FormBuilderFieldDruglist_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } else { theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_PMTCT_Delete_FieldBusinessRule_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } if (theRowAffected == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Updating Custom Field. Try Again.."; AppException.Create("#C1", theMsg); } } ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ID", SqlDbType.Int, ID.ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, FieldName); ClsUtility.AddParameters("@ControlID", SqlDbType.Int, ControlID.ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, DeleteFlag.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@CareEnd", SqlDbType.Int, CareEnd.ToString()); ClsUtility.AddParameters("@flag", SqlDbType.Int, flag.ToString()); ClsUtility.AddParameters("@SelectList", SqlDbType.VarChar, SelectList); ClsUtility.AddParameters("@Predefined", SqlDbType.Int, Predefined.ToString()); ClsUtility.AddParameters("@SystemID", SqlDbType.Int, SystemID.ToString()); ClsUtility.AddParameters("@FacilityID", SqlDbType.Int, FacilityId.ToString()); theDR = (DataRow)CustomField.ReturnObject(ClsUtility.theParams, "Pr_PMTCT_SaveUpdateCustomFields_Futures", ClsUtility.ObjectEnum.DataRow); int FieldID = Convert.ToInt32(theDR[0].ToString()); if (FieldID == 0) { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Custom Field. Try Again.."; AppException.Create("#C1", theBL); } /************************Add Business Rule*************************/ if (ControlID == 19) { for (int i = 0; i < business.Rows.Count; i++) { if (FieldName == business.Rows[i]["FieldName"].ToString()) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@FieldID", SqlDbType.Int, FieldID.ToString()); ClsUtility.AddParameters("@DrugId", SqlDbType.Int, business.Rows[i]["DrugId"].ToString()); ClsUtility.AddParameters("@DrugTypeId", SqlDbType.Int, business.Rows[i]["DrugTypeId"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@Predefined", SqlDbType.Int, Predefined.ToString()); theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SavePharmacyDrugList_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); if (theRowAffected == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Custom Field. Try Again.."; AppException.Create("#C1", theMsg); } } } } else { for (int i = 0; i < business.Rows.Count; i++) { if (FieldName == business.Rows[i]["FieldName"].ToString()) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@FieldID", SqlDbType.Int, FieldID.ToString()); ClsUtility.AddParameters("@BusRuleID", SqlDbType.Int, business.Rows[i]["BusRuleId"].ToString()); ClsUtility.AddParameters("@Value", SqlDbType.VarChar, business.Rows[i]["Value"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@Predefined", SqlDbType.Int, Predefined.ToString()); //12may2011 ClsUtility.AddParameters("@Value1", SqlDbType.VarChar, business.Rows[i]["Value1"].ToString()); theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_PMTCT_SaveBusinessRules_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); if (theRowAffected == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Custom Field. Try Again.."; AppException.Create("#C1", theMsg); } } } } /**************************Add Conditional Fields*************************************/ int Rec = 0; if (dtconditionalFields != null && dtconditionalFields.Rows.Count == 0) { if (CareEnd == 0) { ClsUtility.Init_Hashtable(); string theTSQL = ""; if (Predefined == 1) { theTSQL = "delete from dbo.lnk_conditionalfields where ConFieldId =" + ID.ToString().Replace("9999", ""); } else if (Predefined == 0) { theTSQL = "delete from dbo.lnk_conditionalfields where ConFieldId =" + ID.ToString().Replace("8888", ""); } Int32 theRow = (Int32)CustomField.ReturnObject(ClsUtility.theParams, theTSQL, ClsUtility.ObjectEnum.ExecuteNonQuery); } else if (CareEnd == 2) { ClsUtility.Init_Hashtable(); string theTSQL = ""; if (Predefined == 1) { theTSQL = "delete from dbo.lnk_PatientRegconditionalfields where ConFieldId =" + ID.ToString().Replace("9999", ""); } else if (Predefined == 0) { theTSQL = "delete from dbo.lnk_PatientRegconditionalfields where ConFieldId =" + ID.ToString().Replace("8888", ""); } Int32 theRow = (Int32)CustomField.ReturnObject(ClsUtility.theParams, theTSQL, ClsUtility.ObjectEnum.ExecuteNonQuery); } else { ClsUtility.Init_Hashtable(); string theTSQL = ""; if (Predefined == 1) { theTSQL = "delete from dbo.lnk_CareEndConditionalFields where ConFieldId =" + ID.ToString().Replace("9999", ""); } else if (Predefined == 0) { theTSQL = "delete from dbo.lnk_CareEndConditionalFields where ConFieldId =" + ID.ToString().Replace("8888", ""); } //string theTSQL = "delete from dbo.lnk_CareEndConditionalFields where ConFieldId =" + ID.ToString(); Int32 theRow = (Int32)CustomField.ReturnObject(ClsUtility.theParams, theTSQL, ClsUtility.ObjectEnum.ExecuteNonQuery); } } foreach (DataRow theDRCon in dtconditionalFields.Rows) { ClsUtility.Init_Hashtable(); Rec = Rec + 1; if (theDRCon["ConPredefine"].ToString() == "1" && CareEnd == 0) { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRCon["ConfieldId"].ToString().Replace("9999", "")); } else if (theDRCon["ConPredefine"].ToString() == "1" && CareEnd == 1) { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRCon["ConfieldId"].ToString().Replace("9999", "")); } else if (theDRCon["ConPredefine"].ToString() == "1" && CareEnd == 2) { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRCon["ConfieldId"].ToString().Replace("9999", "")); } if (theDRCon["ConPredefine"].ToString() == "0" && CareEnd == 0) { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRCon["ConfieldId"].ToString().Replace("8888", "")); } else if (theDRCon["ConPredefine"].ToString() == "0" && CareEnd == 1) { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRCon["ConfieldId"].ToString().Replace("8888", "")); } else if (theDRCon["ConPredefine"].ToString() == "0" && CareEnd == 2) { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRCon["ConfieldId"].ToString().Replace("8888", "")); } ClsUtility.AddParameters("@SectionId", SqlDbType.Int, theDRCon["SectionId"].ToString()); if (CareEnd == 1) { //ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRCon["FieldId"].ToString()); if (theDRCon["Predefined"].ToString() == "1") { ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRCon["FieldId"].ToString().Replace("9999", "")); } else { ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRCon["FieldId"].ToString().Replace("8888", "")); } } else { if (theDRCon["Predefined"].ToString() == "1") { ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRCon["FieldId"].ToString().Replace("9999", "")); } else { ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRCon["FieldId"].ToString().Replace("8888", "")); } } ClsUtility.AddParameters("@FieldLabel", SqlDbType.VarChar, theDRCon["FieldLabel"].ToString()); ClsUtility.AddParameters("@Predefined", SqlDbType.Int, theDRCon["Predefined"].ToString()); ClsUtility.AddParameters("@Seq", SqlDbType.Int, Rec.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, theDRCon["SectionName"].ToString()); ClsUtility.AddParameters("@Conpredefine", SqlDbType.Int, theDRCon["Conpredefine"].ToString()); if (Rec == 1) { ClsUtility.AddParameters("@Delete", SqlDbType.Int, "1"); } ClsUtility.AddParameters("@CareEnd", SqlDbType.Int, CareEnd.ToString()); theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SavelnkConditionalForm_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } int Deleted = 0; foreach (DataRow theDRCon in dtICD10Fields.Rows) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@FieldId", SqlDbType.Int, FieldID.ToString()); ClsUtility.AddParameters("@BlockId", SqlDbType.Int, theDRCon["BlockId"].ToString().Replace("'", "")); ClsUtility.AddParameters("@SubBlockId", SqlDbType.Int, theDRCon["SubBlockId"].ToString().Replace("'", "")); ClsUtility.AddParameters("@CodeId", SqlDbType.Int, theDRCon["CodeId"].ToString().Replace("'", "")); ClsUtility.AddParameters("@Predefined", SqlDbType.Int, Predefined.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, theDRCon["Deleteflag"].ToString()); ClsUtility.AddParameters("@Chapterid", SqlDbType.Int, theDRCon["ChapterId"].ToString().Replace("'", "")); theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SaveICD10CodeItems_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); Deleted = 1; } /**************************************************************************************/ /**************************Add Form Version Conditional Fields *************************************/ if (dsFormVersionFields != null && dsFormVersionFields.Tables.Count > 0 && CareEnd == 0) { ///Save Update Form Version Masters if (dsFormVersionFields.Tables[0].Rows.Count > 0 && dsFormVersionFields.Tables[1].Rows.Count > 0) { foreach (DataRow drfield in dsFormVersionFields.Tables[0].Rows) { decimal vername = Convert.ToDecimal(dsFormVersionFields.Tables[0].Rows[0]["VersionName"]) + Convert.ToDecimal(0.1); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@VerId", SqlDbType.Int, "0"); ClsUtility.AddParameters("@VersionName", SqlDbType.Decimal, vername.ToString()); ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, drfield["FeatureId"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); DataRow theDRVer = (DataRow)CustomField.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SaveFormVersion_Futures", ClsUtility.ObjectEnum.DataRow); foreach (DataRow theDRdetails in dsFormVersionFields.Tables[1].Rows) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@VerId", SqlDbType.Int, theDRVer["VersionId"].ToString()); ClsUtility.AddParameters("@Predefined", SqlDbType.Decimal, theDRdetails["Predefined"].ToString()); ClsUtility.AddParameters("@ConPredefined", SqlDbType.Decimal, theDRdetails["ConPredefined"].ToString()); if (theDRdetails["ConPredefined"].ToString() == "1") { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRdetails["ConfieldId"].ToString().Replace("9999", "")); } else if (theDRdetails["ConPredefine"].ToString() == "0") { ClsUtility.AddParameters("@ConfieldId", SqlDbType.Int, theDRdetails["ConfieldId"].ToString().Replace("8888", "")); } if (theDRdetails["Predefined"].ToString() == "1") { ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRdetails["FieldId"].ToString().Replace("9999", "")); } else if (theDRdetails["Predefined"].ToString() == "0") { ClsUtility.AddParameters("@FieldId", SqlDbType.Int, theDRdetails["FieldId"].ToString().Replace("8888", "")); } ClsUtility.AddParameters("@FunctionId", SqlDbType.Int, theDRdetails["FunctionId"].ToString()); ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, drfield["FeatureId"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserID.ToString()); theRowAffected = (int)CustomField.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SaveFormConditionalVersionDetails_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } } } /**************************************************************************************/ DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(FieldID); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveNonARTFollowUp(int PatientID, int PharmacyID, int LocationID, int VisitID, DataSet theDS, DataTable theDT, Hashtable theHT, DateTime OrderedByDate, DateTime DispensedByDate, Boolean Signature, int EmployeeID, int UserID, Boolean flag, Boolean theHIVAssocDisease, int DataQualityFlag, DataTable theCustomFieldData) { ClsObject NonARTManager = new ClsObject(); int theAffectedRows = 0; int PharmacyId = 0; try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); NonARTManager.Connection = this.Connection; NonARTManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, PatientID.ToString()); //Naveen-Added on 23-Aug-2010 ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); // ClsUtility.AddParameters("@LocationId", SqlDbType.Int, LocationID.ToString()); //Naveen-Added on 23-Aug-2010 ClsUtility.AddParameters("@Visit_pk", SqlDbType.Int, VisitID.ToString()); // ClsUtility.AddParameters("@OrderedBy", SqlDbType.Int, theHT["OrderBy"].ToString()); ClsUtility.AddParameters("@OrderedByDate", SqlDbType.VarChar, OrderedByDate.ToString("dd-MMM-yyyy")); ClsUtility.AddParameters("@DispensedBy", SqlDbType.Int, theHT["DispensedBy"].ToString()); ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, DispensedByDate.ToString("dd-MMM-yyyy")); ClsUtility.AddParameters("@Signature", SqlDbType.Bit, Signature.ToString()); ClsUtility.AddParameters("@EmployeeID", SqlDbType.Int, EmployeeID.ToString()); ClsUtility.AddParameters("@VisitType", SqlDbType.Int, theHT["VisitType"].ToString()); ClsUtility.AddParameters("@VisitDate", SqlDbType.VarChar, Convert.ToDateTime(theHT["VisitDate"]).ToString("dd-MMM-yyyy")); ClsUtility.AddParameters("@Temp", SqlDbType.Decimal, theHT["physTemp"].ToString()); ClsUtility.AddParameters("@RR", SqlDbType.Decimal, theHT["physRR"].ToString()); ClsUtility.AddParameters("@HR", SqlDbType.Decimal, theHT["physHR"].ToString()); ClsUtility.AddParameters("@BPDiastolic", SqlDbType.Decimal, theHT["physBPDiastolic"].ToString()); ClsUtility.AddParameters("@BPSystolic", SqlDbType.Decimal, theHT["physBPSystolic"].ToString()); ClsUtility.AddParameters("@Height", SqlDbType.Int, theHT["physHeight"].ToString()); ClsUtility.AddParameters("@Weight", SqlDbType.Decimal, theHT["physWeight"].ToString()); ClsUtility.AddParameters("@Pain", SqlDbType.Int, theHT["phyPain"].ToString()); ClsUtility.AddParameters("@WHOStage", SqlDbType.Int, theHT["physWHOStage"].ToString()); ClsUtility.AddParameters("@WABStage", SqlDbType.Int, theHT["physWABStage"].ToString()); ClsUtility.AddParameters("@ClinicNotes", SqlDbType.VarChar, theHT["ClinicalNotes"].ToString()); ClsUtility.AddParameters("@Pregnant", SqlDbType.Int, theHT["Pregnant"].ToString()); ClsUtility.AddParameters("@EDDDate", SqlDbType.VarChar, theHT["EDDDate"].ToString()); ClsUtility.AddParameters("@Delivered", SqlDbType.Int, theHT["Delivered"].ToString()); ClsUtility.AddParameters("@DelDate", SqlDbType.VarChar, theHT["DelDate"].ToString()); ClsUtility.AddParameters("@LMP", SqlDbType.DateTime, theHT["LMP"].ToString()); ClsUtility.AddParameters("@userId", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@OrderType", SqlDbType.Int, theHT["OrderType"].ToString()); ClsUtility.AddParameters("@DataQuality", SqlDbType.Int, DataQualityFlag.ToString()); ClsUtility.AddParameters("@AppExist", SqlDbType.VarChar, theHT["AppExist"].ToString()); ClsUtility.AddParameters("@VisitIDApp", SqlDbType.VarChar, theHT["VisitIDApp"].ToString()); ClsUtility.AddParameters("@appdate", SqlDbType.VarChar, theHT["AppDate"].ToString()); ClsUtility.AddParameters("@appreason", SqlDbType.VarChar, theHT["AppReason"].ToString()); ClsUtility.AddParameters("@signatureid", SqlDbType.VarChar, theHT["Signatureid"].ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.Int, theHT["Flag"].ToString()); //ClsUtility.AddParameters("@UpdateMode", SqlDbType.Int, UpdateMode.ToString()); ////if (flag == false) ////{ //// theDSResult = (DataSet)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveNonARTFollowUP_Constella", ClsDBUtility.ObjectEnum.DataSet); //// PharmacyId = Convert.ToInt32(theDSResult.Tables[0].Rows[0][0].ToString()); ////} ////else if (flag == true) ////{ string strResult = string.Empty; int theResult = 0; ////ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ////ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); theDSResult = (DataSet)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdateNonARTFollowUP_Constella", ClsDBUtility.ObjectEnum.DataSet); strResult = Convert.ToString(theDSResult.Tables[0].Rows[0][0]); VisitID = Convert.ToInt32(theDSResult.Tables[1].Rows[0][1]); if (theDSResult.Tables[0].Rows.Count > 0) { if (strResult == "") { theResult = 0; } else { if (PharmacyID == 0) { theResult = Convert.ToInt32(theDSResult.Tables[0].Rows[0][0].ToString()); PharmacyID = Convert.ToInt32(theDSResult.Tables[0].Rows[0][0].ToString()); } } } ////} if (theDSResult.Tables[0].Rows[0][0].ToString() == "") { MsgBuilder theBL = new MsgBuilder(); theBL.DataElements["MessageText"] = "Error in Saving Patient's Non-ART Follow-Up Details. Try Again.."; Exception ex = AppException.Create("#C1", theBL); throw ex; } //Updating Appointment Status #region "Updating Appointment Status" if (Convert.ToInt32(theHT["AppExist"].ToString()) == 1) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Visit_pkAppID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@signatureid", SqlDbType.Int, theHT["OrderBy"].ToString()); int RowsAffected = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateIEAppointmentSignature_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } #endregion #region "Patient's Symptoms" //if (flag == true) //{ // /***************** Delete Previous Symptoms Records *******************/ // ClsUtility.Init_Hashtable(); // ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); // ClsUtility.AddParameters("@patientid", SqlDbType.Int, PatientID.ToString()); // ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteFollowUP_PatientSymptoms_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); // if (theAffectedRows == 0) // { // MsgBuilder theMsg = new MsgBuilder(); // theMsg.DataElements["MessageText"] = "Error in Updating Patient's Symptoms Details for Non-ART FollowUp. Try Again.."; // Exception ex = AppException.Create("#C1", theMsg); // throw ex; // } //} if (theDS.Tables[0].Rows.Count != 0) { for (int i = 0; i < theDS.Tables[0].Rows.Count; i++) { theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@symptomID", SqlDbType.Int, theDS.Tables[0].Rows[i]["PresentComplaintsID"].ToString()); ClsUtility.AddParameters("@userID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //if (flag == false) //{ // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} //else if (flag == true) //{ //ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); //theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's Symptoms Details for Non-ART Follow-Up. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } #endregion #region "Patient TB Symptoms" //if (flag == true) //{ // /***************** Delete Previous Symptoms Records *******************/ // ClsUtility.Init_Hashtable(); // ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); // ClsUtility.AddParameters("@patientid", SqlDbType.Int, PatientID.ToString()); // ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteFollowUP_PatientSymptoms_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); // if (theAffectedRows == 0) // { // MsgBuilder theMsg = new MsgBuilder(); // theMsg.DataElements["MessageText"] = "Error in Updating Patient's TBSymptoms Details for Non-ART FollowUp. Try Again.."; // Exception ex = AppException.Create("#C1", theMsg); // throw ex; // } //} if (theDS.Tables[5].Rows.Count != 0) { for (int i = 0; i < theDS.Tables[5].Rows.Count; i++) { theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@symptomID", SqlDbType.Int, theDS.Tables[5].Rows[i]["TBSymptomsID"].ToString()); ClsUtility.AddParameters("@userID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //if (flag == false) //{ // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveComplaintsIEFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} //else if (flag == true) //{ // ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); // ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's TB Symptoms Details for Non-ART Follow-Up. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } #endregion #region "Patient's HIV Associated Diseases" //if (flag == true) //{ // /******************* Delete Previous HIV Associated Diseases Details *******************/ // theAffectedRows = 0; // ClsUtility.Init_Hashtable(); // ClsUtility.AddParameters("@patientID", SqlDbType.Int, PatientID.ToString()); // ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); // ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteMedicalHistoryIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); // if (theAffectedRows == 0) // { // MsgBuilder theMsg = new MsgBuilder(); // theMsg.DataElements["MessageText"] = "Error in Updating Patient's HIV Associated Diseases Details for Non-ART FollowUp. Try Again.."; // Exception ex = AppException.Create("#C1", theMsg); // throw ex; // } //} if (theDS.Tables[2].Rows.Count != 0) { for (int i = 0; i < theDS.Tables[2].Rows.Count; i++) { theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS.Tables[2].Rows[i][0].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS.Tables[2].Rows[i][1].ToString()); ClsUtility.AddParameters("@HIVAssocDiseasePresent", SqlDbType.Bit, theDS.Tables[2].Rows[i][2].ToString()); ClsUtility.AddParameters("@userID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateNonARTFollowUpHIVAssoCondition_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //if (flag == false) //{ // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVAssoConditionNonARTFollowUp_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} //else if (flag == true) //{ // ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); // ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateNonARTFollowUpHIVAssoCondition_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's HIV Associated Diseases Details for Non-ART Follow-Up. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } if (theHIVAssocDisease == true) { if (theDS.Tables[3].Rows.Count != 0) { for (int i = 0; i < theDS.Tables[3].Rows.Count; i++) { theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@PatientID", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@Locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS.Tables[3].Rows[i][0].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS.Tables[3].Rows[i][1].ToString()); ClsUtility.AddParameters("@HIVAssocDiseasePresent", SqlDbType.Bit, theDS.Tables[3].Rows[i][2].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateNonARTFollowUpHIVAssoCondition_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //if (flag == false) //{ // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveHIVAssoConditionNonARTFollowUp_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} //else if (flag == true) //{ // ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); // ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); // theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateNonARTFollowUpHIVAssoCondition_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); //} if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's HIV Associated Diseases Details for Non-ART Follow-Up. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } } #endregion #region "Assessments" if (flag == true) { /****************** Delete Previous Assessments *******************/ theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@plannotes", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_DeleteFollowUP_PatientAssessment_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Updating Patient's Assessments Details for Non-ART FollowUp. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } if (theDS.Tables[1].Rows.Count != 0) { for (int i = 0; i < theDS.Tables[1].Rows.Count; i++) { theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientID", SqlDbType.Int, PatientID.ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, LocationID.ToString()); ClsUtility.AddParameters("@AssessmentID", SqlDbType.Int, theDS.Tables[1].Rows[i]["AssessmentID"].ToString()); ClsUtility.AddParameters("@userID", SqlDbType.Int, UserID.ToString()); if (flag == false) { theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveAssessmentFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (flag == true) { ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, VisitID.ToString()); ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ""); //createdate.ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, theHT["CreateDate"].ToString()); //createdate.ToString()); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateAssessmentFU_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's Assessments Details for Non-ART Follow-Up. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } #endregion #region "Drugs Details" if (flag == true) { /***************** Delete Previous Drugs Records *******************/ //theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Pharmacy_DeletePharmacyDetail_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Updating Patient's Pharmacy Details for Non-ART FollowUp. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } if (theDS.Tables[4].Rows.Count != 0) { for (int i = 0; i < theDS.Tables[4].Rows.Count; i++) { theAffectedRows = 0; int theFinanced = 99999; int theUnit = 99999; Decimal theDose = 99999; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@GenericID", SqlDbType.Int, theDS.Tables[4].Rows[i]["GenericID"].ToString()); ClsUtility.AddParameters("@Drug_Pk", SqlDbType.Int, theDS.Tables[4].Rows[i]["DrugID"].ToString()); ClsUtility.AddParameters("@StrengthID", SqlDbType.Int, theDS.Tables[4].Rows[i]["Strength"].ToString()); ClsUtility.AddParameters("@FrequencyID", SqlDbType.Int, theDS.Tables[4].Rows[i]["Frequency"].ToString()); ClsUtility.AddParameters("@Duration", SqlDbType.Decimal, theDS.Tables[4].Rows[i]["Duration"].ToString()); ClsUtility.AddParameters("@OrderedQuantity", SqlDbType.Decimal, theDS.Tables[4].Rows[i]["QtyPrescribed"].ToString()); ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Decimal, theDS.Tables[4].Rows[i]["QtyDispensed"].ToString()); ClsUtility.AddParameters("@Finance", SqlDbType.Int, theFinanced.ToString()); ClsUtility.AddParameters("@UnitId", SqlDbType.Int, theUnit.ToString()); ClsUtility.AddParameters("@Dose", SqlDbType.Decimal, theDose.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); if (flag == false) { ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, theDSResult.Tables[0].Rows[0][0].ToString()); } else if (flag == true) { ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); } theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveNonARTDrugDetails_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's Pharmacy Details for Non-ART FollowUp. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } /***************Save Other OI *****************/ if (theDT.Rows.Count != 0) { for (int i = 0; i < theDT.Rows.Count; i++) { theAffectedRows = 0; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@GenericID", SqlDbType.Int, theDT.Rows[i]["GenericID"].ToString()); ClsUtility.AddParameters("@Drug_Pk", SqlDbType.Int, theDT.Rows[i]["DrugID"].ToString()); ClsUtility.AddParameters("@StrengthID", SqlDbType.Int, theDT.Rows[i]["StrengthId"].ToString()); ClsUtility.AddParameters("@FrequencyID", SqlDbType.Int, theDT.Rows[i]["FrequencyId"].ToString()); ClsUtility.AddParameters("@Duration", SqlDbType.Int, theDT.Rows[i]["Duration"].ToString()); ClsUtility.AddParameters("@OrderedQuantity", SqlDbType.Int, theDT.Rows[i]["QtyPrescribed"].ToString()); ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Int, theDT.Rows[i]["QtyDispensed"].ToString()); ClsUtility.AddParameters("@Finance", SqlDbType.Int, theDT.Rows[i]["Financed"].ToString()); ClsUtility.AddParameters("@UnitId", SqlDbType.Int, theDT.Rows[i]["UnitId"].ToString()); ClsUtility.AddParameters("@Dose", SqlDbType.Decimal, theDT.Rows[i]["Dose"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); if (flag == false) { ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, theDSResult.Tables[0].Rows[0][0].ToString()); } else if (flag == true) { ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); } theAffectedRows = (int)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveNonARTDrugDetails_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (theAffectedRows == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving Patient's Pharmacy Details for Non-ART FollowUp. Try Again.."; Exception ex = AppException.Create("#C1", theMsg); throw ex; } } } #endregion #region "Custom Fields" //// Custom Fields ////////////// ////////////PreSet Values Used///////////////// /// #99# --- Ptn_Pk /// #88# --- LocationId /// #77# --- Visit_Pk /// #66# --- Visit_Date /// #55# --- Ptn_Pharmacy_Pk /// #44# --- OrderedByDate /// #33# --- LabId /// #22# --- TrackingId /// #11# --- CareEndedId /// #00# --- HomeVisitId /////////////////////////////////////////////// //ClsObject theCustomManager = new ClsObject(); //Generating VisitID from IE Form //String VisitIDNonART = ""; //if (flag == false) //{ // string theSQL = string.Format("Select IDENT_CURRENT('ord_Visit')"); // ClsUtility.Init_Hashtable(); // DataTable DTVisitID = (DataTable)NonARTManager.ReturnObject(ClsUtility.theParams, theSQL, ClsDBUtility.ObjectEnum.DataTable); // VisitIDNonART = DTVisitID.Rows[0][0].ToString(); //} //if (flag == true) //{ // VisitIDNonART = VisitID.ToString(); //} for (Int32 i = 0; i < theCustomFieldData.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomFieldData.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", PatientID.ToString()); theQuery = theQuery.Replace("#88#", LocationID.ToString()); theQuery = theQuery.Replace("#77#", VisitID.ToString()); theQuery = theQuery.Replace("#66#", "'" + theHT["VisitDate"].ToString() + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)NonARTManager.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //////////////////////////////// #endregion DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDSResult); } catch (Exception err) { DataMgr.RollBackTransation(this.Transaction); throw err; } finally { NonARTManager = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveUpdateKNHPeadraticFollowupData(Hashtable hashTable, DataTable dtMultiSelectValues, int DataQuality, int signature) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitDate", SqlDbType.DateTime, hashTable["visitDate"].ToString()); ClsUtility.AddParameters("@ChildAccompaniedByCaregiver", SqlDbType.Int, hashTable["ChildAccompaniedByCaregiver"].ToString()); ClsUtility.AddParameters("@TreatmentSupporterRelationship", SqlDbType.Int, hashTable["TreatmentSupporterRelationship"].ToString()); ClsUtility.AddParameters("@AddressChanged", SqlDbType.Int, hashTable["AddressChanged"].ToString()); ClsUtility.AddParameters("@AddressChange", SqlDbType.VarChar, hashTable["AddressChange"].ToString()); ClsUtility.AddParameters("@PhoneNoChange", SqlDbType.VarChar, hashTable["PhoneNoChange"].ToString()); ClsUtility.AddParameters("@PrimaryCareGiver", SqlDbType.VarChar, hashTable["PrimaryCareGiver"].ToString()); ClsUtility.AddParameters("@DisclosureStatus", SqlDbType.Int, hashTable["DisclosureStatus"].ToString()); ClsUtility.AddParameters("@ReasonNotDisclosed", SqlDbType.VarChar, hashTable["ReasonNotDisclosed"].ToString()); ClsUtility.AddParameters("@OtherDisclosureReason", SqlDbType.VarChar, hashTable["OtherDisclosureReason"].ToString()); ClsUtility.AddParameters("@HighestLevelAttained", SqlDbType.Int, hashTable["HighestLevelAttained"].ToString()); ClsUtility.AddParameters("@HIVSupportGroupMembership", SqlDbType.VarChar, hashTable["HIVSupportGroupMembership"].ToString()); ClsUtility.AddParameters("@HealthEducation", SqlDbType.Int, hashTable["HealthEducation"].ToString()); ClsUtility.AddParameters("@FatherAlive2", SqlDbType.Int, hashTable["FatherAlive2"].ToString()); ClsUtility.AddParameters("@DateOfDeathFather", SqlDbType.DateTime, hashTable["DateOfDeathFather"].ToString()); ClsUtility.AddParameters("@MotherAlive2", SqlDbType.Int, hashTable["MotherAlive2"].ToString()); ClsUtility.AddParameters("@DateOfDeathMother", SqlDbType.DateTime, hashTable["DateOfDeathMother"].ToString()); ClsUtility.AddParameters("@MedicalHistory", SqlDbType.Int, hashTable["MedicalHistory"].ToString()); ClsUtility.AddParameters("@OtherMedicalHistorySpecify", SqlDbType.VarChar, hashTable["OtherMedicalHistorySpecify"].ToString()); ClsUtility.AddParameters("@OtherChronicCondition", SqlDbType.VarChar, hashTable["OtherChronicCondition"].ToString()); //ClsUtility.AddParameters("@PresentingComplaintsAdditionalNotes", SqlDbType.VarChar, hashTable["PresentingComplaintsAdditionalNotes"].ToString()); ClsUtility.AddParameters("@SchoolPerfomance", SqlDbType.Int, hashTable["SchoolPerfomance"].ToString()); ClsUtility.AddParameters("@ImmunisationStatus", SqlDbType.Int, hashTable["ImmunisationStatus"].ToString()); ClsUtility.AddParameters("@TBHistory", SqlDbType.Int, hashTable["TBHistory"].ToString()); ClsUtility.AddParameters("@TBrxCompleteDate", SqlDbType.DateTime, hashTable["TBrxCompleteDate"].ToString()); ClsUtility.AddParameters("@TBRetreatmentDate", SqlDbType.DateTime, hashTable["TBRetreatmentDate"].ToString()); ClsUtility.AddParameters("@TissueBiopsyTest", SqlDbType.Int, hashTable["TissueBiopsyTest"].ToString()); ClsUtility.AddParameters("@TBFindings", SqlDbType.Int, hashTable["TBFindings"].ToString()); ClsUtility.AddParameters("@SputumSmear", SqlDbType.Int, hashTable["SputumSmear"].ToString()); ClsUtility.AddParameters("@TissueBiopsy", SqlDbType.Int, hashTable["TissueBiopsy"].ToString()); ClsUtility.AddParameters("@ChestXRay", SqlDbType.Int, hashTable["ChestXRay"].ToString()); ClsUtility.AddParameters("@CXR", SqlDbType.Int, hashTable["CXR"].ToString()); ClsUtility.AddParameters("@OtherCXR", SqlDbType.VarChar, hashTable["OtherCXR"].ToString()); ClsUtility.AddParameters("@TissueBiopsyResults", SqlDbType.VarChar, hashTable["TissueBiopsyResults"].ToString()); ClsUtility.AddParameters("@TBTypePeads", SqlDbType.Int, hashTable["TBTypePeads"].ToString()); ClsUtility.AddParameters("@PeadsTBPatientType", SqlDbType.Int, hashTable["PeadsTBPatientType"].ToString()); ClsUtility.AddParameters("@TBPlan", SqlDbType.Int, hashTable["TBPlan"].ToString()); ClsUtility.AddParameters("@OtherTBPlan", SqlDbType.VarChar, hashTable["OtherTBPlan"].ToString()); ClsUtility.AddParameters("@TBRegimen", SqlDbType.Int, hashTable["TBRegimen"].ToString()); ClsUtility.AddParameters("@OtherTBRegimen", SqlDbType.VarChar, hashTable["OtherTBRegimen"].ToString()); ClsUtility.AddParameters("@TBRegimenStartDate", SqlDbType.DateTime, hashTable["TBRegimenStartDate"].ToString()); ClsUtility.AddParameters("@TBRegimenEndDate", SqlDbType.DateTime, hashTable["TBRegimenEndDate"].ToString()); ClsUtility.AddParameters("@TBTreatmentOutcomesPeads", SqlDbType.Int, hashTable["TBTreatmentOutcomesPeads"].ToString()); ClsUtility.AddParameters("@NoTB", SqlDbType.Int, hashTable["NoTB"].ToString()); ClsUtility.AddParameters("@ReminderIPT", SqlDbType.Int, hashTable["ReminderIPT"].ToString()); ClsUtility.AddParameters("@INHStartDate", SqlDbType.DateTime, hashTable["INHStartDate"].ToString()); ClsUtility.AddParameters("@INHEndDate", SqlDbType.DateTime, hashTable["INHEndDate"].ToString()); ClsUtility.AddParameters("@PyridoxineStartDate", SqlDbType.DateTime, hashTable["PyridoxineStartDate"].ToString()); ClsUtility.AddParameters("@PyridoxineEndDate", SqlDbType.DateTime, hashTable["PyridoxineEndDate"].ToString()); ClsUtility.AddParameters("@TBAdherenceAssessed", SqlDbType.Int, hashTable["TBAdherenceAssessed"].ToString()); ClsUtility.AddParameters("@ReferredForAdherence", SqlDbType.Int, hashTable["ReferredForAdherence"].ToString()); ClsUtility.AddParameters("@OtherTBsideEffects", SqlDbType.VarChar, hashTable["OtherTBsideEffects"].ToString()); ClsUtility.AddParameters("@StopINH", SqlDbType.Int, hashTable["StopINH"].ToString()); ClsUtility.AddParameters("@StopINHDate", SqlDbType.DateTime, hashTable["StopINHDate"].ToString()); ClsUtility.AddParameters("@ContactsScreenedForTB", SqlDbType.Int, hashTable["ContactsScreenedForTB"].ToString()); ClsUtility.AddParameters("@TBnotScreenedSpecify", SqlDbType.VarChar, hashTable["TBnotScreenedSpecify"].ToString()); ClsUtility.AddParameters("@LongTermMedications", SqlDbType.Int, hashTable["LongTermMedications"].ToString()); ClsUtility.AddParameters("@MultivitaminsDate", SqlDbType.DateTime, hashTable["MultivitaminsDate"].ToString()); ClsUtility.AddParameters("@SulfaTMPDate", SqlDbType.DateTime, hashTable["SulfaTMPDate"].ToString()); ClsUtility.AddParameters("@TBRxDate", SqlDbType.DateTime, hashTable["TBRxDate"].ToString()); ClsUtility.AddParameters("@HormonalContraceptivesDate", SqlDbType.DateTime, hashTable["HormonalContraceptivesDate"].ToString()); ClsUtility.AddParameters("@AntifungalsDate", SqlDbType.DateTime, hashTable["AntifungalsDate"].ToString()); ClsUtility.AddParameters("@AnticonvulsantsDate", SqlDbType.DateTime, hashTable["AnticonvulsantsDate"].ToString()); ClsUtility.AddParameters("@OtherLongTermMedications", SqlDbType.VarChar, hashTable["OtherLongTermMedications"].ToString()); ClsUtility.AddParameters("@OtherCurrentLongTermMedications", SqlDbType.VarChar, hashTable["OtherCurrentLongTermMedications"].ToString()); //ClsUtility.AddParameters("@MilestoneAppropriate", SqlDbType.Int, hashTable["MilestoneAppropriate"].ToString()); ClsUtility.AddParameters("@ResonMilestoneInappropriate", SqlDbType.VarChar, hashTable["ResonMilestoneInappropriate"].ToString()); ClsUtility.AddParameters("@OtherGeneralConditions", SqlDbType.VarChar, hashTable["OtherGeneralConditions"].ToString()); ClsUtility.AddParameters("@OtherAbdomenConditions", SqlDbType.VarChar, hashTable["OtherAbdomenConditions"].ToString()); ClsUtility.AddParameters("@OtherCardiovascularConditions", SqlDbType.VarChar, hashTable["OtherCardiovascularConditions"].ToString()); ClsUtility.AddParameters("@OtherOralCavityConditions", SqlDbType.VarChar, hashTable["OtherOralCavityConditions"].ToString()); ClsUtility.AddParameters("@OtherGenitourinaryConditions", SqlDbType.VarChar, hashTable["OtherGenitourinaryConditions"].ToString()); ClsUtility.AddParameters("@OtherCNSConditions", SqlDbType.VarChar, hashTable["OtherCNSConditions"].ToString()); ClsUtility.AddParameters("@OtherChestLungsConditions", SqlDbType.VarChar, hashTable["OtherChestLungsConditions"].ToString()); ClsUtility.AddParameters("@OtherSkinConditions", SqlDbType.VarChar, hashTable["OtherSkinConditions"].ToString()); ClsUtility.AddParameters("@OtherMedicalConditionNotes", SqlDbType.VarChar, hashTable["OtherMedicalConditionNotes"].ToString()); ClsUtility.AddParameters("@ProgressionInWHOstage", SqlDbType.VarChar, hashTable["ProgressionInWHOstage"].ToString()); ClsUtility.AddParameters("@SpecifyWHOprogression", SqlDbType.VarChar, hashTable["SpecifyWHOprogression"].ToString()); ClsUtility.AddParameters("@CurrentlyOnHAART", SqlDbType.Int, hashTable["CurrentlyOnHAART"].ToString()); ClsUtility.AddParameters("@CurrentARTRegimenLine", SqlDbType.Int, hashTable["CurrentARTRegimenLine"].ToString()); ClsUtility.AddParameters("@CurrentARTRegimen", SqlDbType.Int, hashTable["CurrentARTRegimen"].ToString()); ClsUtility.AddParameters("@OtherARTRegimen", SqlDbType.VarChar, hashTable["OtherARTRegimen"].ToString()); ClsUtility.AddParameters("@CurrentARTRegimenDate", SqlDbType.DateTime, hashTable["CurrentARTRegimenDate"].ToString()); ClsUtility.AddParameters("@OIProphylaxis", SqlDbType.Int, hashTable["OIProphylaxis"].ToString()); ClsUtility.AddParameters("@ReasonCTXpresribed", SqlDbType.Int, hashTable["ReasonCTXpresribed"].ToString()); ClsUtility.AddParameters("@OtherOIProphylaxis", SqlDbType.VarChar, hashTable["OtherOIProphylaxis"].ToString()); ClsUtility.AddParameters("@OtherTreatment", SqlDbType.VarChar, hashTable["OtherTreatment"].ToString()); ClsUtility.AddParameters("@MissedDosesFUP", SqlDbType.Int, hashTable["MissedDosesFUP"].ToString()); ClsUtility.AddParameters("@MissedDosesFUPspecify", SqlDbType.VarChar, hashTable["MissedDosesFUPspecify"].ToString()); ClsUtility.AddParameters("@DelaysInTakingMedication", SqlDbType.Int, hashTable["DelaysInTakingMedication"].ToString()); ClsUtility.AddParameters("@ARVSideEffects", SqlDbType.Int, hashTable["ARVSideEffects"].ToString()); ClsUtility.AddParameters("@Specifyothershorttermeffects", SqlDbType.VarChar, hashTable["Specifyothershorttermeffects"].ToString()); ClsUtility.AddParameters("@listlongtermeffect", SqlDbType.VarChar, hashTable["listlongtermeffect"].ToString()); ClsUtility.AddParameters("@HAARTImpression", SqlDbType.Int, hashTable["HAARTImpression"].ToString()); ClsUtility.AddParameters("@HAARTexperienced", SqlDbType.Int, hashTable["HAARTexperienced"].ToString()); ClsUtility.AddParameters("@OtherHAARTImpression", SqlDbType.VarChar, hashTable["OtherHAARTImpression"].ToString()); ClsUtility.AddParameters("@ReviewedPreviousResults", SqlDbType.Int, hashTable["ReviewedPreviousResults"].ToString()); ClsUtility.AddParameters("@ResultsReviewComments", SqlDbType.VarChar, hashTable["ResultsReviewComments"].ToString()); ClsUtility.AddParameters("@HIVRelatedOI", SqlDbType.VarChar, hashTable["HIVRelatedOI"].ToString()); ClsUtility.AddParameters("@NonHIVRelatedOI", SqlDbType.VarChar, hashTable["NonHIVRelatedOI"].ToString()); ClsUtility.AddParameters("@LabEvaluationPeads", SqlDbType.Int, hashTable["LabEvaluationPeads"].ToString()); ClsUtility.AddParameters("@OtherCounselling", SqlDbType.VarChar, hashTable["OtherCounselling"].ToString()); ClsUtility.AddParameters("@AdditionalPsychosocialAssessment", SqlDbType.VarChar, hashTable["AdditionalPsychosocialAssessment"].ToString()); ClsUtility.AddParameters("@ARTTreatmentPlan", SqlDbType.Int, hashTable["ARTTreatmentPlan"].ToString()); ClsUtility.AddParameters("@SubstituteRegimenDrug", SqlDbType.VarChar, hashTable["SubstituteRegimenDrug"].ToString()); ClsUtility.AddParameters("@SpecifyotherARTchangereason", SqlDbType.VarChar, hashTable["SpecifyotherARTchangereason"].ToString()); ClsUtility.AddParameters("@2ndLineRegimenSwitch", SqlDbType.Int, hashTable["2ndLineRegimenSwitch"].ToString()); ClsUtility.AddParameters("@RegimenPrescribed", SqlDbType.Int, hashTable["RegimenPrescribed"].ToString()); ClsUtility.AddParameters("@OtherRegimenPrescribed", SqlDbType.VarChar, hashTable["OtherRegimenPrescribed"].ToString()); ClsUtility.AddParameters("@rdoSexualOrientation", SqlDbType.Int, hashTable["rdoSexualOrientation"].ToString()); ClsUtility.AddParameters("@SexualOrientation", SqlDbType.Int, hashTable["SexualOrientation"].ToString()); ClsUtility.AddParameters("@KnowSexualPartnerHIVStatus", SqlDbType.Int, hashTable["KnowSexualPartnerHIVStatus"].ToString()); ClsUtility.AddParameters("@PartnerHIVStatus", SqlDbType.Int, hashTable["PartnerHIVStatus"].ToString()); ClsUtility.AddParameters("@LMPassessed", SqlDbType.Int, hashTable["LMPassessed"].ToString()); ClsUtility.AddParameters("@LMPDate", SqlDbType.DateTime, hashTable["LMPDate"].ToString()); ClsUtility.AddParameters("@LMPNotaccessedReason", SqlDbType.Int, hashTable["LMPNotaccessedReason"].ToString()); ClsUtility.AddParameters("@pregnant", SqlDbType.Int, hashTable["pregnant"].ToString()); ClsUtility.AddParameters("@EDD", SqlDbType.DateTime, hashTable["EDD"].ToString()); ClsUtility.AddParameters("@GivenPWPMessages", SqlDbType.Int, hashTable["GivenPWPMessages"].ToString()); ClsUtility.AddParameters("@UnsafeSexImportanceExplained", SqlDbType.Int, hashTable["UnsafeSexImportanceExplained"].ToString()); ClsUtility.AddParameters("@CondomsIssued", SqlDbType.Int, hashTable["CondomsIssued"].ToString()); ClsUtility.AddParameters("@ReasonfornotIssuingCondoms", SqlDbType.VarChar, hashTable["ReasonfornotIssuingCondoms"].ToString()); ClsUtility.AddParameters("@STIscreenedPeads", SqlDbType.Int, hashTable["STIscreenedPeads"].ToString()); ClsUtility.AddParameters("@UrethralDischarge", SqlDbType.Int, hashTable["UrethralDischarge"].ToString()); ClsUtility.AddParameters("@VaginalDischarge", SqlDbType.Int, hashTable["VaginalDischarge"].ToString()); ClsUtility.AddParameters("@GenitalUlceration", SqlDbType.Int, hashTable["GenitalUlceration"].ToString()); ClsUtility.AddParameters("@STItreatmentPlan", SqlDbType.VarChar, hashTable["STItreatmentPlan"].ToString()); ClsUtility.AddParameters("@CervicalCancerScreened", SqlDbType.Int, hashTable["CervicalCancerScreened"].ToString()); ClsUtility.AddParameters("@CervicalCancerScreeningResults", SqlDbType.Int, hashTable["CervicalCancerScreeningResults"].ToString()); ClsUtility.AddParameters("@ReferredForCervicalCancerScreening", SqlDbType.Int, hashTable["ReferredForCervicalCancerScreening"].ToString()); ClsUtility.AddParameters("@HPVOffered", SqlDbType.Int, hashTable["HPVOffered"].ToString()); ClsUtility.AddParameters("@OfferedHPVaccine", SqlDbType.Int, hashTable["OfferedHPVaccine"].ToString()); ClsUtility.AddParameters("@HPVDoseDate", SqlDbType.DateTime, hashTable["HPVDoseDate"].ToString()); ClsUtility.AddParameters("@OtherPwPInteventions", SqlDbType.VarChar, hashTable["OtherPwPInteventions"].ToString()); ClsUtility.AddParameters("@WardAdmission", SqlDbType.Int, hashTable["WardAdmission"].ToString()); ClsUtility.AddParameters("@ReferredTo", SqlDbType.Int, hashTable["ReferredTo"].ToString()); ClsUtility.AddParameters("@SpecifyOtherReferredTo", SqlDbType.Int, hashTable["SpecifyOtherReferredTo"].ToString()); ClsUtility.AddParameters("@ScheduledAppointment", SqlDbType.VarChar, hashTable["ScheduledAppointment"].ToString()); ClsUtility.AddParameters("@Otherappointmentreason", SqlDbType.VarChar, hashTable["Otherappointmentreason"].ToString()); if (hashTable["Temp"].ToString() != "") { ClsUtility.AddParameters("@Temp", SqlDbType.Decimal, hashTable["Temp"].ToString()); } if (hashTable["RR"].ToString() != "") { ClsUtility.AddParameters("@RR", SqlDbType.Decimal, hashTable["RR"].ToString()); } if (hashTable["HR"].ToString() != "") { ClsUtility.AddParameters("@HR", SqlDbType.Decimal, hashTable["HR"].ToString()); } if (hashTable["height"].ToString() != "") { ClsUtility.AddParameters("@height", SqlDbType.Decimal, hashTable["height"].ToString()); } if (hashTable["weight"].ToString() != "") { ClsUtility.AddParameters("@weight", SqlDbType.Decimal, hashTable["weight"].ToString()); } if (hashTable["BPDiastolic"].ToString() != "") { ClsUtility.AddParameters("@BPDiastolic", SqlDbType.Decimal, hashTable["BPDiastolic"].ToString()); } if (hashTable["BPSystolic"].ToString() != "") { ClsUtility.AddParameters("@BPSystolic", SqlDbType.Decimal, hashTable["BPSystolic"].ToString()); } ClsUtility.AddParameters("@DataQlty", SqlDbType.Int, DataQuality.ToString()); ClsUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdate_KNH_PaediatricFollowup_FORM", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { if (dtMultiSelectValues.Rows[i]["ID"].ToString() != "") { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int UpsizeData(DataTable theDT, DataTable tblDataTypes, string DBName, string TableName) { //////SqlConnection theCon = (SqlConnection)Entity.GetConnection(ConStr); //////SqlTransaction theTran = theCon.BeginTransaction(); int i = 0; ///////////////////////////// //StreamWriter theWriter = new StreamWriter("c:\\miglog.txt"); //theWriter = File.AppendText("c:\\miglog.txt"); //////////////////////////// try { //////this.Connection = theCon; //////this.Transaction = theTran; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); //////Entity theObject = new Entity(); //////theObject.Connection = this.Connection; //////theObject.Transaction = this.Transaction; ClsObject objUpsize = new ClsObject(); objUpsize.Connection = this.Connection; objUpsize.Transaction = this.Transaction; /////// Table Creation////// string ColumnList = ""; foreach (DataColumn theCol in theDT.Columns) { DataView theDV = new DataView(tblDataTypes); theDV.RowFilter = "COLUMN_NAME ='" + theCol.ColumnName.ToString() + "'"; if (ColumnList == "") { ColumnList = "[" + theCol.ColumnName.ToString() + "]"; if (theDV[0]["CHARACTER_MAXIMUM_LENGTH"].ToString() != "") { ColumnList = ColumnList + " " + dbType(theCol.DataType.Name, theDV[0]["CHARACTER_MAXIMUM_LENGTH"].ToString()); } else { ColumnList = ColumnList + " " + dbType(theCol.DataType.Name, theDV[0]["NUMERIC_PRECISION"].ToString()); } } else { ColumnList = ColumnList + "," + "[" + theCol.ColumnName.ToString() + "]"; if (theDV[0]["CHARACTER_MAXIMUM_LENGTH"].ToString() != "") { ColumnList = ColumnList + " " + dbType(theCol.DataType.Name, theDV[0]["CHARACTER_MAXIMUM_LENGTH"].ToString()); } else { ColumnList = ColumnList + " " + dbType(theCol.DataType.Name, theDV[0]["NUMERIC_PRECISION"].ToString()); } } } string cmd = "create table " + TableName + "( " + ColumnList + ")"; ClsUtility.Init_Hashtable(); int RowsAffected = (Int32)objUpsize.ReturnObject(ClsUtility.theParams, cmd, ClsDBUtility.ObjectEnum.ExecuteNonQuery); //////////////////////////////// //////////////////////////////// /////Export Data///////////// ColumnList = ""; cmd = ""; string theColumns = ""; foreach (DataRow theDR in theDT.Rows) { cmd = "insert into " + TableName + " values("; theColumns = ""; for (i = 0; i < theDT.Columns.Count; i++) { if (theColumns == "") { theColumns = FString(theDR[i].ToString()); } else { theColumns = theColumns + "," + FString(theDR[i].ToString()); } } cmd = cmd + theColumns + ")"; ClsUtility.Init_Hashtable(); RowsAffected = (Int32)objUpsize.ReturnObject(ClsUtility.theParams, cmd, ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //////theTran.Commit(); //////theCon.Close(); DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(RowsAffected); } //////////////////////////////// //////catch (SqlException ex) catch { //theWriter.WriteLine(ex.Message.ToString()+"-"+ TableName + "-" + i.ToString()); //////theTran.Rollback(); DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveUpdateKNHPeadraticFollowupData_TriageTab(Hashtable hashTable, DataTable dtMultiSelectValues, int DataQuality, int signature, int UserId) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["visitDate"].ToString())); ClsUtility.AddParameters("@ChildAccompaniedByCaregiver", SqlDbType.Int, hashTable["ChildAccompaniedByCaregiver"].ToString()); ClsUtility.AddParameters("@TreatmentSupporterRelationship", SqlDbType.Int, hashTable["TreatmentSupporterRelationship"].ToString()); ClsUtility.AddParameters("@PrimaryCareGiver", SqlDbType.VarChar, hashTable["PrimaryCareGiver"].ToString()); ClsUtility.AddParameters("@DisclosureStatus", SqlDbType.Int, hashTable["DisclosureStatus"].ToString()); ClsUtility.AddParameters("@ReasonNotDisclosed", SqlDbType.VarChar, hashTable["ReasonNotDisclosed"].ToString()); ClsUtility.AddParameters("@OtherDisclosureReason", SqlDbType.VarChar, hashTable["OtherDisclosureReason"].ToString()); ClsUtility.AddParameters("@FatherAlive2", SqlDbType.Int, hashTable["FatherAlive2"].ToString()); ClsUtility.AddParameters("@DateOfDeathFather", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["DateOfDeathFather"].ToString())); ClsUtility.AddParameters("@MotherAlive2", SqlDbType.Int, hashTable["MotherAlive2"].ToString()); ClsUtility.AddParameters("@DateOfDeathMother", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["DateOfDeathMother"].ToString())); ClsUtility.AddParameters("@HealthEducation", SqlDbType.Int, hashTable["HealthEducation"].ToString()); ClsUtility.AddParameters("@SchoolingStatus", SqlDbType.Int, hashTable["SchoolingStatus"].ToString()); ClsUtility.AddParameters("@HighestLevelAttained", SqlDbType.Int, hashTable["HighestLevelAttained"].ToString()); ClsUtility.AddParameters("@HIVSupportGroup", SqlDbType.Int, hashTable["HIVSupportGroup"].ToString()); ClsUtility.AddParameters("@HIVSupportGroupMembership", SqlDbType.VarChar, hashTable["HIVSupportGroupMembership"].ToString()); ClsUtility.AddParameters("@AddressChanged", SqlDbType.Int, hashTable["AddressChanged"].ToString()); ClsUtility.AddParameters("@AddressChange", SqlDbType.VarChar, hashTable["AddressChange"].ToString()); ClsUtility.AddParameters("@PhoneNoChange", SqlDbType.VarChar, hashTable["PhoneNoChange"].ToString()); ClsUtility.AddParameters("@NursesComments", SqlDbType.VarChar, hashTable["NursesComments"].ToString()); if (hashTable["Temp"].ToString() != "") { ClsUtility.AddParameters("@Temp", SqlDbType.Decimal, hashTable["Temp"].ToString()); } if (hashTable["RR"].ToString() != "") { ClsUtility.AddParameters("@RR", SqlDbType.Decimal, hashTable["RR"].ToString()); } if (hashTable["HR"].ToString() != "") { ClsUtility.AddParameters("@HR", SqlDbType.Decimal, hashTable["HR"].ToString()); } if (hashTable["height"].ToString() != "") { ClsUtility.AddParameters("@height", SqlDbType.Decimal, hashTable["height"].ToString()); } if (hashTable["weight"].ToString() != "") { ClsUtility.AddParameters("@weight", SqlDbType.Decimal, hashTable["weight"].ToString()); } if (hashTable["BPDiastolic"].ToString() != "") { ClsUtility.AddParameters("@BPDiastolic", SqlDbType.Decimal, hashTable["BPDiastolic"].ToString()); } if (hashTable["BPSystolic"].ToString() != "") { ClsUtility.AddParameters("@BPSystolic", SqlDbType.Decimal, hashTable["BPSystolic"].ToString()); } if (hashTable["HeadCircumference"].ToString() != "") { ClsUtility.AddParameters("@HeadCircumference", SqlDbType.Decimal, hashTable["HeadCircumference"].ToString()); } if (hashTable["WeightForAge"].ToString() != "") { ClsUtility.AddParameters("@WeightForAge", SqlDbType.Decimal, hashTable["WeightForAge"].ToString()); } if (hashTable["WeightForHeight"].ToString() != "") { ClsUtility.AddParameters("WeightForHeight", SqlDbType.Int, hashTable["WeightForHeight"].ToString()); } ClsUtility.AddParameters("@StartTime", SqlDbType.VarChar, hashTable["starttime"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@DataQlty", SqlDbType.Int, DataQuality.ToString()); ClsUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdate_KNH_PaediatricFollow_FORM_TriageTab", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { if (dtMultiSelectValues.Rows[i]["ID"].ToString() != "") { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); ClsUtility.AddParameters("@OtherNotes", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["Other_Notes"].ToString()); ClsUtility.AddParameters("@DateField1", SqlDbType.DateTime, dtMultiSelectValues.Rows[i]["DateField1"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int UpdateICDCodeRecord(string Id, Hashtable theHT, ArrayList theAL) { String TableName = "mst_" + theHT["TableName"].ToString(); ClsObject CustomManager = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); CustomManager.Connection = this.Connection; this.Transaction = DataMgr.BeginTransaction(this.Connection); CustomManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@TableName", SqlDbType.VarChar, TableName); ClsUtility.AddParameters("@Id", SqlDbType.Int, Id.ToString()); ClsUtility.AddParameters("@Name", SqlDbType.VarChar, theHT["Name"].ToString()); ClsUtility.AddParameters("@Code", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@Stage", SqlDbType.VarChar, theHT["Stage"].ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, theHT["Status"].ToString()); ClsUtility.AddParameters("@Sequence", SqlDbType.Int, theHT["Sequence"].ToString()); ClsUtility.AddParameters("@Category", SqlDbType.Int, theHT["Category"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, theHT["UserId"].ToString()); ClsUtility.AddParameters("@SystemId", SqlDbType.Int, theHT["SystemId"].ToString()); ClsUtility.AddParameters("@CID", SqlDbType.Int, theHT["CountryID"].ToString()); Int32 RowsAffected = (Int32)CustomManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_UpdateCustomListMasters_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); String DiseaseId = Convert.ToString(Id); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@DiseaseId", SqlDbType.Int, DiseaseId); ClsUtility.AddParameters("@ICDCodeId", SqlDbType.Int, theHT["ICDCode"].ToString()); ClsUtility.AddParameters("@Validate", SqlDbType.Int, theHT["Validate"].ToString()); if (Convert.ToInt32(theHT["Code"]) == 31) { ClsUtility.AddParameters("@DiseaseFlag", SqlDbType.Int, "1"); } else { ClsUtility.AddParameters("@DiseaseFlag", SqlDbType.Int, "0"); } ClsUtility.AddParameters("@UserId", SqlDbType.Int, theHT["UserId"].ToString()); int RowsAffectedICDCode = (Int32)CustomManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_UpdateCustomMastersLinkICDCodes_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); int CountFlag = 0; foreach (String AR in theAL) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@DiseaseId", SqlDbType.Int, DiseaseId); ClsUtility.AddParameters("@CountFlag", SqlDbType.Int, CountFlag.ToString()); ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, AR); ClsUtility.AddParameters("@ICDCodeId", SqlDbType.Int, theHT["ICDCode"].ToString()); if (Convert.ToInt32(theHT["Code"]) == 31) { ClsUtility.AddParameters("@DiseaseFlag", SqlDbType.Int, "1"); } else { ClsUtility.AddParameters("@DiseaseFlag", SqlDbType.Int, "0"); } ClsUtility.AddParameters("@UserId", SqlDbType.Int, theHT["UserId"].ToString()); int RowsAffectedModuleICDCode = (Int32)CustomManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_UpdateCustomMastersLinkModuleICDCodes_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); CountFlag++; } DataMgr.CommitTransaction(this.Transaction); return(RowsAffectedICDCode); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { CustomManager = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveUpdateKNHPeadraticFollowupData_ExamTab(Hashtable hashTable, DataTable dtMultiSelectValues, int DataQuality, int signature, int UserId) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); ClsUtility.AddParameters("@locationID", SqlDbType.Int, hashTable["locationID"].ToString()); ClsUtility.AddParameters("@visitDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["visitDate"].ToString())); ClsUtility.AddParameters("@OtherCurrentLongTermMedications", SqlDbType.VarChar, hashTable["OtherCurrentLongTermMedications"].ToString()); ClsUtility.AddParameters("@MilestoneAppropriate", SqlDbType.Int, hashTable["MilestoneAppropriate"].ToString()); ClsUtility.AddParameters("@ResonMilestoneInappropriate", SqlDbType.VarChar, hashTable["ResonMilestoneInappropriate"].ToString()); ClsUtility.AddParameters("@OtherGeneralConditions", SqlDbType.VarChar, hashTable["OtherGeneralConditions"].ToString()); ClsUtility.AddParameters("@OtherAbdomenConditions", SqlDbType.VarChar, hashTable["OtherAbdomenConditions"].ToString()); ClsUtility.AddParameters("@OtherCardiovascularConditions", SqlDbType.VarChar, hashTable["OtherCardiovascularConditions"].ToString()); ClsUtility.AddParameters("@OtherOralCavityConditions", SqlDbType.VarChar, hashTable["OtherOralCavityConditions"].ToString()); ClsUtility.AddParameters("@OtherGenitourinaryConditions", SqlDbType.VarChar, hashTable["OtherGenitourinaryConditions"].ToString()); ClsUtility.AddParameters("@OtherCNSConditions", SqlDbType.VarChar, hashTable["OtherCNSConditions"].ToString()); ClsUtility.AddParameters("@OtherChestLungsConditions", SqlDbType.VarChar, hashTable["OtherChestLungsConditions"].ToString()); ClsUtility.AddParameters("@OtherSkinConditions", SqlDbType.VarChar, hashTable["OtherSkinConditions"].ToString()); ClsUtility.AddParameters("@OtherMedicalConditionNotes", SqlDbType.VarChar, hashTable["OtherMedicalConditionNotes"].ToString()); ClsUtility.AddParameters("@ProgressionInWHOstage", SqlDbType.Int, hashTable["ProgressionInWHOstage"].ToString()); ClsUtility.AddParameters("@SpecifyWHOprogression", SqlDbType.VarChar, hashTable["SpecifyWHOprogression"].ToString()); ClsUtility.AddParameters("@WABStage", SqlDbType.Int, hashTable["WABStage"].ToString()); ClsUtility.AddParameters("@CurrentWHOStage", SqlDbType.Int, hashTable["CurrentWHOStage"].ToString()); ClsUtility.AddParameters("@Menarche", SqlDbType.Int, hashTable["Menarche"].ToString()); ClsUtility.AddParameters("@MenarcheDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["MenarcheDate"].ToString())); ClsUtility.AddParameters("@TannerStaging", SqlDbType.Int, hashTable["TannerStaging"].ToString()); ClsUtility.AddParameters("@Impression", SqlDbType.Int, hashTable["Impression"].ToString()); ClsUtility.AddParameters("@OtherImpression", SqlDbType.VarChar, hashTable["OtherImpression"].ToString()); ClsUtility.AddParameters("@reviewprevresult", SqlDbType.Int, hashTable["reviewprevresult"].ToString()); ClsUtility.AddParameters("@additonalinformation", SqlDbType.Int, hashTable["additonalinformation"].ToString()); ClsUtility.AddParameters("@HIVRelatedOI", SqlDbType.VarChar, hashTable["HIVRelatedOI"].ToString()); ClsUtility.AddParameters("@NonHIVRelatedOI", SqlDbType.Int, hashTable["NonHIVRelatedOI"].ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); ClsUtility.AddParameters("@DataQlty", SqlDbType.Int, DataQuality.ToString()); ClsUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); ClsUtility.AddParameters("@StartTime", SqlDbType.VarChar, hashTable["starttime"].ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdate_KNH_PaediatricFollowup_FORM_ExamTab", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { if (dtMultiSelectValues.Rows[i]["ID"].ToString() != "") { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); ClsUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); ClsUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); ClsUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); ClsUtility.AddParameters("@OtherNotes", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["Other_Notes"].ToString()); ClsUtility.AddParameters("@DateField1", SqlDbType.DateTime, dtMultiSelectValues.Rows[i]["DateField1"].ToString()); int temp = (int)VisitManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveUpdate(String Insert, DataSet DS, int TabId) { DataSet theDS = new DataSet(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject CustomMgrSave = new ClsObject(); CustomMgrSave.Connection = this.Connection; CustomMgrSave.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Insert", SqlDbType.VarChar, Insert.ToString()); theDS = (DataSet)CustomMgrSave.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveCustomForm_Constella", ClsUtility.ObjectEnum.DataSet); int LabID = Convert.ToInt32(theDS.Tables[2].Rows[0]["LabID"]); for (int i = 0; i < DS.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@LabID", SqlDbType.Int, LabID.ToString()); ClsUtility.AddParameters("@LocationID", SqlDbType.Int, theDS.Tables[2].Rows[0]["LocationId"].ToString()); ClsUtility.AddParameters("@LabTestID", SqlDbType.Int, DS.Tables[0].Rows[i]["LabTestId"].ToString()); ClsUtility.AddParameters("@ParameterID", SqlDbType.Int, DS.Tables[0].Rows[i]["LabParameterId"].ToString()); ClsUtility.AddParameters("@TestResults", SqlDbType.Decimal, DS.Tables[0].Rows[i]["LabResult"].ToString()); ClsUtility.AddParameters("@TestResults1", SqlDbType.Decimal, DS.Tables[0].Rows[i]["LabResult1"].ToString()); ClsUtility.AddParameters("@Financed", SqlDbType.Int, DS.Tables[0].Rows[i]["Financed"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, theDS.Tables[2].Rows[0]["UserId"].ToString()); ClsUtility.AddParameters("@TabId", SqlDbType.Int, TabId.ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.VarChar, "Lab"); int retvaldisclose = (Int32)CustomMgrSave.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveCustomFormLabPharmacyRegimen_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); } int PharmacyID = Convert.ToInt32(theDS.Tables[1].Rows[0]["PharmacyID"]); for (int i = 0; i < DS.Tables[1].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); ClsUtility.AddParameters("@Drug_Id", SqlDbType.Int, DS.Tables[1].Rows[i]["DrugId"].ToString()); ClsUtility.AddParameters("@GenericID", SqlDbType.Int, DS.Tables[1].Rows[i]["GenericId"].ToString()); ClsUtility.AddParameters("@Dose", SqlDbType.Decimal, DS.Tables[1].Rows[i]["Dose"].ToString()); ClsUtility.AddParameters("@FrequencyID", SqlDbType.Int, DS.Tables[1].Rows[i]["FrequencyId"].ToString()); ClsUtility.AddParameters("@Duration", SqlDbType.Decimal, DS.Tables[1].Rows[i]["Duration"].ToString()); ClsUtility.AddParameters("@StrengthID", SqlDbType.Int, "0"); ClsUtility.AddParameters("@QtyPrescribed", SqlDbType.Decimal, DS.Tables[1].Rows[i]["QtyPrescribed"].ToString()); ClsUtility.AddParameters("@QtyDispensed", SqlDbType.Decimal, DS.Tables[1].Rows[i]["QtyDispensed"].ToString()); ClsUtility.AddParameters("@ARFinance", SqlDbType.Int, DS.Tables[1].Rows[i]["ARFinance"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, theDS.Tables[1].Rows[0]["UserID"].ToString()); ClsUtility.AddParameters("@TabId", SqlDbType.Int, TabId.ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.VarChar, "ARVDrug"); int retvaldisclose = (Int32)CustomMgrSave.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveCustomFormLabPharmacyRegimen_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); } for (int i = 0; i < DS.Tables[2].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ptn_pharmacy_pk", SqlDbType.Int, PharmacyID.ToString()); ClsUtility.AddParameters("@Drug_Id", SqlDbType.Int, DS.Tables[2].Rows[i]["DrugId"].ToString()); ClsUtility.AddParameters("@GenericID", SqlDbType.Int, DS.Tables[2].Rows[i]["GenericId"].ToString()); ClsUtility.AddParameters("@UnitId", SqlDbType.Int, DS.Tables[2].Rows[i]["UnitId"].ToString()); ClsUtility.AddParameters("@Dose", SqlDbType.Decimal, DS.Tables[2].Rows[i]["SingleDose"].ToString()); ClsUtility.AddParameters("@FrequencyID", SqlDbType.Int, DS.Tables[2].Rows[i]["FrequencyID"].ToString()); ClsUtility.AddParameters("@Duration", SqlDbType.Decimal, DS.Tables[2].Rows[i]["Duration"].ToString()); ClsUtility.AddParameters("@QtyPrescribed", SqlDbType.Decimal, DS.Tables[2].Rows[i]["QtyOrdered"].ToString()); ClsUtility.AddParameters("@QtyDispensed", SqlDbType.Decimal, DS.Tables[2].Rows[i]["QtyDispensed"].ToString()); ClsUtility.AddParameters("@ARFinance", SqlDbType.Int, DS.Tables[2].Rows[i]["ARFinance"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, theDS.Tables[1].Rows[0]["UserID"].ToString()); ClsUtility.AddParameters("@TabId", SqlDbType.Int, TabId.ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.VarChar, "NonARVDrug"); int retvaldisclose = (Int32)CustomMgrSave.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveCustomFormLabPharmacyRegimen_Constella", ClsUtility.ObjectEnum.ExecuteNonQuery); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(theDS); }
public DataSet SaveInitialEvaluation(Hashtable ht, int none, int notDocumented, int AssoCondnone, int AssoCondnotDocumented, DataSet theDS_IE, ArrayList AssessmentAL, int VisitIE, string AssessmentDescription1, string AssessmentDescription2, int intflag, int DataQualityFlag, DataTable theCustomFieldData, string ClinicalNotes) { ClsObject IEManager = new ClsObject(); DataSet theDS; try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); IEManager.Connection = this.Connection; IEManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@Visit_typeID", SqlDbType.Int, ht["VisitTypeID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, ht["VisitPKID"].ToString()); ClsUtility.AddParameters("@HIVvisitdate", SqlDbType.VarChar, ht["visitdate"].ToString()); ClsUtility.AddParameters("@HIVDiagnosisdate", SqlDbType.VarChar, ht["HIVDiagnosisdate"].ToString()); ClsUtility.AddParameters("@diagnosisverified", SqlDbType.Int, ht["diagnosisverified"].ToString()); ClsUtility.AddParameters("@disclosed", SqlDbType.Int, ht["disclosed"].ToString()); ClsUtility.AddParameters("@lmp", SqlDbType.VarChar, ht["lmp"].ToString()); ClsUtility.AddParameters("@Pregnant", SqlDbType.Int, ht["Pregnant"].ToString()); ClsUtility.AddParameters("@Delivered", SqlDbType.VarChar, ht["Delivered"].ToString()); ClsUtility.AddParameters("@DelDate", SqlDbType.VarChar, ht["DelDate"].ToString()); ClsUtility.AddParameters("@EDDDate", SqlDbType.VarChar, ht["EDDDate"].ToString()); ClsUtility.AddParameters("@flagsulfa", SqlDbType.VarChar, ht["flagsulfa"].ToString()); ClsUtility.AddParameters("@sulfaallergyID", SqlDbType.VarChar, ht["allergy_Sulfa_ID"].ToString()); ClsUtility.AddParameters("@otherallergyID", SqlDbType.VarChar, ht["allergy_Other_ID"].ToString()); ClsUtility.AddParameters("@allergynameother", SqlDbType.VarChar, ht["allergynameother"].ToString()); ClsUtility.AddParameters("@longTermMedsSulfa", SqlDbType.VarChar, ht["longTermMedsSulfa"].ToString()); ClsUtility.AddParameters("@longTermMedsSulfaDesc", SqlDbType.VarChar, ht["longTermMedsSulfaDesc"].ToString()); ClsUtility.AddParameters("@longTermTBMed", SqlDbType.VarChar, ht["longTermTBMed"].ToString()); ClsUtility.AddParameters("@longTermTBMedDesc", SqlDbType.VarChar, ht["longTermTBMedDesc"].ToString()); ClsUtility.AddParameters("@longTermMedsOther1", SqlDbType.VarChar, ht["longTermMedsOther1"].ToString()); ClsUtility.AddParameters("@longTermMedsOther1Desc", SqlDbType.VarChar, ht["longTermMedsOther1Desc"].ToString()); ClsUtility.AddParameters("@longTermMedsOther2", SqlDbType.VarChar, ht["longTermMedsOther2"].ToString()); ClsUtility.AddParameters("@longTermMedsOther2Desc", SqlDbType.VarChar, ht["longTermMedsOther2Desc"].ToString()); ClsUtility.AddParameters("@PrevLowestCD4None", SqlDbType.VarChar, ht["PrevLowestCD4None"].ToString()); ClsUtility.AddParameters("@PrevLowestCD4NotDocumented", SqlDbType.VarChar, ht["PrevLowestCD4NotDocumented"].ToString()); ClsUtility.AddParameters("@PrevLowestCD4", SqlDbType.VarChar, ht["PrevLowestCD4"].ToString()); ClsUtility.AddParameters("@PrevLowestCD4Percent", SqlDbType.VarChar, ht["PrevLowestCD4Percent"].ToString()); ClsUtility.AddParameters("@PrevARVsCD4None", SqlDbType.VarChar, ht["PrevARVsCD4None"].ToString()); ClsUtility.AddParameters("@PrevARVsCD4NotDocumented", SqlDbType.VarChar, ht["PrevARVsCD4NotDocumented"].ToString()); ClsUtility.AddParameters("@PrevARVsCD4", SqlDbType.VarChar, ht["PrevARVsCD4"].ToString()); ClsUtility.AddParameters("@VisitID_IE", SqlDbType.VarChar, VisitIE.ToString()); ClsUtility.AddParameters("@PrevARVsCD4Percent", SqlDbType.VarChar, ht["PrevARVsCD4Percent"].ToString()); ClsUtility.AddParameters("@PrevMostRecentCD4None", SqlDbType.VarChar, ht["PrevMostRecentCD4None"].ToString()); ClsUtility.AddParameters("@PrevMostRecentCD4NotDocumented", SqlDbType.VarChar, ht["PrevMostRecentCD4NotDocumented"].ToString()); ClsUtility.AddParameters("@PrevMostRecentCD4", SqlDbType.VarChar, ht["PrevMostRecentCD4"].ToString()); ClsUtility.AddParameters("@PrevMostRecentCD4Percent", SqlDbType.VarChar, ht["PrevMostRecentCD4Percent"].ToString()); ClsUtility.AddParameters("@PrevMostRecentViralLoadNone", SqlDbType.VarChar, ht["PrevMostRecentViralLoadNone"].ToString()); ClsUtility.AddParameters("@PrevMostRecentViralLoadNotDocumented", SqlDbType.VarChar, ht["PrevMostRecentViralLoadNotDocumented"].ToString()); ClsUtility.AddParameters("@PrevMostRecentViralLoad", SqlDbType.VarChar, ht["PrevMostRecentViralLoad"].ToString()); ClsUtility.AddParameters("@PrevARVExposureNone", SqlDbType.VarChar, ht["PrevARVExposureNone"].ToString()); ClsUtility.AddParameters("@PrevARVExposureNotDocumented", SqlDbType.VarChar, ht["PrevARVExposureNotDocumented"].ToString()); ClsUtility.AddParameters("@PrevARVExposure", SqlDbType.VarChar, ht["PrevARVExposure"].ToString()); ClsUtility.AddParameters("@CurrentART", SqlDbType.VarChar, ht["CurrentART"].ToString()); ClsUtility.AddParameters("@PrevSingleDoseNVP", SqlDbType.VarChar, ht["PrevSingleDoseNVP"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen", SqlDbType.VarChar, ht["PrevARVRegimen"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen1Name", SqlDbType.VarChar, ht["PrevARVRegimen1Name"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen1Months", SqlDbType.VarChar, ht["PrevARVRegimen1Months"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen2Name", SqlDbType.VarChar, ht["PrevARVRegimen2Name"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen2Months", SqlDbType.VarChar, ht["PrevARVRegimen2Months"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen3Name", SqlDbType.VarChar, ht["PrevARVRegimen3Name"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen3Months", SqlDbType.VarChar, ht["PrevARVRegimen3Months"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen4Name", SqlDbType.VarChar, ht["PrevARVRegimen4Name"].ToString()); ClsUtility.AddParameters("@PrevARVRegimen4Months", SqlDbType.VarChar, ht["PrevARVRegimen4Months"].ToString()); ClsUtility.AddParameters("@Temp", SqlDbType.VarChar, ht["Temp"].ToString()); ClsUtility.AddParameters("@RR", SqlDbType.VarChar, ht["RR"].ToString()); ClsUtility.AddParameters("@HR", SqlDbType.VarChar, ht["HR"].ToString()); ClsUtility.AddParameters("@BPDiastolic", SqlDbType.VarChar, ht["BPDiastolic"].ToString()); ClsUtility.AddParameters("@BPSystolic", SqlDbType.VarChar, ht["BPSystolic"].ToString()); ClsUtility.AddParameters("@Height", SqlDbType.VarChar, ht["Height"].ToString()); ClsUtility.AddParameters("@Weight", SqlDbType.VarChar, ht["Weight"].ToString()); ClsUtility.AddParameters("@Pain", SqlDbType.VarChar, ht["Pain"].ToString()); ClsUtility.AddParameters("@WABStage", SqlDbType.VarChar, ht["WABStage"].ToString()); ClsUtility.AddParameters("@WHOStage", SqlDbType.VarChar, ht["WHOStage"].ToString()); ClsUtility.AddParameters("@ARVtherapyPlan", SqlDbType.VarChar, ht["ARVtherapyPlan"].ToString()); ClsUtility.AddParameters("@ARVTherapyReasonCode", SqlDbType.VarChar, ht["ARVTherapyReasonCode"].ToString()); ClsUtility.AddParameters("@TherapyOther", SqlDbType.VarChar, ht["ARVTherapyReasonOther"].ToString()); ClsUtility.AddParameters("@signatureid", SqlDbType.VarChar, ht["Signatureid"].ToString()); ClsUtility.AddParameters("@userID", SqlDbType.VarChar, ht["UserID"].ToString()); ClsUtility.AddParameters("@DataQuality", SqlDbType.VarChar, DataQualityFlag.ToString()); ClsUtility.AddParameters("@PrevSingleDoseNVPDate1", SqlDbType.VarChar, ht["txtprevSingleDoseNVPDate1"].ToString()); ClsUtility.AddParameters("@PrevSingleDoseNVPDate2", SqlDbType.VarChar, ht["txtprevSingleDoseNVPDate2"].ToString()); ClsUtility.AddParameters("@currentARTStartDate", SqlDbType.VarChar, ht["currentARTStartDate"].ToString()); ClsUtility.AddParameters("@PrevMostRecentViralLoadDate", SqlDbType.VarChar, ht["PrevMostRecentViralLoadDate"].ToString()); ClsUtility.AddParameters("@PrevARVsCD4Date", SqlDbType.VarChar, ht["PrevARVsCD4Date"].ToString()); ClsUtility.AddParameters("@PrevLowestCD4Date", SqlDbType.VarChar, ht["PrevLowestCD4Date"].ToString()); ClsUtility.AddParameters("@longTermTBStartDate", SqlDbType.VarChar, ht["longTermTBStartDate"].ToString()); ClsUtility.AddParameters("@PrevMostRecentCD4Date", SqlDbType.VarChar, ht["PrevMostRecentCD4Date"].ToString()); ClsUtility.AddParameters("@AppExist", SqlDbType.VarChar, ht["AppExist"].ToString()); ClsUtility.AddParameters("@VisitIDApp", SqlDbType.VarChar, Convert.ToString(ht["VisitIDApp"])); ClsUtility.AddParameters("@appdate", SqlDbType.VarChar, Convert.ToString(ht["appdate"])); ClsUtility.AddParameters("@appreason", SqlDbType.VarChar, Convert.ToString(ht["appreason"])); ClsUtility.AddParameters("@ClinicalNotes", SqlDbType.VarChar, ClinicalNotes); ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.Int, ht["Flag"].ToString()); theDS = (DataSet)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_SaveUpdateIE_Constella", ClsDBUtility.ObjectEnum.DataSet); if (Convert.ToInt32(ht["AppExist"].ToString()) == 1) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@Visit_pkAppID", SqlDbType.Int, ht["VisitIDApp"].ToString()); ClsUtility.AddParameters("@signatureid", SqlDbType.BigInt, ht["Signatureid"].ToString()); int RowsAffected = (int)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateIEAppointmentSignature_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } /**Disclose To**/ for (int i = 0; i < theDS_IE.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@disclosureid", SqlDbType.Int, theDS_IE.Tables[0].Rows[i]["DisclosureID"].ToString()); ClsUtility.AddParameters("@HIVDisclosureOther", SqlDbType.VarChar, theDS_IE.Tables[0].Rows[i]["DisclosureOther"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); int retvaldisclose = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateDiscloseIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } /** Presenting Complaints **/ for (int i = 0; i < theDS_IE.Tables[1].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_IE.Tables[1].Rows[i]["PresentComplaintsID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalcomplaint = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } /****TBScreening*****/ for (int i = 0; i < theDS_IE.Tables[5].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@Symptomid", SqlDbType.Int, theDS_IE.Tables[5].Rows[i]["TBScreeningID"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalcomplaint = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateComplaintsIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } /* MediHistoryManager*/ //None if (none == 95) { Boolean DiseasePresent = false; String DiseaseYear = "1900"; String SpDisease = "None"; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@MedHistDiseaseID", SqlDbType.Int, none.ToString()); ClsUtility.AddParameters("@MediHisDiseasePresent", SqlDbType.Bit, DiseasePresent.ToString()); ClsUtility.AddParameters("@MedHistDiseaseYear", SqlDbType.VarChar, DiseaseYear); ClsUtility.AddParameters("@MedHistSpecifyDisease", SqlDbType.VarChar, SpDisease); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalMedHistory = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateMedicalHistoryIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Not Documented else if (notDocumented == 94) { Boolean DiseasePresent = false; String DiseaseYear = "1900"; String SpDisease = "Notdocumented"; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@MedHistDiseaseID", SqlDbType.Int, notDocumented.ToString()); ClsUtility.AddParameters("@MediHisDiseasePresent", SqlDbType.Bit, DiseasePresent.ToString()); ClsUtility.AddParameters("@MedHistDiseaseYear", SqlDbType.VarChar, DiseaseYear); ClsUtility.AddParameters("@MedHistSpecifyDisease", SqlDbType.VarChar, SpDisease); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalMedHistory = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateMedicalHistoryIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } else if (none == 0 && notDocumented == 0) { for (int i = 0; i < theDS_IE.Tables[2].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@MedHistDiseaseID", SqlDbType.Int, theDS_IE.Tables[2].Rows[i]["MedHistoryID"].ToString()); ClsUtility.AddParameters("@MediHisDiseasePresent", SqlDbType.Bit, theDS_IE.Tables[2].Rows[i]["MediHisDiseasePresent"].ToString()); ClsUtility.AddParameters("@MedHistDiseaseYear", SqlDbType.VarChar, theDS_IE.Tables[2].Rows[i]["YearDiseasePresent"].ToString()); ClsUtility.AddParameters("@MedHistSpecifyDisease", SqlDbType.VarChar, theDS_IE.Tables[2].Rows[i]["SpecifyDiseasePresent"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalMedHistory = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateMedicalHistoryIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } /* Associate Condition Left */ //Associated Assocond - None if (AssoCondnone == 97) { Boolean DiseasePresent = false; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, AssoCondnone.ToString()); ClsUtility.AddParameters("@HIVAssocDiseasePresent", SqlDbType.Bit, DiseasePresent.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseYear", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalleft = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateHIVAssoConditionIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Associated Assocond - Not Documented if (AssoCondnotDocumented == 96) { Boolean DiseasePresent = false; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, AssoCondnotDocumented.ToString()); ClsUtility.AddParameters("@HIVAssocDiseasePresent", SqlDbType.Bit, DiseasePresent.ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseYear", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalleft = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateHIVAssoConditionIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //HIV Associated Conditions if (AssoCondnone == 0 && AssoCondnotDocumented == 0) { //Left Side Items. for (int i = 0; i < theDS_IE.Tables[3].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS_IE.Tables[3].Rows[i]["chkHIVAssoCondID1"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseasePresent", SqlDbType.Bit, theDS_IE.Tables[3].Rows[i]["HIVAssoDiseasePresent1"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseYear", SqlDbType.VarChar, theDS_IE.Tables[3].Rows[i]["HIVAssocCondYear1"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, ""); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalleft = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateHIVAssoConditionIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //Right Side Items for (int i = 0; i < theDS_IE.Tables[4].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseID", SqlDbType.Int, theDS_IE.Tables[4].Rows[i]["chkHIVAssoCondid2"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseasePresent", SqlDbType.Bit, theDS_IE.Tables[4].Rows[i]["HIVAssoDiseasePresent2"].ToString()); ClsUtility.AddParameters("@HIVAssocDiseaseYear", SqlDbType.VarChar, theDS_IE.Tables[4].Rows[i]["HIVAssocCondYear2"].ToString()); ClsUtility.AddParameters("@DiseaseDesc", SqlDbType.VarChar, theDS_IE.Tables[4].Rows[i]["HIVAssoDiseaseDesc"].ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalright = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateHIVAssoConditionIE_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } } /* Saving Assessment Details */ for (int i = 0; i < AssessmentAL.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@patientid", SqlDbType.Int, ht["patientid"].ToString()); ClsUtility.AddParameters("@locationid", SqlDbType.Int, ht["locationid"].ToString()); ClsUtility.AddParameters("@AssessmentID", SqlDbType.Int, AssessmentAL[i].ToString()); ClsUtility.AddParameters("@Description1", SqlDbType.VarChar, AssessmentDescription1.ToString()); ClsUtility.AddParameters("@Description2", SqlDbType.VarChar, AssessmentDescription2.ToString()); ClsUtility.AddParameters("@UserID", SqlDbType.Int, ht["UserID"].ToString()); ClsUtility.AddParameters("@Visit_pkID", SqlDbType.Int, theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); //ClsUtility.AddParameters("@createdate", SqlDbType.DateTime, ht["CreateDate"].ToString()); int retvalAssessnent = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_Clinical_UpdateAssessment_Constella", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //// Custom Fields ////////////// ////////////PreSet Values Used///////////////// /// #99# --- Ptn_Pk /// #88# --- LocationId /// #77# --- Visit_Pk /// #66# --- Visit_Date /// #55# --- Ptn_Pharmacy_Pk /// #44# --- OrderedByDate /// #33# --- LabId /// #22# --- TrackingId /// #11# --- CareEndedId /// #00# --- HomeVisitId /////////////////////////////////////////////// //ClsObject theCustomManager = new ClsObject(); //Generating VisitID from IE Form for (Int32 i = 0; i < theCustomFieldData.Rows.Count; i++) { ClsUtility.Init_Hashtable(); string theQuery = theCustomFieldData.Rows[i]["Query"].ToString(); theQuery = theQuery.Replace("#99#", ht["patientid"].ToString()); theQuery = theQuery.Replace("#88#", ht["locationid"].ToString()); theQuery = theQuery.Replace("#77#", theDS.Tables[0].Rows[0]["Visit_Id"].ToString()); theQuery = theQuery.Replace("#66#", "'" + ht["visitdate"].ToString() + "'"); ClsUtility.AddParameters("@QryString", SqlDbType.VarChar, theQuery); int RowsAffected = (Int32)IEManager.ReturnObject(ClsUtility.theParams, "pr_General_Dynamic_Insert", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } //////////////////////////////// DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { IEManager = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(theDS); }
public int SaveUserGroupDetail(int GroupID, String Groupname, DataSet theDS, int UserID, int Flag, int EnrollmentFlag, int PreCareEnd, int EditIdentifiers) { ClsObject UserGroupManager = new ClsObject(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); UserGroupManager.Connection = this.Connection; UserGroupManager.Transaction = this.Transaction; ClsUtility.Init_Hashtable(); DataRow theDR; ClsUtility.AddParameters("@GID", SqlDbType.Int, GroupID.ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.Int, Flag.ToString()); ClsUtility.AddParameters("@GroupName", SqlDbType.VarChar, Groupname); ClsUtility.AddParameters("@UserID", SqlDbType.Int, UserID.ToString()); ClsUtility.AddParameters("@PerEnrollment", SqlDbType.Int, EnrollmentFlag.ToString()); ClsUtility.AddParameters("@PerCareEnd", SqlDbType.Int, PreCareEnd.ToString()); ClsUtility.AddParameters("@EditIdentifiers", SqlDbType.Int, EditIdentifiers.ToString()); theDR = (DataRow)UserGroupManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_SaveUserGroup_Detail_Constella", ClsDBUtility.ObjectEnum.DataRow); int GroupId = Convert.ToInt32(theDR[0].ToString()); if (GroupId != 0) { for (int i = 0; i < theDS.Tables[0].Rows.Count; i++) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@FacilityID", SqlDbType.Int, theDS.Tables[0].Rows[i]["FacilityID"].ToString()); ClsUtility.AddParameters("@ModuleID", SqlDbType.Int, theDS.Tables[0].Rows[i]["ModuleID"].ToString()); ClsUtility.AddParameters("@FeatureID", SqlDbType.Int, theDS.Tables[0].Rows[i]["FeatureID"].ToString()); ClsUtility.AddParameters("@FeatureName", SqlDbType.VarChar, theDS.Tables[0].Rows[i]["FeatureName"].ToString()); ClsUtility.AddParameters("@TabID", SqlDbType.Int, theDS.Tables[0].Rows[i]["TabID"].ToString()); ClsUtility.AddParameters("@FunctionID", SqlDbType.Int, theDS.Tables[0].Rows[i]["FunctionID"].ToString()); ClsUtility.AddParameters("@GroupID", SqlDbType.Int, GroupId.ToString()); int RowsAffected = (int)UserGroupManager.ReturnObject(ClsUtility.theParams, "Pr_Admin_SaveFacilityServiceUserGroupFunction_Detail", ClsDBUtility.ObjectEnum.ExecuteNonQuery); if (RowsAffected == 0) { MsgBuilder theMsg = new MsgBuilder(); theMsg.DataElements["MessageText"] = "Error in Saving UserGroupRole. Try Again.."; AppException.Create("#C1", theMsg); } } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(Convert.ToInt32(theDR[0])); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { UserGroupManager = null; if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int IQTouchSaveExpressDetails(List <BIQTouchExpressFields> lstobjExpressFields) { ClsObject expressManagerTest = new ClsObject(); int theRowAffected = 0; int totalRowInserted = 0; try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); expressManagerTest.Connection = this.Connection; expressManagerTest.Transaction = this.Transaction; if (lstobjExpressFields.Count > 0) { foreach (var objExpressFields in lstobjExpressFields) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@ID", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.ID).ToString()); ClsUtility.AddParameters("@Ptn_pk", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.PtnPk).ToString()); ClsUtility.AddParameters("@LocationId", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.LocationId).ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.UserId).ToString()); ClsUtility.AddParameters("@ChildAccompaniedByCaregiver", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.ChildAccompaniedByCaregiver).ToString()); ClsUtility.AddParameters("@TreatmentSupporterRelationship", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.TreatmentSupporterRelationship).ToString()); ClsUtility.AddParameters("@Temperature", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.Temperature).ToString()); ClsUtility.AddParameters("@RespirationRate", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.RespirationRate).ToString()); ClsUtility.AddParameters("@HeartRate", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.HeartRate).ToString()); ClsUtility.AddParameters("@SystolicBloodPressure", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.SystolicBloodPressure).ToString()); ClsUtility.AddParameters("@DiastolicBloodPressure", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.DiastolicBloodPressure).ToString()); ClsUtility.AddParameters("@MedicalCondition", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.MedicalCondition).ToString()); ClsUtility.AddParameters("@SpecificMedicalCondition", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.SpecificMedicalCondition).ToString()); ClsUtility.AddParameters("@OnFollowUp", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.OnFollowUp).ToString()); if (objExpressFields.LastFollowUpDate.Year.ToString() != "1900") { ClsUtility.AddParameters("@LastFollowUpDate", SqlDbType.DateTime, objExpressFields.LastFollowUpDate.ToString()); } ClsUtility.AddParameters("@PreviousAdmission", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.PreviousAdmission).ToString()); ClsUtility.AddParameters("@PreviousAdmissionDiagnosis", SqlDbType.VarChar, ConverTotValue.NullToString(objExpressFields.PreviousAdmissionDiagnosis).ToString()); if (objExpressFields.PreviousAdmissionStart.Year.ToString() != "1900") { ClsUtility.AddParameters("@PreviousAdmissionStart", SqlDbType.DateTime, objExpressFields.PreviousAdmissionStart.ToString()); } if (objExpressFields.PreviousAdmissionEnd.Year.ToString() != "1900") { ClsUtility.AddParameters("@PreviousAdmissionEnd", SqlDbType.DateTime, objExpressFields.PreviousAdmissionEnd.ToString()); } ClsUtility.AddParameters("@TBAssessmentICF", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.TBAssessmentIcf).ToString()); ClsUtility.AddParameters("@TBFindings", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.TBFindings).ToString()); ClsUtility.AddParameters("@RegimenPrescribedFUP", SqlDbType.VarChar, ConverTotValue.NullToString(objExpressFields.RegimenPrescribedFup).ToString()); ClsUtility.AddParameters("@LabEvaluationPeads", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.LabEvaluationPeads).ToString()); ClsUtility.AddParameters("@SpecifyLabEvaluation", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.SpecifyLabEvaluation).ToString()); ClsUtility.AddParameters("@OIProphylaxis", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.OIProphylaxis).ToString()); ClsUtility.AddParameters("@OtherOIProphylaxis", SqlDbType.VarChar, ConverTotValue.NullToString(objExpressFields.OtherOIProphylaxis).ToString()); ClsUtility.AddParameters("@TreatmentPlan", SqlDbType.VarChar, ConverTotValue.NullToString(objExpressFields.TreatmentPlan).ToString()); ClsUtility.AddParameters("@PwPMessagesGiven", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.PwPMessagesGiven).ToString()); ClsUtility.AddParameters("@CondomsIssued", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.CondomsIssued).ToString()); ClsUtility.AddParameters("@ReasonfornotIssuingCondoms", SqlDbType.VarChar, ConverTotValue.NullToString(objExpressFields.ReasonfornotIssuingCondoms).ToString()); ClsUtility.AddParameters("@IntentionOfPregnancy", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.IntentionOfPregnancy).ToString()); ClsUtility.AddParameters("@DiscussedDualContraception", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.DiscussedDualContraception).ToString()); ClsUtility.AddParameters("@DiscussedFertilityOption", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.DiscussedFertilityOption).ToString()); ClsUtility.AddParameters("@OnFP", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.OnFP).ToString()); ClsUtility.AddParameters("@FPmethod", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.FPmethod).ToString()); ClsUtility.AddParameters("@CervicalCancerScreened", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.CervicalCancerScreened).ToString()); ClsUtility.AddParameters("@ReferredForCervicalCancerScreening", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.ReferredForCervicalCancerScreening).ToString()); ClsUtility.AddParameters("@CervicalCancerScreeningResults", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.CervicalCancerScreeningResults).ToString()); ClsUtility.AddParameters("@RegimenPrescribed", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.RegimenPrescribed).ToString()); ClsUtility.AddParameters("@OtherRegimenPrescribed", SqlDbType.VarChar, ConverTotValue.NullToInt(objExpressFields.OtherRegimenPrescribed).ToString()); ClsUtility.AddParameters("@ResultsCervicalCancer", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.ResultsCervicalCancer).ToString()); ClsUtility.AddParameters("@ReasonCTXpresribed", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.ReasonCTXpresribed).ToString()); ClsUtility.AddParameters("@Flag", SqlDbType.VarChar, ConverTotValue.NullToString(objExpressFields.Flag).ToString()); if (objExpressFields.VisitDate.Year.ToString() != "1900") { ClsUtility.AddParameters("@VisitDate", SqlDbType.DateTime, objExpressFields.VisitDate.ToString()); } ClsUtility.AddParameters("@SignatureID", SqlDbType.Int, ConverTotValue.NullToInt(objExpressFields.Signature).ToString()); ClsUtility.AddParameters("@Height", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.Height).ToString()); ClsUtility.AddParameters("@Weight", SqlDbType.Decimal, ConverTotValue.NullToInt(objExpressFields.Weight).ToString()); theRowAffected = (int)expressManagerTest.ReturnObject(ClsUtility.theParams, "Pr_IQTouch_Clinical_AddKNHExpress", ClsDBUtility.ObjectEnum.ExecuteNonQuery); totalRowInserted = totalRowInserted + theRowAffected; } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(totalRowInserted); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveHomePageIndicator(DataSet dsSaveIndicatorQuery, string Flag) { int iFeatureId; try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject FormDetail = new ClsObject(); FormDetail.Connection = this.Connection; FormDetail.Transaction = this.Transaction; int theRowAffected = 0; DataRow theDR; int iId; ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, dsSaveIndicatorQuery.Tables[1].Rows[0]["FeatureId"].ToString()); ClsUtility.AddParameters("@FeatureName", SqlDbType.VarChar, dsSaveIndicatorQuery.Tables[1].Rows[0]["FeatureName"].ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, "0"); ClsUtility.AddParameters("@SystemId", SqlDbType.Int, "0"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveIndicatorQuery.Tables[1].Rows[0]["UserID"].ToString()); ClsUtility.AddParameters("@Published", SqlDbType.Int, dsSaveIndicatorQuery.Tables[1].Rows[0]["Published"].ToString()); ClsUtility.AddParameters("@ModuleId", SqlDbType.Int, dsSaveIndicatorQuery.Tables[1].Rows[0]["ModuleId"].ToString()); theDR = (DataRow)FormDetail.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SaveFeature_Futures", ClsUtility.ObjectEnum.DataRow); iFeatureId = System.Convert.ToInt32(theDR[0].ToString()); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Id", SqlDbType.Int, dsSaveIndicatorQuery.Tables[2].Rows[0]["Id"].ToString()); ClsUtility.AddParameters("@Name", SqlDbType.VarChar, dsSaveIndicatorQuery.Tables[2].Rows[0]["Name"].ToString()); ClsUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, "0"); ClsUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveIndicatorQuery.Tables[2].Rows[0]["UserId"].ToString()); theDR = (DataRow)FormDetail.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SaveHomePageIndicatorQuery_Futures", ClsUtility.ObjectEnum.DataRow); iId = System.Convert.ToInt32(theDR[0].ToString()); for (int i = 0; i <= dsSaveIndicatorQuery.Tables[0].Rows.Count - 1; i++) { ClsUtility.Init_Hashtable(); if (Flag == "U") { ClsUtility.AddParameters("@Id", SqlDbType.Int, dsSaveIndicatorQuery.Tables[0].Rows[i]["Id"].ToString()); } else { ClsUtility.AddParameters("@Id", SqlDbType.Int, "0"); } ClsUtility.AddParameters("@HomePageId", SqlDbType.Int, iId.ToString()); ClsUtility.AddParameters("@IndicatorName", SqlDbType.VarChar, dsSaveIndicatorQuery.Tables[0].Rows[i]["Indicator"].ToString()); ClsUtility.AddParameters("@Query", SqlDbType.VarChar, dsSaveIndicatorQuery.Tables[0].Rows[i]["Query"].ToString()); ClsUtility.AddParameters("@Seq", SqlDbType.Int, (i + 1).ToString()); ClsUtility.AddParameters("@DeleteFlag", SqlDbType.Int, "0"); ClsUtility.AddParameters("@UserId", SqlDbType.Int, dsSaveIndicatorQuery.Tables[0].Rows[i]["UserId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(ClsUtility.theParams, "Pr_FormBuilder_SavedtlHomePageIndicatorQuery_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch (Exception err) { DataMgr.RollBackTransation(this.Transaction); throw err; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(iFeatureId); }
public DataTable SavePharmacyDispense(Int32 thePatientId, Int32 theLocationId, Int32 theStoreId, Int32 theUserId, DateTime theDispDate, Int32 theOrderType, Int32 theProgramId, string theRegimen, Int32 theOrderId, DataTable theDT, DateTime PharmacyRefillDate) { DataTable thePharmacyDT = new DataTable(); try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject theManager = new ClsObject(); ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, thePatientId.ToString()); ClsUtility.AddParameters("@LocationId", SqlDbType.Int, theLocationId.ToString()); ClsUtility.AddParameters("@DispensedBy", SqlDbType.Int, theUserId.ToString()); ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", theDispDate).ToString()); ClsUtility.AddParameters("@OrderType", SqlDbType.Int, theOrderType.ToString()); ClsUtility.AddParameters("@ProgramId", SqlDbType.Int, theProgramId.ToString()); ClsUtility.AddParameters("@StoreId", SqlDbType.Int, theStoreId.ToString()); ClsUtility.AddParameters("@Regimen", SqlDbType.VarChar, theRegimen); ClsUtility.AddParameters("@UserId", SqlDbType.Int, theUserId.ToString()); ClsUtility.AddParameters("@OrderId", SqlDbType.Int, theOrderId.ToString()); ClsUtility.AddParameters("@PharmacyRefillAppDate", SqlDbType.VarChar, PharmacyRefillDate.ToString("dd-MMM-yyyy")); thePharmacyDT = (DataTable)theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyDispenseOrder_Futures", ClsDBUtility.ObjectEnum.DataTable); foreach (DataRow theDR in theDT.Rows) { ClsUtility.Init_Hashtable(); ClsUtility.AddParameters("@Ptn_Pk", SqlDbType.Int, thePatientId.ToString()); ClsUtility.AddParameters("@StoreId", SqlDbType.Int, theStoreId.ToString()); ClsUtility.AddParameters("@VisitId", SqlDbType.Int, thePharmacyDT.Rows[0]["VisitId"].ToString()); ClsUtility.AddParameters("@Ptn_Pharmacy_Pk", SqlDbType.Int, thePharmacyDT.Rows[0]["Ptn_Pharmacy_Pk"].ToString()); ClsUtility.AddParameters("@Drug_Pk", SqlDbType.Int, theDR["ItemId"].ToString()); ClsUtility.AddParameters("@StrengthId", SqlDbType.Int, theDR["StrengthId"].ToString()); ClsUtility.AddParameters("@FrequencyId", SqlDbType.Int, theDR["FrequencyId"].ToString()); ClsUtility.AddParameters("@DispensedQuantity", SqlDbType.Int, Convert.ToInt32(theDR["QtyDisp"]).ToString()); ClsUtility.AddParameters("@Prophylaxis", SqlDbType.Int, theDR["Prophylaxis"].ToString()); ClsUtility.AddParameters("@BatchId", SqlDbType.Int, theDR["BatchId"].ToString()); ClsUtility.AddParameters("@CostPrice", SqlDbType.Decimal, theDR["CostPrice"].ToString() != "" ? theDR["CostPrice"].ToString() : "0"); if (theDR["BatchNo"].ToString().Contains("(")) { ClsUtility.AddParameters("@BatchNo", SqlDbType.VarChar, theDR["BatchNo"].ToString().Substring(0, theDR["BatchNo"].ToString().IndexOf('('))); } else { ClsUtility.AddParameters("@BatchNo", SqlDbType.VarChar, theDR["BatchNo"].ToString()); } ClsUtility.AddParameters("@Margin", SqlDbType.Decimal, theDR["Margin"].ToString() != "" ? theDR["Margin"].ToString() : "0"); ClsUtility.AddParameters("@SellingPrice", SqlDbType.Decimal, theDR["SellingPrice"].ToString() != "" ? theDR["SellingPrice"].ToString() : "0"); ClsUtility.AddParameters("@BillAmount", SqlDbType.Decimal, theDR["BillAmount"].ToString() != "" ? theDR["BillAmount"].ToString() : "0"); ClsUtility.AddParameters("@ExpiryDate", SqlDbType.VarChar, theDR["ExpiryDate"].ToString()); ClsUtility.AddParameters("@DispensingUnit", SqlDbType.Int, theDR["DispensingUnitId"].ToString()); ClsUtility.AddParameters("@DispensedByDate", SqlDbType.VarChar, theDispDate.ToString("dd-MMM-yyyy")); ClsUtility.AddParameters("@LocationId", SqlDbType.Int, theLocationId.ToString()); ClsUtility.AddParameters("@UserId", SqlDbType.Int, theUserId.ToString()); ClsUtility.AddParameters("@DataStatus", SqlDbType.Int, theDR["DataStatus"].ToString()); ClsUtility.AddParameters("@PrescribeOrderedQuantity", SqlDbType.Decimal, theDR["OrderedQuantity"].ToString() != "" ? theDR["OrderedQuantity"].ToString() : "0"); ClsUtility.AddParameters("@Dose", SqlDbType.Decimal, theDR["Dose"].ToString() != "" ? theDR["Dose"].ToString() : "0"); ClsUtility.AddParameters("@Duration", SqlDbType.Decimal, theDR["Duration"].ToString() != "" ? theDR["Duration"].ToString() : "0"); ClsUtility.AddParameters("@PrintPrescriptionStatus", SqlDbType.Int, theDR["PrintPrescriptionStatus"].ToString()); ClsUtility.AddParameters("@PatientInstructions", SqlDbType.VarChar, theDR["PatientInstructions"].ToString()); Int32 theRowCount = (Int32)theManager.ReturnObject(ClsUtility.theParams, "pr_SCM_SavePharmacyDispenseOrderDetail_Futures", ClsDBUtility.ObjectEnum.ExecuteNonQuery); } // return thePharmacyDT; DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } return(thePharmacyDT); }
public DataSet SaveUpdateKNHRevisedAdultFollowupData(Hashtable hashTable, DataTable dtMultiSelectValues, int signature, int UserId) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); oUtility.Init_Hashtable(); oUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); oUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); oUtility.AddParameters("@LocationId", SqlDbType.Int, hashTable["locationID"].ToString()); oUtility.AddParameters("@visitdate", SqlDbType.DateTime, hashTable["visitDate"].ToString()); oUtility.AddParameters("@ChildAccompaniedByCaregiver", SqlDbType.Int, hashTable["ChildAccompaniedByCaregiver"].ToString()); oUtility.AddParameters("@TreatmentSupporterRelationship", SqlDbType.Int, hashTable["TreatmentSupporterRelationship"].ToString()); oUtility.AddParameters("@DisclosureStatus", SqlDbType.Int, hashTable["DisclosureStatus"].ToString()); oUtility.AddParameters("@HealthEducation", SqlDbType.Int, hashTable["HealthEducation"].ToString()); oUtility.AddParameters("@ReasonNotDisclosed", SqlDbType.VarChar, hashTable["ReasonNotDisclosed"].ToString()); oUtility.AddParameters("@OtherDisclosureReason", SqlDbType.VarChar, hashTable["OtherDisclosureReason"].ToString()); oUtility.AddParameters("@SchoolingStatus", SqlDbType.Int, hashTable["SchoolingStatus"].ToString()); oUtility.AddParameters("@HighestLevelAttained", SqlDbType.Int, hashTable["HighestLevelAttained"].ToString()); oUtility.AddParameters("@HIVSupportGroup", SqlDbType.Int, hashTable["HIVSupportGroup"].ToString()); oUtility.AddParameters("@HIVSupportGroupMembership", SqlDbType.VarChar, hashTable["HIVSupportGroupMembership"].ToString()); oUtility.AddParameters("@AddressChanged", SqlDbType.Int, hashTable["AddressChanged"].ToString()); oUtility.AddParameters("@AddressChange", SqlDbType.VarChar, hashTable["AddressChange"].ToString()); oUtility.AddParameters("@PhoneNoChange", SqlDbType.VarChar, hashTable["PhoneNoChange"].ToString()); oUtility.AddParameters("@NursesComments", SqlDbType.VarChar, hashTable["NursesComments"].ToString()); oUtility.AddParameters("@CurrentlyOnHAART", SqlDbType.Int, hashTable["CurrentlyOnHAART"].ToString()); oUtility.AddParameters("@CurrentARTRegimenLine", SqlDbType.Int, hashTable["CurrentARTRegimenLine"].ToString()); oUtility.AddParameters("@CurrentARTRegimen", SqlDbType.Int, hashTable["CurrentARTRegimen"].ToString()); oUtility.AddParameters("@OtherARTRegimen", SqlDbType.VarChar, hashTable["OtherARTRegimen"].ToString()); oUtility.AddParameters("@CurrentARTRegimenDate", SqlDbType.DateTime, hashTable["CurrentARTRegimenDate"].ToString()); oUtility.AddParameters("@SchoolPerfomance", SqlDbType.Int, hashTable["SchoolPerfomance"].ToString()); oUtility.AddParameters("@OtherPresentingComplaints", SqlDbType.VarChar, hashTable["OtherPresentingComplaints"].ToString()); oUtility.AddParameters("@MedicalCondition", SqlDbType.Int, hashTable["MedicalCondition"].ToString()); oUtility.AddParameters("@CurrentSurgicalCondition", SqlDbType.VarChar, hashTable["CurrentSurgicalCondition"].ToString()); oUtility.AddParameters("@PreviousSurgicalCondition", SqlDbType.VarChar, hashTable["PreviousSurgicalCondition"].ToString()); oUtility.AddParameters("@PreExistingMedicalConditionsFUP", SqlDbType.Int, hashTable["PreExistingMedicalConditionsFUP"].ToString()); oUtility.AddParameters("@Antihypertensives", SqlDbType.VarChar, hashTable["Antihypertensives"].ToString()); oUtility.AddParameters("@Anticonvulsants", SqlDbType.VarChar, hashTable["Anticonvulsants"].ToString()); oUtility.AddParameters("@Hypoglycemics", SqlDbType.VarChar, hashTable["Hypoglycemics"].ToString()); oUtility.AddParameters("@RadiotherapyChemotherapy", SqlDbType.VarChar, hashTable["RadiotherapyChemotherapy"].ToString()); oUtility.AddParameters("@PreviousAdmission", SqlDbType.Int, hashTable["PreviousAdmission"].ToString()); oUtility.AddParameters("@PreviousAdmissionDiagnosis", SqlDbType.VarChar, hashTable["PreviousAdmissionDiagnosis"].ToString()); oUtility.AddParameters("@PreviousAdmissionStart", SqlDbType.DateTime, hashTable["PreviousAdmissionStart"].ToString()); oUtility.AddParameters("@PreviousAdmissionEnd", SqlDbType.DateTime, hashTable["PreviousAdmissionEnd"].ToString()); oUtility.AddParameters("@HIVAssociatedConditionsPeads", SqlDbType.Int, hashTable["HIVAssociatedConditionsPeads"].ToString()); oUtility.AddParameters("@TBFindings", SqlDbType.Int, hashTable["TBFindings"].ToString()); oUtility.AddParameters("@TBresultsAvailable", SqlDbType.Int, hashTable["TBresultsAvailable"].ToString()); oUtility.AddParameters("@SputumSmear", SqlDbType.Int, hashTable["SputumSmear"].ToString()); oUtility.AddParameters("@SputumSmearDate", SqlDbType.DateTime, hashTable["SputumSmearDate"].ToString()); oUtility.AddParameters("@TissueBiopsy", SqlDbType.Int, hashTable["TissueBiopsy"].ToString()); oUtility.AddParameters("@TissueBiopsyDate", SqlDbType.DateTime, hashTable["TissueBiopsyDate"].ToString()); oUtility.AddParameters("@ChestXRay", SqlDbType.Int, hashTable["ChestXRay"].ToString()); oUtility.AddParameters("@ChestXRayDate", SqlDbType.DateTime, hashTable["ChestXRayDate"].ToString()); oUtility.AddParameters("@CXR", SqlDbType.Int, hashTable["CXR"].ToString()); oUtility.AddParameters("@OtherCXR", SqlDbType.VarChar, hashTable["OtherCXR"].ToString()); oUtility.AddParameters("@TBTypePeads", SqlDbType.Int, hashTable["TBTypePeads"].ToString()); oUtility.AddParameters("@PeadsTBPatientType", SqlDbType.Int, hashTable["PeadsTBPatientType"].ToString()); oUtility.AddParameters("@TBPlan", SqlDbType.Int, hashTable["TBPlan"].ToString()); oUtility.AddParameters("@OtherTBPlan", SqlDbType.VarChar, hashTable["OtherTBPlan"].ToString()); oUtility.AddParameters("@TBRegimen", SqlDbType.Int, hashTable["TBRegimen"].ToString()); oUtility.AddParameters("@OtherTBRegimen", SqlDbType.VarChar, hashTable["OtherTBRegimen"].ToString()); oUtility.AddParameters("@TBRegimenStartDate", SqlDbType.DateTime, hashTable["TBRegimenStartDate"].ToString()); oUtility.AddParameters("@TBRegimenEndDate", SqlDbType.DateTime, hashTable["TBRegimenEndDate"].ToString()); oUtility.AddParameters("@TBTreatmentOutcomesPeads", SqlDbType.Int, hashTable["TBTreatmentOutcomesPeads"].ToString()); oUtility.AddParameters("@ARVSideEffects", SqlDbType.Int, hashTable["ARVSideEffects"].ToString()); oUtility.AddParameters("@Specifyothershorttermeffects", SqlDbType.VarChar, hashTable["Specifyothershorttermeffects"].ToString()); oUtility.AddParameters("@listlongtermeffect", SqlDbType.Int, hashTable["listlongtermeffect"].ToString()); oUtility.AddParameters("@ReviewedPreviousResults", SqlDbType.Int, hashTable["ReviewedPreviousResults"].ToString()); oUtility.AddParameters("@ResultsReviewComments", SqlDbType.VarChar, hashTable["ResultsReviewComments"].ToString()); oUtility.AddParameters("@HIVRelatedOI", SqlDbType.VarChar, hashTable["HIVRelatedOI"].ToString()); oUtility.AddParameters("@NonHIVRelatedOI", SqlDbType.VarChar, hashTable["NonHIVRelatedOI"].ToString()); if (hashTable["ProgressionInWHOstage"] != null) { oUtility.AddParameters("@ProgressionInWHOstage", SqlDbType.Int, hashTable["ProgressionInWHOstage"].ToString()); } oUtility.AddParameters("@SpecifyWHOprogression", SqlDbType.VarChar, hashTable["SpecifyWHOprogression"].ToString()); oUtility.AddParameters("@MissedDosesFUP", SqlDbType.Int, hashTable["MissedDosesFUP"].ToString()); oUtility.AddParameters("@MissedDosesFUPspecify", SqlDbType.VarChar, hashTable["MissedDosesFUPspecify"].ToString()); oUtility.AddParameters("@DelaysInTakingMedication", SqlDbType.Int, hashTable["DelaysInTakingMedication"].ToString()); oUtility.AddParameters("@SpecifyARVallergy", SqlDbType.VarChar, hashTable["SpecifyARVallergy"].ToString()); oUtility.AddParameters("@SpecifyAntibioticAllery", SqlDbType.VarChar, hashTable["SpecifyAntibioticAllery"].ToString()); oUtility.AddParameters("@OtherDrugAllergy", SqlDbType.VarChar, hashTable["OtherDrugAllergy"].ToString()); oUtility.AddParameters("@WorkUpPlan", SqlDbType.VarChar, hashTable["WorkUpPlan"].ToString()); oUtility.AddParameters("@OtherCounselling", SqlDbType.VarChar, hashTable["OtherCounselling"].ToString()); oUtility.AddParameters("@SubstituteRegimenDrug", SqlDbType.VarChar, hashTable["SubstituteRegimenDrug"].ToString()); oUtility.AddParameters("@ARTTreatmentPlan", SqlDbType.Int, hashTable["ARTTreatmentPlan"].ToString()); oUtility.AddParameters("@SpecifyotherARTchangereason", SqlDbType.VarChar, hashTable["SpecifyotherARTchangereason"].ToString()); oUtility.AddParameters("@2ndLineRegimenSwitch", SqlDbType.Int, hashTable["2ndLineRegimenSwitch"].ToString()); oUtility.AddParameters("@RegimenPrescribed", SqlDbType.Int, hashTable["RegimenPrescribed"].ToString()); oUtility.AddParameters("@OtherRegimenPrescribed", SqlDbType.VarChar, hashTable["OtherRegimenPrescribed"].ToString()); oUtility.AddParameters("@OIProphylaxis", SqlDbType.Int, hashTable["OIProphylaxis"].ToString()); oUtility.AddParameters("@ReasonCTXpresribed", SqlDbType.Int, hashTable["ReasonCTXpresribed"].ToString()); oUtility.AddParameters("@OtherOIProphylaxis", SqlDbType.VarChar, hashTable["OtherOIProphylaxis"].ToString()); oUtility.AddParameters("@OtherTreatment", SqlDbType.VarChar, hashTable["OtherTreatment"].ToString()); oUtility.AddParameters("@SexuallyActive", SqlDbType.Int, hashTable["SexuallyActive"].ToString()); oUtility.AddParameters("@SexualOrientation", SqlDbType.Int, hashTable["SexualOrientation"].ToString()); oUtility.AddParameters("@KnowSexualPartnerHIVStatus", SqlDbType.Int, hashTable["KnowSexualPartnerHIVStatus"].ToString()); oUtility.AddParameters("@PartnerHIVStatus", SqlDbType.Int, hashTable["PartnerHIVStatus"].ToString()); oUtility.AddParameters("@LMPassessed", SqlDbType.Int, hashTable["LMPassessed"].ToString()); oUtility.AddParameters("@LMPDate", SqlDbType.DateTime, hashTable["LMPDate"].ToString()); oUtility.AddParameters("@LMPNotaccessedReason", SqlDbType.Int, hashTable["LMPNotaccessedReason"].ToString()); oUtility.AddParameters("@PDTdonet", SqlDbType.Int, hashTable["PDTdonet"].ToString()); oUtility.AddParameters("@pregnant", SqlDbType.Int, hashTable["pregnant"].ToString()); oUtility.AddParameters("@PMTCToffered", SqlDbType.Int, hashTable["PMTCToffered"].ToString()); oUtility.AddParameters("@EDD", SqlDbType.DateTime, hashTable["EDD"].ToString()); oUtility.AddParameters("@GivenPWPMessages", SqlDbType.Int, hashTable["GivenPWPMessages"].ToString()); oUtility.AddParameters("@UnsafeSexImportanceExplained", SqlDbType.Int, hashTable["UnsafeSexImportanceExplained"].ToString()); oUtility.AddParameters("@CondomsIssued", SqlDbType.Int, hashTable["CondomsIssued"].ToString()); oUtility.AddParameters("@ReasonfornotIssuingCondoms", SqlDbType.VarChar, hashTable["ReasonfornotIssuingCondoms"].ToString()); oUtility.AddParameters("@IntentionOfPregnancy", SqlDbType.Int, hashTable["IntentionOfPregnancy"].ToString()); oUtility.AddParameters("@DiscussedFertilityOption", SqlDbType.Int, hashTable["DiscussedFertilityOption"].ToString()); oUtility.AddParameters("@DiscussedDualContraception", SqlDbType.Int, hashTable["DiscussedDualContraception"].ToString()); oUtility.AddParameters("@OnFP", SqlDbType.Int, hashTable["OnFP"].ToString()); oUtility.AddParameters("@FPmethod", SqlDbType.Int, hashTable["FPmethod"].ToString()); oUtility.AddParameters("@CervicalCancerEverScreened", SqlDbType.Int, hashTable["CervicalCancerEverScreened"].ToString()); if (hashTable["CervicalCancerScreeningResults"] != null) { oUtility.AddParameters("@CervicalCancerScreeningResults", SqlDbType.Int, hashTable["CervicalCancerScreeningResults"].ToString()); } if (hashTable["ReferredForCervicalCancerScreening"] != null) { oUtility.AddParameters("@ReferredForCervicalCancerScreening", SqlDbType.Int, hashTable["ReferredForCervicalCancerScreening"].ToString()); } oUtility.AddParameters("@HPVOffered", SqlDbType.Int, hashTable["HPVOffered"].ToString()); oUtility.AddParameters("@OfferedHPVaccine", SqlDbType.Int, hashTable["OfferedHPVaccine"].ToString()); oUtility.AddParameters("@HPVDoseDate", SqlDbType.DateTime, hashTable["HPVDoseDate"].ToString()); oUtility.AddParameters("@STIscreened", SqlDbType.Int, hashTable["STIscreened"].ToString()); oUtility.AddParameters("@UrethralDischarge", SqlDbType.Int, hashTable["UrethralDischarge"].ToString()); oUtility.AddParameters("@VaginalDischarge", SqlDbType.Int, hashTable["VaginalDischarge"].ToString()); oUtility.AddParameters("@GenitalUlceration", SqlDbType.Int, hashTable["GenitalUlceration"].ToString()); oUtility.AddParameters("@STItreatmentPlan", SqlDbType.VarChar, hashTable["STItreatmentPlan"].ToString()); oUtility.AddParameters("@WardAdmission", SqlDbType.Int, hashTable["WardAdmission"].ToString()); oUtility.AddParameters("@ReferToSpecialistClinic", SqlDbType.VarChar, hashTable["ReferToSpecialistClinic"].ToString()); oUtility.AddParameters("@TransferOut", SqlDbType.VarChar, hashTable["TransferOut"].ToString()); oUtility.AddParameters("@SpecifyOtherReferredTo", SqlDbType.VarChar, hashTable["SpecifyOtherReferredTo"].ToString()); oUtility.AddParameters("@OtherGeneralConditions", SqlDbType.VarChar, hashTable["OtherGeneralConditions"].ToString()); oUtility.AddParameters("@OtherAbdomenConditions", SqlDbType.VarChar, hashTable["OtherAbdomenConditions"].ToString()); oUtility.AddParameters("@OtherCardiovascularConditions", SqlDbType.VarChar, hashTable["OtherCardiovascularConditions"].ToString()); oUtility.AddParameters("@OtherOralCavityConditions", SqlDbType.VarChar, hashTable["OtherOralCavityConditions"].ToString()); oUtility.AddParameters("@OtherGenitourinaryConditions", SqlDbType.VarChar, hashTable["OtherGenitourinaryConditions"].ToString()); oUtility.AddParameters("@OtherCNSConditions", SqlDbType.VarChar, hashTable["OtherCNSConditions"].ToString()); oUtility.AddParameters("@OtherChestLungsConditions", SqlDbType.VarChar, hashTable["OtherChestLungsConditions"].ToString()); oUtility.AddParameters("@OtherSkinConditions", SqlDbType.VarChar, hashTable["OtherSkinConditions"].ToString()); oUtility.AddParameters("@OtherMedicalConditionNotes", SqlDbType.VarChar, hashTable["OtherMedicalConditionNotes"].ToString()); if (hashTable["Temp"].ToString() != "") { oUtility.AddParameters("@Temp", SqlDbType.Decimal, hashTable["Temp"].ToString()); } if (hashTable["RR"].ToString() != "") { oUtility.AddParameters("@RR", SqlDbType.Decimal, hashTable["RR"].ToString()); } if (hashTable["HR"].ToString() != "") { oUtility.AddParameters("@HR", SqlDbType.Decimal, hashTable["HR"].ToString()); } if (hashTable["height"].ToString() != "") { oUtility.AddParameters("@height", SqlDbType.Decimal, hashTable["height"].ToString()); } if (hashTable["weight"].ToString() != "") { oUtility.AddParameters("@weight", SqlDbType.Decimal, hashTable["weight"].ToString()); } if (hashTable["BPDiastolic"].ToString() != "") { oUtility.AddParameters("@BPDiastolic", SqlDbType.Decimal, hashTable["BPDiastolic"].ToString()); } if (hashTable["BPSystolic"].ToString() != "") { oUtility.AddParameters("@BPSystolic", SqlDbType.Decimal, hashTable["BPSystolic"].ToString()); } if (hashTable["HeadCircumference"].ToString() != "") { oUtility.AddParameters("@HeadCircumference", SqlDbType.Decimal, hashTable["HeadCircumference"].ToString()); } if (hashTable["WeightForAge"].ToString() != "") { oUtility.AddParameters("@WeightForAge", SqlDbType.Decimal, hashTable["WeightForAge"].ToString()); } if (hashTable["WeightForHeight"].ToString() != "") { oUtility.AddParameters("WeightForHeight", SqlDbType.Decimal, hashTable["WeightForHeight"].ToString()); } oUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); oUtility.AddParameters("@DataQlty", SqlDbType.Int, hashTable["qltyFlag"].ToString()); oUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(oUtility.theParams, "pr_Clinical_SaveUpdate_KNH_RevisedFollowup_FORM", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); oUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); oUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); oUtility.AddParameters("@OtherNotes", SqlDbType.Int, dtMultiSelectValues.Rows[i]["OtherNotes"].ToString()); oUtility.AddParameters("@DateField1", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["DateField1"].ToString()); int temp = (int)VisitManager.ReturnObject(oUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public int SaveCustomRegistrationFormDetail(DataSet dsSaveFormData, DataTable dtFieldDetails) { try { this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); ClsObject FormDetail = new ClsObject(); FormDetail.Connection = this.Connection; FormDetail.Transaction = this.Transaction; int theRowAffected = 0; DataRow theDR; int iFeatureId; string strTableName = string.Empty; //save mst_feature data oUtility.Init_Hashtable(); if (dsSaveFormData.Tables[0].Rows[0]["InsertUpdateStatus"].ToString() == "I") { oUtility.AddParameters("@FeatureId", SqlDbType.Int, "0"); } else { oUtility.AddParameters("@FeatureId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["FeatureId"].ToString()); } oUtility.AddParameters("@FeatureName", SqlDbType.VarChar, dsSaveFormData.Tables[0].Rows[0]["FeatureName"].ToString().Replace("'", "")); oUtility.AddParameters("@ReportFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["ReportFlag"].ToString()); oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["DeleteFlag"].ToString()); oUtility.AddParameters("@AdminFlag", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["AdminFlag"].ToString()); oUtility.AddParameters("@SystemId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["SystemId"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["UserID"].ToString()); oUtility.AddParameters("@Published", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["Published"].ToString()); oUtility.AddParameters("@CountryId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["CountryId"].ToString()); oUtility.AddParameters("@ModuleId", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["ModuleId"].ToString()); oUtility.AddParameters("@MultiVisit", SqlDbType.Int, dsSaveFormData.Tables[0].Rows[0]["MultiVisit"].ToString()); theDR = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveMstFeature_Futures", ClsUtility.ObjectEnum.DataRow); iFeatureId = System.Convert.ToInt32(theDR[0].ToString()); string[] strFeatureName = new string[10]; strFeatureName = dsSaveFormData.Tables[0].Rows[0]["FeatureName"].ToString().Split(' '); for (int j = 0; j < strFeatureName.Length; j++) { if (j > 0) { strTableName += "_" + strFeatureName[j]; } else { strTableName += strFeatureName[j]; } } for (int i = 0; i < dsSaveFormData.Tables[1].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["SectionId"].ToString()); oUtility.AddParameters("@SectionName", SqlDbType.VarChar, dsSaveFormData.Tables[1].Rows[i]["SectionName"].ToString()); oUtility.AddParameters("@Seq", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["Sequence"].ToString()); oUtility.AddParameters("@CustomFlag", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["CustomFlag"].ToString()); oUtility.AddParameters("@DeleteFlag", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["DeleteFlag"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[1].Rows[i]["UserId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); theDR = (DataRow)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveMstSection_Futures", ClsUtility.ObjectEnum.DataRow); } //save lnk_form data for (int i = 0; i < dsSaveFormData.Tables[2].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@Id", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Id"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["SectionId"].ToString()); oUtility.AddParameters("@FieldId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString()); oUtility.AddParameters("@FieldLabel", SqlDbType.VarChar, dsSaveFormData.Tables[2].Rows[i]["FieldLabel"].ToString()); oUtility.AddParameters("@Seq", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Sequence"].ToString()); oUtility.AddParameters("@UserID", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["UserId"].ToString()); oUtility.AddParameters("@Predefined", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_SaveLnkForm_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); DataView dvFilteredRow = new DataView(); dvFilteredRow = dtFieldDetails.DefaultView; DataTable dtRow = new DataTable(); if (dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString().Contains("7100000") == true) { dvFilteredRow.RowFilter = "ID='71' and predefine=" + dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString(); } else { dvFilteredRow.RowFilter = "ID='" + dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString() + "' and predefine=" + dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString(); } dtRow = dvFilteredRow.ToTable(); oUtility.Init_Hashtable(); oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableName); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtRow.Rows[0]["FieldName"].ToString()); oUtility.AddParameters("@DataType", SqlDbType.Int, dtRow.Rows[0]["ControlId"].ToString()); oUtility.AddParameters("@Predefined", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["Predefined"].ToString()); oUtility.AddParameters("@FieldId", SqlDbType.Int, dsSaveFormData.Tables[2].Rows[i]["FieldId"].ToString()); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_PatientRegistrationCustomTableCreation_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } //Delete fields selected from remove field in formbuilder while in update mode for (int i = 0; i < dsSaveFormData.Tables[3].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@Id", SqlDbType.Int, dsSaveFormData.Tables[3].Rows[i]["Id"].ToString()); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dsSaveFormData.Tables[3].Rows[i]["FieldName"].ToString()); oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableName); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_RemoveFieldInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } //Delete sections selected from remove section in formbuilder while in update mode if (dsSaveFormData.Tables.Count > 4) { for (int i = 0; i < dsSaveFormData.Tables[4].Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@SectionId", SqlDbType.Int, dsSaveFormData.Tables[4].Rows[i]["SectionId"].ToString()); oUtility.AddParameters("@FeatureId", SqlDbType.Int, iFeatureId.ToString()); oUtility.AddParameters("@TableName", SqlDbType.VarChar, strTableName); theRowAffected = (int)FormDetail.ReturnObject(oUtility.theParams, "Pr_FormBuilder_RemoveSectionAndFieldInFormBuilder_Futures", ClsUtility.ObjectEnum.ExecuteNonQuery); } } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(iFeatureId); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public DataSet SaveUpdateKNHRevisedFollowupData_CATab(Hashtable hashTable, DataTable dtMultiSelectValues, int DataQuality, int signature, int UserId) { try { DataSet theDS; int visitID; this.Connection = DataMgr.GetConnection(); this.Transaction = DataMgr.BeginTransaction(this.Connection); oUtility.Init_Hashtable(); oUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); oUtility.AddParameters("@Visit_Pk", SqlDbType.Int, hashTable["visitID"].ToString()); oUtility.AddParameters("@LocationId", SqlDbType.Int, hashTable["locationID"].ToString()); oUtility.AddParameters("@visitdate", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["visitDate"].ToString())); oUtility.AddParameters("@SchoolPerfomance", SqlDbType.Int, hashTable["SchoolPerfomance"].ToString()); oUtility.AddParameters("@OtherPresentingComplaints", SqlDbType.VarChar, hashTable["OtherPresentingComplaints"].ToString()); oUtility.AddParameters("@AdditonalPresentingComplaints", SqlDbType.VarChar, hashTable["OtherAdditionPresentingComplaints"].ToString()); //oUtility.AddParameters("@MedicalCondition", SqlDbType.Int, hashTable["MedicalCondition"].ToString()); oUtility.AddParameters("@OtherMedicalConditionNotes", SqlDbType.Int, hashTable["OtherMedicalCondition"].ToString()); oUtility.AddParameters("@CurrentSurgicalCondition", SqlDbType.VarChar, hashTable["CurrentSurgicalCondition"].ToString()); oUtility.AddParameters("@PreviousSurgicalCondition", SqlDbType.VarChar, hashTable["PreviousSurgicalCondition"].ToString()); oUtility.AddParameters("@PreExistingMedicalConditionsFUP", SqlDbType.Int, hashTable["PreExistingMedicalConditionsFUP"].ToString()); oUtility.AddParameters("@Antihypertensives", SqlDbType.VarChar, hashTable["Antihypertensives"].ToString()); oUtility.AddParameters("@Anticonvulsants", SqlDbType.VarChar, hashTable["Anticonvulsants"].ToString()); oUtility.AddParameters("@Hypoglycemics", SqlDbType.VarChar, hashTable["Hypoglycemics"].ToString()); oUtility.AddParameters("@RadiotherapyChemotherapy", SqlDbType.VarChar, hashTable["RadiotherapyChemotherapy"].ToString()); oUtility.AddParameters("@Othercurrentlongmedication", SqlDbType.VarChar, hashTable["OtherCurrentLongtermMedication"].ToString()); oUtility.AddParameters("@PreviousAdmission", SqlDbType.Int, hashTable["PreviousAdmission"].ToString()); oUtility.AddParameters("@PreviousAdmissionDiagnosis", SqlDbType.VarChar, hashTable["PreviousAdmissionDiagnosis"].ToString()); oUtility.AddParameters("@PreviousAdmissionStart", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["PreviousAdmissionStart"].ToString())); oUtility.AddParameters("@PreviousAdmissionEnd", SqlDbType.VarChar, String.Format("{0:dd-MMM-yyyy}", hashTable["PreviousAdmissionEnd"].ToString())); oUtility.AddParameters("@HIVAssociatedConditionsPeads", SqlDbType.Int, hashTable["HIVAssociatedConditionsPeads"].ToString()); oUtility.AddParameters("@UserId", SqlDbType.Int, UserId.ToString()); oUtility.AddParameters("@DataQlty", SqlDbType.Int, hashTable["qltyFlag"].ToString()); oUtility.AddParameters("@signature", SqlDbType.Int, signature.ToString()); oUtility.AddParameters("@StartTime", SqlDbType.VarChar, hashTable["starttime"].ToString()); ClsObject VisitManager = new ClsObject(); VisitManager.Connection = this.Connection; VisitManager.Transaction = this.Transaction; // DataSet tempDataSet; theDS = (DataSet)VisitManager.ReturnObject(oUtility.theParams, "pr_Clinical_SaveUpdate_KNH_RevisedFollowup_FORM_CATab", ClsUtility.ObjectEnum.DataSet); visitID = (int)theDS.Tables[0].Rows[0]["Visit_Id"]; //Pre Existing Medical Condition for (int i = 0; i < dtMultiSelectValues.Rows.Count; i++) { oUtility.Init_Hashtable(); oUtility.AddParameters("@Ptn_pk", SqlDbType.Int, hashTable["patientID"].ToString()); oUtility.AddParameters("@Visit_Pk", SqlDbType.Int, visitID.ToString()); oUtility.AddParameters("@ID", SqlDbType.Int, dtMultiSelectValues.Rows[i]["ID"].ToString()); oUtility.AddParameters("@FieldName", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["FieldName"].ToString()); oUtility.AddParameters("@OtherNotes", SqlDbType.Int, dtMultiSelectValues.Rows[i]["OtherNotes"].ToString()); oUtility.AddParameters("@DateField1", SqlDbType.VarChar, dtMultiSelectValues.Rows[i]["DateField1"].ToString()); int temp = (int)VisitManager.ReturnObject(oUtility.theParams, "pr_Clinical_Save_Multiselect_line", ClsUtility.ObjectEnum.ExecuteNonQuery); } DataMgr.CommitTransaction(this.Transaction); DataMgr.ReleaseConnection(this.Connection); return(theDS); } catch { DataMgr.RollBackTransation(this.Transaction); throw; } finally { if (this.Connection != null) { DataMgr.ReleaseConnection(this.Connection); } } }
public object ReturnObjectNewImpl(Hashtable Params, string CommandText, ClsDBUtility.ObjectEnum Obj) { int i; string cmdpara, cmdvalue, cmddbtype; ParameterDirection cmdDirection; SqlCommand theCmd = new SqlCommand(); SqlTransaction theTran = (SqlTransaction)this.Transaction; SqlConnection cnn = null; StringBuilder strParam = new StringBuilder(); try { if (null == this.Connection) { cnn = (SqlConnection)DataMgr.GetConnection(); } else { cnn = (SqlConnection)this.Connection; } if (null == this.Transaction) { theCmd = new SqlCommand(CommandText, cnn); } else { theCmd = new SqlCommand(CommandText, cnn, theTran); } for (i = 1; i < Params.Count;) { cmdpara = Params[i].ToString(); cmddbtype = Params[i + 1].ToString(); if (Params[i + 2] != null) { if (Params[i + 2].GetType() != ParameterDirection.Output.GetType()) { cmdvalue = Params[i + 2].ToString(); SqlDbType sType = (SqlDbType)Enum.Parse(typeof(SqlDbType), cmddbtype); if (sType == SqlDbType.DateTime) { //if (string.IsNullOrEmpty(cmdvalue.Trim()) == true) //{ // theCmd.Parameters.AddWithValue(cmdpara, DBNull.Value); //} //else if (String.IsNullOrWhiteSpace(cmdvalue) == true) //{ // theCmd.Parameters.AddWithValue(cmdpara, DBNull.Value); //} //else //{ DateTime tmpDate; if (DateTime.TryParse(cmdvalue, out tmpDate)) { theCmd.Parameters.Add(cmdpara, sType).Value = tmpDate.ToString("yyyy-MM-dd hh:mm:ss"); } else { theCmd.Parameters.AddWithValue(cmdpara, DBNull.Value); } //} } else { theCmd.Parameters.Add(cmdpara, cmddbtype).Value = cmdvalue; } } else { cmdDirection = (ParameterDirection)Params[i + 2]; theCmd.Parameters.Add(cmdpara, (SqlDbType)Params[i + 1]).Direction = cmdDirection; } } else { cmdvalue = string.Empty; theCmd.Parameters.Add(cmdpara, cmddbtype).Value = cmdvalue; } i = i + 3; } theCmd.CommandType = CommandType.StoredProcedure; theCmd.CommandTimeout = DataMgr.CommandTimeOut(); string theSubstring = CommandText.Substring(0, 6).ToUpper(); switch (theSubstring) { case "SELECT": theCmd.CommandType = CommandType.Text; break; case "UPDATE": theCmd.CommandType = CommandType.Text; break; case "INSERT": theCmd.CommandType = CommandType.Text; break; case "DELETE": theCmd.CommandType = CommandType.Text; break; } theCmd.Connection = cnn; if (Obj == ClsDBUtility.ObjectEnum.DataSet) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataSet theDS = new DataSet(); theAdpt.Fill(theDS); theAdpt.Dispose(); return(theDS); } if (Obj == ClsDBUtility.ObjectEnum.DataTable) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataTable theDT = new DataTable(); theAdpt.Fill(theDT); theAdpt.Dispose(); return(theDT); } if (Obj == ClsDBUtility.ObjectEnum.DataRow) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataTable theDT = new DataTable(); theAdpt.Fill(theDT); theAdpt.Dispose(); return(theDT.Rows[0]); } if (Obj == ClsDBUtility.ObjectEnum.ExecuteNonQuery) { int NoRowsAffected = 0; NoRowsAffected = theCmd.ExecuteNonQuery(); if (theCmd.Parameters.Contains("@idNEW")) { if ((int)theCmd.Parameters["@idNEW"].Value > 0) { NoRowsAffected = (int)theCmd.Parameters["@idNEW"].Value; } } return(NoRowsAffected); } return(0); } catch (Exception err) { for (i = 1; i < Params.Count;) { cmdpara = Params[i].ToString(); cmddbtype = Params[i + 1].ToString(); if (Params[i + 2] != null) { if (Params[i + 2].GetType() != ParameterDirection.Output.GetType()) { cmdvalue = Params[i + 2].ToString(); SqlDbType sType = (SqlDbType)Enum.Parse(typeof(SqlDbType), cmddbtype); string val = cmdvalue; if (sType == SqlDbType.DateTime) { if (string.IsNullOrEmpty(cmdvalue.Trim()) == true || cmdvalue.ToString().ToLower() == "null" || String.IsNullOrWhiteSpace(cmdvalue) == true) { val = DBNull.Value.ToString(); } else { val = DateTime.Parse(cmdvalue).ToString("yyyy-MM-dd hh:mm:ss"); } } strParam.Append("Name: " + cmdpara + ", Type: " + cmddbtype + ", Value: " + val + ", Direction: Input"); strParam.Append(Environment.NewLine); } else { cmdDirection = (ParameterDirection)Params[i + 2]; strParam.Append("Name: " + cmdpara + ", Type: " + cmddbtype + ", Direction: Output"); strParam.Append(Environment.NewLine); } } i = i + 3; } CLogger.WriteLog("Namespace: DataAccess.Entity, Class: ClsObject, Method: ReturnObject - Call started.", CommandText, strParam.ToString(), err.ToString()); throw err; } finally { if (null != cnn) { if (null == this.Connection) { DataMgr.ReleaseConnection(cnn); } } } }
/// <summary> /// Returns the object. /// </summary> /// <param name="paramaters">The parameters.</param> /// <param name="commandText">The command text.</param> /// <param name="Obj">The object.</param> /// <param name="Mode">The mode.</param> /// <returns></returns> public object ReturnObject(Hashtable paramaters, string commandText, ClsUtility.ObjectEnum Obj, ConnectionMode Mode) { //int i; //string cmdpara, cmdvalue, cmddbtype; SqlCommand theCmd = new SqlCommand(); SqlTransaction theTran = (SqlTransaction)this.Transaction; SqlConnection cnn; if (null == this.Connection) { cnn = (SqlConnection)DataMgr.GetConnection(Mode); } else { cnn = (SqlConnection)this.Connection; } if (null == this.Transaction) { theCmd = new SqlCommand(commandText, cnn); } else { theCmd = new SqlCommand(commandText, cnn, theTran); } /* for (i = 1; i < Params.Count; ) * { * cmdpara = Params[i].ToString(); * cmddbtype = Params[i + 1].ToString(); * cmdvalue = Params[i + 2].ToString(); * System.Data.Common.DbParameter p = theCmd.CreateParameter(); * p.ParameterName = cmdpara; * p.Value = cmdvalue; * theCmd.Parameters.Add(cmdpara); * * theCmd.Parameters.Add(cmdpara, cmddbtype).Value = cmdvalue; * i = i + 3; * } */ for (int i = 1; i <= paramaters.Count;) { theCmd.Parameters.Add(paramaters[i]); i++; } theCmd.CommandType = CommandType.StoredProcedure; theCmd.CommandTimeout = DataMgr.CommandTimeOut(); string theSubstring = commandText.Substring(0, 6).ToUpper(); switch (theSubstring) { case "SELECT": theCmd.CommandType = CommandType.Text; break; case "UPDATE": theCmd.CommandType = CommandType.Text; break; case "INSERT": theCmd.CommandType = CommandType.Text; break; case "DELETE": theCmd.CommandType = CommandType.Text; break; case "TRUNCA": theCmd.CommandType = CommandType.Text; break; } theCmd.Connection = cnn; try { if (Obj == ClsUtility.ObjectEnum.DataSet) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataSet theDS = new DataSet(); theAdpt.Fill(theDS); theAdpt.Dispose(); return(theDS); } if (Obj == ClsUtility.ObjectEnum.DataTable) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataTable theDT = new DataTable(); theAdpt.Fill(theDT); theAdpt.Dispose(); return(theDT); } if (Obj == ClsUtility.ObjectEnum.DataRow) { SqlDataAdapter theAdpt = new SqlDataAdapter(theCmd); DataTable theDT = new DataTable(); theAdpt.Fill(theDT); theAdpt.Dispose(); return(theDT.Rows[0]); } if (Obj == ClsUtility.ObjectEnum.ExecuteNonQuery) { int NoRowsAffected = theCmd.ExecuteNonQuery(); return(NoRowsAffected); } return(0); } catch (Exception err) { throw err; } finally { if (null != cnn) { if (null == this.Connection) { DataMgr.ReleaseConnection(cnn); } } } }