using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Windows.Forms; using System.Drawing; using System.Data; using FastReport; using FastReport.Data; using FastReport.Dialog; using FastReport.Barcode; using FastReport.Table; using FastReport.Utils; namespace FastReport { public class ReportScript { int decimalValue = 0; bool showDiscount = false; int zeroRatedItemsFound = 0; bool isVatRegistered = false; private void _StartReport(object sender, EventArgs e) { //Style string stylePath = Report.GetParameterValue("MainAppPath").ToString() + "\\Resources\\DocStyles\\Styles\\" + Report.GetColumnValue("companies.InvoiceStylePath").ToString(); if (stylePath.Length > 0) { picStyle.ImageLocation = stylePath; } //Logo string logoPath = Report.GetColumnValue("companies.LogoPath").ToString(); if (logoPath.Length > 0) { picLogo.ImageLocation = Report.GetParameterValue("MainAppPath").ToString() + "\\Resources\\Logos\\" + logoPath; picLogo.Printable = true; } else { picLogo.Printable = false; } //Qty Column format decimalValue = Convert.ToInt32(Report.GetColumnValue("programs_config.QtyDecimalValue")); //Show Discount if (Report.GetColumnValue("programs_config.ShowDiscountOnSalesDocument").ToString() == "1") showDiscount = true; HeaderDefault.Visible = !showDiscount; DataDefault.Visible = !showDiscount; HeaderDiscount.Visible = showDiscount; DataDiscount.Visible = showDiscount; txtTotLines.Visible = !showDiscount; txtTotLinesD.Visible = showDiscount; txtTotQty.Visible = !showDiscount; txtTotQtyD.Visible = showDiscount; //Is VatRegistered if (Report.GetColumnValue("companies.VATno").ToString().Length > 0) isVatRegistered = true; //Show Amount Due on Sales docs if (Report.GetColumnValue("programs_config.ShowAmountDueOnSalesDocs").ToString() == "1") { lblAmountDue.Visible = true; txtAmountDue.Visible = true; } else { lblAmountDue.Visible = false; txtAmountDue.Visible = false; } } private void PageHeader1_AfterData(object sender, EventArgs e) { //Invoice OR Tax Invoice if (Report.GetColumnValue("companies.VATno").ToString().Length > 0) txtInvoice.Text = "Tax Invoice"; else txtInvoice.Text = "Invoice"; //Print the SalesRep if (Report.GetColumnValue("trans.SalesRep").ToString().Length == 0) { txtSalesRep1.Visible = false; txtSalesRep2.Visible = false; } //Print the Delivery Address if (Report.GetColumnValue("trans.DeliveryAddress").ToString().Length == 0) { shpDelAddress.Visible = false; txtDelAddress1.Visible = false; txtDelAddress2.Visible = false; } } private void Child1_AfterData(object sender, EventArgs e) { if (txtCustomText1.Text.Length > 0) { txtCustomText1.Visible = true; txtCustomLabel1.Visible = true; } if (txtCustomText2.Text.Length > 0) { txtCustomText2.Visible = true; txtCustomLabel2.Visible = true; } if (txtCustomText3.Text.Length > 0) { txtCustomText3.Visible = true; txtCustomLabel3.Visible = true; } if (txtCustomText4.Text.Length > 0) { txtCustomText4.Visible = true; txtCustomLabel4.Visible = true; } if (txtCustomText5.Text.Length > 0) { txtCustomText5.Visible = true; txtCustomLabel5.Visible = true; } if (txtCustomText6.Text.Length > 0) { txtCustomText6.Visible = true; txtCustomLabel6.Visible = true; } } private void Data1_AfterData(object sender, EventArgs e) { //Zero Rated marker if (Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalVAT")) == 0 & Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0 & isVatRegistered) { txtZeroRated.Text = "*"; txtZeroRatedD.Text = "*"; zeroRatedItemsFound++; } else { txtZeroRated.Text = string.Empty; txtZeroRatedD.Text = string.Empty; } if (!showDiscount) //Only do this when showing the default header and data { //Include when items were sold with a zero qty decimal qty = Convert.ToDecimal(Report.GetColumnValue("trans_items.Qty")); decimal unitPrice = 0; decimal total = 0; if (qty != 0) { //Total if (Report.GetColumnValue("programs_config.InvShowRetailPriceExcl").ToString() == "1") total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingExcl")); else total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingIncl")); //Unit Price unitPrice = (total / qty); } //exclude notes if (Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0) { txtQty.Text = String.Format("{0:F" + decimalValue + "}", qty); txtItemPrice.Text = unitPrice.ToString("# ### ###.00"); txtItemTotal.Text = total.ToString("# ### ###.00"); } } } private void DataDiscount_AfterData(object sender, EventArgs e) { //Zero Rated marker if (Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalVAT")) == 0 & Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0 & isVatRegistered) { txtZeroRated.Text = "*"; txtZeroRatedD.Text = "*"; zeroRatedItemsFound++; } else { txtZeroRated.Text = string.Empty; txtZeroRatedD.Text = string.Empty; } if (showDiscount) //Only do this when configured to show the discount { //Include when items were sold with a zero qty decimal qty = Convert.ToDecimal(Report.GetColumnValue("trans_items.Qty")); decimal unitPrice = 0; decimal total = 0; decimal discount = 0; decimal priceBeforeDiscount = 0; if (qty != 0) { //Total if (Report.GetColumnValue("programs_config.InvShowRetailPriceExcl").ToString() == "1") total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingExcl")); else total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingIncl")); //Unit Price unitPrice = (total / qty); //Discount discount = Convert.ToDecimal(Report.GetColumnValue("trans_items.Discount")); //Price before discount if (discount == 0 | discount == 100) priceBeforeDiscount = unitPrice; else priceBeforeDiscount = unitPrice / (1 - (discount / 100)); } //exclude notes if (Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0) { txtQtyD.Text = String.Format("{0:F" + decimalValue + "}", qty); txtItemPriceD.Text = priceBeforeDiscount.ToString("# ### ###.00"); txtItemTotalD.Text = total.ToString("# ### ###.00"); txtDiscountD.Text = discount.ToString("0.##") + "%"; } } } private void Data2_AfterData(object sender, EventArgs e) { if (zeroRatedItemsFound > 0) lblZeroRated.Visible = true; } private void PageFooter1_AfterData(object sender, EventArgs e) { //Total Due decimal totDue = Convert.ToDecimal(Report.GetColumnValue("trans.TotalIncl")) - Convert.ToDecimal(Report.GetColumnValue("trans.TotalPaid")) - Convert.ToDecimal(Report.GetColumnValue("trans.TotalCrNotesIncl")); if (totDue == 0) picPaid.Visible = true; else picPaid.Visible = false; //Total Qty field - format decimal qtyVal = 0; if (Decimal.TryParse(txtTotQty.Text, out qtyVal)) { txtTotQty.Text = "Total Qty: " + String.Format("{0:F" + decimalValue + "}", qtyVal); } if (Decimal.TryParse(txtTotQtyD.Text, out qtyVal)) { txtTotQtyD.Text = "Total Qty: " + String.Format("{0:F" + decimalValue + "}", qtyVal); } } } }