public Game Get(int GameId)
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Games.Where(x => x.Id == GameId).FirstOrDefault());
}
}
public List <Game> GetAll()
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Games.ToList());
}
}
public List <Player> GetAll()
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Players.ToList());
}
}
public Player Get(int PlayerId)
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Players.Where(x => x.Id == PlayerId).FirstOrDefault());
}
}
public Player GetByName(string PlayerName)
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Players.Where(x => x.Nick.Contains(PlayerName)).FirstOrDefault());
}
}
public List <Room> GetAll()
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Rooms.ToList());
}
}
public Room Get(int RoomId)
{
using (GameTestEntities ctx = new GameTestEntities())
{
return(ctx.Rooms.Where(x => x.Id == RoomId).FirstOrDefault());
}
}
public void Delete(int id)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var ic = ctx.Games.Where(x => x.Id == id).FirstOrDefault();
ctx.Games.Remove(ic);
ctx.SaveChanges();
}
}
public Player Update(Player model)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var ic = ctx.Players.Where(x => x.Id == model.Id).FirstOrDefault();
ic.Nick = model.Nick;
ic.Room = model.Room;
ctx.SaveChanges();
return(model);
}
}
public Room Update(Room model)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var ic = ctx.Rooms.Where(x => x.Id == model.Id).FirstOrDefault();
ic.CreatorId = model.CreatorId;
ic.Name = model.Name;
ic.Password = model.Password;
ctx.SaveChanges();
return(model);
}
}
public Game Update(Game model)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var ic = ctx.Games.Where(x => x.Id == model.Id).FirstOrDefault();
ic.Name = model.Name;
ic.Password = model.Password;
ic.Room = model.Room;
ic.Description = model.Description;
ctx.SaveChanges();
return(model);
}
}
public Player Add(Player model)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var m = ctx.Players.Add(new Player()
{
Nick = model.Nick
}); //tu dodajemy model
ctx.SaveChanges(); //tu zapisujemy zmiany
model.Id = m.Id;
ctx.SaveChanges();
return(model);
}
}
public Room Add(Room model)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var m = ctx.Rooms.Add(new Room()
{
Name = model.Name,
Password = model.Password,
CreatorId = model.CreatorId
}); //tu dodajemy model
ctx.SaveChanges(); //tu zapisujemy zmiany
model.Id = m.Id;
ctx.SaveChanges();
return(model);
}
}
public Game Add(Game model)
{
using (GameTestEntities ctx = new GameTestEntities())
{
var m = ctx.Games.Add(new Game()
{
Name = model.Name,
Password = model.Password,
Time = model.Time,
Room = model.Room,
Description = model.Description
}); //tu dodajemy model
ctx.SaveChanges(); //tu zapisujemy zmiany
model.Id = m.Id;
ctx.SaveChanges();
return(model);
}
}