/// <summary>
/// Function to print report
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
public void Print(DateTime fromDate, DateTime toDate)
{
try
{
FinancialStatementSP spFinance = new FinancialStatementSP();
AccountGroupSP spAccountGroup = new AccountGroupSP();
DataSet dsAccountGroup = new DataSet();
DataTable dtblAccountGroup = spAccountGroup.AccountGroupReportFill(fromDate, toDate);
string strSum = lblBalanceTotal.Text;
DataTable dtblSum = new DataTable();
dtblSum.Columns.Add("Sum", typeof(string));
DataRow dr = dtblSum.NewRow();
dr[0] = strSum;
dtblSum.Rows.InsertAt(dr, 0);
DataTable dtblCompany = spFinance.FundFlowReportPrintCompany(1);
dsAccountGroup.Tables.Add(dtblAccountGroup);
dsAccountGroup.Tables.Add(dtblCompany);
dsAccountGroup.Tables.Add(dtblSum);
////frmReport //frmReport = new frmReport();
//frmReport.MdiParent = formMDI.MDIObj;
// frmreport.AccountGroup(dsAccountGroup);
}
catch (Exception ex)
{
MessageBox.Show("AGR:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get dataset for printing the report
/// </summary>
/// <returns></returns>
public DataSet getdataset1()
{
DataSet dsFundFlow = new DataSet();
try
{
FinancialStatementSP spfinancial = new FinancialStatementSP();
DataTable dtblFund = dtblageing1();
DataTable dtblCompany = new DataTable();
dtblCompany = spfinancial.FundFlowReportPrintCompany(1);//(PublicVariables._decCurrentCompanyId);
dsFundFlow.Tables.Add(dtblFund);
dsFundFlow.Tables.Add(dtblCompany);
}
catch (Exception ex)
{
MessageBox.Show("AR7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(dsFundFlow);
}
/// <summary>
/// Function to create datasets
/// </summary>
/// <returns></returns>
public DataSet getdataset()
{
FinancialStatementSP spfinancial = new FinancialStatementSP();
DataSet dsBudget = new DataSet();
try
{
DataTable dtblbudget = GetDataTable();
DataTable dtblCompany = new DataTable();
dtblCompany = spfinancial.FundFlowReportPrintCompany(1);
dsBudget.Tables.Add(dtblbudget);
dsBudget.Tables.Add(dtblCompany);
}
catch (Exception ex)
{
MessageBox.Show("BV:04" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(dsBudget);
}
/// <summary>
/// Function to Convert DataTable to DataSet
/// </summary>
/// <returns></returns>
public DataSet GetdataSet()
{
FinancialStatementSP spfinancial = new FinancialStatementSP();
DataSet dsFundFlow = new DataSet();
try
{
DataTable dtblFund = GetDataTable();
DataTable dtblWC = GetDatagrid2();
DataTable dtblCompany = new DataTable();
dtblCompany = spfinancial.FundFlowReportPrintCompany(1);
dsFundFlow.Tables.Add(dtblFund);
dsFundFlow.Tables.Add(dtblCompany);
dsFundFlow.Tables.Add(dtblWC);
}
catch (Exception ex)
{
MessageBox.Show("FF:03" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(dsFundFlow);
}