public void TestSetup()
{
report_testObject = new Report();
busReport = new BReport();
DatabaseGateway.TA_ReportDataTable reportTable = new DatabaseGateway.TA_ReportDataTable();
reportTable = reportTA.GetRoot();
if (reportTable.Rows.Count == 0)
{
reportTA.Insert("TestRoot", 0, "", null, false);
reportTable = reportTA.GetRoot();
}
ADOReportRoot.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReportRoot.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReportRoot.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
reportTA.Insert("TestReport1", ADOReportRoot.ID, "", null, false);
reportTA.Insert("TestReport2", ADOReportRoot.ID, "", null, false);
reportTable = reportTA.GetDataByName("TestReport1");
ADOReport1.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReport1.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReport1.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
reportTable = reportTA.GetDataByName("TestReport2");
ADOReport2.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReport2.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReport2.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
reportFileTA.Insert("TestReportFile1", "xml");
reportFileTA.Insert("TestReportFile2", "xml");
DatabaseGateway.TA_ReportFileDataTable reportFileDT = new DatabaseGateway.TA_ReportFileDataTable();
reportFileDT = reportFileTA.GetDataByName("TestReportFile1");
ADOReportFile1.ID = Convert.ToInt32(reportFileDT.Rows[0]["reportfile_ID"]);
ADOReportFile1.Name = Convert.ToString(reportFileDT.Rows[0]["reportfile_Name"]);
reportFileDT = reportFileTA.GetDataByName("TestReportFile2");
ADOReportFile2.ID = Convert.ToInt32(reportFileDT.Rows[0]["reportfile_ID"]);
ADOReportFile2.Name = Convert.ToString(reportFileDT.Rows[0]["reportfile_Name"]);
reportTA.Insert("TestReport3", ADOReport2.ID, "", ADOReportFile2.ID, true);
reportTable = reportTA.GetDataByName("TestReport3");
ADOReport3.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReport3.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReport3.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
ADOReport3.ReportFile = new ReportFile()
{
ID = ADOReportFile2.ID
};
ADOReport3.IsReport = true;
}
public void TestSetup()
{
busReportParameter = new BReportParameter();
reportParameter_testObject = new ReportParameter();
DatabaseGateway.TA_ReportDataTable reportTable = new DatabaseGateway.TA_ReportDataTable();
reportTable = reportTA.GetRoot();
if (reportTable.Rows.Count == 0)
{
reportTA.Insert("TestRoot", 0, "", null, false);
reportTable = reportTA.GetRoot();
}
ADOReportRoot.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReportRoot.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReportRoot.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
reportTA.Insert("TestReport1", ADOReportRoot.ID, "", null, false);
reportTA.Insert("TestReport2", ADOReportRoot.ID, "", null, false);
reportTable = reportTA.GetDataByName("TestReport1");
ADOReport1.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReport1.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReport1.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
reportTable = reportTA.GetDataByName("TestReport2");
ADOReport2.ID = Convert.ToInt32(reportTable.Rows[0]["report_ID"]);
ADOReport2.ParentId = Utility.ToInteger(reportTable.Rows[0]["report_ParentID"]);
ADOReport2.Name = Convert.ToString(reportTable.Rows[0]["report_Name"]);
reportFileTA.Insert("TestReportFile1", "XML");
reportFileTA.GetDataByName("TestReportFile1");
DatabaseGateway.TA_ReportFileDataTable reportFileDT = new DatabaseGateway.TA_ReportFileDataTable();
reportFileDT = reportFileTA.GetDataByName("TestReportFile1");
ADOReportFile1.ID = Convert.ToInt32(reportFileDT.Rows[0]["reportfile_ID"]);
ADOReportFile1.Name = Convert.ToString(reportFileDT.Rows[0]["reportfile_Name"]);
uiParamterTA.Insert("TestUIParam1", "TestPage.aspx", "FNNAME", "ENNAME", 1, "Action1", false);
DatabaseGateway.TA_ReportUIParameterDataTable uiParamtable = uiParamterTA.GetDataByKey("TestPage.aspx");
ADOReportUIParam1.ID = Convert.ToDecimal(uiParamtable.Rows[0][0]);
reportParamTA.Insert(ADOReportUIParam1.ID, "TestParam1", ADOReportFile1.ID);
reportParamTA.Insert(ADOReportUIParam1.ID, "TestParam2", ADOReportFile1.ID);
DatabaseGateway.TA_ReportParameterDataTable paramTable = reportParamTA.GetDataByReportId(ADOReportFile1.ID);
ADOReportParam1.ID = Convert.ToDecimal(paramTable.Rows[0]["ReportParameter_ID"]);
ADOReportParam1.Name = Convert.ToString(paramTable.Rows[0]["ReportParameter_Name"]);
ADOReportParam2.ID = Convert.ToDecimal(paramTable.Rows[1]["ReportParameter_ID"]);
ADOReportParam2.Name = Convert.ToString(paramTable.Rows[1]["ReportParameter_Name"]);
}
