public DataSet ShortExpiryReportPrinting(decimal groupId, decimal productId, decimal brandId, decimal sizeId, decimal modelNoId, decimal godownId, decimal rackId, decimal tExpiry, string cExpiry, DateTime today, decimal companyId) { DataSet dst = new DataSet(); try { dst = spReminder.ShortExpiryReportPrinting(groupId, productId, brandId, sizeId, modelNoId, godownId, rackId, tExpiry, cExpiry, today, companyId); } catch (Exception ex) { MessageBox.Show("RO6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(dst); }
/// <summary> /// Function to print the report /// </summary> public void PrintReport() { try { ReminderSP SPReminder = 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; } DataSet dsShortExpiryReport = SPReminder.ShortExpiryReportPrinting(decA, decB, decC, decD, decE, decF, decG, decproExp, strproExp, PublicVariables._dtCurrentDate, 1); frmReport frmRepor = new frmReport(); frmRepor.MdiParent = formMDI.MDIObj; if (dgvShortExpiryReport.Rows.Count > 0) { frmRepor.ShortExpiryReportPrinting(dsShortExpiryReport); } else { Messages.InformationMessage("No Data Found"); } } catch (Exception ex) { MessageBox.Show("SER:10" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }