private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (optDatewise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("SD");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSales", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optProductwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbProductName.SelectedIndex == 0 ? "0" : cmbProductName.SelectedValue.ToString());
para_value.Add("SP");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSales", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optCustomerwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Customer_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbCustomerName.SelectedIndex == 0 ? "0" : cmbCustomerName.SelectedValue.ToString());
para_value.Add("SK");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSales", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else
{
}
}
catch (Exception err)
{
err.GetBaseException();
}
clear();
}
private void FRM_Customer_Ledger_Load(object sender, EventArgs e)
{
para.Clear();
paraname.Clear();
paraname.Add("@flag");
para.Add("12");
DataSet ds = bl_obj.blFill_para_name(paraname, para, "SP_FILLDDL");
function.fillcombo(cmbCustomerName, ds.Tables[0]);
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (optGstr3.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("GT");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptGSTTax", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optGstr1.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("GSTR1");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RPTGSTR", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
else if (optGstr2.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("GSTR2");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RPTGSTR", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
catch (Exception err)
{ err.GetBaseException(); }
clear();
}
private void FRM_RPTGENERALLEDGER_Load(object sender, EventArgs e)
{
//function.settheme(this);
//DataSet ds = bl_obj.blFill("SP_CustomerMaster");
para.Clear();
paraname.Clear();
paraname.Add("@flag");
para.Add("11");
DataSet ds = bl_obj.blFill_para_name(paraname, para, "SP_FILLDDL");
function.fillcombo(cmbCustomerName, ds.Tables[0]);
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
List <string> para_value = new List <string>();
if (cmbCustomerName.SelectedIndex == 0)
{
para_name.Clear();
para_value.Clear();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("ACTD");
}
else
{
para_name.Clear();
para_value.Clear();
para_name.Add("@Customer_Id");
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
para_value.Add(cmbCustomerName.SelectedValue.ToString());
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("CCTD");
}
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("rptDateWiseAllCustTotal", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
catch (Exception err)
{
err.GetBaseException();
}
clear();
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(cmbRootName.SelectedValue.ToString());
para_value.Add("RT");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptRoot", ds, 0);
}
catch (Exception err)
{
err.GetBaseException();
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(txtInvoiceNo.Text);
para_value.Add("SI");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptSalesInvoice", ds, 0);
}
catch (Exception err)
{
err.GetBaseException();
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add("RP");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("rptProductionReport", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
catch (Exception err)
{ err.GetBaseException(); }
clear();
}
private void Report_Viewer_Load(object sender, EventArgs e)
{
function.settheme(this);
//--------*********>>>>>>>>>>>>>>>>> Binding a Report Master Form <<<<<<<<<<<<<<<*********--------
if (module_Rpt.rpt_name.CompareTo("FRM_EMPLOYEEMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_EmployeeMaster");
doc = new RptEmployeeMaster();
doc.Database.Tables["Tbl_EmployeeMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_ITEMMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_ItemMaster");
doc = new RptItemMaster();
doc.Database.Tables["Tbl_ItemMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_CUSTOMERMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_CustomerMaster");
doc = new RptCustomerMaster();
doc.Database.Tables["Tbl_CustomerMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_TRANSPORTATION_MASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_TransportationMaster");
doc = new RptTransportationMaster();
doc.Database.Tables["Tbl_TransportationMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_EXPENCESMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_ExpencesMaster");
doc = new RptExpencesMaster();
doc.Database.Tables["Tbl_ExpencesMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_ROWMATERIAL") == 0)
{
DataSet ds = bl_obj.blFill("SP_RowHedar");
doc = new RptRowMaterial();
doc.Database.Tables["Tbl_RowHedar"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_SUPPLIERMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_SupplierMaster");
doc = new RptSupplierMaster();
doc.Database.Tables["Tbl_SupplierMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_TRANSPORTATION_MASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_TransportationMaster");
doc = new RptTransportationMaster();
doc.Database.Tables["Tbl_TransportationMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_SUBEXPENCESMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_SubExpencesMaster");
doc = new RptSubExpencesMaster();
doc.Database.Tables["Tbl_SubExpencesMaster"].SetDataSource(ds.Tables[0]);
//doc.Database.Tables["Tbl_ExpencesMaster"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("FRM_MEASUREMENTMASTER") == 0)
{
DataSet ds = bl_obj.blFill("SP_MeasurementMaster");
doc = new RptMeasurmentMaster();
doc.Database.Tables["Tbl_Measurment"].SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
//--------*********>>>>>>>>>>>>>>>>> Binding a Report Transaction <<<<<<<<<<<<<<<*********--------
if (module_Rpt.rpt_name.CompareTo("RptSalesInvoice") == 0)
{
doc = new RptSalesInvoice();
doc.Database.Tables["Tbl_Sales_Invoice"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptPendingInvoice") == 0)
{
doc = new RptPendingInvoice();
doc.Database.Tables["Tbl_PendingInvoice"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptPendingInvoiceCustomerwise") == 0)
{
doc = new RptPendingInvoiceCustomerwise();
doc.Database.Tables["Tbl_PendingInvoiceCustomerwise"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptScrapwise") == 0)
{
doc = new RptScrapwise();
doc.Database.Tables["Tbl_Scrapwise"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptDayBook") == 0)
{
doc = new rptDayBookNew();
doc.Database.Tables["DayBookNew"].SetDataSource(dataSet1.Tables[0]);
//doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]);
//doc.ParameterFields.Add("OpeningBal");
//doc.SetParameterValue("OpeningBal",dataSet1.Tables[1].Rows[0][0].ToString());
//doc.SetParameterValue("Date", dataSet1.Tables[1].Rows[0][1].ToString());
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptCashBook") == 0)
{
DataSet ds = new DataSet();
paraname.Clear();
paravalue.Clear();
paraname.Add("@From_Date");
paraname.Add("@flag");
paravalue.Add(_fromdate.ToString("yyyy-MM-dd"));
paravalue.Add("OP");
ds = bl_obj.blFill_para_name(paraname, paravalue, "SP_Report");
doc = new rptCashBook();
doc.Database.Tables["CashBookNew"].SetDataSource(dataSet1.Tables[0]);
//doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]);
//doc.ParameterFields.Add("OpeningBal");
doc.SetParameterValue("OpeningBal", ds.Tables[0].Rows[0][0].ToString());
doc.SetParameterValue("Date", _fromdate);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptSales") == 0)
{
doc = new RptSales();
doc.Database.Tables["Tbl_Sales"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptPurchase") == 0)
{
doc = new RptPurchase();
doc.Database.Tables["Tbl_Purchase"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptGeneralLedger") == 0)
{
doc = new RptGeneralLedger();
doc.Database.Tables["Tbl_GeneralLedger"].SetDataSource(dataSet1.Tables[0]);
doc.SetParameterValue("OpeningBal", dataSet1.Tables[1].Rows[0][0].ToString());
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptTrialBalance") == 0)
{
doc = new RptTrialBalance();
doc.Database.Tables["Tbl_TrialBalance"].SetDataSource(dataSet1.Tables[0]);
//doc.Database.Tables["Tbl_OpeningBalance"].SetDataSource(dataSet1.Tables[1]);
//doc.ParameterFields.Add("OpeningBal");
doc.SetParameterValue("OpeningBal", dataSet1.Tables[1].Rows[0][0].ToString());
doc.SetParameterValue("Date", dataSet1.Tables[1].Rows[0][1].ToString());
doc.SetParameterValue("ToDate", dataSet1.Tables[1].Rows[0][2].ToString());
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptRoot") == 0)
{
doc = new RptRoot();
doc.Database.Tables["Tbl_Root"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptFinishedGoods") == 0)
{
doc = new rptFinishedGoods();
doc.Database.Tables["Tbl_FinishedGoods"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptRowMaterialStock") == 0)
{
doc = new rptRowMaterialStock();
doc.Database.Tables["Tbl_RowMaterialStock"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptProductionReport") == 0)
{
doc = new rptProductionReport();
doc.Database.Tables["Tbl_ProductionReport"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
//if (module_Rpt.rpt_name.CompareTo("RptTax") == 0)
//{
// doc = new RptTax();
// doc.Database.Tables["Tbl_Tax"].SetDataSource(dataSet1.Tables[0]);
// crystalReportViewer1.ReportSource = doc;
//}
if (module_Rpt.rpt_name.CompareTo("rptCustomerLedgerNew") == 0)
{
doc = new rptCustomerLedgerNew();
doc.Database.Tables["Tbl_Customer_Ledger_New"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("rptDateWiseAllCustTotal") == 0)
{
doc = new rptDateWiseAllCustTotal();
doc.Database.Tables["AllCustDateWiseTotal"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
//if (module_Rpt.rpt_name.CompareTo("RptDateWiseAllCustomer") == 0)
//{
// doc = new RptDateWiseAllCustomer();
// doc.Database.Tables["AllCustDateWiseTotal"].SetDataSource(dataSet1.Tables[0]);
// crystalReportViewer1.ReportSource = doc;
//}
if (module_Rpt.rpt_name.CompareTo("rptDebitCreditTransaction") == 0)
{
doc = new rptDebitCreditTransaction();
doc.Database.Tables["Tbl_DebitCreditTransaction"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RptGSTTax") == 0)
{
doc = new RptGSTTax();
doc.Database.Tables["Tbl_Tax"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
if (module_Rpt.rpt_name.CompareTo("RPTGSTR") == 0)
{
doc = new RPTGSTR();
doc.Database.Tables["Tbl_GSTR"].SetDataSource(dataSet1.Tables[0]);
crystalReportViewer1.ReportSource = doc;
}
else
{
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
try
{
if (txtAmount.Text == "" && cmbCustomerName.SelectedIndex == 0)
{
if (optDatewise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("SR");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoice", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
else if (cmbCustomerName.SelectedIndex == 0)
{
if (optAmountwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(txtAmount.Text);
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("AA");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoice", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
else if (txtAmount.Text == "")
{
if (optCustomerwise.Checked == true)
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Customer_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbCustomerName.SelectedValue.ToString());
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("PC"); // PC - Pending Invoice Customerwise
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoiceCustomerwise", ds, 0, dtpFromDate.Value, dtpToDate.Value);
}
}
else
{
List <string> para_name = new List <string>();
para_name.Add("@From_Date");
para_name.Add("@To_Date");
para_name.Add("@Customer_Id");
para_name.Add("@Data_Id");
para_name.Add("@flag");
List <string> para_value = new List <string>();
para_value.Add(function.date_save_to_db(dtpFromDate.Value));
para_value.Add(function.date_save_to_db(dtpToDate.Value));
para_value.Add(cmbCustomerName.SelectedValue.ToString());
para_value.Add(txtAmount.Text);
//para_value.Add(dtpFromDate.Value.ToString("MM/dd/yyyy"));
//para_value.Add(dtpToDate.Value.ToString("MM/dd/yyyy"));
para_value.Add("CA");
DataSet ds = bl_obj.blFill_para_name(para_name, para_value, "SP_Report");
function.Show_Report("RptPendingInvoice", ds, 1, dtpFromDate.Value, dtpToDate.Value);
}
}
catch (Exception err)
{
err.GetBaseException();
}
clear();
}