public JsonResult GetGridTests(string page, string size)
{
List <TestDescriptionViewModel> list = new List <TestDescriptionViewModel>();
using (var context = new Entities())
{
var pageSize = Convert.ToInt32(size);
var skipSize = pageSize * (Convert.ToInt32(page) - 1);
var rangeOfSets = context.TestSets.OrderByDescending(x => x.Id).Skip(skipSize).Take(pageSize);
var lastTestRun = string.Empty;
foreach (var set in rangeOfSets)
{
if (context.TestRuns.Where(x => x.TestSetId == set.Id).Count() != 0)
{
lastTestRun = context.TestRuns.Where(x => x.TestSetId == set.Id).
OrderByDescending(p => p.DateOfRun).Take(1).ToList()
.Last().DateOfRun.ToString();
}
else
{
lastTestRun = "never";
}
var shortDescription = string.Empty;
if (set.Description.Length > 25)
{
shortDescription = set.Description.Substring(0, 12) + "...";
}
else
{
shortDescription = set.Description;
}
var fileSize = string.Empty;
fileSize = set.Size == 0 ? "< 1" : set.Size.ToString();
var testSet = new TestDescriptionViewModel
{
CreatedBy = context.Users.FirstOrDefault <Users>(x => x.Id == set.CreatorId).UserName,
DateCreated = set.DateOfCreation.ToString(),
Description = shortDescription,
FileSize = fileSize + " kb",
LastRun = lastTestRun,
Runs = context.TestRuns.Count(x => x.TestSetId == set.Id).ToString(),
TestName = set.Name
};
list.Add(testSet);
}
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult TestDetails(string testName)
{
var result = new TestDescriptionViewModel();
using (var context = new Entities())
{
var set = context.TestSets.Where(x => x.Name == testName).ToArray()[0];
var lastTestRun = string.Empty;
if (context.TestRuns.Where(x => x.TestSetId == set.Id).Count() != 0)
{
lastTestRun = context.TestRuns.Where(x => x.TestSetId == set.Id).
OrderByDescending(p => p.DateOfRun).Take(1).ToList()
.Last().DateOfRun.ToString();
}
else
{
lastTestRun = "never";
}
var fileSize = string.Empty;
fileSize = set.Size == 0 ? "< 1" : set.Size.ToString();
result = new TestDescriptionViewModel
{
CreatedBy = context.Users.FirstOrDefault <Users>(x => x.Id == set.CreatorId).UserName,
DateCreated = set.DateOfCreation.ToString(),
Description = set.Description,
FileSize = fileSize,
LastRun = lastTestRun,
Runs = context.TestRuns.Count(x => x.TestSetId == set.Id).ToString(),
TestName = set.Name
};
}
return(View(result));
}