private static void FixSportsman()
{
var connTarget = new InfoInteCleansingContext();
var i = 0;
using (var conn = new InfoInteCleansingContext())
{
conn.Database.SetCommandTimeout(500);
foreach (var sportsman in conn.sportsman)
{
var entryChanged = false;
if (sportsman.firstname != null && sportsman.firstname.EndsWith(" 0") && sportsman.firstname.Length > 1)
{
// Cut of " 0"
if (" 0".Equals(sportsman.firstname))
{
sportsman.firstname = null;
}
else
{
sportsman.firstname = sportsman.firstname.Substring(0, sportsman.firstname.Length - 3);
}
entryChanged = true;
}
if (sportsman.lastname != null && sportsman.lastname.ToUpper() == sportsman.lastname && sportsman.lastname.Length > 1)
{
sportsman.lastname = UppercaseWords(sportsman.lastname.ToLower());
if (sportsman.lastname.ToUpper() != sportsman.lastname)
{
entryChanged = true;
}
}
++i;
if (entryChanged)
{
Console.WriteLine("Change at: " + i + " id: " + sportsman.id);
connTarget.sportsman.Update(sportsman);
}
if (i % 50 == 0)
{
connTarget.SaveChanges();
}
}
}
}
static void Main(string[] args)
{
var connTarget = new NpgsqlConnection("Host=sebastiankoall.de;Username=infointe;Password=InfoInte1516%;Database=infointe");
connTarget.Open();
var connTarget2 = new InfoInteCleansingContext();
var i = 0;
using (var conn = new InfoInteCleansingContext())
{
conn.Database.SetCommandTimeout(200);
foreach (sportsman sportsman in conn.sportsman)
{
var entryChanged = false;
if (sportsman.firstname != null && sportsman.firstname.EndsWith(" 0") && sportsman.firstname.Length > 1)
{
// Cut of " 0"
if (" 0".Equals(sportsman.firstname))
{
sportsman.firstname = null;
}
else
{
sportsman.firstname = sportsman.firstname.Substring(0, sportsman.firstname.Length - 3);
}
entryChanged = true;
}
if (sportsman.lastname != null && sportsman.lastname.ToUpper() == sportsman.lastname && sportsman.lastname.Length > 1)
{
sportsman.lastname = UppercaseWords(sportsman.lastname.ToLower());
if (sportsman.lastname.ToUpper() != sportsman.lastname)
{
entryChanged = true;
}
}
++i;
//Console.WriteLine("Checked: " + i);
if (entryChanged)
{
Console.WriteLine("Change at: " + i + " id: " + sportsman.id);
connTarget2.sportsman.Update(sportsman);
/*var cmd = new NpgsqlCommand();
cmd.Connection = connTarget;
// Insert some data
cmd.CommandText = "UPDATE sportsman SET firstname = '" + sportsman.firstname + "', lastname = '" + sportsman.lastname + "' WHERE id = " + sportsman.id;
cmd.ExecuteNonQuery();*/
}
if (i%50 == 0)
{
connTarget2.SaveChanges();
}
}
}
connTarget.Close();
Console.ReadKey();
}