/// <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)
{
formMDI.infoError.ErrorString = "SER8:" + ex.Message;
}
}
/// <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);
}
}