public static void InsertDataToDb(GameEngine.GameBoard board, string boardName)
{
using var ctx = new AppDbContext();
// Create GameBoard model
var gameBoardModel = new GameBoard()
{
BoardName = boardName,
JsonString = JsonConvert.SerializeObject(board)
};
// Insert GameBoard model and save changes
ctx.GameBoards.Add(gameBoardModel);
ctx.SaveChanges();
}
public static GameEngine.GameBoard LoadDataFromDb(int boardId)
{
using var ctx = new AppDbContext();
var gameBoard = new GameEngine.GameBoard();
foreach (var board in ctx.GameBoards)
{
if (board.GameBoardId == boardId)
{
gameBoard = JsonConvert.DeserializeObject <GameEngine.GameBoard>(board.JsonString);
}
}
return(gameBoard);
}