public List<ScenarioTile> GetScenarioTiles(int scenarioid)
 {
     List<ScenarioTile> scenarioTiles = new List<ScenarioTile>();
     PanzerEntities entities = new PanzerEntities();
     var panzer_ScenarioTiles = entities.Panzer_ScenarioTile.Where(pst => pst.ScenarioId == scenarioid).ToList();
     foreach (Panzer_ScenarioTile panzer_ScenarioTile in panzer_ScenarioTiles)
     {
         scenarioTiles.Add(CreateScenarioTile(panzer_ScenarioTile));
     }
     return scenarioTiles;
 }
 public List<Scenario> GetActiveScenarios()
 {
     List<Scenario> scenarios = new List<Scenario>();
     PanzerEntities entities = new PanzerEntities();
     var query = entities.Panzer_Scenario.Where(ps => ps.ActiveInd == true);
     foreach (var panzer_scenario in query)
     {
         scenarios.Add(CreateScenario(panzer_scenario));
     }
     return scenarios;
 }
 public ScenarioTile GetScenarioTile(int scenarioTileid)
 {
     PanzerEntities entities = new PanzerEntities();
     var panzer_ScenarioTile = entities.Panzer_ScenarioTile.Where(pst => pst.ScenarioTileId == scenarioTileid).FirstOrDefault();
     return CreateScenarioTile(panzer_ScenarioTile);
 }