private List<Fixture> GetFixtures() { //command.Connection = connection; //command.CommandType = CommandType.StoredProcedure; //command.CommandText = "GetFixtures"; connection.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { Fixture fixture = new Fixture() { FixtureId = Convert.ToInt32(reader["FixtureId"]), HTeamID = Convert.ToInt32(reader["HTeamId"]), ATeamID = Convert.ToInt32(reader["ATeamId"]) }; fixtures.Add(fixture); } return fixtures; }
private void GetFixtures() { DateTime time = DateTime.Now; int thisWeek = Convert.ToInt16(time.GetWeekOfMonth()); /* Select all fixtures from FixtureTbl and create a class for each fixture */ connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetFixtures"; var reader = command.ExecuteReader(); while (reader.Read()) { Fixture fix = new Fixture() { FixtureId = Convert.ToInt32(reader["FixtureId"]), GameWeek = Convert.ToInt16(reader["GameWeek"]), HTeamID = Convert.ToInt32(reader["HTeamId"]), ATeamID = Convert.ToInt32(reader["ATeamId"]) }; tempFixtures.Add(fix); } reader.Close(); connection.Close(); //http://stackoverflow.com/questions/2136487/calculate-week-of-month-in-net/2136549#2136549 foreach (Fixture fix in tempFixtures) { if (fix.GameWeek == thisWeek) { fixtures.Add(fix); } } }