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