/// <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); }