static void Main(string[] args) { // //string gh = "user id=DPPADMIN; password=DPPADMIN; Connection Timeout=600; Max Pool Size=150; data source= (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.4.90)(PORT = 1700)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = TWODB))))"; //string conString = "Data Source=172.19.4.103:1700/TWODB;User Id=DPPADMIN;password=DPPADMIN;"; //string twoConString = !string.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings["TwoConfig"]) ? Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["TwoConfig"]) : string.Empty; //string MEBSource = !string.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings["MEBSource"]) ? Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["MEBSource"]) : string.Empty; //string MEBTarget = !string.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings["MEBTarget"]) ? Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["MEBTarget"]) : string.Empty; string reportPath = !string.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings["ReportPath"]) ? Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["ReportPath"]) : string.Empty; string logopath = !string.IsNullOrEmpty(System.Configuration.ConfigurationManager.AppSettings["LogoPath"]) ? Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["LogoPath"]) : string.Empty; IDapperGeneralSettings _repo = new DapperGeneralSettings(); // string conString = twoConString; // var dd = new SettlementProcess().GetMSC_PERC("1654487896", "1199803451", "2044QF28", "2044OG00V000183", "VISA", "566", "8220", 20916, "566", "0", "0",0,0,0,0, "0"); // int rec1 = _repo.PostMEB(MEBSource, MEBTarget, reportPath, logopath, "9622331", null); // DateTime? v_SETTDATE = null; //new SettlementProcess().SETTProcess("9622331"); //(SETTDATE, reportPATH, lgopath, NULL); IMainReport _repoSETT = new MainReport(); ////string sett = _repoSETT.RPT_GenSettlementFile(DateTime.Parse("02-FEB-17"), reportPath, logopath, null); //var g = new EmailProcess(); // g.SendMerchantarteeSettlementEmail("26-May-2017", ""); // IMainReport _repoSETT = new MainReport(); // g.SendMerchantVIPSettlementEmail("29-JUN-2017", ""); // string sett2 = _repoSETT.RPT_GenVIPMerchant(new DateTime(2017,09,06), reportPath, logopath, null); //new SettlementProcess_MEB().SETTProcess("9622331", "08-FEB-17"); //string dtFrom2 = DateTime.Today.ToString("dd-MMM-yyyy"); //new MEBCollectionClass().MEBProcess(dtFrom2); ////v_SETTDATE = DateTime.Today; ////v_SETTDATE.Value.Date.ToString("dd-MMM-yy"); //IDapperSettlementReport _repoSETT = new DapperSettlementReport(); // bool sett = _repoSETT.GenSettlementFileSETT(DateTime.Parse(v_SETTDATE.Value.Date.ToString("dd-MMM-yy")), null, reportPath, logopath, null); // bool sett = _repoSETT.GenSettlementFileSETT(DateTime.Parse("16-JAN-17"), null, reportPath, logopath, null); // int rec2 = _repo.processSettlement(MEBTarget, reportPath, logopath, null); //P.SendSettlementInstitutionNotification("12-MAY-2017", ""); //var cbn_code = "011"; //var prefixM = string.Concat("2", cbn_code, "LA"); ; //var lastMidGen = ""; //var recM = _repo.GetLastMidTidGenerated(prefixM, cbn_code, "M"); //if(recM != null) //{ // lastMidGen = recM.MERCHANTID; //} //var mid = MidTidGenerator.GenMid(prefixM, "2011LAAAAAAAAA9"); //Console.WriteLine("Start processing.........."); //LogFunction lgfn = new LogFunction(); //lgfn.loginfo("", null, DateTime.Now.ToString()); ////var D = new EmailProcess(); ////D.SendMerchantarteeSettlementEmail("24-MAY-2017", ""); //var output = @"C:\POS_AUTOMATION\SETTLEMENT_DETAIL_SETT_28-Jul-2017\ACCESS BANK NIGERIA PLC\ACQUIRER\NAIRA SETTLEMENT\ACCESS BANK NIGERIA PLC_ACQUIRER.xlsx"; //var ext = Path.GetExtension(output); //var fileNameNew = string.Concat(Path.GetFileNameWithoutExtension(output), "_", DateTime.Now.ToString("dd-MM-yyyy"), Path.GetExtension(output)); //var dest = @"C:\FTP_Path\UBA"; //if (File.Exists(output) && Directory.Exists(dest)) //{ // LogFunction2.WriteMaintenaceLogToFile("Directory exist for both source and destination path"); // // copy file to ftp path // File.Copy(output, Path.Combine(dest, fileNameNew)); // LogFunction2.WriteMaintenaceLogToFile("File Copied Successfully"); //} Console.WriteLine("enter a report type.........."); Console.WriteLine("1. SETTLEMENT MASTER REPORTS"); Console.WriteLine("2. NIBSS SETTLEMENT REPORTS"); Console.WriteLine("3. ACQUIRERE/ISSUER/MDB REPORTS"); Console.WriteLine("4. MERCHANT REPORTS"); Console.WriteLine("5. PTSP/PTSA/TERW/SWTH REPORTS"); Console.WriteLine("6. ARTEE MERCHANT REPORTS"); Console.WriteLine("7. VIP MERCHANT REPORT"); Console.WriteLine("8. COLLECTION REPORT"); Console.WriteLine("9. UPHSS REPORT"); Console.WriteLine("10. UPHSS REPORT CONSOLIDATED"); string opt = Console.ReadLine(); //GenHSSReportConsolidated Console.WriteLine("Select Date type.........."); Console.WriteLine("1. By Single Day"); Console.WriteLine("2. By Date Range"); string optdatetype = Console.ReadLine(); int noofdays = 0; string dtFrom = ""; if (optdatetype == "2") { Console.WriteLine("enter a report Start date.........."); string fromdt = Console.ReadLine(); Console.WriteLine("enter a report End date.........."); string todt = Console.ReadLine(); dtFrom = fromdt; noofdays = (Convert.ToDateTime(todt) - Convert.ToDateTime(fromdt)).Days; Console.WriteLine("Starting From" + dtFrom); for (int i = 0; i < noofdays; i++) { DateTime dtFromDate = Convert.ToDateTime(dtFrom); ////IDapperSettlementReport _repoSETT = new DapperSettlementReport(); ////bool sett = _repoSETT.GenSettlementFileSETT_EEPLUS(dtFromDate, null, reportPath, logopath, null); //IMainReport _repoSETT = new MainReport(); // _repoSETT.TestExport(); if (opt == "1") { Console.WriteLine("processing........SETTLEMENT MASTER REPORT" + dtFrom); string sett = _repoSETT.RPT_GenSettlementMASTER(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "2") { Console.WriteLine("processing.........NIBSS Settlement Report" + dtFrom); //string sett = _repoSETT.RPT_GenSettlementFile2(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "3") { Console.WriteLine("processing.........ACQUIRER/ISSUER/MDB REPORT" + dtFrom); //string sett = _repoSETT.RPT_GenSettlementFile(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "4") { Console.WriteLine("processing..........Merchant Reports" + dtFrom); //string sett = _repoSETT.RPT_GenMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "6") { Console.WriteLine("processing..........ARTEE Merchant Reports" + dtFrom); //string sett = _repoSETT.RPT_GenARTEEMerchant(DateTime.Parse(dtFrom), reportPath, logopath, null); //var P = new EmailProcess(); //P.SendMerchantarteeSettlementEmail(dtFrom, ""); } if (opt == "7") { Console.WriteLine("processing..........VIP Merchant Reports" + dtFrom); // string sett = _repoSETT.RPT_GenVIPMerchant(DateTime.Parse(dtFrom), reportPath, logopath, null); // var P = new EmailProcess(); //P.SendMerchantVIPSettlementEmail(dtFrom, ""); } if (opt == "8") { Console.WriteLine("processing..........Collection Merchant Reports" + dtFrom); // string sett = _repoSETT.RPT_CollectionGenMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); // var P = new EmailProcess(); // P.SendMerchantVIPSettlementEmail(dtFrom, ""); } ////if (opt == "5") ////{ //// Console.WriteLine("processing..........Merchant Report By Merchant Deposit Bank" + dtFrom); //// string sett = _repoSETT.RPT_GenMDBMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); ////} if (opt == "5") { Console.WriteLine("processing..........Party Report (PTSP/PTSA/TERW/SWTH)" + dtFrom); //string sett = _repoSETT.RPT_Settlement(DateTime.Parse(dtFrom), reportPath, logopath, null); } Console.WriteLine("processing Completed For " + dtFrom); dtFrom = Convert.ToDateTime(dtFrom).AddDays(1).ToString(); } Console.WriteLine("processing Completed"); } else { Console.WriteLine("enter a report processing date.........."); dtFrom = Console.ReadLine(); Console.WriteLine(dtFrom); //DateTime dtFromDate =DateTime.Parse(dtFrom); //DateTime dtFromDate = DateTime.ParseExact(dtFrom, "dd/MM/yyyy", null); //Console.WriteLine("enter a report type.........."); //Console.WriteLine("1. SETTLEMENT MASTER REPORTS"); //Console.WriteLine("2. NIBSS SETTLEMENT REPORTS"); //Console.WriteLine("3. ACQUIRERE/ISSUER/MDB REPORTS"); //Console.WriteLine("4. MERCHANT REPORTS"); //Console.WriteLine("5. PTSP/PTSA/TERW/SWTH REPORTS"); //Console.WriteLine("6. ARTEE MERCHANT REPORTS"); //Console.WriteLine("7. VIP MERCHANT REPORT"); //Console.WriteLine("8. COLLECTION REPORT"); // opt = Console.ReadLine(); Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB"); //dd/MM/yyyy if (opt == "1") { Console.WriteLine("processing........SETTLEMENT MASTER REPORT" + dtFrom); string sett = _repoSETT.RPT_GenSettlementMASTER(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "2") { //Console.WriteLine("processing.........NIBSS Settlement Report" + dtFrom); string sett = _repoSETT.RPT_NIBSS(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "3") { Console.WriteLine("processing.........ACQUIRERE/ISSUER/MDB REPORT" + dtFrom); string sett = _repoSETT.RPT_ACQUIREREISSMDB(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "4") { Console.WriteLine("processing..........Merchant Reports" + dtFrom); // string sett = _repoSETT.RPT_GenMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "6") { Console.WriteLine("processing..........ARTEE Merchant Reports" + dtFrom); //string sett = _repoSETT.RPT_GenARTEEMerchant(DateTime.Parse(dtFrom), reportPath, logopath, null); //var P = new EmailProcess(); //P.SendMerchantarteeSettlementEmail(dtFrom, ""); } if (opt == "7") { Console.WriteLine("processing..........VIP Merchant Reports" + dtFrom); //string sett = _repoSETT.RPT_GenVIPMerchant(DateTime.Parse(dtFrom), reportPath, logopath, null); //var P = new EmailProcess(); //P.SendMerchantVIPSettlementEmail(dtFrom, ""); } if (opt == "8") { Console.WriteLine("processing..........Collection Merchant Reports" + dtFrom); //string sett = _repoSETT.RPT_CollectionGenMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); // var P = new EmailProcess(); // P.SendMerchantVIPSettlementEmail(dtFrom, ""); } ////if (opt == "5") ////{ //// Console.WriteLine("processing..........Merchant Report By Merchant Deposit Bank" + dtFrom); //// string sett = _repoSETT.RPT_GenMDBMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); ////} if (opt == "5") { Console.WriteLine("processing..........Party Report (PTSP/PTSA/TERW/SWTH)" + dtFrom); //string sett = _repoSETT.RPT_Settlement(DateTime.Parse(dtFrom), reportPath, logopath, null); } if (opt == "9") { //string[] sessions = { "2018021916" }; Console.WriteLine("Enter Session ID: "); string sessionID = Console.ReadLine(); //foreach (string sessionID in sessions) //{ Console.WriteLine("processing..........UPHSS REPORT " + dtFrom + " SESSION: " + sessionID); //string sett = _repoSETT.RPT_GenHSSReport(DateTime.Parse(dtFrom), reportPath, logopath, null, sessionID); // } } if (opt == "10") { //string[] sessions = { "2018021916" }; // Console.WriteLine("Enter Session ID: "); // string sessionID = Console.ReadLine(); //foreach (string sessionID in sessions) //{ Console.WriteLine("processing..........UPHSS REPORT cosolidated "); //string sett = _repoSETT.GenHSSReportConsolidated(DateTime.Parse(dtFrom), reportPath, logopath, null); // } } Console.WriteLine("processing Completed"); } }
private void SchedularCallback(object e) { try { DateTime dtFromA; LogFunction2.WriteMaintenaceLogToFile("Start processing.........."); var conDate = ConfigurationManager.AppSettings["SettlementDate"].ToUpper(); var dtFrom = ""; if (DateTime.TryParse(conDate, out dtFromA)) { dtFrom = dtFromA.ToString("dd-MMM-yyyy"); } else { dtFrom = DateTime.Now.ToString("dd-MMM-yyyy"); } LogFunction2.WriteMaintenaceLogToFile("enter a report processing date.........."); // string dtFrom = Console.ReadLine(); LogFunction2.WriteMaintenaceLogToFile(dtFrom); DateTime dtFromDate = Convert.ToDateTime(dtFrom); ////IDapperSettlementReport _repoSETT = new DapperSettlementReport(); ////bool sett = _repoSETT.GenSettlementFileSETT_EEPLUS(dtFromDate, null, reportPath, logopath, null); //LogFunction2.WriteMaintenaceLogToFile("enter a report type.........."); //LogFunction2.WriteMaintenaceLogToFile("1. SETTLEMENT MASTER REPORTS"); //LogFunction2.WriteMaintenaceLogToFile("2. NIBSS SETTLEMENT REPORTS"); //LogFunction2.WriteMaintenaceLogToFile("3. ACQUIRERE/ISSUER/MDB REPORTS"); //LogFunction2.WriteMaintenaceLogToFile("4. MERCHANT REPORTS"); //LogFunction2.WriteMaintenaceLogToFile("5. PTSP/PTSA/TERW/SWTH REPORTS"); //string opt = Console.ReadLine(); IMainReport _repoSETT = new MainReport(); //var P = new EmailProcess(); //string emailSubject = string.Format("SETTLEMENT REPORT FOR {0} ", dtFromDate.ToString("dd-MMM-yyyy")); try { LogFunction2.WriteMaintenaceLogToFile("processing........SETTLEMENT MASTER REPORT" + dtFrom); //LogFunction2.WriteMaintenaceLogToFile("processing........Settlement Date--" + dtFromDate); // LogFunction2.WriteMaintenaceLogToFile("processing........Settlement Report Path--" + reportPath); //LogFunction2.WriteMaintenaceLogToFile("processing........Settlement Logo Path--" + logopath); string sett = _repoSETT.RPT_GenSettlementMASTER(dtFromDate, reportPath, logopath, null); try { //SEND EMAIL HERE // P.SendSettlementMasterNotification(dtFrom, string.Concat(emailSubject, ":SETTLEMENT MASTER REPORT")); } catch (Exception ex) { LogFunction2.WriteMaintenaceLogToFile("Maintenance Settlement Email Service Error on: {0} " + ex.Message + ex.StackTrace); } LogFunction2.WriteMaintenaceLogToFile("completed........SETTLEMENT MASTER REPORT: {0}" + dtFrom); } catch (Exception ex) { LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); } //try //{ // LogFunction2.WriteMaintenaceLogToFile("processing..........Merchant Reports" + dtFrom); // string sett = _repoSETT.RPT_GenARTEEMerchant(dtFromDate, reportPath, logopath, null); // try // { // LogFunction2.WriteMaintenaceLogToFile("completed..........Merchant Reports" + dtFrom); // P.SendMerchantarteeSettlementEmail(dtFrom, ""); // } // catch // { // } //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); //} //try //{ // LogFunction2.WriteMaintenaceLogToFile("processing.........NIBSS Settlement Report" + dtFrom); // string sett = _repoSETT.RPT_GenSettlementFile2(dtFromDate, reportPath, logopath, null); // try // { // P.SendSettlementMasterNotification(dtFrom, string.Concat(emailSubject, ":NIBSS REPORT")); // } // catch (Exception ex) // { // LogFunction2.WriteMaintenaceLogToFile("Maintenance Nibss Email Service Error on: {0} " + ex.Message + ex.StackTrace); // } // LogFunction2.WriteMaintenaceLogToFile("completed.........NIBSS Settlement Report" + dtFrom); //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); //} //try //{ // LogFunction2.WriteMaintenaceLogToFile("processing.........ACQUIRER/ISSUER/MDB REPORT" + dtFrom); // string sett = _repoSETT.RPT_GenSettlementFile(dtFromDate, reportPath, logopath, null); // //SEND EMAIL HERE // //P.SendSettlementInstitutionNotification("12-MAY-2017", ""); // LogFunction2.WriteMaintenaceLogToFile("completed.........ACQUIRER/ISSUER/MDB REPORT" + dtFrom); //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); //} //try //{ // LogFunction2.WriteMaintenaceLogToFile("processing..........Party Report (PTSP/PTSA/TERW/SWTH)" + dtFrom); // string sett = _repoSETT.RPT_Settlement(dtFromDate, reportPath, logopath, null); // LogFunction2.WriteMaintenaceLogToFile("completed..........Party Report (PTSP/PTSA/TERW/SWTH)" + dtFrom); //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); //} //try //{ // LogFunction2.WriteMaintenaceLogToFile("processing..........Merchant Reports" + dtFrom); // string sett = _repoSETT.RPT_GenMerchants(dtFromDate, reportPath, logopath, null); // LogFunction2.WriteMaintenaceLogToFile("completed..........Merchant Reports" + dtFrom); //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); //} //try //{ // LogFunction2.WriteMaintenaceLogToFile("processing..........Merchant Reports" + dtFrom); // string sett = _repoSETT.RPT_GenMerchants(dtFromDate, reportPath, logopath, null); // LogFunction2.WriteMaintenaceLogToFile("completed..........Merchant Reports" + dtFrom); //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); //} ////if (opt == "5") ////{ //// LogFunction2.WriteMaintenaceLogToFile("processing..........Merchant Report By Merchant Deposit Bank" + dtFrom); //// string sett = _repoSETT.RPT_GenMDBMerchants(DateTime.Parse(dtFrom), reportPath, logopath, null); ////} LogFunction2.WriteMaintenaceLogToFile("processing Completed"); } catch (Exception ex) { LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); } //try //{ // var pDays = ConfigurationManager.AppSettings["purgedays"].ToUpper(); // int purgeDays = 0; // if (int.TryParse(pDays, out purgeDays)) // { // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Log: {0}"); // var gen = new Maintenance(); // gen.Purge(purgeDays); // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Completed Log: {0}"); // } // this.ScheduleService(); //} //catch (Exception ex) //{ // LogFunction2.WriteMaintenaceLogToFile("Maintenance Service Error on: {0} " + ex.Message + ex.StackTrace); // //Stop the Windows Service. // //using (System.ServiceProcess.ServiceController serviceController = new System.ServiceProcess.ServiceController("SimpleService")) // //{ // // serviceController.Stop(); // //} //} }