//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();
}
}
