Example #1
0
        /// <summary>
        /// Function to fill Datagridview
        /// </summary>
        public void gridFill()
        {
            decimal   decVoucherTypeId = 0;
            decimal   decLedgerId      = 0;
            string    strVoucherNo     = string.Empty;
            string    strSalesMode     = string.Empty;
            DataTable dtblReg          = new DataTable();

            try
            {
                DateTime dtFromdate = this.dtpFormDate.Value;
                DateTime dtTodate   = this.dtpToDate.Value;
                if (cmbVoucherType.SelectedIndex > -1)
                {
                    if (cmbVoucherType.SelectedValue.ToString() != "System.Data.DataRowView" && cmbVoucherType.Text != "System.Data.DataRowView")
                    {
                        if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1)
                        {
                            decVoucherTypeId = 0;
                        }
                        else
                        {
                            decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
                        }
                    }
                }
                if (cmbCashorParty.SelectedIndex > -1)
                {
                    if (cmbCashorParty.SelectedValue.ToString() != "System.Data.DataRowView" && cmbCashorParty.Text != "System.Data.DataRowView")
                    {
                        if (cmbCashorParty.SelectedIndex == 0 || cmbCashorParty.SelectedIndex == -1)
                        {
                            decLedgerId = 0;
                        }
                        else
                        {
                            decLedgerId = Convert.ToDecimal(cmbCashorParty.SelectedValue.ToString());
                        }
                    }
                }
                if (cmbVoucherNo.SelectedIndex == 0 || cmbVoucherNo.SelectedIndex == -1)
                {
                    strVoucherNo = string.Empty;
                }
                else
                {
                    strVoucherNo = cmbVoucherNo.Text;
                }
                strSalesMode             = cmbSalesMode.Text;
                dtblReg                  = spSalesmaster.SalesInvoiceRegisterGridfill(dtFromdate, dtTodate, decVoucherTypeId, decLedgerId, strVoucherNo, strSalesMode);
                dgvSiRegister.DataSource = dtblReg;
            }
            catch (Exception ex)
            {
                formMDI.infoError.ErrorString = "SIREG2:" + ex.Message;
            }
        }
        public List <DataTable> SalesInvoiceRegisterGridfill(DateTime dtFrom, DateTime dtTo, decimal decVoucherType, decimal decLedgerId, string strVoucherNo, string strSalesMode)
        {
            List <DataTable> listObj = new List <DataTable>();

            try
            {
                listObj = SPSalesMaster.SalesInvoiceRegisterGridfill(dtFrom, dtTo, decVoucherType, decLedgerId, strVoucherNo, strSalesMode);
            }
            catch (Exception ex)
            {
                MessageBox.Show("PBBLL:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            return(listObj);
        }