#pragma warning disable IDE0051 // Remove unused private members
private static void ValidateConnectionToDB()
#pragma warning restore IDE0051 // Remove unused private members
{
string myConnectionString = ConfigurationManager.ConnectionStrings[0].ConnectionString;
using (SurvivalContext context = new SurvivalContext())
{
// Creating a Database with Code First in EF Core
// https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-example.html
context.Database.EnsureCreated();
//context.EnsureBasicDataCreated();
var obstacles = context.MapObstacles.Where(mo => mo.MapId == 1).OrderByDescending(mo => mo.Id).ToList();
Console.WriteLine(obstacles.Count);
}
}
public static List <IMap> GetAllMapNames()
{
using (SurvivalContext context = new SurvivalContext())
{
List <IMap> maps = new List <IMap>();
var dbMaps = context.Maps.ToList();
foreach (var dbMap in dbMaps)
{
IMap map = new Map(dbMap.Id, dbMap.Name, dbMap.SizeWidth, dbMap.SizeHeight, null);
maps.Add(map);
}
return(maps);
}
}
public static IMap GetMapData(int mapId)
{
using (SurvivalContext context = new SurvivalContext())
{
DAL.Map dbMap = context.Maps.Where(map => map.Id == mapId).SingleOrDefault();
if (dbMap == null)
{
return(null);
}
List <IObstacle> obstacles = new List <IObstacle>();
List <DAL.MapObstacle> dbObstacles = context.MapObstacles.Where(mo => mo.MapId == mapId).ToList();
foreach (var dbObstacle in dbObstacles)
{
IObstacle obstacle = new Obstacle(dbObstacle.Id, dbObstacle.CoordX, dbObstacle.CoordY, dbObstacle.Radius, dbObstacle.ObstacleType);
obstacles.Add(obstacle);
}
IMap map = new Map(dbMap.Id, dbMap.Name, dbMap.SizeWidth, dbMap.SizeHeight, obstacles);
return(map);
}
}
