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