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