/// <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);
     }
 }