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