Example #1
0
        public List <DataTable> SalesReturnReportGrideFill(DateTime fromDate, DateTime toDate, decimal decLedgerId, decimal decVoucherTypeId, decimal decEmployeeId, string strProductCode, string strVoucherNo)
        {
            List <DataTable> ListObj = new List <DataTable>();

            try
            {
                ListObj = spSalesReturnMaster.SalesReturnReportGrideFill(fromDate, toDate, decLedgerId, decVoucherTypeId, decEmployeeId, strProductCode, strVoucherNo);
            }
            catch (Exception ex)
            {
                MessageBox.Show("AG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return(ListObj);
        }
Example #2
0
 /// <summary>
 /// Function to fill datagridview
 /// </summary>
 public void SalesReturnReportGrideFill()
 {
     try
     {
         if (cmbCashOrParty.SelectedValue != null && cmbSalesMan.SelectedValue != null && cmbVoucherType.SelectedValue != null)
         {
             if (cmbCashOrParty.SelectedValue.ToString() != "System.Data.DataRowView" && cmbSalesMan.SelectedValue.ToString() != "System.Data.DataRowView" && cmbVoucherType.SelectedValue.ToString() != "System.Data.DataRowView")
             {
                 DataTable dtblReg = new DataTable();
                 dtblReg = spSalesReturnMaster.SalesReturnReportGrideFill(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()), Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString()), txtProductCode.Text, txtVoucherNo.Text);
                 dgvsalesReturnReport.DataSource = dtblReg;
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("SRRprt6:" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }