public IActionResult AddGenre(string NameOfGenre, string Description) { int IdGenre = 0; using (GamesShopDB_Context db = new GamesShopDB_Context()) { if (db.Genre.Count() != 0) { IdGenre = db.Genre.Max(p => p.IdGenre + 1); } Genre genre = new Genre { IdGenre = IdGenre, DescriptionOfGenre = Description, NameOfGenre = NameOfGenre }; // Добавление if (NameOfGenre == null || Description == null) { ViewData["Message"] = "Заполните оба поля ввода!"; return(View()); } else { db.Genre.Add(genre); db.SaveChanges(); } } ViewData["Message"] = "Запись " + NameOfGenre + " была успешно добавлена!"; return(View()); }
public async Task <IActionResult> AddFeedback(int id, string textFeedback) { int idFb = 0; var user = await _userManager.FindByNameAsync(User.Identity.Name); using (GamesShopDB_Context db = new GamesShopDB_Context()) { if (db.Feedback.Count() != 0) { idFb = db.Feedback.Max(p => p.IdFeedback + 1); } Feedbacks fb = new Feedbacks { IdPokupatel = user.Id, IdGame = id, IdFeedback = idFb, TextOfFeedback = textFeedback, DateOfFeedback = DateTime.Now }; // Добавление db.Feedback.Add(fb); db.SaveChanges(); } return(RedirectToAction("ListGames")); }
public IActionResult EditGenresForGame(int Id_game, int Id_genre) { using (GamesShopDB_Context db = new GamesShopDB_Context()) { int Id_recording = 1; if (db.GenresGames.Count() != 0) { Id_recording = db.GenresGames.Max(p => p.id_recording + 1); } GenresGame genregame = new GenresGame { id_recording = Id_recording, IdGame = Id_game, IdGenre = Id_genre }; // Добавление db.GenresGames.Add(genregame); db.SaveChanges(); } var model = new SomeModelsGenreGame() { Game = db.Games.FirstOrDefault(x => x.IdGame == Id_game), Genre = db.Genre.AsEnumerable() }; ViewData["MessageAddGenresGames"] = "Запись '" + Id_game + " " + Id_genre + "' была успешно добавлена!"; return(View(model)); }
public async Task <IActionResult> ViewFeedback(string name) { var user = await _userManager.FindByNameAsync(name); if (user != null) { using (GamesShopDB_Context db = new GamesShopDB_Context()) { var listDetailFeedback = db.Feedback.Where(x => x.IdPokupatel == user.Id).Include(x => x.IdGameNavigation); return(View(listDetailFeedback.ToList())); } } return(RedirectToAction("Profile")); }
public async Task <IActionResult> EditRoles(string userId, /*List<string> roles*/ List <string> roleId) { try { using (GamesShopDB_Context db = new GamesShopDB_Context()) { var userRoles = db.UserRoles.Where(p => p.UserId == userId).Select(x => x.RoleId); var addedRoles = roleId.Except(userRoles); var removedRoles = userRoles.ToList().Except(roleId); foreach (var ur in addedRoles) { IdentityUserRole <string> userrole = new IdentityUserRole <string>() { UserId = userId, RoleId = ur }; await db.UserRoles.AddAsync(userrole); await db.SaveChangesAsync(); } foreach (var ur in removedRoles) { IdentityUserRole <string> userroledelete = new IdentityUserRole <string>() { UserId = userId, RoleId = ur }; db.UserRoles.Remove(userroledelete); await db.SaveChangesAsync(); } return(RedirectToAction("UserList")); } } catch { return(NotFound()); } }
public IActionResult AddDeveloper(string NameOfDeveloper, string LinkToTheWebSite) { int IdDeveloper = 0; using (GamesShopDB_Context db = new GamesShopDB_Context()) { if (db.Developer.Count() != 0) { IdDeveloper = db.Developer.Max(p => p.IdDeveloper + 1); } Developer dev = new Developer { IdDeveloper = IdDeveloper, NameOfDeveloper = NameOfDeveloper, LinkToTheWebSite = LinkToTheWebSite }; // Добавление db.Developer.Add(dev); db.SaveChanges(); } ViewData["Message"] = "Запись '" + IdDeveloper + " " + NameOfDeveloper + " " + LinkToTheWebSite + "' была успешно добавлена!"; return(View()); }
public IActionResult AddGames(string NameOfGame, string Image, DateTime DateOfRelease, string Description, int Cost, int CountOfKeys, int IdDeveloper, int Id_publisher) { int IdGame = 0; using (GamesShopDB_Context db = new GamesShopDB_Context()) { if (db.Games.Count() != 0) { IdGame = db.Games.Max(p => p.IdGame + 1); } Games game = new Games { IdGame = IdGame, NameOfGame = NameOfGame, Image = "/Images/" + Image, DateOfRelease = DateOfRelease.Date, Cost = Cost, CountOfKeys = CountOfKeys, IdDeveloper = IdDeveloper, IdPublisher = Id_publisher, Description = Description }; // Добавление db.Games.Add(game); db.SaveChanges(); var modgame = db.Games.FirstOrDefault(x => x.IdGame == game.IdGame); Console.WriteLine("ID GAME IMAGE: " + modgame.Image); ViewData["MessageAddGames"] = "Запись '" + IdGame + " " + NameOfGame + " " + DateOfRelease + " " + Cost + " " + CountOfKeys + "' была успешно добавлена!"; return(RedirectToAction("AddGenresForGame", modgame)); } }
public IActionResult AddPublisher(string NameOfPublisher, string LinkToTheWebSite) { int IdPublisher = 0; using (GamesShopDB_Context db = new GamesShopDB_Context()) { if (db.Publisher.Count() != 0) { IdPublisher = db.Publisher.Max(p => p.IdPublisher + 1); } Publisher pub = new Publisher { IdPublisher = IdPublisher, NameOfIzdatel = NameOfPublisher, LinkToTheWebSite = LinkToTheWebSite }; // Добавление db.Publisher.Add(pub); db.SaveChanges(); } ViewData["Message"] = "Запись " + NameOfPublisher + " была успешно добавлена!"; return(View()); }
public GenreController(GamesShopDB_Context context) { db = context; }
public HomeController(GamesShopDB_Context context) { db = context; }
public CartController(GamesShopDB_Context game, Cart cart) { this.db = game; this.cart = cart; }
public GamesController(GamesShopDB_Context context, UserManager <User> _userManager, IWebHostEnvironment appEnvironment) { db = context; this._userManager = _userManager; _appEnvironment = appEnvironment; }
public PublisherController(GamesShopDB_Context context) { db = context; }
public OrderController(GamesShopDB_Context db, Cart shopCart, UserManager <User> userManager) { this.db = db; this.shopCart = shopCart; this._userManager = userManager; }