public int DeleteVendors(Vendor vendor) { using (var dbContext = new CompareTheGameEntities()) { var foundVendor = dbContext.Vendors.First(v => v.VendorID == vendor.VendorID); dbContext.Vendors.Remove(foundVendor); return(dbContext.SaveChanges()); } }
public List <Vendor> GetVendors() { using (var dbContext = new CompareTheGameEntities()) { return(dbContext.Vendors .Include(v => v.VendorGameSettings.Select(vgs => vgs.GamePlatform.Platform)) .OrderBy(v => v.VendorName).ToList()); } }
public SearchOptions GetSearchOptions() { using (var dbContext = new CompareTheGameEntities()) { SearchOptions searchOptions = new SearchOptions(); searchOptions.Genres = dbContext.Genres.OrderBy(g => g.GenreName).ToList(); searchOptions.Modes = dbContext.Modes.OrderBy(m => m.ModeName).ToList(); searchOptions.Platforms = dbContext.Platforms.OrderBy(p => p.PlatformName).ToList(); searchOptions.Perspectives = dbContext.Perspectives.OrderBy(p => p.PerspectiveName).ToList(); searchOptions.Themes = dbContext.Themes.OrderBy(t => t.ThemeName).ToList(); return(searchOptions); } }
public List <Game> SearchForGame(string gameName) { using (var dbContext = new CompareTheGameEntities()) { return(dbContext.Games .Include(g => g.GameGenres.Select(gg => gg.Genre)) .Include(g => g.GameModes.Select(gm => gm.Mode)) .Include(g => g.GamePerspectives.Select(gp => gp.Perspective)) .Include(g => g.GamePlatforms.Select(gp => gp.Platform)) .Include(g => g.GameScreenshots.Select(gs => gs.Screenshot)) .Include(g => g.GameThemes.Select(gt => gt.Theme)) .Include(g => g.GamePlatforms.Select(gp => gp.VendorGameHistories.Select(vfh => vfh.Vendor))) .Where(g => g.CoverImageURL != null && g.GameName.Contains(gameName) && !g.GameName.StartsWith("???")) .OrderBy(g => g.GameName) .ToList()); } }
public Game GetGame(string game) { int gameID = int.Parse(game); using (var dbContext = new CompareTheGameEntities()) { return(dbContext.Games .Include(g => g.GameGenres.Select(gg => gg.Genre)) .Include(g => g.GameModes.Select(gm => gm.Mode)) .Include(g => g.GamePerspectives.Select(gp => gp.Perspective)) .Include(g => g.GamePlatforms.Select(gp => gp.Platform)) .Include(g => g.GameScreenshots.Select(gs => gs.Screenshot)) .Include(g => g.GameThemes.Select(gt => gt.Theme)) .Include(g => g.GamePlatforms.Select(gp => gp.VendorGameHistories.Select(vfh => vfh.Vendor))) .Where(g => g.CoverImageURL != null && g.GameID == gameID).FirstOrDefault()); } }
public int SaveVendor(Vendor vendor) { using (var dbContext = new CompareTheGameEntities()) { var user = HttpContext.Current.User.Identity.Name; if (vendor.VendorID == 0) { vendor.CreatedBy = user; vendor.CreatedDate = DateTime.Now; } vendor.ModifiedBy = user; vendor.ModifiedDate = DateTime.Now; dbContext.Vendors.AddOrUpdate(vendor); return(dbContext.SaveChanges()); } }
public List <Game> GetAllGames(bool forAdmin) { using (var dbContext = new CompareTheGameEntities()) { return(dbContext.Games .Include(g => g.GameGenres.Select(gg => gg.Genre)) .Include(g => g.GameModes.Select(gm => gm.Mode)) .Include(g => g.GamePerspectives.Select(gp => gp.Perspective)) .Include(g => g.GamePlatforms.Select(gp => gp.Platform)) .Include(g => g.GameScreenshots.Select(gs => gs.Screenshot)) .Include(g => g.GameThemes.Select(gt => gt.Theme)) .Include(g => g.GamePlatforms.Select(gp => gp.VendorGameHistories.Select(vgh => vgh.Vendor))) .Include(g => g.GamePlatforms.Select(gp => gp.VendorGameSettings.Select(vgs => vgs.Vendor))) .Include(g => g.GamePlatforms.Select(gp => gp.VendorGameSettings.Select(vgs => vgs.GamePlatform.Platform))) .Where(g => g.CoverImageURL != null && !g.GameName.StartsWith("???")) .OrderBy(g => g.GameName) .ToList()); } }