public List <DataTable> SalesInvoiceReportFill(DateTime dtfromDate, DateTime dttoDate, decimal decVoucherTypeId, decimal decLedgerId, decimal decAreaId, string strSalesMode, decimal decEmployeeId, string strProductName, string strVoucherNo, string strstatus, decimal decRouteId, decimal decModelNoId, string strProductCode) { List <DataTable> listObj = new List <DataTable>(); try { listObj = SPSalesMaster.SalesInvoiceReportFill(dtfromDate, dttoDate, decVoucherTypeId, decLedgerId, decAreaId, strSalesMode, decEmployeeId, strProductName, strVoucherNo, strstatus, decRouteId, decModelNoId, strProductCode); } catch (Exception ex) { MessageBox.Show("PBBLL:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }
/// <summary> /// Function to fill datagridview /// </summary> public void gridFill() { try { decimal decVoucherTypeId = 0; decimal decLedgerId = 0; decimal decRouteId = 0; decimal decAreaId = 0; decimal decEmployeeId = 0; decimal decModelNo = 0; string strStatus = string.Empty; string strProductName = string.Empty; string strProductCode = string.Empty; string strVoucherNo = string.Empty; string strSalesMode = string.Empty; DateTime dtFromdate = this.dtpFrmDate.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 (cmbArea.SelectedIndex > -1) { if (cmbArea.SelectedValue.ToString() != "System.Data.DataRowView" && cmbArea.Text != "System.Data.DataRowView") { if (cmbArea.SelectedIndex == 0 || cmbArea.SelectedIndex == -1) { decAreaId = 0; } else { decAreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString()); } } } if (cmbSalesMan.SelectedIndex > -1) { if (cmbSalesMan.SelectedValue.ToString() != "System.Data.DataRowView" && cmbSalesMan.Text != "System.Data.DataRowView") { if (cmbSalesMan.SelectedIndex == 0 || cmbSalesMan.SelectedIndex == -1) { decEmployeeId = 0; } else { decEmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString()); } } } if (cmbRoute.SelectedIndex > -1) { if (cmbRoute.SelectedValue.ToString() != "System.Data.DataRowView" && cmbRoute.Text != "System.Data.DataRowView") { if (cmbRoute.SelectedIndex == 0 || cmbRoute.SelectedIndex == -1) { decRouteId = 0; } else { decRouteId = Convert.ToDecimal(cmbRoute.SelectedValue.ToString()); } } } if (cmbModelNo.SelectedIndex > -1) { if (cmbModelNo.SelectedValue.ToString() != "System.Data.DataRowView" && cmbRoute.Text != "System.Data.DataRowView") { if (cmbModelNo.SelectedIndex == 0 || cmbModelNo.SelectedIndex == -1) { decModelNo = 0; } else { decModelNo = Convert.ToDecimal(cmbModelNo.SelectedValue.ToString()); } } } if (txtVoucherNo.Text == "") { strVoucherNo = string.Empty; } else { strVoucherNo = txtVoucherNo.Text; } if (txtProductCode.Text == "") { strProductCode = string.Empty; } else { strProductCode = txtProductCode.Text; } if (txtProductName.Text == "") { strProductName = string.Empty; } else { strProductName = txtProductName.Text; } if (cmbSalesMode.SelectedIndex == 0 || cmbSalesMode.SelectedIndex == -1) { strSalesMode = "All"; } else { strSalesMode = cmbSalesMode.Text; } if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1) { strStatus = "All"; } else { strStatus = cmbStatus.Text; } DataTable dtbl = new DataTable(); dtbl = spSalesMaster.SalesInvoiceReportFill(dtFromdate, dtTodate, decVoucherTypeId, decLedgerId, decAreaId, strSalesMode, decEmployeeId, strProductName, strVoucherNo, strStatus, decRouteId, decModelNo, strProductCode); dgvSIReport.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("SIRPT: 08" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }