public async Task GetsStats() { using (var context = new ApplicationDbContext(_options)) { context.Stats.AddRange( new Stats { Id = 1 }, new Stats { Id = 2 }, new Stats { Id = 3 }); context.SaveChanges(); } using (var context = new ApplicationDbContext(_options)) { var statsRepository = new StatsRepository(context); var stats = await statsRepository.GetAll(0, 2); Assert.Equal(2, stats.Count); Assert.NotNull(stats.SingleOrDefault(x => x.Id == 1)); Assert.NotNull(stats.SingleOrDefault(x => x.Id == 2)); } }
public void MultiStatsSelect() { StatsRepository repo = new StatsRepository(new StatsSQLContext()); List <Stats> s = repo.GetAll(); Assert.IsNotNull(s, "Multiple stats weren't correctly retrieved"); }
// GET: Stats public ActionResult Index() { var userId = User.Identity.GetUserId(); var allStats = _statsRepo.GetAll().Where(x => x.UserId == userId); var user = _db.Users.Include(u => u.Stats).FirstOrDefault(u => u.Id == userId); return(View()); }
public IEnumerable <SelectListItem> GetStats() { var repo = new StatsRepository(new StatsSQLContext()); var roles = repo.GetAll().Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.ToReadableString() }); return(new SelectList(roles, "Value", "Text")); }