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 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 Player GetPlayer(string playername)
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var OnePlayer = gameShopDBContext.Players.SingleOrDefault(x => x.PlayerName == playername);
return(OnePlayer);
}
}
public List <PlayerDto> GetPlayer()
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var AllPlayers = gameShopDBContext.Players
.Select(x => new PlayerDto()
{
Id = x.Id,
PlayerName = x.PlayerName,
Email = x.Email,
Phone = x.Phone,
BirthDate = x.BirthDate,
Gender = x.Gender
}).ToList();
return(AllPlayers);
}
}
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 List <GameDto> GetGame()
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var games = gameShopDBContext.Games
.Select(x => new GameDto()
{
Id = x.Id,
GameName = x.GameName,
Publisher = x.Publisher,
GameType = x.GameType,
ReleaseDate = x.ReleaseDate,
PlayTime = x.PlayTime,
Price = x.Price
}).ToList();
return(games);
}
}
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);
}
}
public PlayerDto GetPlayer(int id)
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var OnePlayer = gameShopDBContext.Players
.Select(x => new PlayerDto()
{
Id = x.Id,
PlayerName = x.PlayerName,
Email = x.Email,
Phone = x.Phone,
BirthDate = x.BirthDate,
Gender = x.Gender
})
.SingleOrDefault(x => x.Id == id);
return(OnePlayer);
}
}
public GameDto GetGame(int id)
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var OneGame = gameShopDBContext.Games
.Select(x => new GameDto()
{
Id = x.Id,
GameName = x.GameName,
Publisher = x.Publisher,
GameType = x.GameType,
ReleaseDate = x.ReleaseDate,
PlayTime = x.PlayTime,
Price = x.Price
})
.SingleOrDefault(x => x.Id == id);
return(OneGame);
}
}
public OrderDto GetOrder(int id)
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var OneOrder = gameShopDBContext.Orders.Include(x => x.game).Include(x => x.player)
.Select(x => new OrderDto()
{
Id = x.Id,
GameName = x.game.GameName,
PlayerName = x.player.PlayerName,
DiscountPrice = x.DiscountPrice,
Email = x.player.Email,
Price = x.game.Price,
Phone = x.player.Phone,
ReleaseDate = x.game.ReleaseDate
})
.SingleOrDefault(x => x.Id == id);
return(OneOrder);
}
}
public List <OrderDto> GetOrder()
{
using (GameShopDBContext gameShopDBContext = new GameShopDBContext())
{
var AllOrders = gameShopDBContext.Orders.Include(x => x.game).Include(x => x.player)
.Select(x => new OrderDto()
{
Id = x.Id,
GameName = x.game.GameName,
PlayerName = x.player.PlayerName,
DiscountPrice = x.DiscountPrice,
Email = x.player.Email,
Price = x.game.Price,
Phone = x.player.Phone,
ReleaseDate = x.game.ReleaseDate
})
.ToList();
return(AllOrders);
}
}
public CommentRepository(GameShopDBContext dBContext) : base(dBContext)
{
}
public IActionResult Shop()
{
db = new GameShopDBContext();
return(View(db));
}
