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;
}
