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.ShowDiscountOnSalesDocument").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;
//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
{
txtVatNo.Text = String.Empty;
txtInvoice.Text = "Invoice";
}
//Reg No
if (Report.GetColumnValue("companies.RegNo").ToString().Length == 0)
txtRegNo.Text = String.Empty;
//Tel No
if (Report.GetColumnValue("companies.ContactNo").ToString().Length == 0)
txtTelNo.Text = String.Empty;
//Alt Tel No
if (Report.GetColumnValue("companies.AltNo").ToString().Length == 0)
txtAltNo.Text = String.Empty;
//Email
if (Report.GetColumnValue("companies.Email").ToString().Length == 0)
txtEmail.Text = String.Empty;
//Print the SalesRep
if (Report.GetColumnValue("trans.SalesRep").ToString().Length == 0)
txtSalesRep2.Text = String.Empty;
//Invoice To
if (Report.GetColumnValue("trans.ClientName").ToString().Length == 0)
txtInvoiceTo.Text = String.Empty;
}
private void Child1_AfterData(object sender, EventArgs e)
{
//Print the Delivery Address
if (Report.GetColumnValue("trans.DeliveryAddress").ToString().Length == 0)
{
txtDelAddress1.Text = String.Empty;
txtDelAddress2.Text = String.Empty;
}
}
private void Child2_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 (Report.GetColumnValue("programs_config.InvShowRetailPriceExcl").ToString() == "1")
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingExcl"));
else
total = Convert.ToDecimal(Report.GetColumnValue("trans_items.TotalSellingIncl"));
}
//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 (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)
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 Data2_AfterData(object sender, EventArgs e)
{
if (zeroRatedItemsFound > 0)
lblZeroRated.Visible = true;
}
private void Child3_AfterData(object sender, EventArgs e)
{
//Banking Details
if (Report.GetColumnValue("companies.BankingDetails").ToString().Length == 0)
txtBankingDetails.Text = String.Empty;
}
}
}