private void countValidRiskMasterPayments() { string selectValidRecordsStatement = @"select count(*) as COUNT FROM XXCOK.XXCOK_RM_IMPORT_PF PF inner join (select IMPORT_ID, IMPORT_DATE, PAYMENT_ID, nvl(max(INVOICE_NUMBER), '0') as INVOICE_NUMBER from XXCOK.XXCOK_RM_IMPORT_PD group by IMPORT_ID, IMPORT_DATE, PAYMENT_ID) PD on PF.IMPORT_ID = PD.IMPORT_ID and PF.IMPORT_DATE = PD.IMPORT_DATE and PF.PAYMENT_ID = PD.PAYMENT_ID where PF.IS_VALID = 1 AND IS_PROCESSED = 0"; dynamic qresult = oracleDBFacade.Query(selectValidRecordsStatement); XVar recordXVar = qresult.fetchAssoc(); if (recordXVar != null && recordXVar.Count() > 0) { dynamic record = recordXVar.Value; XVar value; if (record.TryGetValue("COUNT", out value)) { if (value != null && value.IsNumeric()) { int count = int.Parse(value); this.TotalRecordsValidated = this.TotalRecordsValidated + count; } } } }
public bool validateSupplierSiteCode(string npiNumber, string title) { bool returnSuccess = false; try { string formatSupplierSiteCodeStr = @"SELECT APSSA.VENDOR_ID AS VENDOR_ID FROM AP.AP_SUPPLIER_SITES_ALL APSSA INNER JOIN AP.AP_SUPPLIERS APS ON APSSA.VENDOR_ID = APS.VENDOR_ID WHERE APS.SEGMENT1 = {0} AND UPPER(APSSA.VENDOR_SITE_CODE) = UPPER('{1}') AND APSSA.PAY_SITE_FLAG IS NOT NULL AND APSSA.PAY_SITE_FLAG = 'Y'"; string validateSupplierSiteCodeStmt = String.Format(formatSupplierSiteCodeStr, npiNumber, title); dynamic qresult = oracleDBFacade.Query(validateSupplierSiteCodeStmt); XVar recordXVar = qresult.fetchAssoc(); if (recordXVar != null && recordXVar.Count() > 0) { dynamic record = recordXVar.Value; XVar value; if (record.TryGetValue("VENDOR_ID", out value)) { if (value != null) { returnSuccess = true; } } } } catch (Exception e) { throw e; /* * Console.WriteLine("An exception ({0}) occurred.", * e.GetType().Name); * Console.WriteLine(" Message:\n{0}", e.Message); * Console.WriteLine(" Stack Trace:\n {0}", e.StackTrace); * Exception ie = e.InnerException; * if (ie != null) * { * Console.WriteLine(" The Inner Exception:"); * Console.WriteLine(" Exception Name: {0}", ie.GetType().Name); * Console.WriteLine(" Message: {0}\n", ie.Message); * Console.WriteLine(" Stack Trace:\n {0}\n", ie.StackTrace); * } */ } return(returnSuccess); }
/// <summary> /// Sets padding in xml text. /// Helps to make the xmlcode readable but can be disabled by emptying arg_str_pad when we do not need to read the xml code. /// </summary> /// <param name="arg_int_pad_number">the number of indentation pads in this tag</param> /// <param name="arg_str_pad">the single pad size</param> /// <returns></returns> private XVar pad(XVar arg_int_pad_number = null, XVar arg_str_pad = null) { if (arg_int_pad_number as Object == null || arg_str_pad as Object == null) { return(null); } StringBuilder str_pad = new StringBuilder(); for (int i = 0; i < arg_int_pad_number.Count(); i++) { str_pad.Append(arg_str_pad.ToString()); } return(str_pad.Length > 0 ? "\n" + str_pad.ToString() : ""); }