private void cmdShow_Click(object sender, EventArgs e)
{
try
{
DataTable dataSetReport = new DataTable();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
dataSetReport = myReports.getPaymentSlipS(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dataSetReport.WriteXml("PaymentSlip.xml");
DataTable NewDt = myReports.getDayWiseGreenLeaf(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
NewDt.TableName = "DayLeaf";
NewDt.WriteXml("DayGreenLeaf.xml");
DataTable Newdt1 = myReports.getSalarySlipDetailItems(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
Newdt1.TableName = "SalaryItems";
Newdt1.WriteXml("SalaryItems.xml");
//GetCashBalance
PaySlipRPT myaclist = new PaySlipRPT();
//BoughtleafPayslipRPT
myaclist.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
myaclist.SetDataSource(dataSetReport);
myaclist.Subreports["Leaf"].SetDataSource(NewDt);
myaclist.Subreports["Item"].SetDataSource(Newdt1);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("year", cmbYear.Text);
myaclist.SetParameterValue("month", cmbMonth.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.crystalReportViewer1.DisplayGroupTree = true;
myReportViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDouble_Click(object sender, EventArgs e)
{
try
{
if (cmbMonth.SelectedIndex == -1)
{
MessageBox.Show("Please Select The Month");
}
else
{
if (radioButton1.Checked == true && radioButton1.Text == "Sinhala")
{
//MessageBox.Show("dasdasd");
DataSet dsGeneral = new DataSet();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
dsGeneral = myReports.GetSupplierPaymentForPaySlipGeneral(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGeneral.Tables[0].TableName = "GetSupplierPaymentForPaySlipGeneral";
//dataSetReport.WriteXml("PaymentSlip.xml");
DataSet dsGreenLeaf = myReports.GetSupplierPaymentForPaySlipGreenLeaf(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGreenLeaf.Tables[0].TableName = "GetSupplierPaymentForPaySlipGreenLeaf";
// NewDt.WriteXml("DayGreenLeaf.xml");
DataSet dsThisMonthIssues = myReports.GetSupplierPaymentForPaySlipThisMonthIssues(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsThisMonthIssues.Tables[0].TableName = "GetSupplierPaymentForPaySlipThisMonthIssues";
PayslipRPT_Sinhala myaclist = new PayslipRPT_Sinhala();
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGeneral"].SetDataSource(dsGeneral.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGreenLeaf"].SetDataSource(dsGreenLeaf.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipThisMonthIssues"].SetDataSource(dsThisMonthIssues.Tables[0]);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myaclist.SetParameterValue("company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myaclist.SetParameterValue("factory", BoughtLeafBusinessLayer.BLUser.getFactoryName());
myReportViewer.crystalReportViewer1.DisplayGroupTree = true;
myReportViewer.Show();
}
else if (radioButton2.Checked == true && radioButton2.Text == "English")
{
//;
DataSet dsGeneral = new DataSet();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
dsGeneral = myReports.GetSupplierPaymentForPaySlipGeneral(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGeneral.Tables[0].TableName = "GetSupplierPaymentForPaySlipGeneral";
//dataSetReport.WriteXml("PaymentSlip.xml");
DataSet dsGreenLeaf = myReports.GetSupplierPaymentForPaySlipGreenLeaf(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGreenLeaf.Tables[0].TableName = "GetSupplierPaymentForPaySlipGreenLeaf";
// NewDt.WriteXml("DayGreenLeaf.xml");
DataSet dsThisMonthIssues = myReports.GetSupplierPaymentForPaySlipThisMonthIssues(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsThisMonthIssues.Tables[0].TableName = "GetSupplierPaymentForPaySlipThisMonthIssues";
PayslipRPT_English myaclist = new PayslipRPT_English();
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGeneral"].SetDataSource(dsGeneral.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGreenLeaf"].SetDataSource(dsGreenLeaf.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipThisMonthIssues"].SetDataSource(dsThisMonthIssues.Tables[0]);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myaclist.SetParameterValue("company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myaclist.SetParameterValue("factory", BoughtLeafBusinessLayer.BLUser.getFactoryName());
myReportViewer.crystalReportViewer1.DisplayGroupTree = true;
myReportViewer.Show();
}
else if (radioButton1.Checked == true && radioButton1.Text == "Pre Printed")
{
if (BoughtLeafBusinessLayer.BLUser.getCompanyCode().ToUpper() == "APL")
{
DataSet dsGeneral = new DataSet();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
dsGeneral = myReports.GetSupplierPaymentForPaySlipGeneral(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGeneral.Tables[0].TableName = "GetSupplierPaymentForPaySlipGeneral";
//dataSetReport.WriteXml("PaymentSlip.xml");
DataSet dsGreenLeaf = myReports.GetSupplierPaymentForPaySlipGreenLeaf(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGreenLeaf.Tables[0].TableName = "GetSupplierPaymentForPaySlipGreenLeaf";
// NewDt.WriteXml("DayGreenLeaf.xml");
DataSet dsThisMonthIssues = myReports.GetSupplierPaymentForPaySlipThisMonthIssues(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsThisMonthIssues.Tables[0].TableName = "GetSupplierPaymentForPaySlipThisMonthIssues";
APLPayslipRPT myaclist = new APLPayslipRPT();
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGeneral"].SetDataSource(dsGeneral.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGreenLeaf"].SetDataSource(dsGreenLeaf.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipThisMonthIssues"].SetDataSource(dsThisMonthIssues.Tables[0]);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myaclist.SetParameterValue("company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myaclist.SetParameterValue("factory", BoughtLeafBusinessLayer.BLUser.getFactoryName());
myReportViewer.crystalReportViewer1.DisplayGroupTree = true;
myReportViewer.Show();
}
else if (BoughtLeafBusinessLayer.BLUser.getCompanyCode().ToUpper() == "KTFL")
{
DataSet dsGeneral = new DataSet();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
dsGeneral = myReports.GetSupplierPaymentForPaySlipGeneral(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGeneral.Tables[0].TableName = "GetSupplierPaymentForPaySlipGeneral";
//dataSetReport.WriteXml("PaymentSlip.xml");
DataSet dsGreenLeaf = myReports.GetSupplierPaymentForPaySlipGreenLeaf(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGreenLeaf.Tables[0].TableName = "GetSupplierPaymentForPaySlipGreenLeaf";
// NewDt.WriteXml("DayGreenLeaf.xml");
DataSet dsThisMonthIssues = myReports.GetSupplierPaymentForPaySlipThisMonthIssues(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsThisMonthIssues.Tables[0].TableName = "GetSupplierPaymentForPaySlipThisMonthIssues";
dsThisMonthIssues.WriteXml("ThisMonthIssuesXml.xml");
KTFLPayslip myaclist = new KTFLPayslip();
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGeneral"].SetDataSource(dsGeneral.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGreenLeaf"].SetDataSource(dsGreenLeaf.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipThisMonthIssues"].SetDataSource(dsThisMonthIssues.Tables[0]);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
//myaclist.SetParameterValue("company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
// myaclist.SetParameterValue("factory", BoughtLeafBusinessLayer.BLUser.getFactoryName());
myReportViewer.crystalReportViewer1.DisplayGroupTree = true;
myReportViewer.Show();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnShow_Click(object sender, EventArgs e)
{
try
{
DataSet dsGeneral = new DataSet();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
dsGeneral = myReports.GetSupplierPaymentForPaySlipGeneral(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGeneral.Tables[0].TableName = "GetSupplierPaymentForPaySlipGeneral";
//dataSetReport.WriteXml("PaymentSlip.xml");
DataSet dsGreenLeaf = myReports.GetSupplierPaymentForPaySlipGreenLeaf(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsGreenLeaf.Tables[0].TableName = "GetSupplierPaymentForPaySlipGreenLeaf";
// NewDt.WriteXml("DayGreenLeaf.xml");
DataSet dsThisMonthIssues = myReports.GetSupplierPaymentForPaySlipThisMonthIssues(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
dsThisMonthIssues.Tables[0].TableName = "GetSupplierPaymentForPaySlipThisMonthIssues";
//Newdt1.WriteXml("SalaryItems.xml");
//GetCashBalance
PaySlipRPT01 myaclist = new PaySlipRPT01();
#region Payslip Paper Selection
PrintDocument pDoc = new PrintDocument();
int paperNo = 0;
for (int j = 0; j < pDoc.PrinterSettings.PaperSizes.Count; j++)
{
if (pDoc.PrinterSettings.PaperSizes[j].PaperName.Equals("lol1"))
{
paperNo = (int)pDoc.PrinterSettings.PaperSizes[j].RawKind;
break;
}
}
// myaclist.PrintOptions.PrinterName = "EPSON LQ-2190 ESC/P2";
myaclist.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)paperNo;
myaclist.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Auto;
#endregion
//BoughtleafPayslipRPT
//DataSet FinalDs = new DataSet();
//FinalDs.Tables.Add(dsGeneral.Tables[0]);
//FinalDs.Tables.Add(dsGreenLeaf.Tables[0]);
//FinalDs.Tables.Add(dsThisMonthIssues.Tables[0]);
//myaclist.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
//myaclist.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.DefaultPaperSize;
// myaclist.SetDataSource(dsGeneral.Tables[0]);
//myaclist.SetDataSource(dsGreenLeaf.Tables[0]);
// myaclist.SetDataSource(dsThisMonthIssues.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGeneral"].SetDataSource(dsGeneral.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipGreenLeaf"].SetDataSource(dsGreenLeaf.Tables[0]);
myaclist.Database.Tables["GetSupplierPaymentForPaySlipThisMonthIssues"].SetDataSource(dsThisMonthIssues.Tables[0]);
//myaclist.Subreports["Leaf"].SetDataSource(NewDt);
//myaclist.Subreports["Item"].SetDataSource(Newdt1);
ReportViewer myReportViewer = new ReportViewer();
//myaclist.SetParameterValue("year", cmbYear.Text);
//myaclist.SetParameterValue("month", cmbMonth.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.crystalReportViewer1.DisplayGroupTree = true;
myReportViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}