private static bool CheckIfTheNameIsInTheDataBase(string nameOfTheSavedGame)
{
using (CheckersDBEntities db = new CheckersDBEntities())
{
try
{
var name = db.GameManagments.Where(g => g.Name == nameOfTheSavedGame).First();
return(true);
}
catch { }
}
return(false);
}
public static Guid GetData(string nameOfTheSavedGame)
{
using (CheckersDBEntities db = new CheckersDBEntities())
{
try
{
var gameId = db.GameManagments.Where(g => g.Name == nameOfTheSavedGame).First().GameId;
return(gameId);
}
catch { }
}
return(Guid.Empty);
}
public static List <BoardTile> GetData(Guid gameId)
{
using (CheckersDBEntities db = new CheckersDBEntities())
{
try
{
var boardTiles = db.BoardTiles.Where(b => b.GameId == gameId);
if (boardTiles.Any() == false)
{
return(new List <BoardTile>());
}
return(boardTiles.ToList());
}
catch
{ }
}
return(new List <BoardTile>());
}
public static Guid InsertData(string nameOfTheSavedGame, int CurrentTurn)
{
Guid gameId = new Guid();
using (CheckersDBEntities db = new CheckersDBEntities())
{
try
{
if (CheckIfTheNameIsInTheDataBase(nameOfTheSavedGame))
{
gameId = db.GameManagments.Where(g => g.Name == nameOfTheSavedGame).First().GameId;
db.GameManagments.Where(g => g.Name == nameOfTheSavedGame).First().CurrentColorTurn = CurrentTurn;
}
else
{
gameId = Guid.NewGuid();
GameManagment newGame = new GameManagment()
{
Name = nameOfTheSavedGame,
CurrentColorTurn = CurrentTurn,
GameId = gameId
};
db.GameManagments.Add(newGame);
}
db.SaveChanges();
return(gameId);
}
catch
{
return(Guid.Empty);
}
}
}
private static bool DeleteData(Guid gameId)
{
using (CheckersDBEntities db = new CheckersDBEntities())
{
try
{
var query = from Tiles in db.BoardTiles
where Tiles.GameId == gameId
select Tiles;
foreach (var tile in query)
{
db.BoardTiles.Remove(tile);
}
db.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
public static bool InsertData(List <BoardTile> boardTiles)
{
if (DeleteData(boardTiles[0].GameId) == false)
{
return(false);
}
using (CheckersDBEntities db = new CheckersDBEntities())
{
try
{
foreach (var tile in boardTiles)
{
db.BoardTiles.Add(tile);
db.SaveChanges();
}
}
catch
{
return(false);
}
}
return(true);
}