public void CreateAndTransferFile(int BranchID, string TerminalNo, DateTime pvtDateInitialized) { DateTime dteDateToprocess = pvtDateInitialized; Event clsEvent = new Event(); try { clsEvent.AddEventLn("Starting Ayala FILE CREATOR.", true); clsEvent.AddEventLn("==================================================", true); clsEvent.AddEventLn("= Ayala FILE CREATOR =", true); clsEvent.AddEventLn("==================================================", true); /*********************************************************************** * Check the destination dir if existing. * ********************************************************************/ clsEvent.AddEventLn("Checking directory settings.", true); string dir = mclsAyalaDetails.OutputDirectory; dir = dir.Replace("{YYYY}", DateTime.Now.ToString("yyyy")); dir = dir.Replace("{MM}", DateTime.Now.ToString("MM")); dir = dir.Replace("{MMM}", DateTime.Now.ToString("MMM")); dir = dir.Replace("{MMMM}", DateTime.Now.ToString("MMMM")); if (!System.IO.Directory.Exists(dir)) { clsEvent.AddEventLn("Directory [" + dir + "] does not exist.", true); System.IO.Directory.CreateDirectory(dir); } else { clsEvent.AddEventLn("Directory [" + dir + "] exist.", true); } mclsAyalaDetails.OutputDirectory = dir; /*********************************************************************** * GET The report of Current Terminal using Specified InitializationDate * ********************************************************************/ Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(); Data.TerminalReportDetails clsTerminalReportDetail = clsTerminalReportHistory.Details(BranchID, TerminalNo, dteDateToprocess); string stDailyTableName = CreateDailySales(dteDateToprocess, clsTerminalReportDetail); string stHourlyTableName = CreateHourlySales(BranchID, TerminalNo, dteDateToprocess); clsTerminalReportHistory.UpdateTerminalReportBatchCounter(TerminalNo, dteDateToprocess); clsTerminalReportHistory.CommitAndDispose(); clsEvent.AddEventLn("Record for [" + dteDateToprocess.ToString("yyyy-MM-dd HH:mm:ss") + "] BacthCounter:" + clsTerminalReportDetail.BatchCounter.ToString() + " has been created for Ayala.", true); TransferFile(stDailyTableName); TransferFile(stHourlyTableName); } catch (Exception ex) { clsEvent.AddErrorEventLn(ex); throw ex; } clsEvent.AddEventLn("Ayala FILE CREATOR exited.", true); }
public void CreateAndTransferFile(int BranchID, string TerminalNo, DateTime pvtDateInitialized) { DateTime dteDateToprocess = pvtDateInitialized; Event clsEvent = new Event(); try { clsEvent.AddEventLn("Starting Ayala FILE CREATOR.", true); clsEvent.AddEventLn("==================================================", true); clsEvent.AddEventLn("= Ayala FILE CREATOR =", true); clsEvent.AddEventLn("==================================================", true); /*********************************************************************** * Check the destination dir if existing. * ********************************************************************/ clsEvent.AddEventLn("Checking directory settings.", true); string dir = mclsAyalaDetails.OutputDirectory; dir = dir.Replace("{YYYY}", DateTime.Now.ToString("yyyy")); dir = dir.Replace("{MM}", DateTime.Now.ToString("MM")); dir = dir.Replace("{MMM}", DateTime.Now.ToString("MMM")); dir = dir.Replace("{MMMM}", DateTime.Now.ToString("MMMM")); if (!System.IO.Directory.Exists(dir)) { clsEvent.AddEventLn("Directory [" + dir + "] does not exist.", true); System.IO.Directory.CreateDirectory(dir); } else { clsEvent.AddEventLn("Directory [" + dir + "] exist.", true); } mclsAyalaDetails.OutputDirectory = dir; /*********************************************************************** * GET The report of Current Terminal using Specified InitializationDate * ********************************************************************/ Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(); Data.TerminalReportDetails clsTerminalReportDetail = clsTerminalReportHistory.Details(BranchID, TerminalNo, dteDateToprocess); string stDailyTableName = CreateDailySales(dteDateToprocess, clsTerminalReportDetail); string stHourlyTableName = CreateHourlySales(BranchID, TerminalNo, dteDateToprocess); clsTerminalReportHistory.UpdateTerminalReportBatchCounter(TerminalNo, dteDateToprocess); clsTerminalReportHistory.CommitAndDispose(); clsEvent.AddEventLn("Record for [" + dteDateToprocess.ToString("yyyy-MM-dd HH:mm:ss") + "] BacthCounter:" + clsTerminalReportDetail.BatchCounter.ToString() + " has been created for Ayala.", true); TransferFile(stDailyTableName); TransferFile(stHourlyTableName); } catch (Exception ex) { clsEvent.AddErrorEventLn(ex); throw ex; } clsEvent.AddEventLn("Ayala FILE CREATOR exited.", true); }
public void ReprintZRead() { DialogResult result = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessTypes.ReprintZRead); if (result == DialogResult.None) { LogInWnd login = new LogInWnd(); login.AccessType = AccessTypes.PrintZRead; login.Header = "Re-Print ZREAD Report"; login.TerminalDetails = mclsTerminalDetails; login.ShowDialog(this); result = login.Result; login.Close(); login.Dispose(); } if (result == DialogResult.OK) { bool boWithTF = true; TerminalHistoryDateWnd clsTerminalHistoryDateWnd = new TerminalHistoryDateWnd(); clsTerminalHistoryDateWnd.TerminalDetails = mclsTerminalDetails; clsTerminalHistoryDateWnd.WithTF = boWithTF; clsTerminalHistoryDateWnd.ShowDialog(this); DialogResult clsTerminalHistoryDateWndresult = clsTerminalHistoryDateWnd.Result; DateTime dtDateLastInitialized = clsTerminalHistoryDateWnd.DateLastInitialized; Keys keyCommand = clsTerminalHistoryDateWnd.keyCommand; clsTerminalHistoryDateWnd.Close(); clsTerminalHistoryDateWnd.Dispose(); if (clsTerminalHistoryDateWndresult == System.Windows.Forms.DialogResult.OK) { Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(mConnection, mTransaction); mConnection = clsTerminalReportHistory.Connection; mTransaction = clsTerminalReportHistory.Transaction; if (keyCommand == Keys.F12) //override boWithTF, so that it will get the actual if it is an F12 { boWithTF = false; } // get the details, boWithTF will determine if it will be selected from esales or from actual Data.TerminalReportDetails Details = clsTerminalReportHistory.Details(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, dtDateLastInitialized, boWithTF); clsTerminalReportHistory.CommitAndDispose(); decimal OldTrustFund = mclsTerminalDetails.TrustFund; if (keyCommand == Keys.F12) //override even if boWithTF=true { mclsTerminalDetails.TrustFund = 0; Details.TrustFund = 0; } else { mclsTerminalDetails.TrustFund = Details.TrustFund; } AceSoft.Common.SYSTEMTIME st = new AceSoft.Common.SYSTEMTIME(); // set the sytem date to NextDetails DateLastInitialized st = AceSoft.Common.ConvertToSystemTime(Details.DateLastInitialized.AddSeconds(-2).ToUniversalTime()); mdtCurrentDateTime = DateTime.Now; tmr.Enabled = true; tmr.Start(); AceSoft.Common.SetSystemTime(ref st); TerminalReportWnd clsTerminalReportWnd = new TerminalReportWnd(); clsTerminalReportWnd.SysConfigDetails = mclsSysConfigDetails; clsTerminalReportWnd.TerminalDetails = mclsTerminalDetails; clsTerminalReportWnd.Details = Details; clsTerminalReportWnd.CashierName = mCashierName; clsTerminalReportWnd.TerminalReportType = TerminalReportType.ZRead; clsTerminalReportWnd.ShowDialog(this); result = clsTerminalReportWnd.Result; clsTerminalReportWnd.Close(); clsTerminalReportWnd.Dispose(); if (result == DialogResult.OK) { //PrintZReadDelegate printzreadDel = new PrintZReadDelegate(PrintZRead); //printzreadDel.BeginInvoke(Details, null, null); RePrintZRead(Details); InsertAuditLog(AccessTypes.ReprintZRead, "Re-Print ZRead report: TerminalNo=" + mclsTerminalDetails.TerminalNo + " DateLastInitialized=" + dtDateLastInitialized.ToString("yyyy-MM-dd hh:mm") + " @ Branch: " + mclsTerminalDetails.BranchDetails.BranchCode); } // set the sytem date to NextDetails DateLastInitialized st = AceSoft.Common.ConvertToSystemTime(mdtCurrentDateTime.ToUniversalTime()); AceSoft.Common.SetSystemTime(ref st); tmr.Stop(); tmr.Enabled = false; mclsTerminalDetails.TrustFund = OldTrustFund; } } }
public bool CreateAndTransferFile(Int32 BranchID, string TerminalNo, DateTime pvtDateInitialized) { bool bolRetValue = false; DateTime dteDateToprocess = pvtDateInitialized; Event clsEvent = new Event(); try { clsEvent.AddEventLn("Starting RLC FILE CREATOR.", true); clsEvent.AddEventLn("==================================================", true); clsEvent.AddEventLn("= RLC FILE CREATOR =", true); clsEvent.AddEventLn("==================================================", true); /*********************************************************************** * Check the destination dir if existing. * ********************************************************************/ clsEvent.AddEventLn("Checking directory settings.", true); string dir = mclsRLCDetails.OutputDirectory; dir = dir.Replace("{YYYY}", DateTime.Now.ToString("yyyy")); dir = dir.Replace("{MM}", DateTime.Now.ToString("MM")); dir = dir.Replace("{MMM}", DateTime.Now.ToString("MMM")); dir = dir.Replace("{MMMM}", DateTime.Now.ToString("MMMM")); if (!System.IO.Directory.Exists(dir)) { clsEvent.AddEventLn("Directory [" + dir + "] does not exist.", true); System.IO.Directory.CreateDirectory(dir); } else { clsEvent.AddEventLn("Directory [" + dir + "] exist.", true); } mclsRLCDetails.OutputDirectory = dir; /*********************************************************************** * GET The report of Current Terminal using Specified InitializationDate * ********************************************************************/ Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(); Data.TerminalReportDetails clsTerminalReportDetail = clsTerminalReportHistory.Details(BranchID, TerminalNo, dteDateToprocess); Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsTerminalReportHistory.Connection, clsTerminalReportHistory.Transaction); long lngSeniorCitizenDiscountCount = 0; decimal decSeniorCitizenDiscount = clsSalesTransactions.SeniorCitizenDiscounts(clsTerminalReportDetail.BranchID, clsTerminalReportDetail.TerminalNo, clsTerminalReportDetail.BeginningTransactionNo, clsTerminalReportDetail.EndingTransactionNo, out lngSeniorCitizenDiscountCount); long lngPWDDiscountCount = 0; decimal decPWDDiscount = clsSalesTransactions.PersonWithDisabilityDiscounts(clsTerminalReportDetail.BranchID, clsTerminalReportDetail.TerminalNo, clsTerminalReportDetail.BeginningTransactionNo, clsTerminalReportDetail.EndingTransactionNo, out lngPWDDiscountCount); string stDailyTableName = CreateDailySales(dteDateToprocess, clsTerminalReportDetail, decSeniorCitizenDiscount, lngSeniorCitizenDiscountCount, decPWDDiscount, lngPWDDiscountCount); clsTerminalReportHistory.CommitAndDispose(); bool bolTransferFile = TransferFile(stDailyTableName); if (bolTransferFile) { clsTerminalReportHistory = new Data.TerminalReportHistory(); clsTerminalReportHistory.UpdateTerminalReportBatchCounter(clsTerminalReportDetail.TerminalNo, dteDateToprocess); clsTerminalReportHistory.UpdateTerminalReportIsMallFileUploadComplete(clsTerminalReportDetail.TerminalNo, dteDateToprocess, true); if (clsTerminalReportDetail.BatchCounter == 1) { clsTerminalReportHistory.UpdateTerminalReportMallForwarderFileName(clsTerminalReportDetail.TerminalNo, dteDateToprocess, stDailyTableName); } clsTerminalReportHistory.CommitAndDispose(); bolRetValue = true; } clsEvent.AddEventLn("Record for [" + dteDateToprocess.ToString("yyyy-MM-dd HH:mm:ss") + "] BacthCounter:" + clsTerminalReportDetail.BatchCounter.ToString() + " has been created for RLC.", true); } catch (Exception ex) { clsEvent.AddErrorEventLn(ex); throw ex; } clsEvent.AddEventLn("RLC FILE CREATOR exited.", true); return(bolRetValue); }
public bool CreateAndTransferFile(Int32 BranchID, string TerminalNo, DateTime pvtDateInitialized) { bool bolRetValue = false; DateTime dteDateToprocess = pvtDateInitialized; Event clsEvent = new Event(); try { clsEvent.AddEventLn("Starting RLC FILE CREATOR.", true); clsEvent.AddEventLn("==================================================", true); clsEvent.AddEventLn("= RLC FILE CREATOR =", true); clsEvent.AddEventLn("==================================================", true); /*********************************************************************** * Check the destination dir if existing. * ********************************************************************/ clsEvent.AddEventLn("Checking directory settings.", true); string dir = mclsRLCDetails.OutputDirectory; dir = dir.Replace("{YYYY}", DateTime.Now.ToString("yyyy")); dir = dir.Replace("{MM}", DateTime.Now.ToString("MM")); dir = dir.Replace("{MMM}", DateTime.Now.ToString("MMM")); dir = dir.Replace("{MMMM}", DateTime.Now.ToString("MMMM")); if (!System.IO.Directory.Exists(dir)) { clsEvent.AddEventLn("Directory [" + dir + "] does not exist.", true); System.IO.Directory.CreateDirectory(dir); } else { clsEvent.AddEventLn("Directory [" + dir + "] exist.", true); } mclsRLCDetails.OutputDirectory = dir; /*********************************************************************** * GET The report of Current Terminal using Specified InitializationDate * ********************************************************************/ Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(); Data.TerminalReportDetails clsTerminalReportDetail = clsTerminalReportHistory.Details(BranchID, TerminalNo, dteDateToprocess); Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsTerminalReportHistory.Connection, clsTerminalReportHistory.Transaction); long lngSeniorCitizenDiscountCount = 0; decimal decSeniorCitizenDiscount = clsSalesTransactions.SeniorCitizenDiscounts(clsTerminalReportDetail.BranchID, clsTerminalReportDetail.TerminalNo, clsTerminalReportDetail.BeginningTransactionNo, clsTerminalReportDetail.EndingTransactionNo, out lngSeniorCitizenDiscountCount); long lngPWDDiscountCount = 0; decimal decPWDDiscount = clsSalesTransactions.PersonWithDisabilityDiscounts(clsTerminalReportDetail.BranchID, clsTerminalReportDetail.TerminalNo, clsTerminalReportDetail.BeginningTransactionNo, clsTerminalReportDetail.EndingTransactionNo, out lngPWDDiscountCount); string stDailyTableName = CreateDailySales(dteDateToprocess, clsTerminalReportDetail, decSeniorCitizenDiscount, lngSeniorCitizenDiscountCount, decPWDDiscount, lngPWDDiscountCount); clsTerminalReportHistory.CommitAndDispose(); bool bolTransferFile = TransferFile(stDailyTableName); if (bolTransferFile ) { clsTerminalReportHistory = new Data.TerminalReportHistory(); clsTerminalReportHistory.UpdateTerminalReportBatchCounter(clsTerminalReportDetail.TerminalNo, dteDateToprocess); clsTerminalReportHistory.UpdateTerminalReportIsMallFileUploadComplete(clsTerminalReportDetail.TerminalNo, dteDateToprocess, true); if (clsTerminalReportDetail.BatchCounter == 1) clsTerminalReportHistory.UpdateTerminalReportMallForwarderFileName(clsTerminalReportDetail.TerminalNo, dteDateToprocess, stDailyTableName); clsTerminalReportHistory.CommitAndDispose(); bolRetValue = true; } clsEvent.AddEventLn("Record for [" + dteDateToprocess.ToString("yyyy-MM-dd HH:mm:ss") + "] BacthCounter:" + clsTerminalReportDetail.BatchCounter.ToString() + " has been created for RLC.", true); } catch (Exception ex) { clsEvent.AddErrorEventLn(ex); throw ex; } clsEvent.AddEventLn("RLC FILE CREATOR exited.", true); return bolRetValue; }