예제 #1
0
 /// <summary>
 /// On 'Print' button click
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnPrint_Click(object sender, EventArgs e)
 {
     try
     {
         if (dgvContraReport.RowCount > 0)
         {
             DataSet        ds              = new DataSet();
             CompanySP      spCompany       = new CompanySP();
             frmReport      reportobj       = new frmReport();
             ContraMasterSP spContraMaster  = new ContraMasterSP();
             DataTable      dtblCompany     = spCompany.CompanyViewDataTable(1);
             DataTable      dtblCotraReport = spContraMaster.ContraReport(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbVoucherType.Text, cmbCashOrBank.Text, strType);
             ds.Tables.Add(dtblCompany);
             ds.Tables.Add(dtblCotraReport);
             reportobj.MdiParent = formMDI.MDIObj;
             reportobj.ContraVoucherReport(ds);
         }
         else
         {
             MessageBox.Show("No data found", "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("CRT:12" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }
예제 #2
0
        public List <DataTable> ContraReport(DateTime dtdateFrom, DateTime dtdateTo, string strVoucherType, string strLedgerName, string strType)
        {
            List <DataTable> listObj = new List <DataTable>();

            try
            {
                ContraMasterSP spContraMaster = new ContraMasterSP();
                listObj = spContraMaster.ContraReport(dtdateFrom, dtdateTo, strVoucherType, strLedgerName, strType);
            }
            catch (Exception ex)
            {
                MessageBox.Show("CVBLL:8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return(listObj);
        }
예제 #3
0
 /// <summary>
 /// Function to fill Datagridview
 /// </summary>
 public void GridFill()
 {
     try
     {
         ContraMasterSP spContraMaster = new ContraMasterSP();
         DataTable      dtbl           = new DataTable();
         if (rbtnDeposit.Checked)
         {
             strType = "Deposit";
         }
         else
         {
             strType = "Withdraw";
         }
         dtbl = spContraMaster.ContraReport(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbVoucherType.Text, cmbCashOrBank.Text, strType);
         dgvContraReport.DataSource = dtbl;
     }
     catch (Exception ex)
     {
         MessageBox.Show("CRT:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }