public static void calculateResults() { using (CastlesTableAdapters.CastlesTableAdapter adapter = new CastlesTableAdapters.CastlesTableAdapter()) { Castles.CastlesDataTable table = new Castles.CastlesDataTable(); Castles.CastlesDataTable compareToTable = new Castles.CastlesDataTable(); //Castles.CastlesDataTable compareToTables = new Castles.CastlesDataTable(); adapter.FillByRange(table, 0, 0); adapter.Fill(compareToTable); #region ToDo stuff //Castle castleFrom = new Castle(); //castleFrom = Castle.FrontDataObject(table[0]); //adapter.FillByNotID(compareToTables, 1); List <Castle> castles = new List <Castle>(); foreach (Castles.CastlesRow row in table) { Castle castle = new Castle(); castle = Castle.FrontDataObject(row); castles.Add(castle); } List <Castle> allCastles = new List <Castle>(); foreach (Castles.CastlesRow row in compareToTable) { Castle cas = new Castle(); cas = Castle.FrontDataObject(row); allCastles.Add(cas); } addPoints(castles, allCastles); foreach (Castles.CastlesRow row in table) { Castle castle = castles.Where(x => x.ID == row.Id).FirstOrDefault(); Castle.toDataObject(castle, row); } #endregion adapter.Update(table); table.AcceptChanges(); } }
public static Castle FrontDataObject(Castles.CastlesRow row) { Castle cas = new Castle(); cas.ID = row.Id; cas.CastleOne = row.CastleOne; cas.CastleTwo = row.CastleTwo; cas.CastleThree = row.CastleThree; cas.CastleFour = row.CastleFour; cas.CastleFive = row.CastleFive; cas.CastleSix = row.CastleSix; cas.CastleSeven = row.CastleSeven; cas.CastleEight = row.CastleEight; cas.CastleNine = row.CastleNine; cas.CastleTen = row.CastleTen; cas.TotalWins = row.IsTotalWinsNull() ? 0 : row.TotalWins; cas.TotalLosses = row.IsTotalLossesNull() ? 0 : row.TotalLosses; cas.TotalTies = row.IsTotalTiedNull() ? 0 : row.TotalTied; cas.Rank = row.IsRankNull() ? 0 : row.Rank; return(cas); }
public static void toDataObject(Castle cas, Castles.CastlesRow row) { row.TotalWins = cas.TotalWins; row.TotalLosses = cas.TotalLosses; row.TotalTied = cas.TotalTies; }