public List <GameInfo> GetGameInfosByLeagues(IEnumerable <string> leagues)
{
List <GameInfo> list = new List <GameInfo>();
using (IDataReader reader = (IDataReader)SqlServerHelper.ExecuteReader(CommandType.Text, string.Format("select * from GameInfo where league IN N('{0}') and data_ready=0;", (object)string.Join("','", leagues)), new SqlParameter[0]))
{
while (reader.Read())
{
GameInfo gameInfo = DataHandler.RetrieveGameInfo(reader);
list.Add(gameInfo);
}
return(list);
}
}
public static List <GameInfo> GetGameInfosByDateAndLeague(DateTime gameTime, string League)
{
string cmdText = string.Format("SELECT * FROM GameInfo WHERE CAST(game_time as date)='{0}' AND league_name='{1}';", (object)gameTime.ToString("yyyy-MM-dd"), (object)League);
List <GameInfo> list = new List <GameInfo>();
using (IDataReader reader = (IDataReader)SqlServerHelper.ExecuteReader(CommandType.Text, cmdText, new SqlParameter[0]))
{
while (reader.Read())
{
GameInfo gameInfo = DataHandler.RetrieveGameInfo(reader);
list.Add(gameInfo);
}
return(list);
}
}
public static List <GameInfo> GetGameInfosByDate(string gameTime, bool dataReady)
{
string cmdText = string.Format("SELECT * FROM GameInfo WHERE CAST(game_time as date)='{0}';", (object)gameTime, (object)(dataReady ? 1 : 0));
List <GameInfo> list = new List <GameInfo>();
using (IDataReader reader = (IDataReader)SqlServerHelper.ExecuteReader(CommandType.Text, cmdText, new SqlParameter[0]))
{
while (reader.Read())
{
GameInfo gameInfo = DataHandler.RetrieveGameInfo(reader);
list.Add(gameInfo);
}
return(list);
}
}
