private void FRM_RPTROOTWISEPENDING_Load(object sender, EventArgs e)
{
function.settheme(this);
DataSet ds = bl_obj.blFill("SP_RootTransaction");
function.fillcombo(cmbRootName, ds.Tables[1]);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
private void Frm_RptTrialBalance_Load(object sender, EventArgs e)
{
function.settheme(this);
dtpFromDate.Value = DateTime.Now.Date;
dtpToDate.Value = DateTime.Now.Date;
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
private void FRM_RPTDEBTICREDITTRANSACTION_Load(object sender, EventArgs e)
{
function.settheme(this);
dtpFromDate.Value = DateTime.Now.Date;
dtpToDate.Value = DateTime.Now.Date;
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
private void Report_Viewer_Load(object sender, EventArgs e)
{
function.settheme(this);
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;
}
else
{
}
}
private void FRM_RPTPENDINGINVOICE_Load(object sender, EventArgs e)
{
function.settheme(this);
DataSet ds = bl_obj.blFill("SP_CustomerMaster");
function.fillcombo(cmbCustomerName, ds.Tables[0]);
lblCustomerName.Visible = false;
lblAmount.Visible = false;
txtAmount.Visible = false;
cmbCustomerName.Visible = false;
optDatewise.Checked = true;
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
private void FRM_RPTPURCHASE_Load(object sender, EventArgs e)
{
function.settheme(this);
DataSet ds = bl_obj.blFill("SP_SupplierMaster");
function.fillcombo(cmbSupplierName, ds.Tables[0]);
DataSet ds1 = bl_obj.blFill("SP_RowMaterialMaster");
function.fillcombo(cmbProductName, ds1.Tables[0]);
lblSupplierName.Visible = false;
cmbSupplierName.Visible = false;
lblProductName.Visible = false;
cmbProductName.Visible = false;
optDatewise.Checked = true;
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
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 FRM_DayBook_Load(object sender, EventArgs e)
{
function.settheme(this);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
private void FRM_RPTSALESINVOICE_Load(object sender, EventArgs e)
{
function.settheme(this);
//DataSet ds = bl_obj.blFill("Sp_SalesInvoice");
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}
private void FRM_RPTSCRAPWISE_Load(object sender, EventArgs e)
{
function.settheme(this);
dtpFromDate.Value = Convert.ToDateTime("01/04/2017");
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; // Do not resize the form.
}