public dynamic DashboardStatistics()
{
DashboardModel data = this.Bind <DashboardModel>();
string connString = _appSettings.GetConnectionStringByName(data.ConnName);
Task <int> totalReportCountTask = Task.Run(() => _reportJobRepository.GetTotalReportCount(connString, data.StartDate, data.EndDate));
Task <TimeSpan> avgExecutionTimeTask = Task.Run(() => _reportJobRepository.GetAverageExecutionTime(connString, data.StartDate, data.EndDate));
Task <TimeSpan> avgGenerationTimeTask = Task.Run(() => _reportJobRepository.GetAverageGenerationTime(connString, data.StartDate, data.EndDate));
Task <IEnumerable <ReportCount> > activeUsersTask = Task.Run(() => _reportJobRepository.GetMostActiveUsers(connString, 10, data.StartDate, data.EndDate));
Task <IEnumerable <ReportCount> > mostRunReportsTask = Task.Run(() => _reportJobRepository.GetMostRunReports(connString, 10, data.StartDate, data.EndDate));
Task <IEnumerable <ReportCount> > reportCountByDayTask = Task.Run(() => _reportJobRepository.GetReportCountByDay(connString, data.StartDate, data.EndDate));
Task <int> errorCountTask = Task.Run(() => _reportJobRepository.GetErrorCount(connString, data.StartDate, data.EndDate));
Task.WaitAll(totalReportCountTask, avgExecutionTimeTask, avgGenerationTimeTask, activeUsersTask, mostRunReportsTask, reportCountByDayTask, errorCountTask);
StatisticsViewModel viewModel = new StatisticsViewModel();
viewModel.TotalReportCount = totalReportCountTask.Result;
viewModel.AverageExecutionSeconds = avgExecutionTimeTask.Result.TotalSeconds;
viewModel.AverageGenerationSeconds = avgGenerationTimeTask.Result.TotalSeconds;
viewModel.MostActiveUsers = activeUsersTask.Result;
viewModel.MostRunReports = mostRunReportsTask.Result;
viewModel.ReportCountByDay = reportCountByDayTask.Result;
viewModel.ErrorCount = errorCountTask.Result;
return(Response.AsJson(viewModel));
}
public void DashboardStatistics_OnExecute_PopulatesModel()
{
// setup
Random r = new Random();
string connName = Guid.NewGuid().ToString();
string connString = Guid.NewGuid().ToString();
int totalReportCount = r.Next();
DateTime startDate = DateTime.Now.AddMonths(-3).AddMinutes(r.Next(10, 50));
DateTime endDate = DateTime.Now;
double avgExecutionSeconds = r.Next(1, 10);
double avgGenerationSeconds = avgExecutionSeconds + 2;
int errorCount = r.Next();
DateTime startDateReceived = DateTime.MinValue;
DateTime endDateReceived = DateTime.MinValue;
_appSettings.GetConnectionStringByName(connName).Returns(connString);
_reportJobRepository.GetTotalReportCount(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(totalReportCount);
_reportJobRepository.When(x => x.GetTotalReportCount(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>())).Do((ci) => {
startDateReceived = ci.ArgAt <DateTime>(1);
endDateReceived = ci.ArgAt <DateTime>(2);
});
_reportJobRepository.GetAverageExecutionTime(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(TimeSpan.FromSeconds(avgExecutionSeconds));
_reportJobRepository.GetAverageGenerationTime(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(TimeSpan.FromSeconds(avgGenerationSeconds));
ReportCount[] activeUsers = CreateDummyReportResult();
_reportJobRepository.GetMostActiveUsers(connString, 10, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(activeUsers);
ReportCount[] mostRunReports = CreateDummyReportResult();
_reportJobRepository.GetMostRunReports(connString, 10, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(mostRunReports);
ReportCount[] reportCountByDay = CreateDummyReportResult();
_reportJobRepository.GetReportCountByDay(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(reportCountByDay);
_reportJobRepository.GetErrorCount(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>()).Returns(errorCount);
var browser = CreateBrowser();
// execute
var response = browser.Post(Actions.Dashboard.Statistics, (with) =>
{
with.HttpRequest();
with.FormValue("ConnName", connName);
with.FormValue("StartDate", startDate.ToString(DateFormatForPost));
with.FormValue("EndDate", endDate.ToString(DateFormatForPost));
});
StatisticsViewModel result = JsonConvert.DeserializeObject <StatisticsViewModel>(response.Body.AsString());
// assert
Assert.AreEqual(HttpStatusCode.OK, response.StatusCode);
Assert.AreEqual(totalReportCount, result.TotalReportCount);
Assert.That(startDate, Is.EqualTo(startDateReceived).Within(TimeSpan.FromSeconds(1.0)));
Assert.That(endDate, Is.EqualTo(endDateReceived).Within(TimeSpan.FromSeconds(1.0)));
Assert.AreEqual(avgExecutionSeconds, result.AverageExecutionSeconds);
Assert.AreEqual(avgGenerationSeconds, result.AverageGenerationSeconds);
Assert.AreEqual(activeUsers.Length, result.MostActiveUsers.Count());
Assert.AreEqual(mostRunReports.Length, result.MostRunReports.Count());
Assert.AreEqual(reportCountByDay.Length, result.ReportCountByDay.Count());
Assert.AreEqual(errorCount, result.ErrorCount);
_appSettings.Received(1).GetConnectionStringByName(connName);
_reportJobRepository.Received(1).GetTotalReportCount(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>());
_reportJobRepository.Received(1).GetAverageExecutionTime(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>());
_reportJobRepository.Received(1).GetAverageGenerationTime(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>());
_reportJobRepository.Received(1).GetMostActiveUsers(connString, 10, Arg.Any <DateTime>(), Arg.Any <DateTime>());
_reportJobRepository.Received(1).GetMostRunReports(connString, 10, Arg.Any <DateTime>(), Arg.Any <DateTime>());
_reportJobRepository.Received(1).GetReportCountByDay(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>());
_reportJobRepository.Received(1).GetErrorCount(connString, Arg.Any <DateTime>(), Arg.Any <DateTime>());
}
public void GetReportCountByDay_Executes_WithoutSqlErrors()
{
_reportJobRepository.GetReportCountByDay(TestUtility.TestDbConnectionString(TestUtility.TestRootFolder), DateTime.Now.AddMonths(-3), DateTime.Now);
}