/// <summary>
/// Function to get dataset for printing the report
/// </summary>
/// <returns></returns>
public DataSet getdataset1()
{
DataSet dsFundFlow = new DataSet();
try
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataTable dtblFund = dtblageing1();
List<DataTable> listCompany = new List<DataTable>();
listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1);//(PublicVariables._decCurrentCompanyId);
dsFundFlow.Tables.Add(dtblFund);
dsFundFlow.Tables.Add(listCompany[0]);
}
catch (Exception ex)
{
MessageBox.Show("AR7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return dsFundFlow;
}
/// <summary>
/// Function to convert datatable to dataset
/// </summary>
/// <returns></returns>
public DataSet getdataset()
{
DataSet dsTrail = new DataSet();
try
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataTable dtblTrail = Getdatatable();
List<DataTable> list = new List<DataTable>();
list = bllFinancialStatement.FundFlowReportPrintCompany(1);
dsTrail.Tables.Add(dtblTrail);
dsTrail.Tables.Add(list[0]);
}
catch (Exception ex)
{
MessageBox.Show("TB:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return dsTrail;
}
/// <summary>
/// Function to get dataset
/// </summary>
/// <returns></returns>
public DataSet getdataset()
{
DataSet dsFundFlow = new DataSet();
try
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataTable dtblFund = dtblBalanceSheet();
List< DataTable> list = new List<DataTable>();
list = bllFinancialStatement.FundFlowReportPrintCompany(1);
dsFundFlow.Tables.Add(dtblFund);
dsFundFlow.Tables.Add(list[0]);
return dsFundFlow;
}
catch (Exception ex)
{
MessageBox.Show("BS :3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return dsFundFlow;
}
/// <summary>
/// Function to print report
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
public void Print(DateTime fromDate, DateTime toDate)
{
try
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
DataSet dsAccountGroup = new DataSet();
List<DataTable> ListObj = bllAccountGroup.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);
List<DataTable> listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1);
dsAccountGroup.Tables.Add(ListObj[0]);
dsAccountGroup.Tables.Add(listCompany[0]);
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 Convert DataTable to DataSet
/// </summary>
/// <returns></returns>
public DataSet GetdataSet()
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
DataSet dsFundFlow = new DataSet();
try
{
DataTable dtblFund = GetDataTable();
DataTable dtblWC = GetDatagrid2();
List< DataTable> listCompany = new List<DataTable>();
listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1);
dsFundFlow.Tables.Add(dtblFund);
dsFundFlow.Tables.Add(listCompany[0]);
dsFundFlow.Tables.Add(dtblWC);
}
catch (Exception ex)
{
MessageBox.Show("FF:03" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return dsFundFlow;
}