public List <DataTable> FreeSaleReportGridFill(DateTime fromDate, DateTime toDate, string voucherNo, decimal voucherTypeId, decimal groupId, string productCode, decimal ledgerId, decimal decEmployeeId) { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPSalesMaster.FreeSaleReportGridFill(fromDate, toDate, voucherNo, voucherTypeId, groupId, productCode, ledgerId, decEmployeeId); } catch (Exception ex) { MessageBox.Show("PBBLL:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill the grid /// </summary> public void GridFill() { try { SalesMasterSP spSalesMaster = new SalesMasterSP(); DataTable dtbl = new DataTable(); DateTime fromDate, toDate; fromDate = Convert.ToDateTime(txtFromDate.Text); toDate = Convert.ToDateTime(txtToDate.Text); string voucherNo = txtVoucherNo.Text.ToString(); decimal voucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()); decimal groupId = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString()); decimal ledgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); decimal employeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString()); string productCode = cmbProductCode.Text.ToString(); dgvFreeSalesReport.DataSource = spSalesMaster.FreeSaleReportGridFill(fromDate, toDate, voucherNo, voucherTypeId, groupId, productCode, ledgerId, employeeId); } catch (Exception ex) { formMDI.infoError.ErrorString = "FSR1:" + ex.Message; } }