public ActionResult Index(Vote vote, string optionsRadios) { using (var d = new BlogContext()) { var model = new HomeIndexModelView { Articles = d.Articles.ToList(), Votes = d.Votes.ToList() }; if (optionsRadios == "1") { Vote v = d.Votes.Find(1); v.Amount++; d.SaveChanges(); } if (optionsRadios == "2") { Vote v = d.Votes.Find(2); v.Amount++; d.SaveChanges(); } if (optionsRadios == "3") { Vote v = d.Votes.Find(3); v.Amount++; d.SaveChanges(); } ViewBag.Count = (from i in d.Votes select i.Amount).Sum(); ViewBag.One = (from i in d.Votes where i.Id == 1 select i.Amount).Sum(); ViewBag.Two = (from i in d.Votes where i.Id == 2 select i.Amount).Sum(); ViewBag.Three = (from i in d.Votes where i.Id == 3 select i.Amount).Sum(); return(View(model)); } }
public ActionResult Index(int page = 1) { //ViewBag.Votes = db1.Votes.ToList(); //return View(db.GetArticleList()); using (var d = new BlogContext()) { var model = new HomeIndexModelView { Articles = d.Articles.ToList(), Votes = d.Votes.ToList(), }; ViewBag.Count = (from i in d.Votes select i.Amount).Sum(); ViewBag.One = (from i in d.Votes where i.Id == 1 select i.Amount).Sum(); ViewBag.Two = (from i in d.Votes where i.Id == 2 select i.Amount).Sum(); ViewBag.Three = (from i in d.Votes where i.Id == 3 select i.Amount).Sum(); int pageSize = 2; // количество объектов на страницу IEnumerable <Article> articlesPerPages = model.Articles.Skip((page - 1) * pageSize).Take(pageSize); PageInfo pageInfo = new PageInfo { PageNumber = page, PageSize = pageSize, TotalItems = model.Articles.Count() }; IndexViewModel ivm = new IndexViewModel { PageInfo = pageInfo, Articles = articlesPerPages }; // ViewBag.ivm = ivm; model.IndexView = ivm; return(View(model)); } }
public IActionResult Index() { HomeIndexModelView retval = new HomeIndexModelView(); int iVesselCount = SiteStatics.Context.Vessels.Count(); int iClassCount = SiteStatics.Context.ShipClasses.Count(); int iEventCount = SiteStatics.Context.Event.Count(); Random r = new Random(); retval.FeaturedVessel = SiteStatics.Context.Vessels.OrderBy(x => x.Id).Skip(r.Next(iVesselCount)).Take(1).Single(); retval.FeaturedClass = SiteStatics.Context.ShipClasses.OrderBy(x => x.Id).Skip(r.Next(iClassCount)).Take(1).Single(); retval.FeaturedEvent = SiteStatics.Context.Event.OrderBy(x => x.Id).Skip(r.Next(iEventCount)).Take(1).Single(); return(View(retval)); }