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.ShowDiscountOnPurchaseDocument").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;
}
private void PageHeader1_AfterData(object sender, EventArgs e)
{
//Print the Delivery Address
if (Report.GetColumnValue("trans.DeliveryAddress").ToString().Length == 0)
{
shpDelAddress.Visible = false;
txtDelAddress1.Visible = false;
txtDelAddress2.Visible = false;
}
//Print the User
if (Report.GetColumnValue("trans.User").ToString().Length == 0)
{
lblUser.Visible = false;
txtUser.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 (String.Compare(Report.GetColumnValue("suppliers.TaxOnInvoice").ToString(), "inclusive", true) == 0)
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalIncl"));
else
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalExcl"));
//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 (String.Compare(Report.GetColumnValue("suppliers.TaxOnInvoice").ToString(), "inclusive", true) == 0)
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalIncl"));
else
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalExcl"));
//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 PageFooter1_AfterData(object sender, EventArgs e)
{
//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);
}
if (zeroRatedItemsFound > 0)
lblZeroRated.Visible = true;
}
}
}