public async Task <IActionResult> Variations() { var viewModel = new ScoreIndexData(); viewModel.Scores = await _context.Score .Include(i => i.IdentityUser) .Include(i => i.Optimal) .ThenInclude(i => i.Configuration) .AsNoTracking() .OrderBy(i => i.IdentityUserID) .ToListAsync(); viewModel.Configurations = await _context.Configuration .Include(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Variations = await _context.Variation .Include(i => i.Configurations) .ThenInclude(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Optimals = await _context.Optimal .Include(i => i.Configuration) .AsNoTracking() .ToListAsync(); return(View(viewModel)); }
public async Task <IActionResult> Demo2(int fullName, int diskNr) { var viewModel = new ScoreIndexData(); viewModel.Configurations = await _context.Configuration .Include(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Optimals = await _context.Optimal .Include(i => i.Configuration) .AsNoTracking() .ToListAsync(); ViewData["ConfigurationID"] = fullName; Configuration configuration = viewModel.Configurations.Where( i => i.ConfigurationID == fullName).Single(); ViewData["DiskNr"] = diskNr; Optimal Optimal = viewModel.Optimals.Where(o => o.ConfigurationID == fullName && o.DiskNr == diskNr).Single(); var list = new[] { configuration.ConfigurationID, configuration.start, Optimal.MovesO, Optimal.OptimalID }.ToList();; var d = DateTime.Now.ToString("HH:mm:ss.ff"); return(Json(list)); }
public async Task <IActionResult> Variations() { var viewModel = new ScoreIndexData(); viewModel.unique = _context.Variation .Select(p => p.TowerN) .Distinct().ToList(); viewModel.Configurations = await _context.Configuration .Include(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Variations = await _context.Variation .Include(i => i.Configurations) .ThenInclude(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Optimals = await _context.Optimal .Include(i => i.Configuration) .AsNoTracking() .ToListAsync(); return(View(viewModel)); }
public async Task <IActionResult> Demo2(int fullName, int diskNr) { var viewModel = new ScoreIndexData(); viewModel.Configurations = await _context.Configuration .Include(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Optimals = await _context.Optimal .Include(i => i.Configuration) .AsNoTracking() .ToListAsync(); var x = "test"; if (fullName != null) { ViewData["ConfigurationID"] = fullName; Configuration configuration = viewModel.Configurations.Where( i => i.ConfigurationID == fullName).Single(); ViewData["DiskNr"] = diskNr; Optimal Optimal = viewModel.Optimals.Where(o => o.ConfigurationID == fullName && o.DiskNr == diskNr).Single(); //foreach (d in variation.Optimals){d. } //var result = this.Json(variation, JsonRequestBehavior.AllowGet); List <Optimal> optimals = configuration.Optimals.ToList(); //var h = optimals.ToArray(); Optimal[] array = configuration.Optimals.Cast <Optimal>().ToArray(); Object[] ArrayOfObjects = new Object[] { Optimal.OptimalID, configuration.ConfigurationID, configuration.start, configuration.end }; var list = new[] { configuration.ConfigurationID, configuration.start, Optimal.MovesO, Optimal.OptimalID }.ToList();; //foreach (var drat in configuration.Optimals) { if (drat.DiskNr == diskNr ) { list.Add(drat.MovesO);} list.Add(drat.OptimalID); }; var d = DateTime.Now.ToString("HH:mm:ss.ff"); return(Json(list)); } return(new JsonResult("test")); }
// GET: Scores public async Task <IActionResult> Index() { var viewModel = new ScoreIndexData(); viewModel.Scores = await _context.Score .Include(i => i.IdentityUser) .Include(i => i.Optimal) .ThenInclude(i => i.Configuration) .AsNoTracking() .OrderBy(i => i.IdentityUserID) .ToListAsync(); /*if (id != null) * { * ViewData["ConfigurationID"] = id.Value; * Score score = viewModel.Scores.Where( * i => i.OptimalID == id.Value).Single(); * * }*/ viewModel.Configurations = await _context.Configuration .Include(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Variations = await _context.Variation .Include(i => i.Configurations) .ThenInclude(i => i.Optimals) .AsNoTracking() .ToListAsync(); viewModel.Optimals = await _context.Optimal .Include(i => i.Configuration) .AsNoTracking() .ToListAsync(); return(View(viewModel)); /*var applicationDbContext = _context.Score.Include(s => s.Variation); * return View(await applicationDbContext.ToListAsync()); */ }
// GET: Variations public async Task <IActionResult> Index(int?id, int?courseID) { var ViewModel = new ScoreIndexData(); ViewModel.Variations = await _context.Variation.Include(v => v.Configurations).ThenInclude(c => c.Optimals).AsNoTracking().ToListAsync(); if (id != null) { ViewData["VariationID"] = id.Value; Variation variation = ViewModel.Variations.Where(v => v.VariationID == id.Value).Single(); ViewModel.Configurations = _context.Configuration.Where(c => c.VariationID == id.Value); } if (courseID != null) { ViewData["ConfigurationID"] = courseID.Value; ViewModel.Optimals = _context.Optimal.Where(x => x.ConfigurationID == courseID); } return(View(ViewModel)); }