public static void AddIsElectableCandidate(string filename) { const int firstnameIndex = 1; const int lastnameIndex = 2; const int partynameIndex = 3; const int wahlkreisIdIndex = 4; var parsedFile = DataImportGeneral.ParseFile(filename); const int startIndex = 1; using (var context = new ElectionDBEntities()) { for (var i = startIndex; i < parsedFile.Count; i++) { var line = parsedFile.ElementAt(i); var result = GetTitleFirstnameLastnamePartynameFromLine(line); var firstname = result.ElementAt(firstnameIndex); var lastname = result.ElementAt(lastnameIndex); var partyname = result.ElementAt(partynameIndex); int wahlkreisId; var parsed = int.TryParse(line[wahlkreisIdIndex], out wahlkreisId); if (!parsed) { continue; } var existing = GetExistingCandidate(context, firstname, lastname, partyname, line[2]); var entry = new IsElectableCandidate { Election_Id = electionId, Person_Id = existing.Id, Wahlkreis_Id = wahlkreisId }; context.IsElectableCandidates.Add(entry); Console.WriteLine("Added person {0} is electable at wahlkreis {1} in election {2}", existing.Id, wahlkreisId, electionId); } context.SaveChanges(); } }
public static void AddIsElectableCandidate(string filename) { const int personIdIndex = 1; const int wahlkreisIdIndex = 7; var parsedFile = DataImportGeneral.ParseFile(filename); const int startIndex = 1; using (var context = new ElectionDBEntities()) { for (var i = startIndex; i < parsedFile.Count; i++) { var line = parsedFile.ElementAt(i); int wahlkreisId; var parsed = int.TryParse(line[wahlkreisIdIndex], out wahlkreisId); if (!parsed) { continue; } var personId = int.Parse(line[personIdIndex]); var entry = new IsElectableCandidate { Election_Id = electionId, Person_Id = personId, Wahlkreis_Id = wahlkreisId }; context.IsElectableCandidates.Add(entry); Console.WriteLine("Added person {0} is electable in wahlkreis {1} for election {2}", personId, wahlkreisId, electionId); } context.SaveChanges(); } }