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