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