예제 #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", "Oneaccount", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
     catch (Exception ex)
     {
         formMDI.infoError.ErrorString = "CRT12:" + ex.Message;
     }
 }
예제 #2
0
 /// <summary>
 /// Function to fill Cash/Bank combobox
 /// </summary>
 public void BankOrCashComboFill()
 {
     try
     {
         ContraMasterSP spContraMaster = new ContraMasterSP();
         DataTable      dtbl           = new DataTable();
         dtbl = spContraMaster.CashOrBankComboFill();
         DataRow dr = dtbl.NewRow();
         dr[0] = "ALL";
         dtbl.Rows.InsertAt(dr, 0);
         cmbCashOrBank.DataSource    = dtbl;
         cmbCashOrBank.ValueMember   = "ledgerId";
         cmbCashOrBank.DisplayMember = "ledgerName";
         cmbCashOrBank.SelectedIndex = 0;
     }
     catch (Exception ex)
     {
         formMDI.infoError.ErrorString = "CRT1:" + ex.Message;
     }
 }
예제 #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)
     {
         formMDI.infoError.ErrorString = "CRT3:" + ex.Message;
     }
 }
예제 #4
0
 /// <summary>
 /// Function to fill Datagridview
 /// </summary>
 public void Gridfill()
 {
     try
     {
         string strType = string.Empty;
         if (rbtnDeposit.Checked)
         {
             strType = "Deposit";
         }
         else
         {
             strType = "Withdraw";
         }
         ContraMasterSP spContraMaster = new ContraMasterSP();
         DataTable      dtbl           = new DataTable();
         dtbl = spContraMaster.ContraVoucherRegisterSearch(Convert.ToDateTime(dtpFromDate.Value), Convert.ToDateTime(dtpToDate.Value), txtVoucherNo.Text.Trim(), cmbBankOrCash.Text, strType);
         dgvContraRegister.DataSource = dtbl;
     }
     catch (Exception ex)
     {
         formMDI.infoError.ErrorString = "CR2:" + ex.Message;
     }
 }