Exemple #1
0
        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);
        }
Exemple #2
0
        /// <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());
                }
            }
        }
Exemple #3
0
        /// <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());
                }
            }
        }