public static String insertTestDeletion(string Accession, string DateEntered, string Department, string LabLocation, string ReasonForDeletion, string TestsToDeleteString, string Comments, string ProcessingStatus, string UserEnteredBy)
{
//System.Text.StringBuilder sb = new System.Text.StringBuilder();
//sb.Append("Insert into ORD_TestDeletion (TD_AccessionDR,TD_DateEntered,TD_DepartmentDR, TD_LabLocationDR, TD_REASONFORDELETIONDR, TD_TestsToDelete, TD_Comments,TD_ProcessingStatus, TD_UserEnteredBy) VALUES( ");
//sb.Append("'" + Accession + "'" + ", ");
//string EnteredDate = "TO_DATE('" + DateEntered + "','MM/DD/YYYY')";
//sb.Append(EnteredDate + ", ");
//sb.Append("'" + Department + "'" + ", ");
//sb.Append("'" + LabLocation + "'" + ", ");
//sb.Append("'" + ReasonForDeletion + "'" + ", ");
//sb.Append("'" + TestsToDeleteString + "'" + ", ");
//sb.Append("'" + Comments + "'" + ", ");
//sb.Append("'" + ProcessingStatus + "'" + ",");
//sb.Append("'" + UserEnteredBy + "')");
//string insertStatement = sb.ToString();
//CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
//return Convert.ToString(cache.Insert(insertStatement));
Dictionary <string, string> _testDeletionData = new Dictionary <string, string>();
_testDeletionData.Add("ACCESSION", Accession);
_testDeletionData.Add("DEPARTMENT", Department);
_testDeletionData.Add("LAB", LabLocation);
_testDeletionData.Add("REASON", ReasonForDeletion);
_testDeletionData.Add("COMMENTTEXT", Comments);
_testDeletionData.Add("TESTS", TestsToDeleteString);
_testDeletionData.Add("USER", UserEnteredBy);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_SaveTestDeletion(?,?,?,?,?,?,?)", _testDeletionData).Value.ToString());
}
public static DataTable getClientAtRisk(string strDateFrom, string strDateTo, string groupString, out string sessionID)
{
Dictionary <String, String> _getBICAR = new Dictionary <String, String>();
_getBICAR.Add("FROMDATE", strDateFrom);
_getBICAR.Add("TODATE", strDateTo);
_getBICAR.Add("GROUPSTRING", groupString);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
sessionID = cache.StoredProcedure("?=call SP2_ClientAtRisk(?,?,?)", _getBICAR).Value.ToString();
DataTable returnDataTable = new DataTable();
StringBuilder sb = new StringBuilder();
if (sessionID.Length > 0)
{
sb.Append("Select BICAR_RowID, BICAR_ClientDR, BICAR_ClientDR->CLF_CLNUM As AccountNumber, ");
sb.Append("BICAR_ClientDR->CLF_CLNAM As AccountName, ");
sb.Append("BICAR_ClientDR->CLF_CLPHN As AccountPhone, ");
sb.Append("BICAR_ClientDR->CLF_CLSRT As Territory, ");
sb.Append("BICAR_ClientDR->CLF_CLSRT->ST_SalesRepName As SalesRepName, ");
sb.Append("$$GETREVHIST^XT1(BICAR_ClientDR) AS ClientRevenue");
sb.Append(" From");
sb.Append(" BI_TMP_ClientsAtRisk");
sb.Append(" WHERE 1=1");
sb.Append(String.Concat(" AND BICAR_SessionID=", sessionID, ""));
sb.Append(" AND BICAR_AtRisk='Y'");
cache = new CACHEDAL.ConnectionClass();
returnDataTable = cache.FillCacheDataTable(sb.ToString());
}
return(returnDataTable);
}
public static void insertTestDeletion(string Accession, string DateEntered, string Department, string LabLocation, string ReasonForDeletion, string Comments, string TestsToDeleteString, string userID)
{
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
cache.StoredProcedure("call SP_SaveTestDeletion(?,?,?,?,?,?,?,?)", Accession, DateEntered, Department, LabLocation, ReasonForDeletion, Comments, TestsToDeleteString, userID);
//string returnValue = cache.StoredProcedure("?=call SP_getCurrDate()", Microsoft.Data.Odbc.OdbcType.NVarChar).Value.ToString();
}
public static DataTable getTestsInquiry(String clientID, String unitCode, String date, out String UnitCodeTitle, out String SpecialPrice, out String SpecialOptionPrice, String clientMnemonic, String userId, String userLab, String testName, String logEvent)
{
UnitCodeTitle = String.Empty;
SpecialPrice = String.Empty;
SpecialOptionPrice = String.Empty;
Dictionary <String, String> _getTestsInquiry = new Dictionary <String, String>();
_getTestsInquiry.Add("ClientID", clientID);
_getTestsInquiry.Add("UnitCode", unitCode);
_getTestsInquiry.Add("Date", date);
_getTestsInquiry.Add("ClientMnemonic", clientMnemonic);
_getTestsInquiry.Add("UserId", userId);
_getTestsInquiry.Add("UserLab", userLab);
_getTestsInquiry.Add("TestName", testName);
_getTestsInquiry.Add("LogEvent", logEvent);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
String fullOutput = cache.StoredProcedure("?=call SP2_PRICEINQ(?,?,?,?,?,?,?,?)", _getTestsInquiry, 999999).Value.ToString();
String[] values = fullOutput.Split('^');
if (values.Length == 4)
{
UnitCodeTitle = values[0];
SpecialPrice = values[1];
SpecialOptionPrice = values[2];
DataTable returnDataTable = AtlasIndia.AntechCSM.Data.DL_functions.StringToDataTable(values[3], ';', '~');
if (returnDataTable.Columns.Count == 3)
{
returnDataTable.Columns[1].ColumnName = "UnitCode";
returnDataTable.Columns[2].ColumnName = "UnitCodeTitle";
returnDataTable.AcceptChanges();
return(returnDataTable);
}
}
return(null);
}
public static Int32 updateAddOnVerificationRequests(String confirmationID, String callerName, String changeRequestType, String email, String labLocation, String specialInstructions, String addOnTests, String userID, String ReasonForReq, String PathologistRequested, String OriginalPathologist, String CheckTubeType, bool isModify)
{
#region ObsoleteCode
/*System.Text.StringBuilder sb = new System.Text.StringBuilder();
* sb.Append("UPDATE ORD_ADDON SET ");
* sb.Append("ADDON_CALLERNAME = '" + callerName + "',");
* sb.Append(" ADDON_RequestType = '" + changeRequestType + "',");
* sb.Append(" ADDON_Email = '" + email + "',");
* sb.Append(" ADDON_LabLocationDR = '" + labLocation + "',");
* sb.Append(" ADDON_SpecialInstructions = '" + specialInstructions + "',");
* sb.Append(" ADDON_Tests = '" + addOnTests + "',");
* sb.Append(" ADDON_User = '******'");
* sb.Append(" WHERE ADDON_ConfirmationNumber = '" + confirmationID + "'");
* CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
* return cache.Insert(sb.ToString());*/
#endregion ObsoleteCode
Dictionary <String, String> _addonReport = new Dictionary <String, String>();
_addonReport.Add("ConfirmationNumber", confirmationID);
_addonReport.Add("Caller", callerName);
_addonReport.Add("RequestType", changeRequestType);
_addonReport.Add("Email", email);
_addonReport.Add("Lab", labLocation);
_addonReport.Add("SpecialInst", specialInstructions);
_addonReport.Add("Tests", addOnTests);
_addonReport.Add("UserID", userID);
_addonReport.Add("ReasonForReq", ReasonForReq);
_addonReport.Add("PathologistRequested", PathologistRequested);
_addonReport.Add("OriginalPathologist", OriginalPathologist);
_addonReport.Add("CheckTubeType", CheckTubeType);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(Convert.ToInt32(cache.StoredProcedure("?=call SP2_UpdateAddon(?,?,?,?,?,?,?,?,?,?,?,?)", _addonReport).Value));
}
public static String getSystemBroadcastMessage()
{
Dictionary <string, string> _systemBroadCastMessage = new Dictionary <string, string>();
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetSystemBroadCastMessage()", _systemBroadCastMessage, 32000).Value.ToString());
}
//AM Issue#38713 06/17/2008
public String getSystemMessage(string MessageID)
{
Dictionary <string, string> _getSystemMessage = new Dictionary <string, string>();
_getSystemMessage.Add("MSGROW", MessageID);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetSystemMessage(?)", _getSystemMessage, 32000).Value.ToString());
}
public static String verifyTestDeletion(String Reason)
{
Dictionary <string, string> _sendClientgram = new Dictionary <string, string>();
_sendClientgram.Add("REASON", Reason);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_VerifyTestDeletion(?)", _sendClientgram).Value.ToString());
}
public static String getDefaultILCToLab(String rowId)
{
Dictionary <String, String> _ILCData = new Dictionary <String, String>();
_ILCData.Add("rowId", rowId);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetILCDefaultToLab(?)", _ILCData).Value.ToString());
}
public static String getClientCountry(String clientID)
{
Dictionary <string, string> _getClientCountry = new Dictionary <string, string>();
_getClientCountry.Add("ClientID", clientID);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP_getClientCountry(?)", _getClientCountry).Value.ToString());
}
public static String getILCMessageDefaultStatus(String MessageCode)
{
Dictionary <String, String> _ILCData = new Dictionary <String, String>();
_ILCData.Add("MSGCODE", MessageCode);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetILCMessageDefaultStatus(?)", _ILCData).Value.ToString());
}
public static string validateAutodial(String CLID)
{
Dictionary <string, string> _validateAutodial = new Dictionary <string, string>();
_validateAutodial.Add("CLID", CLID);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_ValidateAutodial(?)", _validateAutodial).Value.ToString());
}
public static string getTotalClientCount(string sessionID)
{
Dictionary <String, String> _getClientCount = new Dictionary <String, String>();
_getClientCount.Add("SESSIONID", sessionID);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetTotalClientCount(?)", _getClientCount).Value.ToString());
}
public static string getInquiries(string accessionNumber)
{
Dictionary <String, String> _getInqNote = new Dictionary <String, String>();
_getInqNote.Add("AccessionNumber", accessionNumber);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetInqNotes(?)", _getInqNote, 32000).Value.ToString());
}
public static void deleteMail(String UserID, String MailID)
{
Dictionary <string, string> _mailData = new Dictionary <String, String>();
_mailData.Add("USERID", UserID);
_mailData.Add("MAILID", MailID);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
String dummyReturn = cache.StoredProcedure("?=call SP_DeleteMails(?,?)", _mailData).Value.ToString();
}
public static string getSpecimenLocation(string accessionNumber, bool sp)
{
Dictionary <String, String> _SpecimenLoc = new Dictionary <String, String>();
_SpecimenLoc.Add("AccessionNumber", accessionNumber);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetSpecimenLocation(?)", _SpecimenLoc).Value.ToString());
}
public static string getNTMOwnerLab(string MonitoringLab)
{
Dictionary <String, String> NTMData = new Dictionary <String, String>();
NTMData.Add("MonitoringLab", MonitoringLab);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetNTMOwnerLabList(?)", NTMData).Value.ToString());
}
public static string GetUserGrpNameUsingIDs(string calledFor, string toUserGrpString)
{
Dictionary <String, String> _mailData = new Dictionary <String, String>();
_mailData.Add("CalledFor", calledFor);
_mailData.Add("ToUserGrpString", toUserGrpString);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetUserGrpNameUsingIDs(?,?)", _mailData).Value.ToString());
}
public static string validateNTM(string date, string lab)
{
Dictionary <String, String> NTMData = new Dictionary <String, String>();
NTMData.Add("Date", date);
NTMData.Add("Lab", lab);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_ValidateNTM(?,?)", NTMData).Value.ToString());
}
public static string getNTMDetailsBySearchOptions(string monitoringLab, string ownerLab)
{
Dictionary <String, String> NTMData = new Dictionary <String, String>();
NTMData.Add("MonitoringLab", monitoringLab);
NTMData.Add("OwnerLab", ownerLab);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_GetNTMDetails(?,?)", NTMData, 32000).Value.ToString());
}
//AM Issue#38713 06/17/2008
public static String updateSystemMessage(string MessageID, string DisplayOnLogin, string MessageText)
{
Dictionary <string, string> _updateSystemMessage = new Dictionary <string, string>();
_updateSystemMessage.Add("MSGROW", MessageID);
_updateSystemMessage.Add("MESSAGE", MessageText);
_updateSystemMessage.Add("DISPLAYLOGIN", DisplayOnLogin);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_InsertUpdateSystemMessage(?,?,?)", _updateSystemMessage).Value.ToString());
}
//AM Issue#38713 06/17/2008
public static String insertSystemMessage(string MessageText, string IsDiaplayLogIn)
{
Dictionary <string, string> _insertSystemMessage = new Dictionary <string, string>();
_insertSystemMessage.Add("MSGROW", "");
_insertSystemMessage.Add("MESSAGE", MessageText);
_insertSystemMessage.Add("DISPLAYLOGIN", IsDiaplayLogIn);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_InsertUpdateSystemMessage(?,?,?)", _insertSystemMessage).Value.ToString());
}
public static String printClientReport(String accessionNumber, String printerName, String userName)
{
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
Dictionary <string, string> _printClientReport = new Dictionary <string, string>();
_printClientReport.Add("AccessionNumber", accessionNumber);
_printClientReport.Add("PrinterName", printerName);
_printClientReport.Add("UserName", userName);
return(cache.StoredProcedure("?=call SP2_printClientReport(?,?,?)", _printClientReport).Value.ToString());
}
//AM Issue#32877 AntechCSM 1.0.15.0 09/24/2008
public static void deleteTestDeletion(String TESTROW, String Accession, String UserID)
{
Dictionary <String, String> _testDeletionData = new Dictionary <String, String>();
_testDeletionData.Add("TESTROW", TESTROW);
_testDeletionData.Add("Accession", Accession);
_testDeletionData.Add("UserID", UserID);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
String strTemp = cache.StoredProcedure("?=call SP2_DeleteTestDeletion(?,?,?)", _testDeletionData).Value.ToString();
}
public static void ResetMailRead(string userRowId, string messageId)
{
Dictionary <String, String> _mailData = new Dictionary <String, String>();
_mailData.Add("USER", userRowId);
_mailData.Add("MESSAGENUM", messageId);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
cache.StoredProcedure("?=call SP2_RESETREADMAIL(?,?)", _mailData);
}
public static String validatePriceInqPassword(String clientID, String priceInqPasswd, String User)
{
Dictionary <string, string> _validatePriceInqPasswd = new Dictionary <string, string>();
_validatePriceInqPasswd.Add("CLIENT", clientID);
_validatePriceInqPasswd.Add("PASSWORD", priceInqPasswd);
_validatePriceInqPasswd.Add("USER", User);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_ValidatePriceInqPasswd(?,?,?)", _validatePriceInqPasswd).Value.ToString());
}
public static string uploadSupplyItems(DataTable itemDetails)
{
string blRetVal = "";
string strCurrLine = "";
int intLastCnt = 0;
StringBuilder sbInput;
try
{
char chFieldSeparator = Convert.ToChar(1);
string strRowSeparator = "^";
sbInput = new StringBuilder();
for (int intCnt = 0; intCnt < itemDetails.Rows.Count; intCnt++)
{
if (itemDetails.Rows[intCnt][0].ToString().Trim().Length == 0)
{
continue;
}
strCurrLine = itemDetails.Rows[intCnt][0].ToString();
if (sbInput.Length > 0)
{
sbInput.Append(strRowSeparator);
}
sbInput.Append(itemDetails.Rows[intCnt][0].ToString()); // Category Code
sbInput.Append(chFieldSeparator);
sbInput.Append(itemDetails.Rows[intCnt][1].ToString()); //Category Name
sbInput.Append(chFieldSeparator);
sbInput.Append(itemDetails.Rows[intCnt][2].ToString()); // Mnemonic
sbInput.Append(chFieldSeparator);
sbInput.Append(itemDetails.Rows[intCnt][3].ToString()); // Description
sbInput.Append(chFieldSeparator);
sbInput.Append(itemDetails.Rows[intCnt][4].ToString()); //Multiples Of
sbInput.Append(chFieldSeparator);
sbInput.Append(itemDetails.Rows[intCnt][5].ToString()); //Order As
sbInput.Append(chFieldSeparator);
sbInput.Append(itemDetails.Rows[intCnt][6].ToString()); //Ordering Notes
intLastCnt = intCnt;
}
Dictionary <String, String> itemdetails = new Dictionary <String, String>();
itemdetails.Add("SUPPITEMSTR", sbInput.ToString());
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
blRetVal = cache.StoredProcedure("?=call SP2_UploadSupplyItems(?)", itemdetails).Value.ToString();
}
catch (Exception expOccored)
{
string str = expOccored.Message;
}
return(blRetVal);
}
public static string UnCheckOut(string rowID, string accessionNo, string user)
{
Dictionary <String, String> PurpleData = new Dictionary <String, String>();
PurpleData.Add("AccessionNumber", accessionNo);
PurpleData.Add("RowId", rowID);
PurpleData.Add("User", user);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_MissingSpecimenUnCheckOut(?,?,?)", PurpleData).Value.ToString());
}
public static string processNTM(string accessionList, string user, string lab)
{
Dictionary <String, String> NTMData = new Dictionary <String, String>();
NTMData.Add("AccessionList", accessionList);
NTMData.Add("User", user);
NTMData.Add("MonitoringLab", lab);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_ProcessNTM(?,?,?)", NTMData).Value.ToString());
}
public static String deleteILC(String rowId, String User, String AccessionNumber)
{
Dictionary <String, String> _ILCData = new Dictionary <String, String>();
_ILCData.Add("rowId", rowId);
_ILCData.Add("User", User);
_ILCData.Add("AccessionNumber", AccessionNumber);
CACHEDAL.ConnectionClass cache = new CACHEDAL.ConnectionClass();
return(cache.StoredProcedure("?=call SP2_DeleteILC(?,?,?)", _ILCData).Value.ToString());
}
