/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtblSalesOrderRegister = new DataTable(); SalesOrderMasterSP spSalesOrderMaster = new SalesOrderMasterSP(); if (cmbSalesOrderNo.SelectedIndex == 0 || cmbSalesOrderNo.SelectedIndex == -1) { strInvoiceNo = "All"; } else { strInvoiceNo = cmbSalesOrderNo.Text; } if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1) { decLedgerId = -1; } else { decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString()); } if (rbtnAll.Checked == true) { strCondition = "All"; } if (rbtnPendingOrder.Checked == true) { strCondition = "Pending"; } if (rbtnOverdue.Checked == true) { strCondition = "Due"; } if (rbtnCancelled.Checked == true) { strCondition = "Cancelled"; } DateTime FromDate = this.dtpFromDate.Value; DateTime ToDate = this.dtpToDate.Value; dtblSalesOrderRegister = spSalesOrderMaster.SalesOrderRegisterSearch(strInvoiceNo, decLedgerId, FromDate, ToDate, strCondition); dgvSalesOrderRegister.DataSource = dtblSalesOrderRegister; if (dgvSalesOrderRegister.Columns.Count > 0) { dgvSalesOrderRegister.Columns["dgvtxtBillAmount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } } catch (Exception ex) { MessageBox.Show("SOREG2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public List <DataTable> SalesOrderRegisterSearch(string strInvoiceNo, decimal decLedgerId, DateTime FromDate, DateTime ToDate, string strCondition) { List <DataTable> ListObj = new List <DataTable>(); try { ListObj = spSalesOrderMaster.SalesOrderRegisterSearch(strInvoiceNo, decLedgerId, FromDate, ToDate, strCondition); } catch (Exception ex) { MessageBox.Show("SOBLL9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(ListObj); }