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