private static List <Opfer> FindMatches(Stolperstein stone, List <Opfer> victims) { List <Opfer> matches = new List <Opfer>(); foreach (Opfer victim in victims) { if (victim.Geburtsort == stone.Ort && victim.Strasse == stone.Strasse && victim.Hausnummer == stone.Hausnummer) { victim.MatchingCount += 1; matches.Add(victim); } } return(matches); }
private static List <Stolperstein> CollectMemorialStones(ConsoleLogger logger, MySqlConnection connection) { List <Stolperstein> memorialStones = new List <Stolperstein>(); MySqlCommand command = new MySqlCommand("SELECT id, strasse, hausnummer, ort FROM tbl_st_maps_address;", connection); using (MySqlDataReader reader = command.ExecuteReader()) { int col1 = reader.GetOrdinal("id"); int col2 = reader.GetOrdinal("strasse"); int col3 = reader.GetOrdinal("hausnummer"); int col4 = reader.GetOrdinal("ort"); int counter = 0; while (reader.Read()) { object obj1 = reader.GetValue(col1); object obj2 = reader.GetValue(col2); object obj3 = reader.GetValue(col3); object obj4 = reader.GetValue(col4); int val1 = Convert.ToInt32(obj1); string val2 = obj2 == DBNull.Value ? null : (string)obj2; string val3 = obj3 == DBNull.Value ? null : (string)obj3; string val4 = obj4 == DBNull.Value ? null : (string)obj4; Stolperstein stolperstein = new Stolperstein() { ID = val1, Strasse = val2, Hausnummer = val3, Ort = val4 }; logger.Log($"[{counter}] {stolperstein.ToString()}"); memorialStones.Add(stolperstein); counter += 1; } } return(memorialStones); }