public ActionResult HomepageGallery(int? page) { using (var context = new olympicsEntities()) { // Perform data access using the context var adverts = from a in context.sporteventstables where a.ss_id == 1 && !string.IsNullOrEmpty(a.strimage1) && a.strapproved == "yes" orderby a.strdatetime descending select a; int pageSize = 9; int pageNumber = (page ?? 1); return PartialView(adverts.ToPagedList(pageNumber, pageSize)); } }
public ActionResult HomeDiscover() { //dbContext get content from table: cms where contentAliasType = "homeDiscover" // Perform data access using the context using (var context = new olympicsEntities()) { // Perform data access using the context var hd = from a in context.cms where a.SS_ID == 1 && a.contentTypeAlias == "homeDiscover" select a.content; var viewModel = new HomeDiscoverViewModel() { homeDiscover = hd.FirstOrDefault().ToString() }; return PartialView(viewModel); } }
public AdvertRepository(olympicsEntities context) { this.context = context; }