/// <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)
{
formMDI.infoError.ErrorString = "SRR2:" + ex.Message;
}
}
/// <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>
/// 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)
{
formMDI.infoError.ErrorString = "SRR10:" + ex.Message;
}
}
/// <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);
}
}
