private void btnPaySmryRoute_Click(object sender, EventArgs e)
{
DataTable dataSetReport = new DataTable();
dataSetReport.TableName = "SupplierPaymentsSummaryTown";
BoughtLeafBusinessLayer.MothlyPaymentSummary myMonthlySummary = new BoughtLeafBusinessLayer.MothlyPaymentSummary();
dataSetReport = myMonthlySummary.getSupplierPaymentsDetailByRoute(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())).Tables[0];
dataSetReport.WriteXml("SupplierPaymentsSummaryTown.xml");
SupplierPaymentSummaryRouteRPT myReport = new SupplierPaymentSummaryRouteRPT();
myReport.SetDataSource(dataSetReport);
ReportViewer rptViewer = new ReportViewer();
myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myReport.SetParameterValue("PayRate", mySettings.getKiloRate(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())).ToString("N2"));
myReport.SetParameterValue("CheckTotal", myBank.getCheckPaymentTotal(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())));
myReport.SetParameterValue("BankTotal", myMonthlySummary.getBankPaymentSummaryTotal(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())));
myReport.SetParameterValue("CashTotal", myMonthlySummary.getCashPaymentSummaryTotal(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())));
myReport.SetParameterValue("Year", cmbYear.Text);
myReport.SetParameterValue("SupCount", myMonthlySummary.getMonthlyActiveSupplier(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())));
myReport.SetParameterValue("Month", cmbMonth.SelectedValue.ToString());
rptViewer.crystalReportViewer1.ReportSource = myReport;
rptViewer.Show();
}
//Start Sachintha edited code 2016.10.12
private void btnPaySmryDetail_Click(object sender, EventArgs e)
{
string strRoute = "%";
if (chkRoute.Checked)
{
strRoute = "%";
}
else
{
strRoute = cmbRoute.SelectedValue.ToString();
}
DataTable dataSetReport = new DataTable();
dataSetReport.TableName = "SupplierPaymentsSummaryDetail";
BoughtLeafBusinessLayer.MothlyPaymentSummary myMonthlySummary = new BoughtLeafBusinessLayer.MothlyPaymentSummary();
string supCode = string.Empty;
if (chkSupplier.Checked == true)
{
supCode = "%";
}
else
{
supCode = cmbSupplier.SelectedValue.ToString();
}
dataSetReport = myMonthlySummary.getSupplierPaymentsDetail(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), supCode, strRoute).Tables[0];
dataSetReport.WriteXml("SupplierPaymentsSummaryDetail.xml");
SupplierPaymentSummaryDetailRPT2 myReport = new SupplierPaymentSummaryDetailRPT2();
myReport.SetDataSource(dataSetReport);
ReportViewer rptViewer = new ReportViewer();
myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myReport.SetParameterValue("PayRate", mySettings.getKiloRate(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())).ToString("N2"));
myReport.SetParameterValue("Year", cmbYear.Text);
myReport.SetParameterValue("Month", cmbMonth.SelectedValue.ToString());
if (chkRoute.Checked == true)
{
myReport.SetParameterValue("Route", "All Routes");
}
else
{
myReport.SetParameterValue("Route", cmbRoute.Text);
}
rptViewer.crystalReportViewer1.ReportSource = myReport;
rptViewer.Show();
}
private void btnCollectorPayment_Click(object sender, EventArgs e)
{
DataTable dataSetReport = new DataTable();
dataSetReport.TableName = "SupplierIncentiveDetails";
BoughtLeafBusinessLayer.MothlyPaymentSummary myMonthlySummary = new BoughtLeafBusinessLayer.MothlyPaymentSummary();
string supRoute = "%";
if (!chkRoute.Checked)
{
supRoute = cmbRoute.SelectedValue.ToString();
}
string supCode = string.Empty;
if (chkSupplier.Checked == true)
{
supCode = "%";
}
else
{
supCode = cmbSupplier.SelectedValue.ToString();
}
dataSetReport = myMonthlySummary.ListCollectorPayment(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), "%").Tables[0];
dataSetReport.TableName = "CollectorPayment";
dataSetReport.WriteXml("CollecotrPaymentDetails.xml");
CollectorPaymentDetailsRPT myReport = new CollectorPaymentDetailsRPT();
myReport.SetDataSource(dataSetReport);
ReportViewer rptViewer = new ReportViewer();
myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myReport.SetParameterValue("Year", cmbYear.Text);
myReport.SetParameterValue("Month", cmbMonth.SelectedValue.ToString());
rptViewer.crystalReportViewer1.ReportSource = myReport;
rptViewer.Show();
}
private void btnNMDebt_Click(object sender, EventArgs e)
{
DataTable dataSetReport = new DataTable();
dataSetReport.TableName = "NextMonthSummary";
BoughtLeafBusinessLayer.MothlyPaymentSummary myMonthlySummary = new BoughtLeafBusinessLayer.MothlyPaymentSummary();
dataSetReport = myMonthlySummary.getNextMonthDebts(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString())).Tables[0];
dataSetReport.WriteXml("NextMonthSummary.xml");
NextMonthDebtSummaryRPT myReport = new NextMonthDebtSummaryRPT();
myReport.SetDataSource(dataSetReport);
ReportViewer rptViewer = new ReportViewer();
myReport.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myReport.SetParameterValue("Year", cmbYear.Text);
myReport.SetParameterValue("Month", cmbMonth.SelectedValue.ToString());
rptViewer.crystalReportViewer1.ReportSource = myReport;
rptViewer.Show();
}
