public async Task Get_ReportTable()
{
string connectionString = "ReportExcelConn";;
try
{
//Get Data in to Data Table from Excel
OleDbConnection ExcelConnection; DataSet ds; OleDbDataAdapter Command;
var ExcelPath = Directory.GetParent(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)).Parent.FullName + "\\" +
System.Configuration.ConfigurationManager.AppSettings.Get(connectionString);
var path = connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelPath + ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
ExcelConnection = new OleDbConnection(path);
ExcelConnection.Open();
Command = new OleDbDataAdapter("select * from " + "[Report$]", ExcelConnection);
Command.TableMappings.Add("Table", "TestTable");
ds = new DataSet();
Command.Fill(ds);
ExcelConnection.Close();
if (ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Check column is exist in databale or not, and get that fields value.
int reportTableId = 0;
if (ds.Tables[0].Columns.Contains("ReportTableId"))
{
reportTableId = Convert.ToInt32(dr["ReportTableId"]);
}
int dashBoardId = 0;
if (ds.Tables[0].Columns.Contains("DashBoardId"))
{
dashBoardId = Convert.ToInt32(dr["DashBoardId"]);
}
int dashBoardContentID = 0;
if (ds.Tables[0].Columns.Contains("DashBoardContentID"))
{
dashBoardContentID = Convert.ToInt32(dr["DashBoardContentID"]);
}
int dashboardPageId = 0;
if (ds.Tables[0].Columns.Contains("DashboardPageId"))
{
dashboardPageId = Convert.ToInt32(dr["DashboardPageId"]);
}
string dbconnectionString = string.Empty;
if (ds.Tables[0].Columns.Contains("ConnectionString"))
{
dbconnectionString = Convert.ToString(dr["ConnectionString"]);
}
string startDate = string.Empty;
if (ds.Tables[0].Columns.Contains("StartDate"))
{
startDate = Convert.ToString(dr["StartDate"]);
}
string endDate = string.Empty;
if (ds.Tables[0].Columns.Contains("EndDate"))
{
endDate = Convert.ToString(dr["EndDate"]);
}
string viewBy = string.Empty;
if (ds.Tables[0].Columns.Contains("ViewBy"))
{
viewBy = Convert.ToString(dr["ViewBy"]);
}
Console.WriteLine("Get report table data.\n");
MeasureDashboardController objDashboard = new MeasureDashboardController();
objMeasureDashboardController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(),
objMeasureDashboardController);
//Set Connection string in UserApplicationId of session
List <RevenuePlanner.BDSService.User.ApplicationDetail> lstApplicationDetail = new List <RevenuePlanner.BDSService.User.ApplicationDetail>();
RevenuePlanner.BDSService.User.ApplicationDetail objApplicationDetail = new RevenuePlanner.BDSService.User.ApplicationDetail();
objApplicationDetail.ApplicationTitle = Enums.ApplicationCode.RPC.ToString();
objApplicationDetail.ConnectionString = dbconnectionString;
lstApplicationDetail.Add(objApplicationDetail);
Sessions.User.UserApplicationId = lstApplicationDetail;
var result = await objDashboard.GetReportTable(reportTableId, Enums.ApplicationCode.RPC.ToString(), "", null, false, viewBy, startDate, endDate,
dashBoardId, 0, dashBoardContentID) as string;
Assert.IsNotNull(result);
Assert.IsTrue(result.Contains(string.Format("{0}{1}", "ReportTable", dashBoardContentID)));
Console.WriteLine("MeasureDashboardController - LoadReportTablePartial" + " \n The Assert Value is : " + result);
}
}
}
catch (Exception e)
{
Assert.Fail();
Console.WriteLine("MeasureDashboardController - LoadReportTablePartial" + " \n The Assert Value is : " + e.Message);
}
}
public async Task Get_Chart()
{
try
{
//Get Data in to Data Table from Excel
DataSet ds = ReturnDataSetFromExcel("ReportExcelConn", "Report");
if (ds.Tables[0] != null)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Check column is exist in databale or not, and get that fields value.
int reportGraphId = 0;
if (ds.Tables[0].Columns.Contains("ReportGraphId"))
{
reportGraphId = Convert.ToInt32(dr["ReportGraphId"]);
}
int dashBoardId = 0;
if (ds.Tables[0].Columns.Contains("DashBoardId"))
{
dashBoardId = Convert.ToInt32(dr["DashBoardId"]);
}
int dashBoardContentID = 0;
if (ds.Tables[0].Columns.Contains("DashBoardContentID"))
{
dashBoardContentID = Convert.ToInt32(dr["DashBoardContentID"]);
}
int dashboardPageId = 0;
if (ds.Tables[0].Columns.Contains("DashboardPageId"))
{
dashboardPageId = Convert.ToInt32(dr["DashboardPageId"]);
}
string dbconnectionString = string.Empty;
if (ds.Tables[0].Columns.Contains("ConnectionString"))
{
dbconnectionString = Convert.ToString(dr["ConnectionString"]);
}
string startDate = string.Empty;
if (ds.Tables[0].Columns.Contains("StartDate"))
{
startDate = Convert.ToString(dr["StartDate"]);
}
string endDate = string.Empty;
if (ds.Tables[0].Columns.Contains("EndDate"))
{
endDate = Convert.ToString(dr["EndDate"]);
}
string viewBy = string.Empty;
if (ds.Tables[0].Columns.Contains("ViewBy"))
{
viewBy = Convert.ToString(dr["ViewBy"]);
}
string chartType = string.Empty;
if (ds.Tables[0].Columns.Contains("chartType"))
{
chartType = Convert.ToString(dr["chartType"]);
}
Console.WriteLine("Get report table data.\n");
MeasureDashboardController objDashboard = new MeasureDashboardController();
objMeasureDashboardController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(),
objMeasureDashboardController);
//Set Connection string in UserApplicationId of session
List <RevenuePlanner.BDSService.User.ApplicationDetail> lstApplicationDetail = new List <RevenuePlanner.BDSService.User.ApplicationDetail>();
RevenuePlanner.BDSService.User.ApplicationDetail objApplicationDetail = new RevenuePlanner.BDSService.User.ApplicationDetail();
objApplicationDetail.ApplicationTitle = Enums.ApplicationCode.RPC.ToString();
objApplicationDetail.ConnectionString = dbconnectionString;
lstApplicationDetail.Add(objApplicationDetail);
Sessions.User.UserApplicationId = lstApplicationDetail;
JsonResult result = await objDashboard.GetChart(reportGraphId, Enums.ApplicationCode.RPC.ToString(), "", null, false, viewBy, startDate, endDate, true, false) as JsonResult;
Assert.IsTrue(Convert.ToString(result.Data).Contains("type: '" + chartType + "'"));
Console.WriteLine("MeasureDashboardController - GetChart" + " \n The Assert Value is : " + result);
}
}
}
catch (Exception e)
{
Assert.Fail();
Console.WriteLine("MeasureDashboardController - GetChart" + " \n The Assert Value is : " + e.Message);
}
}
