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