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)
{
//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;
//Is VatRegistered
if (Report.GetColumnValue("companies.VATno").ToString().Length > 0)
isVatRegistered = true;
}
private void PageHeader1_AfterData(object sender, EventArgs e)
{
//Print the User
if (Report.GetColumnValue("trans.User").ToString().Length == 0)
txtUser.Text = String.Empty;
}
private void Child1_AfterData(object sender, EventArgs e)
{
bool dataToPrint = false;
if (txtCustomText1.Text.Length > 0)
{
txtCustomText1.Visible = true;
txtCustomLabel1.Visible = true;
dataToPrint = true;
}
if (txtCustomText2.Text.Length > 0)
{
txtCustomText2.Visible = true;
txtCustomLabel2.Visible = true;
dataToPrint = true;
}
if (txtCustomText3.Text.Length > 0)
{
txtCustomText3.Visible = true;
txtCustomLabel3.Visible = true;
dataToPrint = true;
}
if (txtCustomText4.Text.Length > 0)
{
txtCustomText4.Visible = true;
txtCustomLabel4.Visible = true;
dataToPrint = true;
}
if (txtCustomText5.Text.Length > 0)
{
txtCustomText5.Visible = true;
txtCustomLabel5.Visible = true;
dataToPrint = true;
}
if (txtCustomText6.Text.Length > 0)
{
txtCustomText6.Visible = true;
txtCustomLabel6.Visible = true;
dataToPrint = true;
}
if (dataToPrint)
{
txtCustomHeader.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 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"));
}
//exclude notes
if (Report.GetColumnValue("trans_items.ProductCode").ToString().Length > 0)
{
txtQty.Text = String.Format("{0:F" + decimalValue + "}", qty);
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) + " @ " + priceBeforeDiscount.ToString("# ### ###.00");
txtItemTotalD.Text = total.ToString("# ### ###.00");
txtDiscountD.Text = discount.ToString("0.##") + "%";
}
}
}
private void Child3_AfterData(object sender, EventArgs e)
{
if (zeroRatedItemsFound > 0)
lblZeroRated.Visible = true;
}
}
}