public void PrintPageAndReportFooterSection(bool IsReceipt, DateTime OverRidingPrintDate, bool boPrintTermsAndConditions = false)
{
//if (mclsTerminalDetails.AutoPrint != PrintingPreference.AskFirst)
//{
int iCtr = 0;
string stModule = "";
Receipt clsReceipt = new Receipt(mConnection, mTransaction);
ReceiptDetails clsReceiptDetails;
if (IsReceipt)
{
// print page footer
for (iCtr = 1; iCtr <= 20; iCtr++)
{
stModule = "PageFooterA" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
PrintReportValue(clsReceiptDetails, IsReceipt, OverRidingPrintDate);
}
// print page footer
for (iCtr = 1; iCtr <= 5; iCtr++)
{
stModule = "PageFooterB" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
PrintReportValue(clsReceiptDetails, IsReceipt, OverRidingPrintDate);
}
}
// print report footer
for (iCtr = 1; iCtr <= 5; iCtr++)
{
stModule = "ReportFooter" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
PrintReportValue(clsReceiptDetails, IsReceipt, OverRidingPrintDate);
}
if (mclsTerminalDetails.IncludeTermsAndConditions & boPrintTermsAndConditions)
PrintTermsAndConditions();
// Sep 14, 2014 get the msbToPrint to remove the spacers.
msbEJournalToPrint = msbToPrint;
// print report footer Spacer
clsReceiptDetails = clsReceipt.Details(ReportFormatModule.ReportFooterSpacer);
for (int i = 0; i < Convert.ToInt32(clsReceiptDetails.Value); i++)
{ msbToPrint.Append(Environment.NewLine); }
clsReceipt.CommitAndDispose();
// do the actual print
if (mclsTerminalDetails.AutoPrint != PrintingPreference.AskFirst)
{
this.bgwPOSPrinter.RunWorkerAsync();
// Wait for the BackgroundWorker to finish the download.
while (this.bgwPOSPrinter.IsBusy)
{
Application.DoEvents();
}
//mclsFilePrinter.Write(msbToPrint);
//RawPrinterHelper.SendFileToPrinter(mclsTerminalDetails.PrinterName, mclsFilePrinter.FileName, "RetailPlus " + mclsFilePrinter.FileName);
//mclsFilePrinter.DeleteFile();
////print the first part of transaction header if autocutter
//if (mclsTerminalDetails.IsPrinterAutoCutter)
// //cut the paper if printer is auto cutter
// CutPrinterPaper(mclsTerminalDetails.PrinterName);
}
// Sep 14, 2014 add electronic journal only for all valid transactions with transaction no
if (mclsSalesTransactionDetails.TransactionID != 0)
{
msbEJournalToPrint.Append("-".PadLeft(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
mclsEJournal = new EJournalPrinter();
if (string.IsNullOrEmpty(mstrBeginningTransactionNo))
{
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(mConnection, mTransaction);
mstrBeginningTransactionNo = clsTerminalReport.BeginningTransactionNo(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo);
//mstrBeginningTransactionNo = clsTerminalReport.Details(mclsTerminalDetails.BranchID, mclsTerminalDetails.TerminalNo).BeginningTransactionNo;
clsTerminalReport.CommitAndDispose();
}
mclsEJournal.FileName = mstrBeginningTransactionNo;
mclsEJournal.Write(msbEJournalToPrint);
}
}
public void PrintReportPageHeaderSectionChecked(bool IsReceipt)
{
if (IsReceipt)
{
// print page header <-- second transaction header
int iCtr = 0;
string stModule = "";
Receipt clsReceipt = new Receipt(mConnection, mTransaction);
ReceiptDetails clsReceiptDetails;
for (iCtr = 1; iCtr <= 10; iCtr++)
{
stModule = "PageHeader" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
PrintReportValue(clsReceiptDetails, IsReceipt, DateTime.MinValue);
}
PrintItemHeader();
clsReceipt.CommitAndDispose();
}
}
public void PrintPageFooterBSection()
{
int iCtr = 0;
string stModule = "";
Receipt clsReceipt = new Receipt(mConnection, mTransaction);
ReceiptDetails clsReceiptDetails;
// print page footer
for (iCtr = 1; iCtr <= 5; iCtr++)
{
stModule = "PageFooterB" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
PrintReportValue(clsReceiptDetails, false, DateTime.MinValue);
}
clsReceipt.CommitAndDispose();
}
private void LoadRecord()
{
lblCompanyName.Text = CompanyDetails.CompanyName;
Label lblLabel;
int iCtr = 0;
string stModule = "";
Receipt clsReceipt = new Receipt();
ReceiptDetails clsReceiptDetails;
stModule = "ReportHeaderSpacer";
clsReceiptDetails = clsReceipt.Details(stModule);
// txtReportHeaderSpacer.Text = clsReceiptDetails.Value;
for (iCtr=1;iCtr<=10;iCtr++)
{
lblLabel = (Label) this.FindControl("lblReportHeader" + iCtr);
stModule = "ReportHeader" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=10;iCtr++)
{
lblLabel = (Label) this.FindControl("lblPageHeader" + iCtr);
stModule = "PageHeader" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=20;iCtr++)
{
lblLabel = (Label) this.FindControl("lblPageFooterA" + iCtr);
stModule = "PageFooterA" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=5;iCtr++)
{
lblLabel = (Label) this.FindControl("lblPageFooterB" + iCtr);
stModule = "PageFooterB" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=5;iCtr++)
{
lblLabel = (Label) this.FindControl("lblReportFooter" + iCtr);
stModule = "ReportFooter" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
ApplyFormat(clsReceiptDetails, lblLabel);
}
stModule = "ReportFooterSpacer";
clsReceiptDetails = clsReceipt.Details(stModule);
// txtReportFooterSpacer.Text = clsReceiptDetails.Value;
clsReceipt.CommitAndDispose();
}
public void PrintReportPageHeaderSection(bool isReceipt, bool isCheckOutBill = false)
{
Receipt clsReceipt = new Receipt(mConnection, mTransaction);
ReceiptDetails clsReceiptDetails;
// print Page Header
int iCtr = 0;
string stModule = "";
for (iCtr = 1; iCtr <= 10; iCtr++)
{
stModule = "PageHeader" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
PrintReportValue(clsReceiptDetails, isReceipt, DateTime.MinValue, isCheckOutBill);
}
PrintItemHeader();
clsReceipt.CommitAndDispose();
}
private void PopulatePLUReport()
{
lblCompany.Text = CompanyDetails.CompanyCode;
lblStartDate.Text = "Start Date: " + mStartDate.ToString("MM/dd/yyyy hh:mm:ss tt") + Environment.NewLine;
lblEndDate.Text = "End Date : " + mEndDate.ToString("MM/dd/yyyy hh:mm:ss tt") + Environment.NewLine + Environment.NewLine;
Receipt clsReceipt = new Receipt();
lblReportHeader1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
lblReportHeader2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
lblReportHeader3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
lblReportHeader4.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
this.dgStyle.MappingName = mdtPLUReport.TableName;
dgPLUReport.DataSource = mdtPLUReport;
decimal TotalQuantity = 0;
decimal TotalAmount = 0;
try
{
foreach (System.Data.DataRow dr in mdtPLUReport.Rows)
{
TotalQuantity += Convert.ToDecimal(dr["Quantity"]);
TotalAmount += Convert.ToDecimal(dr["Amount"]);
}
dgPLUReport.Select(0);
}
catch { }
lblTotalQuantity.Text = TotalQuantity.ToString("#,##0.#0");
lblTotalAmount.Text = TotalAmount.ToString("#,##0.#0");
lblGrandTotal.Text = mCashierReportDetails.GrossSales.ToString("#,##0.#0");
lblReportFooter1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
lblReportFooter2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
lblReportFooter3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
clsReceipt.CommitAndDispose();
}
private void PopulateGroupReport()
{
lblCompany.Text = CompanyDetails.CompanyCode;
Receipt clsReceipt = new Receipt();
lblReportHeader1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
lblReportHeader2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
lblReportHeader3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
lblReportHeader4.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
this.dgStyle.MappingName = mdtGroupReport.TableName;
dgGroupReport.DataSource = mdtGroupReport;
decimal TotalTranCount = 0;
decimal TotalAmount = 0;
try
{
foreach (System.Data.DataRow dr in mdtGroupReport.Rows)
{
TotalTranCount += Convert.ToDecimal(dr["TranCount"]);
TotalAmount += Convert.ToDecimal(dr["Amount"]);
}
dgGroupReport.Select(0);
}
catch { }
lblTotalTran.Text = TotalTranCount.ToString("#,##0");
lblTotalAmount.Text = TotalAmount.ToString("#,##0.#0");
if (TotalTranCount > 0)
lblTotalPercentage.Text = "100%";
else
lblTotalPercentage.Text = "0%";
lblDiscount.Text = mTerminalReportDetails.SubTotalDiscount.ToString("#,##0.#0");
lblCharge.Text = mTerminalReportDetails.TotalCharge.ToString("#,##0.#0");
lblVAT.Text = mTerminalReportDetails.VAT.ToString("#,##0.#0");
lblVATName.Visible = !mclsTerminalDetails.IsVATInclusive;
lblVAT.Visible = !mclsTerminalDetails.IsVATInclusive;
lblVATSpacer.Visible = !mclsTerminalDetails.IsVATInclusive;
decimal GrandTotal = mTerminalReportDetails.DailySales + mTerminalReportDetails.VAT + mTerminalReportDetails.TotalCharge;
lblGrandTotal.Text = GrandTotal.ToString("#,##0.#0");
lblReportFooter1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
lblReportFooter2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
lblReportFooter3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
clsReceipt.CommitAndDispose();
}
private void SaveRecord()
{
DropDownList cboOrientationBox;
DropDownList cboBox;
TextBox txtBox;
int iCtr = 1;
Receipt clsReceipt = new Receipt();
ReceiptDetails clsDetails = new ReceiptDetails();
clsDetails.Module = "ReportHeaderSpacer";
clsDetails.Value = txtReportHeaderSpacer.Text;
clsReceipt.Update(clsDetails);
for (iCtr=1;iCtr<=10;iCtr++)
{
cboOrientationBox = (DropDownList) this.FindControl("cboReportHeaderOrientation" + iCtr);
cboBox = (DropDownList) this.FindControl("cboReportHeader" + iCtr);
txtBox = (TextBox) this.FindControl("txtReportHeader" + iCtr);
clsDetails.Module = "ReportHeader" + iCtr;
clsDetails.Text = txtBox.Text;
clsDetails.Value = cboBox.SelectedItem.Value.ToString();
clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString());
clsReceipt.Update(clsDetails);
}
for (iCtr=1;iCtr<=10;iCtr++)
{
cboOrientationBox = (DropDownList) this.FindControl("cboPageHeaderOrientation" + iCtr);
cboBox = (DropDownList) this.FindControl("cboPageHeader" + iCtr);
txtBox = (TextBox) this.FindControl("txtPageHeader" + iCtr);
clsDetails.Module = "PageHeader" + iCtr;
clsDetails.Text = txtBox.Text;
clsDetails.Value = cboBox.SelectedItem.Value.ToString();
clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString());
clsReceipt.Update(clsDetails);
}
for (iCtr=1;iCtr<=20;iCtr++)
{
cboOrientationBox = (DropDownList) this.FindControl("cboPageFooterAOrientation" + iCtr);
cboBox = (DropDownList) this.FindControl("cboPageFooterA" + iCtr);
txtBox = (TextBox) this.FindControl("txtPageFooterA" + iCtr);
clsDetails.Module = "PageFooterA" + iCtr;
clsDetails.Text = txtBox.Text;
clsDetails.Value = cboBox.SelectedItem.Value.ToString();
clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString());
clsReceipt.Update(clsDetails);
}
for (iCtr=1;iCtr<=5;iCtr++)
{
cboOrientationBox = (DropDownList) this.FindControl("cboPageFooterBOrientation" + iCtr);
cboBox = (DropDownList) this.FindControl("cboPageFooterB" + iCtr);
txtBox = (TextBox) this.FindControl("txtPageFooterB" + iCtr);
clsDetails.Module = "PageFooterB" + iCtr;
clsDetails.Text = txtBox.Text;
clsDetails.Value = cboBox.SelectedItem.Value.ToString();
clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString());
clsReceipt.Update(clsDetails);
}
for (iCtr=1;iCtr<=5;iCtr++)
{
cboOrientationBox = (DropDownList) this.FindControl("cboReportFooterOrientation" + iCtr);
cboBox = (DropDownList) this.FindControl("cboReportFooter" + iCtr);
txtBox = (TextBox) this.FindControl("txtReportFooter" + iCtr);
clsDetails.Module = "ReportFooter" + iCtr;
clsDetails.Text = txtBox.Text;
clsDetails.Value = cboBox.SelectedItem.Value.ToString();
clsDetails.Orientation = (ReportFormatOrientation) Enum.Parse(typeof(ReportFormatOrientation),cboOrientationBox.SelectedItem.Value.ToString());
clsReceipt.Update(clsDetails);
}
clsDetails.Module = "ReportFooterSpacer";
clsDetails.Value = txtReportFooterSpacer.Text;
clsReceipt.Update(clsDetails);
clsReceipt.CommitAndDispose();
}
private void LoadRecord()
{
lblCompanyName.Text = CompanyDetails.CompanyName;
lblCompanyName1.Text = CompanyDetails.CompanyName;
DropDownList cboOrientationBox;
DropDownList cboBox;
TextBox txtBox;
Label lblLabel;
int iCtr = 0;
string stModule = "";
Receipt clsReceipt = new Receipt();
ReceiptDetails clsReceiptDetails;
stModule = "ReportHeaderSpacer";
clsReceiptDetails = clsReceipt.Details(stModule);
txtReportHeaderSpacer.Text = clsReceiptDetails.Value;
for (iCtr=1;iCtr<=10;iCtr++)
{
txtBox = (TextBox) this.FindControl("txtReportHeader" + iCtr);
cboBox = (DropDownList) this.FindControl("cboReportHeader" + iCtr);
cboOrientationBox = (DropDownList) this.FindControl("cboReportHeaderOrientation" + iCtr);
lblLabel = (Label) this.FindControl("lblReportHeader" + iCtr);
stModule = "ReportHeader" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
txtBox.Text = clsReceiptDetails.Text;
cboBox.SelectedIndex = cboBox.Items.IndexOf(cboBox.Items.FindByValue(clsReceiptDetails.Value));
cboOrientationBox.SelectedIndex = cboOrientationBox.Items.IndexOf(cboOrientationBox.Items.FindByValue(clsReceiptDetails.Orientation.ToString("d")));
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=10;iCtr++)
{
txtBox = (TextBox) this.FindControl("txtPageHeader" + iCtr);
cboBox = (DropDownList) this.FindControl("cboPageHeader" + iCtr);
cboOrientationBox = (DropDownList) this.FindControl("cboPageHeaderOrientation" + iCtr);
lblLabel = (Label) this.FindControl("lblPageHeader" + iCtr);
stModule = "PageHeader" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
txtBox.Text = clsReceiptDetails.Text;
cboBox.SelectedIndex = cboBox.Items.IndexOf(cboBox.Items.FindByValue(clsReceiptDetails.Value));
cboOrientationBox.SelectedIndex = cboOrientationBox.Items.IndexOf(cboOrientationBox.Items.FindByValue(clsReceiptDetails.Orientation.ToString("d")));
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=20;iCtr++)
{
txtBox = (TextBox) this.FindControl("txtPageFooterA" + iCtr);
cboBox = (DropDownList) this.FindControl("cboPageFooterA" + iCtr);
cboOrientationBox = (DropDownList) this.FindControl("cboPageFooterAOrientation" + iCtr);
lblLabel = (Label) this.FindControl("lblPageFooterA" + iCtr);
stModule = "PageFooterA" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
txtBox.Text = clsReceiptDetails.Text;
cboBox.SelectedIndex = cboBox.Items.IndexOf(cboBox.Items.FindByValue(clsReceiptDetails.Value));
cboOrientationBox.SelectedIndex = cboOrientationBox.Items.IndexOf(cboOrientationBox.Items.FindByValue(clsReceiptDetails.Orientation.ToString("d")));
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=5;iCtr++)
{
txtBox = (TextBox) this.FindControl("txtPageFooterB" + iCtr);
cboBox = (DropDownList) this.FindControl("cboPageFooterB" + iCtr);
cboOrientationBox = (DropDownList) this.FindControl("cboPageFooterBOrientation" + iCtr);
lblLabel = (Label) this.FindControl("lblPageFooterB" + iCtr);
stModule = "PageFooterB" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
txtBox.Text = clsReceiptDetails.Text;
cboBox.SelectedIndex = cboBox.Items.IndexOf(cboBox.Items.FindByValue(clsReceiptDetails.Value));
cboOrientationBox.SelectedIndex = cboOrientationBox.Items.IndexOf(cboOrientationBox.Items.FindByValue(clsReceiptDetails.Orientation.ToString("d")));
ApplyFormat(clsReceiptDetails, lblLabel);
}
for (iCtr=1;iCtr<=5;iCtr++)
{
txtBox = (TextBox) this.FindControl("txtReportFooter" + iCtr);
cboBox = (DropDownList) this.FindControl("cboReportFooter" + iCtr);
cboOrientationBox = (DropDownList) this.FindControl("cboReportFooterOrientation" + iCtr);
lblLabel = (Label) this.FindControl("lblReportFooter" + iCtr);
stModule = "ReportFooter" + iCtr;
clsReceiptDetails = clsReceipt.Details(stModule);
txtBox.Text = clsReceiptDetails.Text;
cboBox.SelectedIndex = cboBox.Items.IndexOf(cboBox.Items.FindByValue(clsReceiptDetails.Value));
cboOrientationBox.SelectedIndex = cboOrientationBox.Items.IndexOf(cboOrientationBox.Items.FindByValue(clsReceiptDetails.Orientation.ToString("d")));
ApplyFormat(clsReceiptDetails, lblLabel);
}
stModule = "ReportFooterSpacer";
clsReceiptDetails = clsReceipt.Details(stModule);
txtReportFooterSpacer.Text = clsReceiptDetails.Value;
clsReceipt.CommitAndDispose();
}
private void PopulateCashiersReport()
{
Receipt clsReceipt = new Receipt();
clsReceipt.GetConnection();
Data.TerminalReportDetails clsTerminalReportDetails = new Data.TerminalReport(clsReceipt.Connection, clsReceipt.Transaction).Details(mclsDetails.BranchID, mclsDetails.TerminalNo);
mclsTerminalDetails.MaxReceiptWidth = 94;
System.Data.DataTable dt = new System.Data.DataTable("tblTerminalReport");
dt.Columns.Add("Module");
dt.Columns.Add("Separator");
dt.Columns.Add("Value");
//dt.Rows.Add(CenterString(CompanyDetails.CompanyCode, mclsTerminalDetails.MaxReceiptWidth));
//dt.Rows.Add("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-'));
//dt.Rows.Add(CenterString("Terminal Report", mclsTerminalDetails.MaxReceiptWidth));
//dt.Rows.Add("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-'));
//string strReportHeader1 = clsReceipt.Details("ReportHeader1").Value;
//string strReportHeader2 = clsReceipt.Details("ReportHeader2").Value;
//string strReportHeader3 = clsReceipt.Details("ReportHeader3").Value;
//string strReportHeader4 = clsReceipt.Details("ReportHeader4").Value;
//if (!string.IsNullOrEmpty(strReportHeader1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader1), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader2), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader3), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader4)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader4), mclsTerminalDetails.MaxReceiptWidth));
dt.Rows.Add("Gross Sales", ":", (mclsDetails.GrossSales + mclsDetails.TotalCharge).ToString("#,##0.#0"));
dt.Rows.Add("(-) Service Charge", ":", mclsDetails.TotalCharge.ToString("#,##0.#0"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Total Amount", ":", mclsDetails.GrossSales.ToString("#,##0.#0"));
dt.Rows.Add("(-) " + mclsTerminalDetails.VAT.ToString("##") + "% VAT Exempt ", ":", (mclsDetails.VATExempt * (mclsTerminalDetails.VAT / 100)).ToString("#,##0.#0"));
dt.Rows.Add("(-) Subtotal Discount", ":", mclsDetails.SubTotalDiscount.ToString("#,##0.#0"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Net Sales", ":", mclsDetails.NetSales.ToString("#,##0.#0"));
dt.Rows.Add("Taxables Breakdown", "", "");
dt.Rows.Add("VAT Exempt", ":", mclsDetails.VATExempt.ToString("#,##0.00"));
dt.Rows.Add("VAT Zero Rated", ":", mclsDetails.ZeroRatedSales.ToString("#,##0.00"));
dt.Rows.Add("NonVATable Amount", ":", mclsDetails.NonVATableAmount.ToString("#,##0.00"));
dt.Rows.Add("VATable Amount", ":", mclsDetails.VATableAmount.ToString("#,##0.00"));
dt.Rows.Add(mclsTerminalDetails.VAT.ToString("##") + "% VAT", ":", mclsDetails.VAT.ToString("#,##0.00"));
dt.Rows.Add("Local Tax", ":", mclsDetails.LocalTax.ToString("#,##0.00"));
dt.Rows.Add("Total Amount Breakdown", "", "");
dt.Rows.Add("Cash Sales", ":", mclsDetails.CashSales.ToString("#,##0.00"));
dt.Rows.Add("Cheque Sales", ":", mclsDetails.ChequeSales.ToString("#,##0.00"));
dt.Rows.Add("Credit Card Sales", ":", mclsDetails.CreditCardSales.ToString("#,##0.00"));
dt.Rows.Add("Credit (Charge)", ":", mclsDetails.CreditSales.ToString("#,##0.00"));
dt.Rows.Add("Credit Payment", ":", mclsDetails.CreditPayment.ToString("#,##0.00"));
dt.Rows.Add(" Cash", ":", mclsDetails.CreditPaymentCash.ToString("#,##0.00"));
dt.Rows.Add(" Cheque", ":", mclsDetails.CreditPaymentCheque.ToString("#,##0.00"));
dt.Rows.Add(" Credit Card", ":", mclsDetails.CreditPaymentCreditCard.ToString("#,##0.00"));
dt.Rows.Add(" Debit", ":", mclsDetails.CreditPaymentDebit.ToString("#,##0.00"));
dt.Rows.Add("Debit Sales", ":", mclsDetails.DebitPayment.ToString("#,##0.00"));
dt.Rows.Add(" Rewards Points Redeemed", ":", mclsDetails.RewardPointsPayment.ToString("#,##0.00"));
dt.Rows.Add("Employee Acct.", ":", "0.00");
dt.Rows.Add("Void Sales", ":", mclsDetails.VoidSales.ToString("#,##0.00"));
dt.Rows.Add("Refund Sales", ":", mclsDetails.RefundSales.ToString("#,##0.00"));
dt.Rows.Add(" Cash", ":", mclsDetails.RefundCash.ToString("#,##0.00"));
dt.Rows.Add(" Cheque", ":", mclsDetails.RefundCheque.ToString("#,##0.00"));
dt.Rows.Add(" Credit Card", ":", mclsDetails.RefundCreditCard.ToString("#,##0.00"));
dt.Rows.Add(" Credit", ":", mclsDetails.RefundCredit.ToString("#,##0.00"));
dt.Rows.Add(" Debit", ":", mclsDetails.RefundDebit.ToString("#,##0.00"));
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsReceipt.Connection, clsReceipt.Transaction);
// CashierID = 0 ALL
Data.TerminalReport clsTerminalReport = new Data.TerminalReport(clsReceipt.Connection, clsReceipt.Transaction);
System.Data.DataTable dtCreditCards = clsSalesTransactions.SalesPerCreditCard(mclsDetails.BranchID, mclsDetails.TerminalNo, mclsDetails.CashierID, clsTerminalReportDetails.DateLastInitialized, clsTerminalReportDetails.NEXTDateLastInitialized);
if (dtCreditCards.Rows.Count > 0)
{
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Credit Card Breakdown", "", "");
dt.Rows.Add("-", "-", "-");
foreach (System.Data.DataRow dr in dtCreditCards.Rows)
{
dt.Rows.Add(dr["CardTypeCode"].ToString(), ":", decimal.Parse(dr["Amount"].ToString()).ToString("#,##0.00"));
}
}
dt.Rows.Add("Discounts", "", "");
dt.Rows.Add("Items Discount", ":", mclsDetails.ItemsDiscount.ToString("#,##0.00"));
dt.Rows.Add("Subtotal Discount", ":", mclsDetails.SubTotalDiscount.ToString("#,##0.00"));
dt.Rows.Add(" Senior Citizen", ":", mclsDetails.SNRDiscount.ToString("#,##0.00"));
dt.Rows.Add(" PWD", ":", mclsDetails.PWDDiscount.ToString("#,##0.00"));
dt.Rows.Add(" Others", ":", mclsDetails.OtherDiscount.ToString("#,##0.00"));
dt.Rows.Add("Total Discounts", ":", mclsDetails.TotalDiscount.ToString("#,##0.00"));
clsSalesTransactions = new Data.SalesTransactions(clsReceipt.Connection, clsReceipt.Transaction);
System.Data.DataTable dtDiscounts = clsSalesTransactions.Discounts(mclsDetails.BranchID, mclsDetails.TerminalNo, clsTerminalReportDetails.BeginningTransactionNo, clsTerminalReportDetails.EndingTransactionNo);
if (dtDiscounts.Rows.Count > 0)
{
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Subtotal Discounts Breakdown", "", "");
dt.Rows.Add("-", "-", "-");
foreach (System.Data.DataRow dr in dtDiscounts.Rows)
{
dt.Rows.Add(dr["DiscountCode"].ToString(), ":", decimal.Parse(dr["Discount"].ToString()).ToString("#,##0.00"));
}
}
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Drawer Information", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Beginning Balance", ":", mclsDetails.BeginningBalance.ToString("#,##0.00"));
dt.Rows.Add("Cash In Drawer", ":", mclsDetails.CashInDrawer.ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Paid Out", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Paid Out", ":", mclsDetails.TotalPaidOut.ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("PICK UP / Disburstment", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash", ":", mclsDetails.CashDisburse.ToString("#,##0.00"));
dt.Rows.Add("Cheque", ":", mclsDetails.ChequeDisburse.ToString("#,##0.00"));
dt.Rows.Add("Credit Card", ":", mclsDetails.CreditCardDisburse.ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Receive on Account", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash", ":", mclsDetails.CashWithHold.ToString("#,##0.00"));
dt.Rows.Add("Cheque", ":", mclsDetails.ChequeWithHold.ToString("#,##0.00"));
dt.Rows.Add("Credit Card", ":", mclsDetails.CreditCardWithHold.ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Customer Deposits", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash", ":", mclsDetails.CashDeposit.ToString("#,##0.00"));
dt.Rows.Add("Cheque", ":", mclsDetails.ChequeDeposit.ToString("#,##0.00"));
dt.Rows.Add("Credit Card", ":", mclsDetails.CreditCardDeposit.ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Transaction Count Breakdown", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash Transactions", ":", mclsDetails.NoOfCashTransactions.ToString("#,##0.00"));
dt.Rows.Add("Cheque Transactions", ":", mclsDetails.NoOfChequeTransactions.ToString("#,##0.00"));
dt.Rows.Add("Credit Card Transactions", ":", mclsDetails.NoOfCreditCardTransactions.ToString("#,##0.00"));
dt.Rows.Add("Credit Transactions", ":", mclsDetails.NoOfCreditTransactions.ToString("#,##0.00"));
dt.Rows.Add("Debit Transactions", ":", mclsDetails.NoOfDebitPaymentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Refund Transactions", ":", mclsDetails.NoOfRefundTransactions.ToString("#,##0.00"));
dt.Rows.Add("Void Transactions", ":", mclsDetails.NoOfVoidTransactions.ToString("#,##0.00"));
dt.Rows.Add("Combination Trans", ":", mclsDetails.NoOfCombinationPaymentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Credit Payment Trans", ":", mclsDetails.NoOfCreditPaymentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Reward Points Trans", ":", mclsDetails.NoOfRewardPointsPayment.ToString("#,##0.00"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Total Transactions", ":", mclsDetails.NoOfTotalTransactions.ToString("#,##0.00"));
dt.Rows.Add("Misc Amount Breakdown", "", "");
dt.Rows.Add(" Consignment", ":", mclsDetails.ConsignmentSales.ToString("#,##0.00"));
dt.Rows.Add(" Walk-In", ":", mclsDetails.WalkInSales.ToString("#,##0.00"));
dt.Rows.Add(" Out Of Stock", ":", mclsDetails.OutOfStockSales.ToString("#,##0.00"));
dt.Rows.Add("Refund - Misc Amount Breakdown", "", "");
dt.Rows.Add(" Consignment", ":", mclsDetails.ConsignmentRefundSales.ToString("#,##0.00"));
dt.Rows.Add(" Walk-In", ":", mclsDetails.WalkInRefundSales.ToString("#,##0.00"));
dt.Rows.Add(" Out Of Stock", ":", mclsDetails.OutOfStockRefundSales.ToString("#,##0.00"));
dt.Rows.Add("Misc Trans Breakdown", "", "");
dt.Rows.Add(" Consignment Trans", ":", mclsDetails.NoOfConsignmentTransactions.ToString("#,##0.00"));
dt.Rows.Add(" Walk-In Trans", ":", mclsDetails.NoOfWalkInTransactions.ToString("#,##0.00"));
dt.Rows.Add(" Out Of Stock Trans", ":", mclsDetails.NoOfOutOfStockTransactions.ToString("#,##0.00"));
dt.Rows.Add("Refund - Misc Trans Breakdown", "", "");
dt.Rows.Add(" Consignment Trans", ":", mclsDetails.NoOfConsignmentRefundTransactions.ToString("#,##0.00"));
dt.Rows.Add(" Walk-In Trans", ":", mclsDetails.NoOfWalkInRefundTransactions.ToString("#,##0.00"));
dt.Rows.Add(" Out Of Stock Trans", ":", mclsDetails.NoOfOutOfStockRefundTransactions.ToString("#,##0.00"));
string strReportFooter1 = clsReceipt.Details("ReportFooter1").Value;
string strReportFooter2 = clsReceipt.Details("ReportFooter2").Value;
string strReportFooter3 = clsReceipt.Details("ReportFooter3").Value;
if (!string.IsNullOrEmpty(strReportFooter1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter1), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter2), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter3), mclsTerminalDetails.MaxReceiptWidth));
clsReceipt.CommitAndDispose();
dgvItems.MultiSelect = true;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = true;
dgvItems.ScrollBars = ScrollBars.Vertical;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
//dgvItems.Columns["ReportValue"].Visible = true;
//dgvItems.Columns["ReportValue"].HeaderText = "";
//dgvItems.Columns["ReportValue"].Width = 388;
dgvItems.Columns["Module"].Visible = true;
dgvItems.Columns["Separator"].Visible = true;
dgvItems.Columns["Value"].Visible = true;
dgvItems.Columns["Module"].HeaderText = "";
dgvItems.Columns["Separator"].HeaderText = "";
dgvItems.Columns["Value"].HeaderText = "";
dgvItems.Columns["Module"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Separator"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvItems.Columns["Value"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Module"].Width = 230;
dgvItems.Columns["Separator"].Width = 20;
dgvItems.Columns["Value"].Width = dgvItems.Width-250-20;
}
private void PopulateTerminalReport()
{
lblCompany.Text = CompanyDetails.CompanyCode;
Receipt clsReceipt = new Receipt();
lblReportHeader1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
lblReportHeader2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
lblReportHeader3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
lblReportHeader4.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
lblGrossSales.Text = mDetails.GrossSales.ToString("#,##0.00");
lblTotalDiscount.Text = mDetails.TotalDiscount.ToString("#,##0.00");
lblNetSales.Text = mDetails.DailySales.ToString("#,##0.00");
lblVAT.Text = mDetails.VAT.ToString("#,##0.00");
lblCharge.Text = mDetails.TotalCharge.ToString("#,##0.00");
decimal TotalAmount = mDetails.DailySales + mDetails.VAT + mDetails.EVAT + mDetails.LocalTax + mDetails.TotalCharge;
lblTotalAmount.Text = TotalAmount.ToString("#,##0.00");
lblVAT1.Text = mDetails.VAT.ToString("#,##0.#0");
lblLocalTax.Text = mDetails.LocalTax.ToString("#,##0.#0");
lblCashSales.Text = mDetails.CashSales.ToString("#,##0.#0");
lblChequeSales.Text = mDetails.ChequeSales.ToString("#,##0.#0");
lblCreditCardSales.Text = mDetails.CreditCardSales.ToString("#,##0.#0");
lblCreditSales.Text = mDetails.CreditSales.ToString("#,##0.#0");
lblCreditPayment.Text = mDetails.CreditPayment.ToString("#,##0.#0");
lblCreditPaymentCash.Text = mDetails.CreditPaymentCash.ToString("#,##0.#0");
lblCreditPaymentCheque.Text = mDetails.CreditPaymentCheque.ToString("#,##0.#0");
lblCreditPaymentCreditCard.Text = mDetails.CreditPaymentCreditCard.ToString("#,##0.#0");
lblCreditPaymentDebit.Text = mDetails.CreditPaymentDebit.ToString("#,##0.#0");
lblDebitPayment.Text = mDetails.DebitPayment.ToString("#,##0.#0");
lblVoidSales.Text = mDetails.VoidSales.ToString("#,##0.#0");
lblRefundSales.Text = mDetails.RefundSales.ToString("#,##0.#0");
lblItemsDiscount.Text = mDetails.ItemsDiscount.ToString("#,##0.#0");
lblSubtotalDiscount.Text = mDetails.SubTotalDiscount.ToString("#,##0.#0");
lblTotalDiscounts.Text = mDetails.TotalDiscount.ToString("#,##0.#0");
lblBeginningBalance.Text = mDetails.BeginningBalance.ToString("#,##0.#0");
lblCashInDrawer.Text = mDetails.CashInDrawer.ToString("#,##0.#0");
lblPaidOut.Text = mDetails.TotalPaidOut.ToString("#,##0.#0");
lblCashDisburse.Text = mDetails.CashDisburse.ToString("#,##0.#0");
lblChequeDisburse.Text = mDetails.ChequeDisburse.ToString("#,##0.#0");
lblCreditCardDisburse.Text = mDetails.CreditCardDisburse.ToString("#,##0.#0");
lblCashWithHold.Text = mDetails.CashWithHold.ToString("#,##0.#0");
lblChequeWithHold.Text = mDetails.ChequeWithHold.ToString("#,##0.#0");
lblCreditCardWithHold.Text = mDetails.CreditCardWithHold.ToString("#,##0.#0");
lblCashDeposit.Text = mDetails.CashDeposit.ToString("#,##0.#0");
lblChequeDeposit.Text = mDetails.ChequeDeposit.ToString("#,##0.#0");
lblCreditCardDeposit.Text = mDetails.CreditCardDeposit.ToString("#,##0.#0");
lblNoOfCashTransactions.Text = mDetails.NoOfCashTransactions.ToString("#,##0");
lblNoOfChequeTransactions.Text = mDetails.NoOfChequeTransactions.ToString("#,##0");
lblNoOfCreditCardTran.Text = mDetails.NoOfCreditCardTransactions.ToString("#,##0");
lblNoOfCreditTran.Text = mDetails.NoOfCreditTransactions.ToString("#,##0");
lblNoOfCombPayTran.Text = mDetails.NoOfCombinationPaymentTransactions.ToString("#,##0");
lblNoOfCreditPaymentTran.Text = mDetails.NoOfCreditPaymentTransactions.ToString("#,##0");
lblNoOfDebitPaymentTransactions.Text = mDetails.NoOfDebitPaymentTransactions.ToString("#,##0");
lblNoOfRefundTransactions.Text = mDetails.NoOfRefundTransactions.ToString("#,##0");
lblNoOfVoidTransactions.Text = mDetails.NoOfVoidTransactions.ToString("#,##0");
lblNoOfTotalTransactions.Text = mDetails.NoOfTotalTransactions.ToString("#,##0");
lblCashCount.Text = mDetails.CashCount.ToString("#,##0.#0");
if (mDetails.CashInDrawer > mDetails.CashCount)
{
lblShortOverName.Text = "Short";
decimal decShort = mDetails.CashInDrawer - mDetails.CashCount;
lblShortOver.Text = decShort.ToString("#,##0.#0");
}
else if (mDetails.CashCount > mDetails.CashInDrawer)
{
lblShortOverName.Text = "Over";
decimal decOver = mDetails.CashCount - mDetails.CashInDrawer;
lblShortOver.Text = decOver.ToString("#,##0.#0");
}
else
{
lblShortOverName.Text = "";
lblShortOver.Text = "";
}
lblReportFooter1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
lblReportFooter2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
lblReportFooter3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
clsReceipt.CommitAndDispose();
}
private void PopulatePLUReport()
{
lblCompany.Text = CompanyDetails.CompanyCode;
lblStartDate.Text = "Start Date: " + mStartDate.ToString("MM/dd/yyyy hh:mm:ss tt") + Environment.NewLine;
lblEndDate.Text = "End Date : " + mEndDate.ToString("MM/dd/yyyy hh:mm:ss tt") + Environment.NewLine + Environment.NewLine;
Receipt clsReceipt = new Receipt();
lblReportHeader1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
lblReportHeader2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
lblReportHeader3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
lblReportHeader4.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
this.dgStyle.MappingName = mdtPLUReport.TableName;
dgPLUReport.DataSource = mdtPLUReport;
decimal TotalQuantity = 0;
decimal TotalAmount = 0;
try
{
foreach (System.Data.DataRow dr in mdtPLUReport.Rows)
{
TotalQuantity += Convert.ToDecimal(dr["Quantity"]);
TotalAmount += Convert.ToDecimal(dr["Amount"]);
}
dgPLUReport.Select(0);
}
catch { }
lblTotalQuantity.Text = TotalQuantity.ToString("#,##0.#0");
lblTotalAmount.Text = TotalAmount.ToString("#,##0.#0");
lblDiscount.Text = mCashierReportDetails.SubTotalDiscount.ToString("#,##0.#0");
decimal GrandTotal = mCashierReportDetails.DailySales + mCashierReportDetails.VAT + mCashierReportDetails.TotalCharge;
lblVATExempt.Text = (TotalAmount - GrandTotal - mCashierReportDetails.SubTotalDiscount).ToString("#,##0.#0");
lblCharge.Text = mCashierReportDetails.TotalCharge.ToString("#,##0.#0");
lblVAT.Text = mCashierReportDetails.VAT.ToString("#,##0.#0");
//put back in case inde gumana
lblVAT.Visible = !mclsTerminalDetails.IsVATInclusive;
lblVATName.Visible = !mclsTerminalDetails.IsVATInclusive;
lblGrandTotal.Text = GrandTotal.ToString("#,##0.#0");
lblReportFooter1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
lblReportFooter2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
lblReportFooter3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
clsReceipt.CommitAndDispose();
}
private void PopulateTerminalReport()
{
Receipt clsReceipt = new Receipt();
mclsTerminalDetails.MaxReceiptWidth = 94;
System.Data.DataTable dt = new System.Data.DataTable("tblTerminalReport");
dt.Columns.Add("Module");
dt.Columns.Add("Separator");
dt.Columns.Add("Value");
//dt.Rows.Add(CenterString(CompanyDetails.CompanyCode, mclsTerminalDetails.MaxReceiptWidth));
//dt.Rows.Add("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-'));
//dt.Rows.Add(CenterString("Terminal Report", mclsTerminalDetails.MaxReceiptWidth));
//dt.Rows.Add("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-'));
//string strReportHeader1 = clsReceipt.Details("ReportHeader1").Value;
//string strReportHeader2 = clsReceipt.Details("ReportHeader2").Value;
//string strReportHeader3 = clsReceipt.Details("ReportHeader3").Value;
//string strReportHeader4 = clsReceipt.Details("ReportHeader4").Value;
//if (!string.IsNullOrEmpty(strReportHeader1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader1), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader2), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader3), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader4)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader4), mclsTerminalDetails.MaxReceiptWidth));
if (Int64.Parse(mclsDetails.BeginningORNo) == 0)
dt.Rows.Add("Beginning OR No.", ":", mclsDetails.BeginningORNo.Remove(mclsDetails.BeginningORNo.Length - 1) + "1");
else
dt.Rows.Add("Beginning OR No.", ":", mclsDetails.BeginningORNo);
dt.Rows.Add("Ending OR No.", ":", mclsDetails.EndingORNo);
dt.Rows.Add("", "", "");
dt.Rows.Add("Gross Sales", ":", ((mclsDetails.GrossSales + mclsDetails.TotalCharge)).ToString("#,##0.#0"));
dt.Rows.Add("(-) Service Charge", ":", mclsDetails.TotalCharge.ToString("#,##0.#0"));
dt.Rows.Add("",":","------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Total Amount", ":", (mclsDetails.GrossSales).ToString("#,##0.#0"));
dt.Rows.Add("(-) " + mclsTerminalDetails.VAT.ToString("##") + "% VAT Exempt ", ":", (mclsDetails.VATExempt * (mclsTerminalDetails.VAT / 100)).ToString("#,##0.#0"));
dt.Rows.Add("(-) Discount", ":", (mclsDetails.SubTotalDiscount + mclsDetails.ItemsDiscount).ToString("#,##0.#0"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Net Sales", ":", (mclsDetails.NetSales).ToString("#,##0.#0"));
if (mclsTerminalDetails.WillPrintGrandTotal == true)
{
//switch (mTerminalReportType)
//{
// case Reports.TerminalReportType.XRead:
// case Reports.TerminalReportType.TerminalReport:
// case Reports.TerminalReportType.CashiersTerminalReport:
// dt.Rows.Add("-", "-", "-");
// dt.Rows.Add("OLD GRAND TOTAL", ":", (mclsDetails.eSalesOldGrandTotal).ToString("#,##0.#0"));
// dt.Rows.Add("This Total Amount", ":", (mclsDetails.GrossSales).ToString("#,##0.#0"));
// dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
// dt.Rows.Add("NEW GRAND TOTAL", ":", (mclsDetails.eSalesNewGrandTotal).ToString("#,##0.#0"));
// break;
// default:
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("OLD GRAND TOTAL", ":", (mclsDetails.OldGrandTotal).ToString("#,##0.#0"));
dt.Rows.Add("This Total Amount", ":", (mclsDetails.GrossSales).ToString("#,##0.#0"));
if (Math.Round((mclsDetails.NewGrandTotal - (mclsDetails.OldGrandTotal + mclsDetails.GrossSales))) != 0)
dt.Rows.Add(" (-) TF Consigned", ":", ((mclsDetails.OldGrandTotal + mclsDetails.GrossSales) - mclsDetails.NewGrandTotal).ToString("#,##0.#0"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("NEW GRAND TOTAL", ":", (mclsDetails.NewGrandTotal).ToString("#,##0.#0"));
// break;
//}
//dt.Rows.Add("-", "-", "-");
//dt.Rows.Add("OLD GRAND TOTAL", ":", (mclsDetails.eSalesOldGrandTotal).ToString("#,##0.#0"));
//dt.Rows.Add("This Total Amount", ":", (mclsDetails.GrossSales).ToString("#,##0.#0"));
//dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
//dt.Rows.Add("NEW GRAND TOTAL", ":", (mclsDetails.eSalesOldGrandTotal + mclsDetails.GrossSales).ToString("#,##0.#0"));
}
dt.Rows.Add("Taxables Breakdown", "", "");
dt.Rows.Add("VAT Exempt", ":", (mclsDetails.VATExempt).ToString("#,##0.00"));
dt.Rows.Add("VAT Zero Rated", ":", (mclsDetails.ZeroRatedSales).ToString("#,##0.00"));
dt.Rows.Add("NonVATable Amount", ":", (mclsDetails.NonVATableAmount).ToString("#,##0.00"));
dt.Rows.Add("VATable Amount", ":", (mclsDetails.VATableAmount).ToString("#,##0.00"));
dt.Rows.Add(mclsTerminalDetails.VAT.ToString("##") + "% VAT", ":", (mclsDetails.VAT).ToString("#,##0.00"));
dt.Rows.Add("Local Tax", ":", (mclsDetails.LocalTax).ToString("#,##0.00"));
dt.Rows.Add("Total Amount Breakdown", "", "");
dt.Rows.Add("Cash Sales", ":", (mclsDetails.CashSales).ToString("#,##0.00"));
dt.Rows.Add("Cheque Sales", ":", (mclsDetails.ChequeSales).ToString("#,##0.00"));
dt.Rows.Add("Credit Card Sales", ":", (mclsDetails.CreditCardSales).ToString("#,##0.00"));
dt.Rows.Add("Credit (Charge)", ":", (mclsDetails.CreditSales).ToString("#,##0.00"));
dt.Rows.Add("Credit Payment", ":", (mclsDetails.CreditPayment).ToString("#,##0.00"));
dt.Rows.Add(" Cash", ":", (mclsDetails.CreditPaymentCash).ToString("#,##0.00"));
dt.Rows.Add(" Cheque", ":", (mclsDetails.CreditPaymentCheque).ToString("#,##0.00"));
dt.Rows.Add(" Credit Card", ":", (mclsDetails.CreditPaymentCreditCard).ToString("#,##0.00"));
dt.Rows.Add(" Debit", ":", (mclsDetails.CreditPaymentDebit).ToString("#,##0.00"));
dt.Rows.Add("Debit Sales", ":", (mclsDetails.DebitPayment).ToString("#,##0.00"));
dt.Rows.Add(" Rewards Points Redeemed", ":", (mclsDetails.RewardPointsPayment).ToString("#,##0.00"));
dt.Rows.Add("Employee Acct.", ":", "0.00");
dt.Rows.Add("Void Sales", ":", (mclsDetails.VoidSales).ToString("#,##0.00"));
dt.Rows.Add("Refund Sales", ":", (mclsDetails.RefundSales).ToString("#,##0.00"));
dt.Rows.Add(" Cash", ":", (mclsDetails.RefundCash).ToString("#,##0.00"));
dt.Rows.Add(" Cheque", ":", (mclsDetails.RefundCheque).ToString("#,##0.00"));
dt.Rows.Add(" Credit Card", ":", (mclsDetails.RefundCreditCard).ToString("#,##0.00"));
dt.Rows.Add(" Credit", ":", (mclsDetails.RefundCredit).ToString("#,##0.00"));
dt.Rows.Add(" Debit", ":", (mclsDetails.RefundDebit).ToString("#,##0.00"));
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(clsReceipt.Connection, clsReceipt.Transaction);
System.Data.DataTable dtCreditCards = clsSalesTransactions.SalesPerCreditCard(mclsDetails.BranchID, mclsDetails.TerminalNo, 0, mclsDetails.DateLastInitialized, mclsDetails.NEXTDateLastInitialized);
if (dtCreditCards.Rows.Count > 0)
{
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Credit Card Breakdown", "", "");
dt.Rows.Add("-", "-", "-");
foreach (System.Data.DataRow dr in dtCreditCards.Rows)
{
dt.Rows.Add(dr["CardTypeCode"].ToString(), ":", (decimal.Parse(dr["Amount"].ToString()) * ((100 - mclsDetails.TrustFund) / 100)).ToString("#,##0.00"));
}
}
dt.Rows.Add("Discounts", "", "");
dt.Rows.Add("Items Discount", ":", (mclsDetails.ItemsDiscount).ToString("#,##0.00"));
dt.Rows.Add("Subtotal Discount", ":", (mclsDetails.SubTotalDiscount).ToString("#,##0.00"));
dt.Rows.Add(" Senior Citizen", ":", (mclsDetails.SNRDiscount).ToString("#,##0.00"));
dt.Rows.Add(" PWD", ":", (mclsDetails.PWDDiscount).ToString("#,##0.00"));
dt.Rows.Add(" Others", ":", (mclsDetails.OtherDiscount).ToString("#,##0.00"));
dt.Rows.Add("Total Discounts", ":", (mclsDetails.TotalDiscount).ToString("#,##0.00"));
clsSalesTransactions = new Data.SalesTransactions(clsReceipt.Connection, clsReceipt.Transaction);
System.Data.DataTable dtDiscounts = clsSalesTransactions.Discounts(mclsDetails.BranchID, mclsDetails.TerminalNo, mclsDetails.BeginningTransactionNo, mclsDetails.EndingTransactionNo);
if (dtDiscounts.Rows.Count > 0)
{
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Subtotal Discounts Breakdown", "", "");
dt.Rows.Add("-", "-", "-");
foreach (System.Data.DataRow dr in dtDiscounts.Rows)
{
dt.Rows.Add(dr["DiscountCode"].ToString(), ":", (decimal.Parse(dr["Discount"].ToString()) * ((100 - mclsDetails.TrustFund) / 100)).ToString("#,##0.00"));
}
}
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Drawer Information", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Beginning Balance", ":", (mclsDetails.BeginningBalance).ToString("#,##0.00"));
dt.Rows.Add("Cash In Drawer", ":", (mclsDetails.CashInDrawer).ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Paid Out", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Paid Out", ":", (mclsDetails.TotalPaidOut).ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("PICK UP / Disburstment", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash", ":", (mclsDetails.CashDisburse).ToString("#,##0.00"));
dt.Rows.Add("Cheque", ":", (mclsDetails.ChequeDisburse).ToString("#,##0.00"));
dt.Rows.Add("Credit Card", ":", (mclsDetails.CreditCardDisburse).ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Receive on Account", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash", ":", (mclsDetails.CashWithHold).ToString("#,##0.00"));
dt.Rows.Add("Cheque", ":", (mclsDetails.ChequeWithHold).ToString("#,##0.00"));
dt.Rows.Add("Credit Card", ":", (mclsDetails.CreditCardWithHold).ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Customer Deposits", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash", ":", (mclsDetails.CashDeposit).ToString("#,##0.00"));
dt.Rows.Add("Cheque", ":", (mclsDetails.ChequeDeposit).ToString("#,##0.00"));
dt.Rows.Add("Credit Card", ":", (mclsDetails.CreditCardDeposit).ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Transaction Count Breakdown", "", "");
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Cash Transactions", ":", mclsDetails.NoOfCashTransactions.ToString("#,##0.00"));
dt.Rows.Add("Cheque Transactions", ":", mclsDetails.NoOfChequeTransactions.ToString("#,##0.00"));
dt.Rows.Add("Credit Card Transactions", ":", mclsDetails.NoOfCreditCardTransactions.ToString("#,##0.00"));
dt.Rows.Add("Credit Transactions", ":", mclsDetails.NoOfCreditTransactions.ToString("#,##0.00"));
dt.Rows.Add("Debit Transactions", ":", mclsDetails.NoOfDebitPaymentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Refund Transactions", ":", mclsDetails.NoOfRefundTransactions.ToString("#,##0.00"));
dt.Rows.Add("Void Transactions", ":", mclsDetails.NoOfVoidTransactions.ToString("#,##0.00"));
dt.Rows.Add("Combination Trans", ":", mclsDetails.NoOfCombinationPaymentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Credit Payment Trans", ":", mclsDetails.NoOfCreditPaymentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Reward Points Trans", ":", mclsDetails.NoOfRewardPointsPayment.ToString("#,##0.00"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Total Transactions", ":", mclsDetails.NoOfTotalTransactions.ToString("#,##0.00"));
// 25Feb2015 : These lines will not be printed in the actual print-out
dt.Rows.Add("Misc Amount Breakdown", "", "");
dt.Rows.Add("Consignment", ":", (mclsDetails.ConsignmentSales).ToString("#,##0.00"));
dt.Rows.Add("Walk-In", ":", (mclsDetails.WalkInSales).ToString("#,##0.00"));
dt.Rows.Add("Out Of Stock", ":", (mclsDetails.OutOfStockSales).ToString("#,##0.00"));
dt.Rows.Add(" Refund", "", "");
dt.Rows.Add("Consignment", ":", (mclsDetails.ConsignmentRefundSales).ToString("#,##0.00"));
dt.Rows.Add("Walk-In", ":", (mclsDetails.WalkInRefundSales).ToString("#,##0.00"));
dt.Rows.Add("Out Of Stock", ":", (mclsDetails.OutOfStockRefundSales).ToString("#,##0.00"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("Consignment Trans", ":", mclsDetails.NoOfConsignmentTransactions.ToString("#,##0.00"));
dt.Rows.Add("Walk-In Trans", ":", mclsDetails.NoOfWalkInTransactions.ToString("#,##0.00"));
dt.Rows.Add("Out Of Stock Trans", ":", mclsDetails.NoOfOutOfStockTransactions.ToString("#,##0.00"));
dt.Rows.Add(" Refund", "", "");
dt.Rows.Add("Consignment Trans", ":", mclsDetails.NoOfConsignmentRefundTransactions.ToString("#,##0.00"));
dt.Rows.Add("Walk-In Trans", ":", mclsDetails.NoOfWalkInRefundTransactions.ToString("#,##0.00"));
dt.Rows.Add("Out Of Stock Trans", ":", mclsDetails.NoOfOutOfStockRefundTransactions.ToString("#,##0.00"));
// 25Feb2015 : End of lines
string strReportFooter1 = clsReceipt.Details("ReportFooter1").Value;
string strReportFooter2 = clsReceipt.Details("ReportFooter2").Value;
string strReportFooter3 = clsReceipt.Details("ReportFooter3").Value;
if (!string.IsNullOrEmpty(strReportFooter1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter1), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter2), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter3), mclsTerminalDetails.MaxReceiptWidth));
clsReceipt.CommitAndDispose();
dgvItems.MultiSelect = true;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = true;
dgvItems.ScrollBars = ScrollBars.Vertical;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
//dgvItems.Columns["ReportValue"].Visible = true;
//dgvItems.Columns["ReportValue"].HeaderText = "";
//dgvItems.Columns["ReportValue"].Width = 388;
dgvItems.Columns["Module"].Visible = true;
dgvItems.Columns["Separator"].Visible = true;
dgvItems.Columns["Value"].Visible = true;
dgvItems.Columns["Module"].HeaderText = "";
dgvItems.Columns["Separator"].HeaderText = "";
dgvItems.Columns["Value"].HeaderText = "";
dgvItems.Columns["Module"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Separator"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvItems.Columns["Value"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Module"].Width = 230;
dgvItems.Columns["Separator"].Width = 20;
dgvItems.Columns["Value"].Width = dgvItems.Width - 250 - 20;
}
private void PopulateGroupReport()
{
Receipt clsReceipt = new Receipt();
// disabled the trustfund
mTerminalReportDetails.TrustFund = 0;
mclsTerminalDetails.MaxReceiptWidth = 94;
System.Data.DataTable dt = new System.Data.DataTable("tblGroupReport");
dt.Columns.Add("Module");
dt.Columns.Add("Separator");
dt.Columns.Add("Value");
dt.Columns.Add("Prcntg");
decimal TotalTranCount = 0;
decimal TotalAmount = 0;
try
{
foreach (System.Data.DataRow dr in mdtGroupReport.Rows)
{
string ProductGroup = dr["ProductGroup"].ToString();
string TranCount = Convert.ToDecimal(dr["TranCount"].ToString()).ToString("#,##0");
string Amount = Convert.ToDecimal(dr["Amount"].ToString()).ToString("#,##0.#0");
string Percentage = dr["Percentage"].ToString();
TotalTranCount += decimal.Parse(Math.Round(Convert.ToDecimal(TranCount) * ((100 - mTerminalReportDetails.TrustFund) / 100), 2).ToString());
TotalAmount += decimal.Parse(Math.Round(Convert.ToDecimal(Amount) * ((100 - mTerminalReportDetails.TrustFund) / 100), 2).ToString());
dt.Rows.Add(ProductGroup, TranCount, Amount, Percentage);
}
}
catch { }
dt.Rows.Add("Total", TotalTranCount.ToString("#,##0.#0"), "", TotalAmount.ToString("#,##0.#0"));
dt.Rows.Add("(+) Items Disc/VatE", ":", "", ((mTerminalReportDetails.GrossSales - TotalAmount) * ((100 - mTerminalReportDetails.TrustFund) / 100)).ToString("#,##0.#0"));
dt.Rows.Add("-----------------------------------", "--", "----------", "----------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 80, '-'));
dt.Rows.Add("Gross Sales", ":", "", ((mTerminalReportDetails.GrossSales + mTerminalReportDetails.TotalCharge) * ((100 - mTerminalReportDetails.TrustFund) / 100)).ToString("#,##0.#0"));
dt.Rows.Add("(-) Service Charge", ":", "", mTerminalReportDetails.TotalCharge.ToString("#,##0.#0"));
dt.Rows.Add("-----------------------------------", "--", "----------", "----------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 80, '-'));
dt.Rows.Add("Total Amount", ":", "", (mTerminalReportDetails.GrossSales * ((100 - mTerminalReportDetails.TrustFund) / 100)).ToString("#,##0.#0"));
dt.Rows.Add("(-) " + mclsTerminalDetails.VAT.ToString("##") + "% VAT Exempt ", ":", "", (mTerminalReportDetails.VATExempt * (mclsTerminalDetails.VAT / 100) * ((100 - mTerminalReportDetails.TrustFund) / 100)).ToString("#,##0.#0"));
dt.Rows.Add("(-) Discount", ":", "", (mTerminalReportDetails.SubTotalDiscount + mTerminalReportDetails.ItemsDiscount).ToString("#,##0.#0"));
dt.Rows.Add("-----------------------------------", "--", "----------", "----------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 80, '-'));
dt.Rows.Add("Net Sales", ":", "", (mTerminalReportDetails.NetSales * ((100 - mTerminalReportDetails.TrustFund) / 100)).ToString("#,##0.#0"));
string strReportFooter1 = clsReceipt.Details("ReportFooter1").Value;
string strReportFooter2 = clsReceipt.Details("ReportFooter2").Value;
string strReportFooter3 = clsReceipt.Details("ReportFooter3").Value;
if (!string.IsNullOrEmpty(strReportFooter1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter1), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter2), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter3), mclsTerminalDetails.MaxReceiptWidth));
clsReceipt.CommitAndDispose();
dgvItems.MultiSelect = true;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = true;
dgvItems.ScrollBars = ScrollBars.Vertical;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
//dgvItems.Columns["ReportValue"].Visible = true;
//dgvItems.Columns["ReportValue"].HeaderText = "";
//dgvItems.Columns["ReportValue"].Width = 388;
dgvItems.Columns["Module"].Visible = true;
dgvItems.Columns["Separator"].Visible = true;
dgvItems.Columns["Value"].Visible = true;
dgvItems.Columns["Prcntg"].Visible = true;
dgvItems.Columns["Module"].HeaderText = "Group";
dgvItems.Columns["Separator"].HeaderText = "Qty";
dgvItems.Columns["Value"].HeaderText = "Amount";
dgvItems.Columns["Prcntg"].HeaderText = "Prcntg.";
dgvItems.Columns["Module"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
dgvItems.Columns["Separator"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvItems.Columns["Value"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Prcntg"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Module"].Width = 200;
dgvItems.Columns["Separator"].Width = 40;
dgvItems.Columns["Value"].Width = (dgvItems.Width - 220 - 40) / 2;
dgvItems.Columns["Prcntg"].Width = (dgvItems.Width - 220 - 40) / 2;
}
private void PopulateTerminalReport1()
{
mclsTerminalDetails.MaxReceiptWidth = 94;
System.Data.DataTable dt = new System.Data.DataTable("tblTerminalReport");
dt.Columns.Add("Module");
dt.Columns.Add("Separator");
dt.Columns.Add("Value");
//dt.Rows.Add(CenterString(CompanyDetails.CompanyCode, mclsTerminalDetails.MaxReceiptWidth));
//dt.Rows.Add("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-'));
//dt.Rows.Add(CenterString("Terminal Report", mclsTerminalDetails.MaxReceiptWidth));
//dt.Rows.Add("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-'));
Receipt clsReceipt = new Receipt();
//string strReportHeader1 = clsReceipt.Details("ReportHeader1").Value;
//string strReportHeader2 = clsReceipt.Details("ReportHeader2").Value;
//string strReportHeader3 = clsReceipt.Details("ReportHeader3").Value;
//string strReportHeader4 = clsReceipt.Details("ReportHeader4").Value;
//if (!string.IsNullOrEmpty(strReportHeader1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader1), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader2), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader3), mclsTerminalDetails.MaxReceiptWidth));
//if (!string.IsNullOrEmpty(strReportHeader4)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportHeader4), mclsTerminalDetails.MaxReceiptWidth));
dt.Rows.Add("Beginning OR No.", ":" , mDetails.BeginningORNo);
string strEndingORNo = (Int64.Parse(mDetails.EndingORNo) - 1).ToString().PadLeft(mDetails.BeginningORNo.Length, '0');
dt.Rows.Add("Ending OR No.", ":", strEndingORNo);
dt.Rows.Add("Gross Sales",":", (mDetails.GrossSales + mDetails.TotalCharge).ToString("#,##0.#0"));
dt.Rows.Add("(-) Service Charge", ":", mDetails.TotalCharge.ToString("#,##0.#0"));
dt.Rows.Add("",":","------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("Total Amount", ":", mDetails.GrossSales.ToString("#,##0.#0"));
dt.Rows.Add("-", "-", "-");
dt.Rows.Add("OLD GRAND TOTAL", ":", mDetails.OldGrandTotal.ToString("#,##0.#0"));
dt.Rows.Add("This Total Amount", ":", mDetails.GrossSales.ToString("#,##0.#0"));
dt.Rows.Add("", ":", "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 66, '-'));
dt.Rows.Add("NEW GRAND TOTAL", ":", mDetails.NewGrandTotal.ToString("#,##0.#0"));
string strReportFooter1 = clsReceipt.Details("ReportFooter1").Value;
string strReportFooter2 = clsReceipt.Details("ReportFooter2").Value;
string strReportFooter3 = clsReceipt.Details("ReportFooter3").Value;
if (!string.IsNullOrEmpty(strReportFooter1)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter1), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter2)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter2), mclsTerminalDetails.MaxReceiptWidth));
if (!string.IsNullOrEmpty(strReportFooter3)) dt.Rows.Add(CenterString(GetReceiptFormatParameter(strReportFooter3), mclsTerminalDetails.MaxReceiptWidth));
clsReceipt.CommitAndDispose();
dgvItems.MultiSelect = true;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = true;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
//dgvItems.Columns["ReportValue"].Visible = true;
//dgvItems.Columns["ReportValue"].HeaderText = "";
//dgvItems.Columns["ReportValue"].Width = 388;
dgvItems.Columns["Module"].Visible = true;
dgvItems.Columns["Separator"].Visible = true;
dgvItems.Columns["Value"].Visible = true;
dgvItems.Columns["Module"].HeaderText = "";
dgvItems.Columns["Separator"].HeaderText = "";
dgvItems.Columns["Value"].HeaderText = "";
dgvItems.Columns["Module"].Width = 230;
dgvItems.Columns["Separator"].Width = 20;
dgvItems.Columns["Value"].Width = 138;
lblTaxableAmount.Text = Convert.ToDecimal(mDetails.VATableAmount).ToString("#,##0.00");
lblNonTaxableAmount.Text = Convert.ToDecimal(mDetails.NonVATableAmount).ToString("#,##0.00");
lblVAT1.Text = Convert.ToDecimal(mDetails.VAT).ToString("#,##0.#0");
lblLocalTax.Text = Convert.ToDecimal(mDetails.LocalTax).ToString("#,##0.#0");
lblCashSales.Text = Convert.ToDecimal(mDetails.CashSales).ToString("#,##0.#0");
lblChequeSales.Text = Convert.ToDecimal(mDetails.ChequeSales).ToString("#,##0.#0");
lblCreditCardSales.Text = Convert.ToDecimal(mDetails.CreditCardSales).ToString("#,##0.#0");
lblCreditSales.Text = Convert.ToDecimal(mDetails.CreditSales).ToString("#,##0.#0");
lblCreditPayment.Text = Convert.ToDecimal(mDetails.CreditPayment).ToString("#,##0.#0");
// Apr 12, 2014 added the breakdown
lblCreditPaymentCash.Text = Convert.ToDecimal(mDetails.CreditPaymentCash).ToString("#,##0.#0");
lblCreditPaymentCheque.Text = Convert.ToDecimal(mDetails.CreditPaymentCheque).ToString("#,##0.#0");
lblCreditPaymentCreditCard.Text = Convert.ToDecimal(mDetails.CreditPaymentCreditCard).ToString("#,##0.#0");
lblCreditPaymentDebit.Text = Convert.ToDecimal(mDetails.CreditPaymentDebit).ToString("#,##0.#0");
lblDebitPayment.Text = Convert.ToDecimal(mDetails.DebitPayment).ToString("#,##0.#0");
lblVoidSales.Text = Convert.ToDecimal(mDetails.VoidSales).ToString("#,##0.#0");
lblRefundSales.Text = Convert.ToDecimal(mDetails.RefundSales).ToString("#,##0.#0");
lblItemsDiscount.Text = Convert.ToDecimal(mDetails.ItemsDiscount).ToString("#,##0.#0");
lblSubtotalDiscount.Text = Convert.ToDecimal(mDetails.SubTotalDiscount).ToString("#,##0.#0");
lblTotalDiscounts.Text = Convert.ToDecimal(mDetails.TotalDiscount).ToString("#,##0.#0");
lblBeginningBalance.Text = Convert.ToDecimal(mDetails.BeginningBalance).ToString("#,##0.#0");
lblCashInDrawer.Text = Convert.ToDecimal(mDetails.CashInDrawer).ToString("#,##0.#0");
lblPaidOut.Text = Convert.ToDecimal(mDetails.TotalPaidOut).ToString("#,##0.#0");
lblCashDisburse.Text = Convert.ToDecimal(mDetails.CashDisburse).ToString("#,##0.#0");
lblChequeDisburse.Text = Convert.ToDecimal(mDetails.ChequeDisburse).ToString("#,##0.#0");
lblCreditCardDisburse.Text = Convert.ToDecimal(mDetails.CreditCardDisburse).ToString("#,##0.#0");
lblCashWithHold.Text = Convert.ToDecimal(mDetails.CashWithHold).ToString("#,##0.#0");
lblChequeWithHold.Text = Convert.ToDecimal(mDetails.ChequeWithHold).ToString("#,##0.#0");
lblCreditCardWithHold.Text = Convert.ToDecimal(mDetails.CreditCardWithHold).ToString("#,##0.#0");
lblCashDeposit.Text = Convert.ToDecimal(mDetails.CashDeposit).ToString("#,##0.#0");
lblChequeDeposit.Text = Convert.ToDecimal(mDetails.ChequeDeposit).ToString("#,##0.#0");
lblCreditCardDeposit.Text = Convert.ToDecimal(mDetails.CreditCardDeposit).ToString("#,##0.#0");
//lblGrossSales.Text = Convert.ToDecimal(mDetails.GrossSales - (mDetails.GrossSales * (mTrustFund / 100))).ToString("#,##0.00");
//lblTotalDiscount.Text = Convert.ToDecimal(mDetails.TotalDiscount - (mDetails.TotalDiscount * (mTrustFund / 100))).ToString("#,##0.00");
//lblNetSales.Text = Convert.ToDecimal(mDetails.DailySales - (mDetails.DailySales * (mTrustFund / 100))).ToString("#,##0.00");
//lblVAT.Text = Convert.ToDecimal(mDetails.VAT - (mDetails.VAT * (mTrustFund / 100))).ToString("#,##0.00");
//lblCharge.Text = Convert.ToDecimal(mDetails.TotalCharge - (mDetails.TotalCharge * (mTrustFund / 100))).ToString("#,##0.00");
//decimal TotalAmount = mDetails.DailySales + mDetails.VAT + mDetails.EVAT + mDetails.LocalTax + mDetails.TotalCharge;
//lblTotalAmount.Text = Convert.ToDecimal(TotalAmount - (TotalAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblOldGrandTotal.Text = Convert.ToDecimal(mDetails.OldGrandTotal - (mDetails.OldGrandTotal * (mTrustFund / 100))).ToString("#,##0.00");
//lblDailySales.Text = Convert.ToDecimal(TotalAmount - (TotalAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblNewGrandTotal.Text = Convert.ToDecimal(mDetails.NewGrandTotal - (mDetails.NewGrandTotal * (mTrustFund / 100))).ToString("#,##0.00");
//lblTaxableAmount.Text = Convert.ToDecimal(mDetails.VATableAmount - (mDetails.VATableAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblNonTaxableAmount.Text = Convert.ToDecimal(mDetails.NonVaTableAmount - (mDetails.NonVaTableAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblVAT1.Text = Convert.ToDecimal(mDetails.VAT - (mDetails.VAT * (mTrustFund / 100))).ToString("#,##0.#0");
//lblLocalTax.Text = Convert.ToDecimal(mDetails.LocalTax - (mDetails.LocalTax * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashSales.Text = Convert.ToDecimal(mDetails.CashSales - (mDetails.CashSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeSales.Text = Convert.ToDecimal(mDetails.ChequeSales - (mDetails.ChequeSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardSales.Text = Convert.ToDecimal(mDetails.CreditCardSales - (mDetails.CreditCardSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditSales.Text = Convert.ToDecimal(mDetails.CreditSales - (mDetails.CreditSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditPayment.Text = Convert.ToDecimal(mDetails.CreditPayment - (mDetails.CreditPayment * (mTrustFund / 100))).ToString("#,##0.#0");
//lblDebitPayment.Text = Convert.ToDecimal(mDetails.DebitPayment - (mDetails.DebitPayment * (mTrustFund / 100))).ToString("#,##0.#0");
//lblVoidSales.Text = Convert.ToDecimal(mDetails.VoidSales - (mDetails.VoidSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblRefundSales.Text = Convert.ToDecimal(mDetails.RefundSales - (mDetails.RefundSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblItemsDiscount.Text = Convert.ToDecimal(mDetails.ItemsDiscount - (mDetails.ItemsDiscount * (mTrustFund / 100))).ToString("#,##0.#0");
//lblSubtotalDiscount.Text = Convert.ToDecimal(mDetails.SubTotalDiscount - (mDetails.SubTotalDiscount * (mTrustFund / 100))).ToString("#,##0.#0");
//lblTotalDiscounts.Text = Convert.ToDecimal(mDetails.TotalDiscount - (mDetails.TotalDiscount * (mTrustFund / 100))).ToString("#,##0.#0");
//lblBeginningBalance.Text = Convert.ToDecimal(mDetails.BeginningBalance - (mDetails.BeginningBalance * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashInDrawer.Text = Convert.ToDecimal(mDetails.CashInDrawer - (mDetails.CashInDrawer * (mTrustFund / 100))).ToString("#,##0.#0");
//lblPaidOut.Text = Convert.ToDecimal(mDetails.TotalPaidOut - (mDetails.TotalPaidOut * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashDisburse.Text = Convert.ToDecimal(mDetails.CashDisburse - (mDetails.CashDisburse * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeDisburse.Text = Convert.ToDecimal(mDetails.ChequeDisburse - (mDetails.ChequeDisburse * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardDisburse.Text = Convert.ToDecimal(mDetails.CreditCardDisburse - (mDetails.CreditCardDisburse * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashWithHold.Text = Convert.ToDecimal(mDetails.CashWithHold - (mDetails.CashWithHold * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeWithHold.Text = Convert.ToDecimal(mDetails.ChequeWithHold - (mDetails.ChequeWithHold * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardWithHold.Text = Convert.ToDecimal(mDetails.CreditCardWithHold - (mDetails.CreditCardWithHold * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashDeposit.Text = Convert.ToDecimal(mDetails.CashDeposit - (mDetails.CashDeposit * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeDeposit.Text = Convert.ToDecimal(mDetails.ChequeDeposit - (mDetails.ChequeDeposit * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardDeposit.Text = Convert.ToDecimal(mDetails.CreditCardDeposit - (mDetails.CreditCardDeposit * (mTrustFund / 100))).ToString("#,##0.#0");
lblNoOfCashTransactions.Text = mDetails.NoOfCashTransactions.ToString("#,##0");
lblNoOfChequeTransactions.Text = mDetails.NoOfChequeTransactions.ToString("#,##0");
lblNoOfCreditCardTran.Text = mDetails.NoOfCreditCardTransactions.ToString("#,##0");
lblNoOfCreditTran.Text = mDetails.NoOfCreditTransactions.ToString("#,##0");
lblNoOfCombPayTran.Text = mDetails.NoOfCombinationPaymentTransactions.ToString("#,##0");
lblNoOfCreditPaymentTran.Text = mDetails.NoOfCreditPaymentTransactions.ToString("#,##0");
lblNoOfDebitPaymentTransactions.Text = mDetails.NoOfDebitPaymentTransactions.ToString("#,##0");
lblNoOfRefundTransactions.Text = mDetails.NoOfRefundTransactions.ToString("#,##0");
lblNoOfVoidTransactions.Text = mDetails.NoOfVoidTransactions.ToString("#,##0");
lblNoOfTotalTransactions.Text = mDetails.NoOfTotalTransactions.ToString("#,##0");
}
private void PopulateHourlyReport()
{
lblCompany.Text = CompanyDetails.CompanyCode;
Receipt clsReceipt = new Receipt();
lblReportHeader1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
lblReportHeader2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
lblReportHeader3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
lblReportHeader4.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
this.dgStyle.MappingName = mdtHourlyReport.TableName;
dgHourlyReport.DataSource = mdtHourlyReport;
decimal TotalTranCount = 0;
decimal TotalAmount = 0;
decimal TotalDiscount = 0;
try
{
dgHourlyReport.Select(0);
foreach (System.Data.DataRow dr in mdtHourlyReport.Rows)
{
TotalTranCount += Convert.ToDecimal(dr["TranCount"]);
TotalAmount += Convert.ToDecimal(dr["Amount"]);
TotalDiscount += Convert.ToDecimal(dr["Discount"]);
}
}
catch { }
lblTotalTran.Text = TotalTranCount.ToString("#,##0");
lblTotalAmount.Text = TotalAmount.ToString("#,##0.#0");
lblTotalDiscount.Text = TotalDiscount.ToString("#,##0.#0");
lblReportFooter1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
lblReportFooter2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
lblReportFooter3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
clsReceipt.CommitAndDispose();
}
private void PopulateTerminalReport()
{
lblCompany.Text = CompanyDetails.CompanyCode;
Receipt clsReceipt = new Receipt();
lblReportHeader1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
lblReportHeader2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
lblReportHeader3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
lblReportHeader4.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
lblBeginningTransactionNo.Text = mDetails.BeginningORNo;
lblEndingTransactionNo.Text = mDetails.EndingORNo;
lblGrossSales.Text = Convert.ToDecimal(mDetails.GrossSales).ToString("#,##0.00");
lblTotalDiscount.Text = Convert.ToDecimal(mDetails.TotalDiscount).ToString("#,##0.00");
lblNetSales.Text = Convert.ToDecimal(mDetails.DailySales).ToString("#,##0.00");
lblVAT.Text = Convert.ToDecimal(mDetails.VAT).ToString("#,##0.00");
lblCharge.Text = Convert.ToDecimal(mDetails.TotalCharge).ToString("#,##0.00");
decimal TotalAmount = mDetails.DailySales + mDetails.VAT + mDetails.EVAT + mDetails.LocalTax + mDetails.TotalCharge;
lblTotalAmount.Text = Convert.ToDecimal(TotalAmount).ToString("#,##0.00");
lblOldGrandTotal.Text = Convert.ToDecimal(mDetails.OldGrandTotal - (mDetails.OldGrandTotal * (mTrustFund / 100))).ToString("#,##0.00");
lblDailySales.Text = Convert.ToDecimal(TotalAmount).ToString("#,##0.00");
lblNewGrandTotal.Text = Convert.ToDecimal((mDetails.OldGrandTotal - (mDetails.OldGrandTotal * (mTrustFund / 100))) + TotalAmount).ToString("#,##0.00");
lblTaxableAmount.Text = Convert.ToDecimal(mDetails.VATableAmount).ToString("#,##0.00");
lblNonTaxableAmount.Text = Convert.ToDecimal(mDetails.NonVATableAmount).ToString("#,##0.00");
lblVAT1.Text = Convert.ToDecimal(mDetails.VAT).ToString("#,##0.#0");
lblLocalTax.Text = Convert.ToDecimal(mDetails.LocalTax).ToString("#,##0.#0");
lblCashSales.Text = Convert.ToDecimal(mDetails.CashSales).ToString("#,##0.#0");
lblChequeSales.Text = Convert.ToDecimal(mDetails.ChequeSales).ToString("#,##0.#0");
lblCreditCardSales.Text = Convert.ToDecimal(mDetails.CreditCardSales).ToString("#,##0.#0");
lblCreditSales.Text = Convert.ToDecimal(mDetails.CreditSales).ToString("#,##0.#0");
lblCreditPayment.Text = Convert.ToDecimal(mDetails.CreditPayment).ToString("#,##0.#0");
// Apr 12, 2014 added the breakdown
lblCreditPaymentCash.Text = Convert.ToDecimal(mDetails.CreditPaymentCash).ToString("#,##0.#0");
lblCreditPaymentCheque.Text = Convert.ToDecimal(mDetails.CreditPaymentCheque).ToString("#,##0.#0");
lblCreditPaymentCreditCard.Text = Convert.ToDecimal(mDetails.CreditPaymentCreditCard).ToString("#,##0.#0");
lblCreditPaymentDebit.Text = Convert.ToDecimal(mDetails.CreditPaymentDebit).ToString("#,##0.#0");
lblDebitPayment.Text = Convert.ToDecimal(mDetails.DebitPayment).ToString("#,##0.#0");
lblVoidSales.Text = Convert.ToDecimal(mDetails.VoidSales).ToString("#,##0.#0");
lblRefundSales.Text = Convert.ToDecimal(mDetails.RefundSales).ToString("#,##0.#0");
lblItemsDiscount.Text = Convert.ToDecimal(mDetails.ItemsDiscount).ToString("#,##0.#0");
lblSubtotalDiscount.Text = Convert.ToDecimal(mDetails.SubTotalDiscount).ToString("#,##0.#0");
lblTotalDiscounts.Text = Convert.ToDecimal(mDetails.TotalDiscount).ToString("#,##0.#0");
lblBeginningBalance.Text = Convert.ToDecimal(mDetails.BeginningBalance).ToString("#,##0.#0");
lblCashInDrawer.Text = Convert.ToDecimal(mDetails.CashInDrawer).ToString("#,##0.#0");
lblPaidOut.Text = Convert.ToDecimal(mDetails.TotalPaidOut).ToString("#,##0.#0");
lblCashDisburse.Text = Convert.ToDecimal(mDetails.CashDisburse).ToString("#,##0.#0");
lblChequeDisburse.Text = Convert.ToDecimal(mDetails.ChequeDisburse).ToString("#,##0.#0");
lblCreditCardDisburse.Text = Convert.ToDecimal(mDetails.CreditCardDisburse).ToString("#,##0.#0");
lblCashWithHold.Text = Convert.ToDecimal(mDetails.CashWithHold).ToString("#,##0.#0");
lblChequeWithHold.Text = Convert.ToDecimal(mDetails.ChequeWithHold).ToString("#,##0.#0");
lblCreditCardWithHold.Text = Convert.ToDecimal(mDetails.CreditCardWithHold).ToString("#,##0.#0");
lblCashDeposit.Text = Convert.ToDecimal(mDetails.CashDeposit).ToString("#,##0.#0");
lblChequeDeposit.Text = Convert.ToDecimal(mDetails.ChequeDeposit).ToString("#,##0.#0");
lblCreditCardDeposit.Text = Convert.ToDecimal(mDetails.CreditCardDeposit).ToString("#,##0.#0");
//lblGrossSales.Text = Convert.ToDecimal(mDetails.GrossSales - (mDetails.GrossSales * (mTrustFund / 100))).ToString("#,##0.00");
//lblTotalDiscount.Text = Convert.ToDecimal(mDetails.TotalDiscount - (mDetails.TotalDiscount * (mTrustFund / 100))).ToString("#,##0.00");
//lblNetSales.Text = Convert.ToDecimal(mDetails.DailySales - (mDetails.DailySales * (mTrustFund / 100))).ToString("#,##0.00");
//lblVAT.Text = Convert.ToDecimal(mDetails.VAT - (mDetails.VAT * (mTrustFund / 100))).ToString("#,##0.00");
//lblCharge.Text = Convert.ToDecimal(mDetails.TotalCharge - (mDetails.TotalCharge * (mTrustFund / 100))).ToString("#,##0.00");
//decimal TotalAmount = mDetails.DailySales + mDetails.VAT + mDetails.EVAT + mDetails.LocalTax + mDetails.TotalCharge;
//lblTotalAmount.Text = Convert.ToDecimal(TotalAmount - (TotalAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblOldGrandTotal.Text = Convert.ToDecimal(mDetails.OldGrandTotal - (mDetails.OldGrandTotal * (mTrustFund / 100))).ToString("#,##0.00");
//lblDailySales.Text = Convert.ToDecimal(TotalAmount - (TotalAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblNewGrandTotal.Text = Convert.ToDecimal(mDetails.NewGrandTotal - (mDetails.NewGrandTotal * (mTrustFund / 100))).ToString("#,##0.00");
//lblTaxableAmount.Text = Convert.ToDecimal(mDetails.VATableAmount - (mDetails.VATableAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblNonTaxableAmount.Text = Convert.ToDecimal(mDetails.NonVaTableAmount - (mDetails.NonVaTableAmount * (mTrustFund / 100))).ToString("#,##0.00");
//lblVAT1.Text = Convert.ToDecimal(mDetails.VAT - (mDetails.VAT * (mTrustFund / 100))).ToString("#,##0.#0");
//lblLocalTax.Text = Convert.ToDecimal(mDetails.LocalTax - (mDetails.LocalTax * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashSales.Text = Convert.ToDecimal(mDetails.CashSales - (mDetails.CashSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeSales.Text = Convert.ToDecimal(mDetails.ChequeSales - (mDetails.ChequeSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardSales.Text = Convert.ToDecimal(mDetails.CreditCardSales - (mDetails.CreditCardSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditSales.Text = Convert.ToDecimal(mDetails.CreditSales - (mDetails.CreditSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditPayment.Text = Convert.ToDecimal(mDetails.CreditPayment - (mDetails.CreditPayment * (mTrustFund / 100))).ToString("#,##0.#0");
//lblDebitPayment.Text = Convert.ToDecimal(mDetails.DebitPayment - (mDetails.DebitPayment * (mTrustFund / 100))).ToString("#,##0.#0");
//lblVoidSales.Text = Convert.ToDecimal(mDetails.VoidSales - (mDetails.VoidSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblRefundSales.Text = Convert.ToDecimal(mDetails.RefundSales - (mDetails.RefundSales * (mTrustFund / 100))).ToString("#,##0.#0");
//lblItemsDiscount.Text = Convert.ToDecimal(mDetails.ItemsDiscount - (mDetails.ItemsDiscount * (mTrustFund / 100))).ToString("#,##0.#0");
//lblSubtotalDiscount.Text = Convert.ToDecimal(mDetails.SubTotalDiscount - (mDetails.SubTotalDiscount * (mTrustFund / 100))).ToString("#,##0.#0");
//lblTotalDiscounts.Text = Convert.ToDecimal(mDetails.TotalDiscount - (mDetails.TotalDiscount * (mTrustFund / 100))).ToString("#,##0.#0");
//lblBeginningBalance.Text = Convert.ToDecimal(mDetails.BeginningBalance - (mDetails.BeginningBalance * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashInDrawer.Text = Convert.ToDecimal(mDetails.CashInDrawer - (mDetails.CashInDrawer * (mTrustFund / 100))).ToString("#,##0.#0");
//lblPaidOut.Text = Convert.ToDecimal(mDetails.TotalPaidOut - (mDetails.TotalPaidOut * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashDisburse.Text = Convert.ToDecimal(mDetails.CashDisburse - (mDetails.CashDisburse * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeDisburse.Text = Convert.ToDecimal(mDetails.ChequeDisburse - (mDetails.ChequeDisburse * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardDisburse.Text = Convert.ToDecimal(mDetails.CreditCardDisburse - (mDetails.CreditCardDisburse * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashWithHold.Text = Convert.ToDecimal(mDetails.CashWithHold - (mDetails.CashWithHold * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeWithHold.Text = Convert.ToDecimal(mDetails.ChequeWithHold - (mDetails.ChequeWithHold * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardWithHold.Text = Convert.ToDecimal(mDetails.CreditCardWithHold - (mDetails.CreditCardWithHold * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCashDeposit.Text = Convert.ToDecimal(mDetails.CashDeposit - (mDetails.CashDeposit * (mTrustFund / 100))).ToString("#,##0.#0");
//lblChequeDeposit.Text = Convert.ToDecimal(mDetails.ChequeDeposit - (mDetails.ChequeDeposit * (mTrustFund / 100))).ToString("#,##0.#0");
//lblCreditCardDeposit.Text = Convert.ToDecimal(mDetails.CreditCardDeposit - (mDetails.CreditCardDeposit * (mTrustFund / 100))).ToString("#,##0.#0");
lblNoOfCashTransactions.Text = mDetails.NoOfCashTransactions.ToString("#,##0");
lblNoOfChequeTransactions.Text = mDetails.NoOfChequeTransactions.ToString("#,##0");
lblNoOfCreditCardTran.Text = mDetails.NoOfCreditCardTransactions.ToString("#,##0");
lblNoOfCreditTran.Text = mDetails.NoOfCreditTransactions.ToString("#,##0");
lblNoOfCombPayTran.Text = mDetails.NoOfCombinationPaymentTransactions.ToString("#,##0");
lblNoOfCreditPaymentTran.Text = mDetails.NoOfCreditPaymentTransactions.ToString("#,##0");
lblNoOfDebitPaymentTransactions.Text = mDetails.NoOfDebitPaymentTransactions.ToString("#,##0");
lblNoOfRefundTransactions.Text = mDetails.NoOfRefundTransactions.ToString("#,##0");
lblNoOfVoidTransactions.Text = mDetails.NoOfVoidTransactions.ToString("#,##0");
lblNoOfTotalTransactions.Text = mDetails.NoOfTotalTransactions.ToString("#,##0");
lblReportFooter1.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
lblReportFooter2.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
lblReportFooter3.Text = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
clsReceipt.CommitAndDispose();
}
private void SetParameters (ReportDocument Report)
{
ParameterFieldDefinition paramField;
ParameterValues currentValues;
ParameterDiscreteValue discreteParam;
paramField = Report.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyName;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
Receipt clsReceipt = new Receipt();
paramField = Report.DataDefinition.ParameterFields["ReportHeader1"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader1").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ReportHeader2"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader2").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ReportHeader3"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader3").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ReportHeader4"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportHeader4").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
/**** Set the report footer ****/
paramField = Report.DataDefinition.ParameterFields["ReportFooter1"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter1").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ReportFooter2"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter2").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ReportFooter3"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = GetReceiptFormatParameter(clsReceipt.Details("ReportFooter3").Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
clsReceipt.CommitAndDispose();
}