/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtblMaterialReceiptRegister = new DataTable(); MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP(); if (txtMaterialReceiptNo.Text.Trim() == string.Empty) { strInvoiceNo = string.Empty; } else { strInvoiceNo = txtMaterialReceiptNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = -1; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; dtblMaterialReceiptRegister = spMaterialReceiptMaster.MaterialReceiptMasterViewAll(strInvoiceNo, decLedgerId, FromDate, ToDate); dgvMaterialReceiptRegister.DataSource = dtblMaterialReceiptRegister; } catch (Exception ex) { MessageBox.Show("MRREG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public List <DataTable> MaterialReceiptMasterViewAll(string strInvoiceNo, decimal decLedgerId, DateTime FromDate, DateTime ToDate) { List <DataTable> ListObj = new List <DataTable>(); try { ListObj = spMaterialReceiptMaster.MaterialReceiptMasterViewAll(strInvoiceNo, decLedgerId, FromDate, ToDate); } catch (Exception ex) { MessageBox.Show("MRBLL4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }