public static void LoadFakesForPeople(MySqlConnection connection, IEnumerable <TVTPerson> people)
{
var command = connection.CreateCommand();
command.CommandText = "SELECT * FROM tvt_convert WHERE type = 'actor'";
var Reader = command.ExecuteReader();
try
{
while (Reader.Read())
{
var oldValue = Reader.GetString("old");
var newValue = Reader.GetString("new");
var foundPeople = people.Where(x => x.FullName == oldValue);
foreach (var person in foundPeople)
{
PersonConverter.ConvertFakeFullname(person, newValue);
}
foundPeople = people.Where(x => x.FakeFullName == " " && x.FullName.Contains(oldValue));
foreach (var person in foundPeople)
{
PersonConverter.ConvertFakeFullname(person, newValue);
}
}
}
finally
{
if (Reader != null && !Reader.IsClosed)
{
Reader.Close();
}
}
}
