public static List <string> Read_SW_Transaction_ID(DateTime selDate, ServiceHelper sh)
{
SWTNBHelper tnbDB = new SWTNBHelper();
List <string> transactionIdList = tnbDB.Select_Soa_Trans(selDate, sh);
return(transactionIdList);
}
/// <summary>
/// This will insert the transaction ID from Logs into SOA_TRANSACTION table
/// </summary>
/// <param name="logFiles">List of Log files from SW folder</param>
/// <param name="sh">Instance of Service Helper</param>
private static void Insert_SOA_Transaction(List <FileInfo> logFiles, ServiceHelper sh)
{
SWTNBHelper sw = new SWTNBHelper();
if (logFiles.Count > 0)
{
try
{
//sw.DeleteTransLog(inputDate, sh);
int totalRows = sw.Insert_Soa_Trans(logFiles.ToList(), sh);
PrintHelper.Trace(string.Format(Messages.TotalRowsInserted, totalRows));
}
catch (Exception ex)
{
PrintHelper.Error(Messages.InsertDataFail);
PrintHelper.Error(ex.ToString());
}
}
}
/// <summary>
/// this will insert the difference into KSF_SYSTEM_SOA_FAIL_TRANS table
/// </summary>
/// <param name="difference">List string of Transaction Id </param>
/// <param name="sh">Instance of Service Helper</param>
/// <param name="inputDate">selected Date</param>
private static void Insert_SOA_Fail_Trans(IEnumerable <string> difference, ServiceHelper sh, DateTime inputDate)
{
SWTNBHelper sw = new SWTNBHelper();
if (difference.Count() > 0)
{
try
{
//sw.DeleteFailTrans(DateTime.Now, sh, inputDate);
int totalRows = sw.Insert_SOAFailTrans(difference, inputDate, sh);
PrintHelper.Trace(string.Format(Messages.TotalRowsInserted,
totalRows.ToString()));
}
catch (Exception ex)
{
PrintHelper.Error(Messages.InsertDataFail);
PrintHelper.Error(ex.ToString());
}
}
}