public List <DataTable> ProfitAndLossReportPrintCompany(decimal decCompanyId) { List <DataTable> list = new List <DataTable>(); try { list = spFinancialStatement.ProfitAndLossReportPrintCompany(decCompanyId); } catch (Exception ex) { MessageBox.Show("FS9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(list); }
/// <summary> /// Function to convert datatable to dataset /// </summary> /// <returns></returns> public DataSet GetDataSet() { DataSet dsProfit = new DataSet(); try { FinancialStatementSP spfinancial = new FinancialStatementSP(); DataTable dtblProfit = GetDataTable(); DataTable dtblCompany = new DataTable(); dtblCompany = spfinancial.ProfitAndLossReportPrintCompany(1);//(PublicVariables._decCurrentCompanyId); dsProfit.Tables.Add(dtblProfit); dsProfit.Tables.Add(dtblCompany); } catch (Exception ex) { MessageBox.Show("PAL :03" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(dsProfit); }