public List <DataTable> MaterialReceiptReportViewAll(decimal decOrderId, string strInvoiceNo, decimal decLedgerId, decimal decVouchertypeId, string strProductCode, DateTime FromDate, DateTime ToDate, string strStatus)
{
List <DataTable> ListObj = new List <DataTable>();
try
{
ListObj = spMaterialReceiptMaster.MaterialReceiptReportViewAll(decOrderId, strInvoiceNo, decLedgerId, decVouchertypeId, strProductCode, FromDate, ToDate, strStatus);
}
catch (Exception ex)
{
MessageBox.Show("MRBLL19:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(ListObj);
}
/// <summary>
/// Function to fill the grid based on the search condition
/// </summary>
public void GridFill()
{
try
{
DataTable dtblMaterialReceiptRegister = new DataTable();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
if (cmbOrderNo.SelectedIndex == 0 || cmbOrderNo.SelectedIndex == -1)
{
decOrderId = -1;
}
else
{
decOrderId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
if (txtVoucherNo.Text.Trim() == string.Empty)
{
strInvoiceNo = string.Empty;
}
else
{
strInvoiceNo = txtVoucherNo.Text;
}
if (cmbCashOrParty.SelectedIndex == 0 || cmbCashOrParty.SelectedIndex == -1)
{
decLedgerId = -1;
}
else
{
decLedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
}
if (cmbVoucherType.SelectedIndex == 0 || cmbVoucherType.SelectedIndex == -1)
{
decVoucherTypeId = -1;
}
else
{
decVoucherTypeId = Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString());
}
if (txtProductCode.Text.Trim() == string.Empty)
{
strproductCode = string.Empty;
}
else
{
strproductCode = txtProductCode.Text;
}
if (cmbStatus.SelectedIndex == 0 || cmbStatus.SelectedIndex == -1)
{
strStatus = "All";
}
else
{
strStatus = cmbStatus.SelectedItem.ToString();
}
DateTime FromDate = this.dtpFromDate.Value;
DateTime ToDate = this.dtpToDate.Value;
dtblMaterialReceiptRegister = spMaterialReceiptMaster.MaterialReceiptReportViewAll(decOrderId, strInvoiceNo, decLedgerId, decVoucherTypeId, strproductCode, FromDate, ToDate, strStatus);
dgvMaterialReceiptReport.DataSource = dtblMaterialReceiptRegister;
}
catch (Exception ex)
{
MessageBox.Show("MRR5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}