public void InitializeAllZreadWithSameORSeries(bool boWithOutTF)
{
try
{
Cursor.Current = Cursors.WaitCursor;
Data.Terminal clsTerminal = new Data.Terminal(mConnection, mTransaction);
mConnection = clsTerminal.Connection; mTransaction = clsTerminal.Transaction;
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(mConnection, mTransaction);
mConnection = clsTerminalReport.Connection; mTransaction = clsTerminalReport.Transaction;
AccessUser clsUser = new AccessUser(mConnection, mTransaction);
mConnection = clsUser.Connection; mTransaction = clsUser.Transaction;
System.Data.DataTable dt = clsTerminal.ListORSeries(mclsTerminalDetails.ORSeriesTerminalNo);
foreach (System.Data.DataRow dr in dt.Rows)
{
Int32 iBranchID = Int32.Parse(dr["BranchID"].ToString());
string stTerminalNo = dr["TerminalNo"].ToString();
clsEvent.AddEventLn("Getting Terminal Info BranchID: " + iBranchID.ToString() + " Terminalno:" + stTerminalNo, true);
mclsTerminalDetails = clsTerminal.Details(iBranchID, stTerminalNo);
mclsSalesTransactionDetails.CashierID = clsTerminal.getLastLoggedCashierID(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
if (mclsSalesTransactionDetails.CashierID == 0)
mclsSalesTransactionDetails.CashierID = Convert.ToInt64(lblCashier.Tag);
AccessUserDetails details = clsUser.Details(mclsSalesTransactionDetails.CashierID);
mclsSalesTransactionDetails.CashierName = details.Name;
if (IsDateLastInitializationOK(false))
{
try
{
clsEvent.AddEvent("[" + lblCashier.Text + "] Initializing ZReading.", true);
PrintZRead(false);
// Dec 01, 2008 Lemuel E. Aceron
// added the IsCashCountInitialized for
// 1 time Cash count every printing of report.
clsTerminal.UpdateIsCashCountInitialized(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo, mclsSalesTransactionDetails.CashierID, false);
//initialize Z-Read
clsTerminalReport.InitializeZRead(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo, mclsSalesTransactionDetails.CashierName, Constants.C_DATE_MIN_VALUE, boWithOutTF);
InsertAuditLog(AccessTypes.InitializeZRead, "Initialize Z-Read." + " [Branch]:" + mclsTerminalDetails.BranchDetails.BranchCode + " [TerminalNo]" + mclsTerminalDetails.TerminalNo);
DateTime dteMAXDateLastInitialized = DateTime.MinValue;
// May 21, 2009 Lemuel E. Aceron
// added the for auto FTP of file for RLC
// get the maxdatelastinitialized
if (CONFIG.MallCode.ToUpper() == MallCodes.RLC)
{
Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(mConnection, mTransaction);
mConnection = clsTerminalReportHistory.Connection; mTransaction = clsTerminalReportHistory.Transaction;
dteMAXDateLastInitialized = clsTerminalReportHistory.MINDateLastInitialized(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo, DateTime.Now);
}
clsEvent.AddEventLn("Done!", true);
MessageBox.Show("Z-Read has been initialized for [Branch]:" + mclsTerminalDetails.BranchDetails.BranchCode + " [TerminalNo]" + mclsTerminalDetails.TerminalNo + "...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
// May 21, 2009 Lemuel E. Aceron
// added the for auto FTP of file for RLC
// send the data to RLC
if (CONFIG.MallCode.ToUpper() == MallCodes.RLC)
ProcessMallForwarder(dteMAXDateLastInitialized, true);
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERRROR!!! Initializing ZREAD for [Branch]:" + mclsTerminalDetails.BranchDetails.BranchCode + " [TerminalNo]" + mclsTerminalDetails.TerminalNo);
}
}
}
clsTerminal.CommitAndDispose();
Cursor.Current = Cursors.Default;
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERRROR!!! Initializing ALL ZREAD [ORSeriesBranchID]:" + mclsTerminalDetails.ORSeriesBranchID.ToString() + " [ORSeriesTerminalNo]" + mclsTerminalDetails.ORSeriesTerminalNo);
}
// 23Mar2015 : Needed to do this
mclsSalesTransactionDetails.CashierID = Convert.ToInt64(lblCashier.Tag);
mclsSalesTransactionDetails.CashierName = lblCashier.Text;
}
private bool IsStartCutOffTimeOK()
{
bool bolRetValue = false;
bool bolMessageBoxShown = false;
try
{
// check if with Cutofftime
if (mclsTerminalDetails.CheckCutOffTime)
{
clsEvent.AddEventLn("Checking StartCutOffTime vs MAXDateLastInitialized...", true);
Data.TerminalReportDetails clsTerminalReportDetails;
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(mConnection, mTransaction);
mConnection = clsTerminalReport.Connection; mTransaction = clsTerminalReport.Transaction;
DateTime dteTransactionDate = Convert.ToDateTime(lblTransDate.Text);
DateTime dteMAXDateLastInitialized = clsTerminalReport.MAXDateLastInitialized(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, Constants.C_DATE_MIN_VALUE);
DateTime dteStartCutOffTime = Convert.ToDateTime(Convert.ToDateTime(lblTransDate.Text).ToString("yyyy-MM-dd") + " " + mclsTerminalDetails.StartCutOffTime);
DateTime dteEndCutOffTime = Convert.ToDateTime(Convert.ToDateTime(lblTransDate.Text).ToString("yyyy-MM-dd") + " " + mclsTerminalDetails.EndCutOffTime);
// if StartCutOffTime is greater than EndCutOffTime
// this means that EndCutOffTime is in the morning.
// Add 1 more day.
if (dteStartCutOffTime >= dteEndCutOffTime)
dteEndCutOffTime = dteEndCutOffTime.AddDays(1);
DateTime dteAllowedStartDateTime; DateTime dteAllowedEndDateTime;
if (dteTransactionDate < dteEndCutOffTime)
{
dteAllowedStartDateTime = Convert.ToDateTime(Convert.ToDateTime(lblTransDate.Text).ToString("yyyy-MM-dd") + " " + mclsTerminalDetails.EndCutOffTime).AddDays(-1).AddMilliseconds(1);
dteAllowedEndDateTime = Convert.ToDateTime(Convert.ToDateTime(lblTransDate.Text).ToString("yyyy-MM-dd") + " " + mclsTerminalDetails.StartCutOffTime);
}
else
{
dteAllowedStartDateTime = Convert.ToDateTime(Convert.ToDateTime(lblTransDate.Text).ToString("yyyy-MM-dd") + " " + mclsTerminalDetails.EndCutOffTime).AddMilliseconds(1);
dteAllowedEndDateTime = Convert.ToDateTime(Convert.ToDateTime(lblTransDate.Text).ToString("yyyy-MM-dd") + " " + mclsTerminalDetails.StartCutOffTime).AddDays(1);
}
if (dteTransactionDate < dteAllowedEndDateTime)
{
dteStartCutOffTime = dteStartCutOffTime.AddDays(1);
dteEndCutOffTime = dteEndCutOffTime.AddDays(1);
}
DateTime dtePreviousStartCutOffTime = dteStartCutOffTime.AddDays(-1);
DateTime dtePreviousEndCutOffTime = dteEndCutOffTime.AddDays(-1);
DateTime dtePreviousAllowedStartDateTime = dteAllowedStartDateTime.AddDays(-1);
DateTime dtePreviousAllowedEndDateTime = dteAllowedEndDateTime.AddDays(-1);
Back:
clsEvent.AddEventLn("PreviousStartCutOff : " + dtePreviousStartCutOffTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("PreviousEndCutOff : " + dtePreviousEndCutOffTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("PrevAllowedStartDateTime : " + dtePreviousAllowedStartDateTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("PrevAllowedEndDateTime : " + dtePreviousAllowedEndDateTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("StartCutOff : " + dteStartCutOffTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("EndCutOff : " + dteEndCutOffTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("AllowedStartDateTime : " + dteAllowedStartDateTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("AllowedEndDateTime : " + dteAllowedEndDateTime.ToString("yyyy-MM-dd HH:mm:ss"), true);
clsEvent.AddEventLn("MAXDateLastInitialized : " + dteMAXDateLastInitialized.ToString("yyyy-MM-dd HH:mm:ss"), true);
if (dteMAXDateLastInitialized < dteAllowedStartDateTime)
{
if (dteMAXDateLastInitialized >= dtePreviousAllowedStartDateTime && dteMAXDateLastInitialized <= dtePreviousEndCutOffTime)
{
if (dteTransactionDate >= dteStartCutOffTime && dteTransactionDate <= dteEndCutOffTime)
{
if (!bolMessageBoxShown)
{
MessageBox.Show("Today's EOD was not performed. Performing Auto Z-Read this may take some time. Please wait...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
bolMessageBoxShown = true;
}
clsEvent.AddEventLn("Today's EOD was not performed: System found AllowedStartDateTime [" + dteAllowedStartDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "] > MAXDateLastInitialized [" + dteMAXDateLastInitialized.ToString("yyyy-MM-dd HH:mm:ss") + "].", true);
clsEvent.AddEventLn("System is Auto-Initializing ZREAD", true);
clsTerminalReportDetails = clsTerminalReport.Details(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
mstrBeginningTransactionNo = clsTerminalReportDetails.BeginningTransactionNo;
PrintZRead(false, clsTerminalReportDetails);
dteMAXDateLastInitialized = Convert.ToDateTime(dteMAXDateLastInitialized.AddDays(1));
clsTerminalReport.InitializeZRead(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, "System Auto Z-Read", dteMAXDateLastInitialized, false);
clsEvent.AddEventLn("Done.", true);
goto Back;
}
else
{
bolRetValue = true;
clsEvent.AddEventLn("OK: AllowedStartDateTime [" + dteAllowedStartDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "] is now less than MAXDateLastInitialized [" + dteMAXDateLastInitialized.ToString("yyyy-MM-dd HH:mm:ss") + "].", true);
}
}
else
{
if (!bolMessageBoxShown)
{
MessageBox.Show("Previous' day's EOD was not performed. Performing Auto Z-Read this may take some time. Please wait...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
bolMessageBoxShown = true;
}
clsEvent.AddEventLn("Previous' day's EOD was not performed: System found AllowedStartDateTime [" + dteAllowedStartDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "] > MAXDateLastInitialized [" + dteMAXDateLastInitialized.ToString("yyyy-MM-dd HH:mm:ss") + "].", true);
clsEvent.AddEventLn("System is Auto-Initializing ZREAD", true);
clsTerminalReportDetails = clsTerminalReport.Details(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
mstrBeginningTransactionNo = clsTerminalReportDetails.BeginningTransactionNo;
PrintZRead(false, clsTerminalReportDetails);
dteMAXDateLastInitialized = Convert.ToDateTime(dteMAXDateLastInitialized.AddDays(1));
clsTerminalReport.InitializeZRead(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, "System Auto Z-Read", dteMAXDateLastInitialized, false);
clsEvent.AddEventLn("Done.",true);
goto Back;
}
}
else
{
bolRetValue = true;
clsEvent.AddEventLn("OK: AllowedStartDateTime [" + dteAllowedStartDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "] is now less than MAXDateLastInitialized [" + dteMAXDateLastInitialized.ToString("yyyy-MM-dd HH:mm:ss") + "].", true);
}
clsTerminalReport.CommitAndDispose();
}
else { clsEvent.AddEventLn("OK: StartCutOffTime not configured if greater than MAXDateLastInitialized", true); }
return bolRetValue;
}
catch (Exception ex)
{
InsertErrorLogToFile(ex);
return false;
}
}
private void InitializeZRead(bool boWithOutTF)
{
if (!SuspendTransactionAndContinue()) return;
DialogResult loginresult = GetWriteAccessAndLogin(mclsSalesTransactionDetails.CashierID, AccessTypes.InitializeZRead);
if (loginresult == DialogResult.OK)
{
Data.SalesTransactions clsSales = new Data.SalesTransactions(mConnection, mTransaction);
mConnection = clsSales.Connection; mTransaction = clsSales.Transaction;
int count = clsSales.CountSuspended(mclsTerminalDetails.TerminalNo, 0, mclsTerminalDetails.BranchID);
clsSales.CommitAndDispose();
if (count != 0)
{
if (MessageBox.Show("There are suspended transactions for this day. Please CLOSE the transactions first or press 'OK' to continue Z-Read... " + Environment.NewLine + Environment.NewLine + " Note: All Suspended transaction will be automatically VOID.", "RetailPlus", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
}
if (IsDateLastInitializationOK() == false)
{
return;
}
if (MessageBox.Show("Warning!!! Z-Read will be initialized...Press OK to continue.", "RetailPlus", MessageBoxButtons.OKCancel , MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
Cursor.Current = Cursors.WaitCursor;
try
{
clsEvent.AddEvent("[" + lblCashier.Text + "] Initializing ZReading.",true);
PrintZRead(true);
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(mConnection, mTransaction);
mConnection = clsTerminalReport.Connection; mTransaction = clsTerminalReport.Transaction;
// Dec 01, 2008 Lemuel E. Aceron
// added the IsCashCountInitialized for
// 1 time Cash count every printing of report.
Data.Terminal clsTerminal = new Data.Terminal(mConnection, mTransaction);
mConnection = clsTerminal.Connection; mTransaction = clsTerminal.Transaction;
clsTerminal.UpdateIsCashCountInitialized(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo, mclsSalesTransactionDetails.CashierID, false);
//initialize Z-Read
clsTerminalReport.InitializeZRead(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo, mclsSalesTransactionDetails.CashierName, Constants.C_DATE_MIN_VALUE, boWithOutTF);
InsertAuditLog(AccessTypes.InitializeZRead, "Initialize Z-Read." + " [Branch]:" + mclsTerminalDetails.BranchDetails.BranchCode + " [TerminalNo]" + mclsTerminalDetails.TerminalNo);
DateTime dteMAXDateLastInitialized = DateTime.MinValue;
// May 21, 2009 Lemuel E. Aceron
// added the for auto FTP of file for RLC
// get the maxdatelastinitialized
if (CONFIG.MallCode.ToUpper() == MallCodes.RLC)
{
Data.TerminalReportHistory clsTerminalReportHistory = new Data.TerminalReportHistory(mConnection, mTransaction);
mConnection = clsTerminalReportHistory.Connection; mTransaction = clsTerminalReportHistory.Transaction;
dteMAXDateLastInitialized = clsTerminalReportHistory.MINDateLastInitialized(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo, DateTime.Now);
}
clsTerminalReport.CommitAndDispose();
clsEvent.AddEventLn("Done!", true);
MessageBox.Show("Z-Read has been initialized for [Branch]:" + mclsTerminalDetails.BranchDetails.BranchCode + " [TerminalNo]" + mclsTerminalDetails.TerminalNo + "...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
// May 21, 2009 Lemuel E. Aceron
// added the for auto FTP of file for RLC
// send the data to RLC
if (CONFIG.MallCode.ToUpper() == MallCodes.RLC)
ProcessMallForwarder(dteMAXDateLastInitialized, true);
// 23Mar2015 : Initialize all reading with the same ORSeriesBranchID and ORSeriesTerminalNo
InitializeAllZreadWithSameORSeries(boWithOutTF);
LoggedOutCashier(false);
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERRROR!!! Initializing ZREAD for [Branch]:" + mclsTerminalDetails.BranchDetails.BranchCode + " [TerminalNo]" + mclsTerminalDetails.TerminalNo);
}
Cursor.Current = Cursors.Default;
}
}
}
