public List <DataTable> ShortExpiryReportGridFill(decimal groupId, decimal productId, decimal brandId, decimal sizeId, decimal modelNoId, decimal godownId, decimal rackId, decimal tExpiry, string cExpiry, DateTime today)
{
List <DataTable> list = new List <DataTable>();
try
{
list = spReminder.ShortExpiryReportGridFill(groupId, productId, brandId, sizeId, modelNoId, godownId, rackId, tExpiry, cExpiry, today);
}
catch (Exception ex)
{
MessageBox.Show("RM6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(list);
}
/// <summary>
/// Function to fill the short expiry products
/// </summary>
public void GridFill()
{
try
{
DataTable dtbl = new DataTable();
ReminderSP SpRemainder = new ReminderSP();
decimal decA = Convert.ToDecimal(cmbProductGroup.SelectedValue.ToString());
decimal decB = Convert.ToDecimal(cmbProductName.SelectedValue.ToString());
decimal decC = Convert.ToDecimal(cmbBrand.SelectedValue.ToString());
decimal decD = Convert.ToDecimal(cmbSize.SelectedValue.ToString());
decimal decE = Convert.ToDecimal(cmbModelno.SelectedValue.ToString());
decimal decF = Convert.ToDecimal(cmbGodown.SelectedValue.ToString());
decimal decG = Convert.ToDecimal(cmbRack.SelectedValue.ToString());
decimal decproExp = 0;
string strproExp = string.Empty;
if (txtProductExpire.Text != string.Empty)
{
decproExp = Convert.ToDecimal(txtProductExpire.Text.ToString());
}
else
{
decproExp = 0;
}
if (cmbProductExpire.Text != string.Empty)
{
strproExp = cmbProductExpire.Text;
}
else
{
strproExp = string.Empty;
}
dtbl = SpRemainder.ShortExpiryReportGridFill(decA, decB, decC, decD, decE, decF, decG, decproExp, strproExp, PublicVariables._dtCurrentDate);
dgvShortExpiryReport.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("SER:8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
