public void SaveHarFile(HarResult result)
{
int id;
using (TestResultContext context = new TestResultContext(ConfigurationManager.ConnectionStrings["TestResultDb"].ConnectionString))
{
context.HarResults.Add(result);
context.SaveChanges();
}
}
public HarResult GetHarFile(int id)
{
HarResult result = new HarResult();
using (TestResultContext context = new TestResultContext(ConfigurationManager.ConnectionStrings["TestResultDb"].ConnectionString))
{
var x = context.HarResults.FirstOrDefault(f => f.Id == id);
result = x;
}
return result;
}
public List<PerformanceTestResult> GetAllTestResults()
{
List<PerformanceTestResult> results = new List<PerformanceTestResult>();
using (TestResultContext context = new TestResultContext(ConfigurationManager.ConnectionStrings["TestResultDb"].ConnectionString))
{
var x = context.PerformanceTestResults;
results = x.ToList();
}
return results;
}
public int SaveTestResult(PerformanceTestResult result)
{
int id;
using (TestResultContext context = new TestResultContext(ConfigurationManager.ConnectionStrings["TestResultDb"].ConnectionString))
{
context.PerformanceTestResults.Add(result);
context.SaveChanges();
id = result.Id;
}
return id;
}
public List<PerformanceTestResult> GetLatestTestResults()
{
var dateTime = DateTime.UtcNow - TimeSpan.FromDays(1);
List<PerformanceTestResult> results = new List<PerformanceTestResult>();
using (TestResultContext context = new TestResultContext(ConfigurationManager.ConnectionStrings["TestResultDb"].ConnectionString))
{
var last24HoursResults = context.PerformanceTestResults.Where(r => r.TestTime > dateTime);
var resultsGroupedByNode = last24HoursResults.GroupBy(r => r.NodeId);
foreach (var resultGroup in resultsGroupedByNode)
{
var averageTime = resultGroup.Average(r => r.TotalTime);
var result = resultGroup.OrderByDescending(r => r.TestTime).First();
result.AverageTime = (int)averageTime;
results.Add(result);
}
}
return results;
}
public TestResultController(TestResultContext context)
{
_context = context;
}
public SaveDB(TestResultContext context)
{
_context = context;
}
/// <summary> /// Initializes new instance of <see cref="HomeController"/> /// </summary> /// <param name="context">app DbContext object</param> public HomeController(TestResultContext context) => _context = context;
