//AM Issue#38713 06/18/2008 public static void deleteSystemMessage(string MessageID) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("Delete From DIC_SystemMessage Where SM_RowID="); sb.Append("'" + MessageID + "'"); string deleteStatement = sb.ToString(); CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); cache.Insert(deleteStatement); }
/*public static DataTable getSpecialPricing(String clientID, String unitCode, String dateOfPrice) * { #region Preparing SQL Statement * * System.Text.StringBuilder sb = new System.Text.StringBuilder(); * sb.Append("SELECT "); * //sb.Append("{fn CONVERT(SP_Price,SQL_VARCHAR)} AS SpecialPrice,"); * sb.Append("SP_Price+'' AS SpecialPrice,"); * sb.Append("SP_OptionPrice As SpecialOptionPrice,"); * sb.Append("SP_UnitCodeDR->UC_DisplayReportingTitle As UnitCodeTitle,"); * sb.Append("SP_RowID As SpecialPriceRowID "); * sb.Append("FROM "); * sb.Append("FIN_SpecialPricing "); * sb.Append("WHERE "); * sb.Append("SP_ACT_ParRef='" + clientID + "'"); * sb.Append(" AND "); * //sb.Append("SP_UnitCodeDR='" + unitCode + "'"); * sb.Append("SP_UnitCodeDR->UC_DisplayReportingTitle='" + unitCode + "'"); * sb.Append(" AND "); * sb.Append("SP_DateSubscript>99999-CAST(TO_DATE('" + dateOfPrice + "','MM/DD/YYYY') AS FLOAT)"); * //sb.Append("TO_DATE(99999 - SP_DateSubscript,'MM/DD/YYYY') > '" + dateOfPrice + "'"); * //sb.Append("SP_DateSubscript>'" + dateOfPrice + "'"); * String selectStatement = sb.ToString(); * #endregion Preparing SQL Statement * * CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); * return cache.FillCacheDataTable(selectStatement); * } * * public static DataTable getSpecialPricingOptionsList(String specialPriceID) * { #region Preparing SQL Statement * * System.Text.StringBuilder sb = new System.Text.StringBuilder(); * sb.Append("SELECT "); * sb.Append("SPOPT_OptionUnitCodeDR As UnitCode,"); * sb.Append("SPOPT_OptionUnitCodeDR->UC_DisplayReportingTitle As UnitCodeTitle "); * sb.Append("FROM "); * sb.Append("FIN_SpecialPricingOptionList "); * sb.Append("WHERE "); * sb.Append("SPOPT_SP_ParRef='" + specialPriceID + "'"); * String selectStatement = sb.ToString(); * #endregion Preparing SQL Statement * * CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); * return cache.FillCacheDataTable(selectStatement); * } * * * public static DataTable getNormalFeeSchedule(String clientID, String dateOfPrice) * { #region Preparing SQL Statement * * System.Text.StringBuilder sb = new System.Text.StringBuilder(); * sb.Append("SELECT "); * sb.Append("NP_FeeSchedule "); * sb.Append("FROM "); * sb.Append("FIN_NormalPricing "); * sb.Append("WHERE "); * sb.Append("NP_ACT_ParRef ='" + clientID + "'"); * sb.Append(" AND "); * sb.Append("NP_DateSubscript>99999-CAST(TO_DATE('" + dateOfPrice + "','MM/DD/YYYY') AS FLOAT)"); * //sb.Append("TO_DATE(99999-NP_DateSubscript,'MM/DD/YYYY') > '" + dateOfPrice + "'"); * //sb.Append("NP_DateSubscript > '" + dateOfPrice + "'"); * String selectStatement = sb.ToString(); * #endregion Preparing SQL Statement * * CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); * return cache.FillCacheDataTable(selectStatement); * } * * public static DataTable getNormalPrice(String dateOfPrice, String unitCode, String normalFeeScheduleID) * { #region Preparing SQL Statement * * System.Text.StringBuilder sb = new System.Text.StringBuilder(); * sb.Append("SELECT "); * sb.Append("UCFS_Price,"); * sb.Append("UCFS_OptionPrice,"); * sb.Append("UCFS_UC_ParRef->UC_DisplayReportingTitle As UnitCodeTitle,"); * sb.Append("UCFS_RowID "); * sb.Append("FROM "); * sb.Append("DIC_UnitCodeFeeSchedule "); * sb.Append("WHERE "); * sb.Append("UCFS_UC_ParRef->UC_DisplayReportingTitle ='" + unitCode + "'"); * //sb.Append("UCFS_UC_ParRef ='" + unitCode + "'"); * sb.Append(" AND "); * sb.Append("UCFS_DateSubscript>99999-CAST(TO_DATE('" + dateOfPrice + "','MM/DD/YYYY') AS FLOAT)"); * //sb.Append("TO_DATE(99999-UCFS_DateSubscript,'MM/DD/YYYY') > '" + dateOfPrice + "'"); * //sb.Append("UCFS_DateSubscript >'" + dateOfPrice + "'"); * sb.Append(" AND "); * sb.Append("UCFS_FeeScheduleID ='" + normalFeeScheduleID + "'"); * String selectStatement = sb.ToString(); * #endregion Preparing SQL Statement * * CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); * return cache.FillCacheDataTable(selectStatement); * } * * public static DataTable getNormalPriceOptions(String NormalPriceID) * { #region Preparing SQL Statement * * System.Text.StringBuilder sb = new System.Text.StringBuilder(); * sb.Append("SELECT "); * sb.Append("UCFSO_OptionUnitCodeDR As UnitCode,"); * sb.Append("UCFSO_OptionUnitCodeDR->UC_DisplayReportingTitle As UnitCodeTitle"); * sb.Append(" FROM "); * sb.Append("DIC_UCFSOptionList "); * sb.Append("WHERE "); * sb.Append("UCFSO_UCFS_ParRef ='" + NormalPriceID + "'"); * String selectStatement = sb.ToString(); * #endregion Preparing SQL Statement * * CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); * return cache.FillCacheDataTable(selectStatement); * }*/ #endregion Unused Code public static Int32 updateAccountNote(String clientMnemonic, String newNote, String priceInqPasswd, Boolean canChangeClientPasswd) { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("UPDATE "); sb.Append("CLF_CLIENTFILE "); sb.Append("SET "); sb.Append("CLF_CustomerServiceNotes = '" + newNote + "' "); if (canChangeClientPasswd) { sb.Append(", CLF_PasswordPriceInquiry = '" + priceInqPasswd + "' "); } sb.Append("WHERE "); sb.Append("CLF_CLMNE = '" + clientMnemonic + "'"); CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); return(cache.Insert(sb.ToString())); }
public static void updateTestDelStatus(String testID, String processedBy, String CheckedOut, String Accession) { String timeFormat = UIfunctions.getTimeFormat(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("Update ORD_TestDeletion set TD_ProcessingStatus = 'PROC' ,TD_UserProcessedBy ='" + processedBy + "',TD_DateProcessed='" + DateTime.Now.ToString("yyyy-MM-dd") + "',TD_TimeProcessed='" + DateTime.Now.ToString(timeFormat) + "' where TD_RowId = '" + testID + "'"); CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); int rows = cache.Insert(sb.ToString()); Dictionary <String, String> _updateTestDelStatus = new Dictionary <String, String>(); _updateTestDelStatus.Add("ACCESSION", Accession); _updateTestDelStatus.Add("TESTROWID", testID); _updateTestDelStatus.Add("USERID", processedBy); _updateTestDelStatus.Add("CHECKEDOUT", CheckedOut); String strTemp = cache.StoredProcedure("?=call SP2_TDCheckInOut(?,?,?,?)", _updateTestDelStatus).Value.ToString(); }
public static void updateTestDelStatus(string testID, string CheckedOut, string checkedBy) { String timeFormat = UIfunctions.getTimeFormat(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("Update ORD_TestDeletion set TD_ProcessingStatus = '" + CheckedOut + "', TD_UserPrintedBy = '" + checkedBy + "',TD_DatePrinted='" + DateTime.Now.ToString("yyyy-MM-dd") + "',TD_TimePrinted='" + DateTime.Now.ToString(timeFormat) + "' where TD_RowId = '" + testID + "'"); CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass(); int rows = cache.Insert(sb.ToString()); DataTable dtAccession = cache.FillCacheDataTable("SELECT TD_AccessionDR FROM ORD_TESTDELETION WHERE TD_ROWID = '" + testID + "'"); if (dtAccession.Rows.Count > 0) { Dictionary <String, String> _updateTestDelStatus = new Dictionary <String, String>(); _updateTestDelStatus.Add("ACCESSION", dtAccession.Rows[0][0].ToString()); _updateTestDelStatus.Add("TESTROWID", testID); _updateTestDelStatus.Add("USERID", checkedBy); _updateTestDelStatus.Add("CHECKEDOUT", CheckedOut); String strTemp = cache.StoredProcedure("?=call SP2_TDCheckInOut(?,?,?,?)", _updateTestDelStatus).Value.ToString(); } }