static int Main(string[] args)
{
if (args.Length < 1)
{
Console.WriteLine("Usage: StratenExport.exe <city>");
return(1); // OS: 0 == ok, != 0 == failure
}
string gemeente = args[0];
// Ctor verdient voorkeur: schrijf om
Land land = new Land {
Id = 1, Naam = "Belgie", TaalCode = "nl"
};
List <IExporter> exporters = new List <IExporter> {
new FileExporter(land), new ConsoleExporter(land)
};
var regio = new Regio {
Id = 1, Naam = "Vlaanderen", Land = land
};
land.Regios.Add(regio.Naam, regio); // SortedList
LandProvider landProvider = new LandProvider(land);
landProvider.Load(); // Lees binary dump file
foreach (var exporter in exporters)
{
exporter.Export(gemeente);
}
return(0);
}
public static void ExportRegio(Regio r)
{
string sql = "INSERT INTO Regio " +
"VALUES(@Id, @Naam, @LandId);";
using (SqlConnection conn = new SqlConnection(_connString))
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@Id", SqlDbType.Int);
cmd.Parameters.Add("@Naam", SqlDbType.NVarChar);
cmd.Parameters.Add("@LandId", SqlDbType.Int);
cmd.Parameters["@Id"].Value = r.Id;
cmd.Parameters["@Naam"].Value = r.Naam;
cmd.Parameters["@LandId"].Value = r.LandId;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
public Locatie(int Id, string Naam, Regio Regio, int OpdrachtgeverId)
{
this.Id = Id;
this.Naam = Naam;
this.Regio = Regio;
this.OpdrachtgeverId = OpdrachtgeverId;
}
public async Task <IActionResult> Postregio([FromBody] Regio regio)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//_regioService.addGame(regio);
if (regio != null)
{
List <Locatie> locaties = regio.locaties;
regio.locaties = null;
_context.Regios.Add(regio);
_context.SaveChanges();
if (locaties != null)
{
foreach (Locatie locatie in locaties)
{
AddMarker(locatie, regio.id);
}
}
return(Created("Created regio", regio));
}
else
{
return(NotFound());
}
}
public async Task <IActionResult> Putregio([FromRoute] int id, [FromBody] Regio regio)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != regio.id)
{
return(BadRequest());
}
_context.Entry(regio).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!regioExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public bool addGame(Regio regio)
{
if (regio != null)
{
_regioRepository.addGame(regio);
return(true);
}
else
{
return(false);
}
}
public bool addGame(Regio regio)
{
if (regio != null)
{
_context.Regios.Add(regio);
_context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public void ExportToDB()
{
var land = new Land()
{
Id = 32, Naam = "Belgie", TaalCode = "nl"
};
Exporters.ExportLand(land);
var regio = new Regio()
{
Id = 1, Naam = "Vlaanderen", LandId = 32
};
Exporters.ExportRegio(regio);
var provincies = _regioProvider.GetProvinciesByRegioId(regio.Id);
foreach (var pro in provincies)
{
Exporters.ExportProvincie(pro);
var gemeenten = _gemeenteProvider.GetGemeentenByProvincieId(pro.Id);
foreach (var gemeente in gemeenten)
{
var straten = _stratenProvider.GetStratenByGemId(gemeente.Id);
if (straten != null)
{
Exporters.ExportGemeente(gemeente);
foreach (Straat straat in straten)
{
Exporters.ExportStraat(straat);
}
}
}
}
}
public async Task <IActionResult> PostGame([FromBody] Game game) // creates new game
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (game != null)
{
List <Team> teams = game.teams;
Regio regio = game.regio;
List <Locatie> locaties = game.enabledLocaties;
game.teams = null;
game.regio = null;
game.enabledLocaties = null;
_context.Games.Add(game);
_context.SaveChanges();
game = await _context.Games.Include(ggame => ggame.teams).ThenInclude(team => team.CapturedLocaties).ThenInclude(capt => capt.locatie).Include(t => t.teams).ThenInclude(p => p.Users).Include(t => t.teams).Include(l => l.regio).ThenInclude(m => m.locaties).ThenInclude(i => i.puzzels).Include(r => r.regio).SingleOrDefaultAsync(m => m.id == game.id);
if (regio != null)
{
var dbregio = _context.Regios.SingleOrDefault(m => m.id == regio.id);
if (dbregio == null)
{
return(NotFound());
}
game.regio = dbregio;
_context.SaveChanges();
}
if (teams != null)
{
foreach (Team team in teams)
{
Team Team = new Team()
{
TeamName = team.TeamName
};
_context.Teams.Add(Team);
_context.SaveChanges();
var dbTeam = _context.Teams.SingleOrDefault(m => m.Id == Team.Id);
game.teams.Add(dbTeam);
_context.SaveChanges();
}
}
if (locaties != null)
{
var dbregio = _context.Regios.Include(r => r.locaties).ThenInclude(l => l.puzzels).SingleOrDefault(m => m.id == regio.id);
if (dbregio == null)
{
return(NotFound());
}
foreach (Locatie locatie in locaties)
{
//foreach(Locatie locatie in )
var dblocatie = dbregio.locaties.SingleOrDefault(m => m.id == locatie.id);
if (dblocatie == null)
{
return(NotFound());
}
if (game.enabledLocaties == null)
{
game.enabledLocaties = new List <Locatie>();
}
game.enabledLocaties.Add(dblocatie);
_context.SaveChanges();
}
}
return(Created("Created game", game));
}
return(BadRequest());
}
