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
{
private void Form1_Shown(object sender, EventArgs e)
{
dtpFromDate.Text = System.DateTime.Now.ToString("d MMMM yyy");
dtpToDate.Text = System.DateTime.Now.ToString("d MMMM yyy");
cboClientName.Items.Insert(0, "All");
cboClientName.Text = "All";
cboOrderBy.Text = cboOrderBy.Items[0].ToString();
lblReason.Visible = chkShowPayouts.Checked;
cboReason.Visible = chkShowPayouts.Checked;
cboReason.Items.Insert(0, "All");
cboReason.Text = "All";
chkShowQuotations.Text = "Show " + Report.GetColumnValue("programs_config.QuotationDefaultName").ToString();
chkShowProforma.Text = "Show " + Report.GetColumnValue("programs_config.ProformaDefaultName").ToString();
string confPayOutReasons = Report.GetColumnValue("PayoutReasons.PayOutReasons").ToString();
string[] reasons = confPayOutReasons.Split(new[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
if (reasons.Length > 0)
{
foreach (string reason in reasons)
{
cboReason.Items.Add(reason);
}
}
else
{
cboReason.Items.Add("No reasons to choose from");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
Report.SetParameterValue("FromDate", dtpFromDate.Value.ToString("yyyy-MM-dd"));
Report.SetParameterValue("ToDate", dtpToDate.Value.ToString("yyyy-MM-dd"));
string orderBy = String.Empty;
if (cboOrderBy.Text == "Date")
orderBy = "DATE_FORMAT(`Date`,'%Y-%m-%d')";
else if (cboOrderBy.Text == "Document #")
orderBy = "TransID";
else if (cboOrderBy.Text == "Client Name")
orderBy = "ClientName";
else if (cboOrderBy.Text == "Sales Rep")
orderBy = "SalesRep";
//For a specific client
string forClient = "ID >= 0";
if (cboClientName.Text != "All")
forClient = String.Format("ClientName = '{0}'", cboClientName.Text);
//IBT
grpHeadIBT.Printable = chkShowIBT.Checked;
DataIBT.Printable = chkShowIBT.Checked;
GrpFootIBT.Printable = chkShowIBT.Checked;
grpHeadIBTreturn.Printable = chkShowIBT.Checked;
DataIBTreturn.Printable = chkShowIBT.Checked;
grpFootIBTreturn.Printable = chkShowIBT.Checked;
ChildIBT.Printable = chkShowIBT.Checked;
//Quotations
grpHeadQuotations.Printable = chkShowQuotations.Checked;
DataQuotations.Printable = chkShowQuotations.Checked;
grpFootQuotations.Printable = chkShowQuotations.Checked;
//Proforma Invoices
grpHeadProforma.Printable = chkShowProforma.Checked;
DataProforma.Printable = chkShowProforma.Checked;
grpFootProforma.Printable = chkShowProforma.Checked;
//Payouts
grpHeadPayouts.Printable = chkShowPayouts.Checked;
DataPayouts.Printable = chkShowPayouts.Checked;
grpFootPayouts.Printable = chkShowPayouts.Checked;
if (chkShowIBT.Checked)
{
TableDataSource tIBT = Report.GetDataSource("IBT") as TableDataSource;
TableDataSource tIBTreturn = Report.GetDataSource("IBT_returns") as TableDataSource;
tIBT.SelectCommand = tIBT.SelectCommand.ToString().Replace("@OrderBy", orderBy);
tIBTreturn.SelectCommand = tIBTreturn.SelectCommand.ToString().Replace("@OrderBy", orderBy);
tIBT.SelectCommand = tIBT.SelectCommand.ToString().Replace("@ForClient", forClient);
tIBTreturn.SelectCommand = tIBTreturn.SelectCommand.ToString().Replace("@ForClient", forClient);
}
if (chkShowQuotations.Checked)
{
TableDataSource tQuotations = Report.GetDataSource("Quotations") as TableDataSource;
tQuotations.SelectCommand = tQuotations.SelectCommand.ToString().Replace("@OrderBy", orderBy);
tQuotations.SelectCommand = tQuotations.SelectCommand.ToString().Replace("@ForClient", forClient);
}
if (chkShowProforma.Checked)
{
TableDataSource tProforma = Report.GetDataSource("Proforma") as TableDataSource;
tProforma.SelectCommand = tProforma.SelectCommand.ToString().Replace("@OrderBy", orderBy);
tProforma.SelectCommand = tProforma.SelectCommand.ToString().Replace("@ForClient", forClient);
}
if (chkShowPayouts.Checked)
{
//For a specific Reason
string Reason = "TransID >= 0";
if (cboReason.Text != "All")
Reason = String.Format("Reason = '{0}'", cboReason.Text.Trim());
TableDataSource tPayouts = Report.GetDataSource("Payouts") as TableDataSource;
tPayouts.SelectCommand = tPayouts.SelectCommand.ToString().Replace("@Reason", Reason);
tPayouts.SelectCommand = tPayouts.SelectCommand.ToString().Replace("@OrderBy", orderBy);
}
}
private void Child2_AfterData(object sender, EventArgs e)
{
txtTotCostIBT.Text = (Report.GetTotalValue("TotalCost_IBT") - Report.GetTotalValue("TotalCost_IBT_Return")).ToString();
decimal number = 0;
if (Decimal.TryParse(txtTotCostIBT.Text, out number))
txtTotCostIBT.Text = Convert.ToDecimal(txtTotCostIBT.Text).ToString("# ###.00");
}
private void chkShowPayouts_Click(object sender, EventArgs e)
{
lblReason.Visible = chkShowPayouts.Checked;
cboReason.Visible = chkShowPayouts.Checked;
}
}
}