/// <summary>
/// Function to fill Datagridview
/// </summary>
public void StockJournalReportGrideFill()
{
try
{
DataTable dtblReg = new DataTable();
dtblReg = spStockJournalMaster.StockJournalReportGrideFill(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), txtVoucherNo.Text, txtProductCode.Text, txtProductName.Text);
dgvStockJournalReport.DataSource = dtblReg;
}
catch (Exception ex)
{
MessageBox.Show("SRR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get values from StockJournal Table based on parameter for Report
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <param name="decVoucherTypeId"></param>
/// <param name="strVoucherNo"></param>
/// <param name="strProductCode"></param>
/// <param name="strProductName"></param>
/// <returns></returns>
public List <DataTable> StockJournalReportGrideFill(DateTime fromDate, DateTime toDate, decimal decVoucherTypeId, string strinvoiceNo, string strProductCode, string strProductName)
{
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = spStockJournalMaster.StockJournalReportGrideFill(fromDate, toDate, decVoucherTypeId, strinvoiceNo, strProductCode, strProductName);
}
catch (Exception ex)
{
MessageBox.Show("AL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listObj);
}
/// <summary>
/// On 'Print' button click to print
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dgvStockJournalReport.RowCount > 0)
{
frmReport frmReportObj = new frmReport();
frmReport frmReportOpen = Application.OpenForms["frmReport"] as frmReport;
DataSet ds = new DataSet();
FinancialStatementSP spfinancial = new FinancialStatementSP();
StockJournalMasterSP spStockJournal = new StockJournalMasterSP();
DataTable dtblCompany = new DataTable();
DataTable dtblStockJournal = new DataTable();
dtblCompany = spfinancial.DayBookReportPrintCompany();
dtblStockJournal = spStockJournal.StockJournalReportGrideFill(Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text), Convert.ToDecimal(cmbVoucherType.SelectedValue.ToString()), txtVoucherNo.Text, txtProductCode.Text, txtProductName.Text);
ds.Tables.Add(dtblCompany);
ds.Tables.Add(dtblStockJournal);
if (frmReportOpen == null)
{
frmReportObj.MdiParent = formMDI.MDIObj;
frmReportObj.StockJournalReportPrint(ds);
}
else
{
frmReportOpen.MdiParent = formMDI.MDIObj;
frmReportOpen.StockJournalReportPrint(ds);
if (frmReportOpen.WindowState == FormWindowState.Minimized)
{
frmReportOpen.WindowState = FormWindowState.Normal;
}
}
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("SRR10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
