public IActionResult Buy(decimal?itemPrice, int quantity, string name) { db = new GameShopDBContext(); List <AspNetUsers> userList = db.AspNetUsers.ToList(); List <Items> itemList = db.Items.ToList(); foreach (Items item in itemList) { if (item.Name == name) { item.Quantity = quantity; //db.Items.Update(item); db.SaveChanges(); } } foreach (AspNetUsers user in userList) { if (user.Email == User.Identity.Name) { user.Funds -= itemPrice; db.AspNetUsers.Update(user); db.SaveChanges(); return(View("Shop", db)); } } return(View("Shop", db)); }
public CreateOrderDto CreateOrder([FromBody] CreateOrderDto orderDto) { using (GameShopDBContext gameShopDBContext = new GameShopDBContext()) { var GameId = gameShopDBContext.Games .Where(x => x.GameName == orderDto.GameName) .Select(x => x.Id).FirstOrDefault(); var PlayerId = gameShopDBContext.Players .Where(x => x.PlayerName == orderDto.PlayerName) .Select(x => x.Id).FirstOrDefault(); Order SaveOrder = new Order(); SaveOrder.gameid = GameId; SaveOrder.playerid = PlayerId; SaveOrder.DiscountPrice = orderDto.DiscountPrice; gameShopDBContext.Orders.Add(SaveOrder); gameShopDBContext.SaveChanges(); orderDto.Id = SaveOrder.Id; return(orderDto); } }
public GameDto CreateGame([FromBody] GameDto gameDto) { using (GameShopDBContext gameShopDBContext = new GameShopDBContext()) { Game game = new Game(); game.GameName = gameDto.GameName; game.GameType = gameDto.GameType; game.PlayTime = gameDto.PlayTime; game.Publisher = gameDto.Publisher; game.ReleaseDate = gameDto.ReleaseDate; game.Price = gameDto.Price; gameShopDBContext.Games.Add(game); gameShopDBContext.SaveChanges(); return(gameDto); } }
public CreatePlayerDto CreatePlayer([FromBody] CreatePlayerDto playerDto) { using (GameShopDBContext gameShopDBContext = new GameShopDBContext()) { Player player = new Player(); player.PlayerName = playerDto.PlayerName; player.Email = playerDto.Email; player.Phone = playerDto.Phone; player.BirthDate = playerDto.BirthDate; player.Gender = playerDto.Gender; player.Password = playerDto.Password; gameShopDBContext.Players.Add(player); gameShopDBContext.SaveChanges(); return(playerDto); } }