public Int64 UpdateBeginningBalance(CashierLogsDetails Details, decimal BeginningBalanceAmount)
{
Int64 iRetValue = Insert(Details);
Data.CashierReports clsCashierReport = new Data.CashierReports(base.Connection, base.Transaction);
clsCashierReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, Details.CashierID, BeginningBalanceAmount);
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(base.Connection, base.Transaction);
clsTerminalReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, BeginningBalanceAmount);
return iRetValue;
}
public Int64 UpdateBeginningBalance(CashierLogsDetails Details, decimal BeginningBalanceAmount)
{
Int64 iRetValue = Insert(Details);
Data.CashierReports clsCashierReport = new Data.CashierReports(base.Connection, base.Transaction);
clsCashierReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, Details.CashierID, BeginningBalanceAmount);
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(base.Connection, base.Transaction);
clsTerminalReport.UpdateBeginningBalance(Details.BranchID, Details.TerminalNo, BeginningBalanceAmount);
return(iRetValue);
}
private bool isValuesAssigned()
{
bool boRetValue = false;
try { Convert.ToDecimal(txtAmount.Text); }
catch
{
MessageBox.Show("Sorry, the amount you entered is not valid." +
"Please check the amount you entered.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (Convert.ToDecimal(txtAmount.Text) > 0)
{
mclsDisburseDetails.Amount = Convert.ToDecimal(txtAmount.Text);
mclsDisburseDetails.PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboType.Text, true);
mclsDisburseDetails.DateCreated = DateTime.Now;
mclsDisburseDetails.TerminalNo = CompanyDetails.TerminalNo;
mclsDisburseDetails.CashierID = mintCashierID;
mclsDisburseDetails.BranchDetails = mclsTerminalDetails.BranchDetails;
mclsDisburseDetails.Remarks = txtRemarks.Text;
// boRetValue = true;
// 15Apr2015 No need to check for this coz Disburse is based on actual cash.
Data.CashierReports clsCashierReport = new Data.CashierReports();
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(clsCashierReport.Connection, clsCashierReport.Transaction);
clsTerminalReport.SyncTransactionSales(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
if (!clsCashierReport.IsDisburseAmountValid(mclsDisburseDetails))
{
MessageBox.Show("Sorry, the amount you entered is greater than the " + cboType.Text + " sales." +
"Please check the amount you entered.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
boRetValue = false;
}
else
{
boRetValue = true;
}
clsCashierReport.CommitAndDispose();
}
else
{
MessageBox.Show("Sorry, amount must be greater than zero." +
"Please enter amount that is greater than zero.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
boRetValue = false;
}
return(boRetValue);
}
private bool isValuesAssigned()
{
bool boRetValue = false;
try { Convert.ToDecimal(txtAmount.Text); }
catch
{
MessageBox.Show("Sorry, the amount you entered is not valid. Please check the amount you entered.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return boRetValue;
}
if (Convert.ToDecimal(txtAmount.Text) > 0)
{
mclsPaidOutDetails.Amount = Convert.ToDecimal(txtAmount.Text);
mclsPaidOutDetails.PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboType.Text, true);
mclsPaidOutDetails.Remarks = txtRemarks.Text;
mclsPaidOutDetails.DateCreated = DateTime.Now;
mclsPaidOutDetails.TerminalNo = CompanyDetails.TerminalNo;
mclsPaidOutDetails.BranchDetails = mclsTerminalDetails.BranchDetails;
mclsPaidOutDetails.CashierID = mCashierID;
// boRetValue = true;
// 15Apr2015 No need to check for this coz Disburse is based on actual cash.
Data.CashierReports clsCashierReport = new Data.CashierReports();
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(clsCashierReport.Connection, clsCashierReport.Transaction);
clsTerminalReport.SyncTransactionSales(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
if (!clsCashierReport.IsPaidOutAmountValid(mclsPaidOutDetails))
{
MessageBox.Show("Sorry, the amount you entered is greater than the " + cboType.Text + " sales." +
"Please check the amount you entered.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
boRetValue = true;
}
clsCashierReport.CommitAndDispose();
}
else
{
MessageBox.Show("Sorry, amount must be greater than zero." +
"Please enter amount that is greater than zero.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return boRetValue;
}
public void PrintCashiersReport()
{
DialogResult loginresult = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessTypes.PrintCashierReport);
if (loginresult == DialogResult.None)
{
LogInWnd login = new LogInWnd();
login.AccessType = AccessTypes.PrintCashierReport;
login.Header = "Print Cashier Report";
login.TerminalDetails = mclsTerminalDetails;
login.ShowDialog(this);
loginresult = login.Result;
login.Close();
login.Dispose();
}
if (loginresult == DialogResult.OK)
{
DateTime dte = DateTime.Now;
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails Details = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.CommitAndDispose();
DialogResult result = DialogResult.OK;
if (mclsTerminalDetails.PreviewTerminalReport)
{
CashierReportWnd clsCashierReportWnd = new CashierReportWnd();
clsCashierReportWnd.TerminalDetails = mclsTerminalDetails;
clsCashierReportWnd.Details = Details;
clsCashierReportWnd.CashierName = mCashierName;
clsCashierReportWnd.ShowDialog(this);
result = clsCashierReportWnd.Result;
clsCashierReportWnd.Close();
clsCashierReportWnd.Dispose();
}
if (result == DialogResult.OK)
{
//PrintCashiersReportDelegate cashierreportDel = new PrintCashiersReportDelegate(PrintCashiersReport);
PrintCashiersReport(Details);
}
}
}
public void PrintPLUReportPerOrderSlipPrinter()
{
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails clsCashierReportDetails = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.GeneratePLUReport(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, false, mCashierName);
Data.PLUReport clsPLUReport = new Data.PLUReport(mConnection, mTransaction);
System.Data.DataTable dtpluReport = clsPLUReport.ListAsDataTable(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.CommitAndDispose();
DateTime StartDate = clsCashierReportDetails.LastLoginDate;
DateTime EndDate = DateTime.Now;
DialogResult result = DialogResult.OK;
if (mclsTerminalDetails.PreviewTerminalReport)
{
PLUReportWnd clsPLUReportWnd = new PLUReportWnd();
clsPLUReportWnd.TerminalDetails = mclsTerminalDetails;
clsPLUReportWnd.CashierName = mCashierName;
clsPLUReportWnd.dtPLUReport = dtpluReport;
clsPLUReportWnd.CashierReportDetail = clsCashierReportDetails;
clsPLUReportWnd.StartDate = StartDate;
clsPLUReportWnd.EndDate = EndDate;
clsPLUReportWnd.ShowDialog(this);
result = clsPLUReportWnd.Result;
clsPLUReportWnd.Close();
clsPLUReportWnd.Dispose();
}
if (result == DialogResult.OK)
{
// put variables in which printer to print
int iRetailPlusOSPrinter1Ctr = 0; int iRetailPlusOSPrinter2Ctr = 0; int iRetailPlusOSPrinter3Ctr = 0; int iRetailPlusOSPrinter4Ctr = 0; int iRetailPlusOSPrinter5Ctr = 0;
foreach (System.Data.DataRow dr in dtpluReport.Rows)
{
bool orderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString());
bool orderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString());
bool orderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString());
bool orderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString());
bool orderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString());
if (orderSlipPrinter1) { iRetailPlusOSPrinter1Ctr++; }
if (orderSlipPrinter2) { iRetailPlusOSPrinter2Ctr++; }
if (orderSlipPrinter3) { iRetailPlusOSPrinter3Ctr++; }
if (orderSlipPrinter4) { iRetailPlusOSPrinter4Ctr++; }
if (orderSlipPrinter5) { iRetailPlusOSPrinter5Ctr++; }
}
if (iRetailPlusOSPrinter1Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter1);
if (iRetailPlusOSPrinter2Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter2);
if (iRetailPlusOSPrinter3Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter3);
if (iRetailPlusOSPrinter4Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter4);
if (iRetailPlusOSPrinter5Ctr > 0) PrintPLUReportPerOrderSlipPrinter(dtpluReport, clsCashierReportDetails, StartDate, EndDate, AceSoft.RetailPlus.OrderSlipPrinter.RetailPlusOSPrinter5);
}
}
public void PrintPLUReportPerGroup()
{
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails clsCashierReportDetails = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.GeneratePLUReport(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, false, mCashierName);
Data.PLUReport clsPLUReport = new Data.PLUReport(mConnection, mTransaction);
mConnection = clsPLUReport.Connection; mTransaction = clsPLUReport.Transaction;
System.Data.DataTable dtpluReport = clsPLUReport.ListAsDataTable(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, true, "ProductGroup");
clsCashierReport.CommitAndDispose();
DateTime StartDate = clsCashierReportDetails.LastLoginDate;
DateTime EndDate = DateTime.Now;
DialogResult result = DialogResult.OK;
if (result == DialogResult.OK)
{
//PrintPLUReportPerGroupDelegate plureportDel = new PrintPLUReportPerGroupDelegate(PrintPLUReportPerGroup);
PrintPLUReportPerGroup(dtpluReport, clsCashierReportDetails, StartDate, EndDate);
}
}
public void PrintPLUReport()
{
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
Data.CashierReportDetails clsCashierReportDetails = clsCashierReport.Details(mclsSalesTransactionDetails.CashierID, Constants.TerminalBranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.GeneratePLUReport(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, false, mCashierName);
Data.PLUReport clsPLUReport = new Data.PLUReport(mConnection, mTransaction);
mConnection = clsPLUReport.Connection; mTransaction = clsPLUReport.Transaction;
System.Data.DataTable dtpluReport = clsPLUReport.ListAsDataTable(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo);
clsCashierReport.CommitAndDispose();
DateTime StartDate = clsCashierReportDetails.LastLoginDate;
DateTime EndDate = DateTime.Now;
DialogResult result = DialogResult.OK;
if (mclsTerminalDetails.PreviewTerminalReport)
{
PLUReportWnd clsPLUReportWnd = new PLUReportWnd();
clsPLUReportWnd.TerminalDetails = mclsTerminalDetails;
clsPLUReportWnd.CashierName = mCashierName;
clsPLUReportWnd.dtPLUReport = dtpluReport;
clsPLUReportWnd.CashierReportDetail = clsCashierReportDetails;
clsPLUReportWnd.StartDate = StartDate;
clsPLUReportWnd.EndDate = EndDate;
clsPLUReportWnd.ShowDialog(this);
result = clsPLUReportWnd.Result;
clsPLUReportWnd.Close();
clsPLUReportWnd.Dispose();
}
if (result == DialogResult.OK)
{
//PrintPLUReportDelegate plureportDel = new PrintPLUReportDelegate(PrintPLUReport);
PrintPLUReport(dtpluReport, clsCashierReportDetails, StartDate, EndDate);
}
}
//public delegate void UpdateCashierReportDelegate(TransactionStatus TransStatus, decimal SubTotal, decimal Discount, decimal Charge, decimal VAT, decimal VATableAmount, decimal ZeroRatedSales, decimal NonVATableAmount, decimal EVAT, decimal LocalTax, decimal CashPayment, decimal ChequePayment, decimal CreditCardPayment, decimal CreditPayment, decimal DebitPayment, PaymentTypes PaymentType);
public void UpdateCashierReport(TransactionStatus TransStatus, decimal ItemSold, decimal QuantitySold, decimal SubTotal, decimal Discount, decimal ItemsDiscount, decimal SNRItemsDiscount, decimal PWDItemsDiscount, decimal OtherItemsDiscount, decimal Charge, decimal VAT, decimal VATableAmount, decimal ZeroRatedSales, decimal NonVATableAmount, decimal VATExempt, decimal EVAT, decimal EVATableAmount, decimal NonEVATableAmount, decimal LocalTax, decimal CashPayment, decimal ChequePayment, decimal CreditCardPayment, decimal CreditPayment, decimal DebitPayment, decimal RewardPointsPayment, decimal RewardConvertedPayment, PaymentTypes PaymentType)
{
Int32 intNoOfCashTransactions = 0;
Int32 intNoOfChequeTransactions = 0;
Int32 intNoOfCreditCardTransactions = 0;
Int32 intNoOfCreditTransactions = 0;
Int32 intNoOfDebitTransactions = 0;
Int32 intNoOfCombinationPaymentTransactions = 0;
Int32 intNoOfDiscountedTransactions = 0;
Int32 intNoOfRewardPointsPayment = 0;
decimal decPromotionalItems = 0;
foreach (System.Data.DataRow dr in ItemDataTable.Rows)
{
decimal ItemQuantity = 0;
try { ItemQuantity = Convert.ToDecimal(dr["Quantity"]); }
catch
{
try { ItemQuantity = Convert.ToDecimal(dr["Quantity"].ToString().Replace("RETURN", "").Trim()); }
catch { }
}
decPromotionalItems += Convert.ToDecimal(dr["PromoApplied"]);
}
switch (PaymentType)
{
case PaymentTypes.Cash: { intNoOfCashTransactions = 1; break; }
case PaymentTypes.Cheque: { intNoOfChequeTransactions = 1; break; }
case PaymentTypes.CreditCard: { intNoOfCreditCardTransactions = 1; break; }
case PaymentTypes.Credit: { intNoOfCreditTransactions = 1; break; }
case PaymentTypes.Debit: { intNoOfDebitTransactions = 1; break; }
case PaymentTypes.RewardPoints: { intNoOfRewardPointsPayment = 1; break; }
case PaymentTypes.Combination: { intNoOfCombinationPaymentTransactions = 1; break; }
default: { intNoOfCashTransactions = 1; break; }
}
Data.CashierReportDetails clsCashierReportDetails = new Data.CashierReportDetails();
if (TransStatus == TransactionStatus.Closed)
{
clsCashierReportDetails.ItemSold = ItemSold;
clsCashierReportDetails.QuantitySold = QuantitySold;
clsCashierReportDetails.NoOfCashTransactions = intNoOfCashTransactions;
clsCashierReportDetails.NoOfChequeTransactions = intNoOfChequeTransactions;
clsCashierReportDetails.NoOfCreditCardTransactions = intNoOfCreditCardTransactions;
clsCashierReportDetails.NoOfCreditTransactions = intNoOfCreditTransactions;
clsCashierReportDetails.NoOfDebitPaymentTransactions = intNoOfDebitTransactions;
clsCashierReportDetails.NoOfCombinationPaymentTransactions = intNoOfCombinationPaymentTransactions;
clsCashierReportDetails.NoOfRewardPointsPayment = intNoOfRewardPointsPayment;
clsCashierReportDetails.NoOfClosedTransactions = 1;
// march 19, 2009
clsCashierReportDetails.NoOfDiscountedTransactions = intNoOfDiscountedTransactions;
clsCashierReportDetails.CreditSalesTax = clsCashierReportDetails.CreditPayment * (mclsTerminalDetails.VAT / 100);
clsCashierReportDetails.PromotionalItems = decPromotionalItems;
clsCashierReportDetails.NoOfTotalTransactions = 1;
}
else if (TransStatus == TransactionStatus.Void)
{
clsCashierReportDetails.ItemSold = 0;
clsCashierReportDetails.QuantitySold = 0;
clsCashierReportDetails.NoOfVoidTransactions = 1;
clsCashierReportDetails.NoOfTotalTransactions = 1;
}
else if (TransStatus == TransactionStatus.Refund)
{
clsCashierReportDetails.ItemSold = -ItemSold;
clsCashierReportDetails.QuantitySold = -QuantitySold;
clsCashierReportDetails.NoOfRefundTransactions = 1;
clsCashierReportDetails.NoOfTotalTransactions = 1;
}
else if (TransStatus == TransactionStatus.CreditPayment)
{
clsCashierReportDetails.PromotionalItems = decPromotionalItems;
clsCashierReportDetails.NoOfCreditPaymentTransactions = 1;
clsCashierReportDetails.NoOfTotalTransactions = 1;
}
else if (TransStatus == TransactionStatus.ClosedWalkIn)
{
clsCashierReportDetails.NoOfWalkInTransactions = 1;
}
else if (TransStatus == TransactionStatus.ClosedOutOfStock)
{
clsCashierReportDetails.NoOfOutOfStockTransactions = 1;
}
else if (TransStatus == TransactionStatus.Consignment)
{
clsCashierReportDetails.NoOfConsignmentTransactions = 1;
}
else if (TransStatus == TransactionStatus.ClosedWalkInRefund)
{
clsCashierReportDetails.NoOfWalkInRefundTransactions = 1;
}
else if (TransStatus == TransactionStatus.ClosedOutOfStockRefund)
{
clsCashierReportDetails.NoOfOutOfStockRefundTransactions = 1;
}
else if (TransStatus == TransactionStatus.ConsignmentRefund)
{
clsCashierReportDetails.NoOfConsignmentRefundTransactions = 1;
}
clsCashierReportDetails.TerminalNo = mclsTerminalDetails.TerminalNo;
clsCashierReportDetails.BranchID = mclsTerminalDetails.BranchID;
clsCashierReportDetails.CashierID = mclsSalesTransactionDetails.CashierID;
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
clsCashierReport.UpdateTransactionSales(clsCashierReportDetails);
}
private bool IsBeginningBalanceInitialized(long CashierID)
{
try
{
bool boRetValue = false;
Data.CashierReports clsCashierReport = new Data.CashierReports(mConnection, mTransaction);
mConnection = clsCashierReport.Connection; mTransaction = clsCashierReport.Transaction;
bool IsBeginningBalanceInitialized = clsCashierReport.IsBeginningBalanceInitialized(mclsTerminalDetails.BranchDetails.BranchID, mclsTerminalDetails.TerminalNo, CashierID);
clsCashierReport.CommitAndDispose();
if (!IsBeginningBalanceInitialized)
{
BalanceWnd clsBalanceWnd = new BalanceWnd();
clsBalanceWnd.TerminalDetails = mclsTerminalDetails;
clsBalanceWnd.CashierID = CashierID;
clsBalanceWnd.ShowDialog(this);
DialogResult balanceResult = clsBalanceWnd.Result;
clsBalanceWnd.Close();
clsBalanceWnd.Dispose();
if (balanceResult == DialogResult.OK)
{
boRetValue = true;
//OpenDrawerDelegate opendrawerDel = new OpenDrawerDelegate(OpenDrawer);
//Invoke(opendrawerDel);
OpenDrawer();
}
}
else
{
boRetValue = true;
}
return boRetValue;
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Initializing balance.");
throw ex;
}
}
