public static void Initialize(OrganisationContext context)
{
context.Database.EnsureCreated();
if (context.Organisations.Any())
{
return;
}
var csvFile = "data/ketenorganisaties.csv";
var headerRead = false;
string line;
// Read the file and split it line by line.
var file = new StreamReader(csvFile);
while ((line = file.ReadLine()) != null)
{
if (!headerRead)
{
headerRead = true;
continue;
}
var d = line.Split(";");
AddNewOrganisation(context, d[1], d[2], d[3], d[4], d[5], d[6], d[7], d[8]);
}
context.SaveChanges();
}
private static void AddNewOrganisation(OrganisationContext context, string name, string organisatieid, string kvknummer, string vestigingsNummer, string rsin, string oin, string organisatiecode, string cbsNummer)
{
Organisation org = new Organisation
{
Id = Guid.NewGuid(),
Naam = name,
Organisatieid = organisatieid,
KvkNummer = kvknummer,
VestigingsNummer = vestigingsNummer,
Rsin = rsin,
Oin = oin,
Organisatiecode = organisatiecode,
CbsNummer = cbsNummer
};
context.Organisations.Add(org);
}
