public NBAGameInfo GetGameById(int gameId)
{
using (IDataReader reader = (IDataReader)this._helper.ExecuteReader(CommandType.Text, string.Format("select * from GameInfo g\r\nleft join TeamInfo a on g.away = a.id\r\nleft join TeamInfo h on g.home = h.id\r\nwhere g.id = '{0}'", (object)gameId), new SqlParameter[0]))
{
NBAGameInfo nbaGameInfo = new NBAGameInfo();
while (reader.Read())
{
nbaGameInfo = this.ReadGameInfo(reader);
}
return(nbaGameInfo);
}
}
public List <NBAGameInfo> GetGamesBySeason(string season)
{
using (IDataReader reader = (IDataReader)this._helper.ExecuteReader(CommandType.Text, string.Format("select * from GameInfo g\r\nleft join TeamInfo a on g.away = a.id\r\nleft join TeamInfo h on g.home = h.id\r\nwhere g.id like '{0}%' \r\norder by g.id desc", (object)season), new SqlParameter[0]))
{
List <NBAGameInfo> list = new List <NBAGameInfo>();
while (reader.Read())
{
NBAGameInfo nbaGameInfo = this.ReadGameInfo(reader);
list.Add(nbaGameInfo);
}
return(list);
}
}
public List <NBAGameInfo> GetGamesByDate(string date)
{
using (IDataReader reader = (IDataReader)this._helper.ExecuteReader(CommandType.Text, string.Format("select * from GameInfo g\r\nleft join TeamInfo a on g.away = a.id\r\nleft join TeamInfo h on g.home = h.id\r\nwhere [time] = '{0}'", (object)date), new SqlParameter[0]))
{
List <NBAGameInfo> list = new List <NBAGameInfo>();
while (reader.Read())
{
NBAGameInfo nbaGameInfo = this.ReadGameInfo(reader);
list.Add(nbaGameInfo);
}
return(list);
}
}
private NBAGameInfo ReadGameInfo(IDataReader reader)
{
NBAGameInfo nbaGameInfo = new NBAGameInfo();
nbaGameInfo.GameId = reader.GetInt32(0);
nbaGameInfo.AwayId = reader.GetInt32(2);
nbaGameInfo.HomeId = reader.GetInt32(3);
nbaGameInfo.GameTime = reader.GetDateTime(4);
nbaGameInfo.HalfScore = reader.GetString(5);
nbaGameInfo.FinalScore = reader.GetString(6);
nbaGameInfo.AsiaTapeResult = reader.GetInt32(9);
string string1 = reader.GetString(8);
if (!string.IsNullOrWhiteSpace(string1) && string1.Trim() != "-")
{
nbaGameInfo.AsiaTape = Convert.ToDecimal(string1);
}
nbaGameInfo.ScoreTapeResult = reader.GetInt32(11);
string string2 = reader.GetString(10);
if (!string.IsNullOrWhiteSpace(string2) && string2.Trim() != "-")
{
nbaGameInfo.ScoreTape = Convert.ToDecimal(string2);
}
nbaGameInfo.AwayName = reader.GetString(14);
nbaGameInfo.AwayEnName = reader.GetString(15);
nbaGameInfo.AwayLeague = reader.GetInt32(16);
nbaGameInfo.AwayAbbr = reader.GetString(17);
nbaGameInfo.HomeName = reader.GetString(21);
nbaGameInfo.HomeEnName = reader.GetString(22);
nbaGameInfo.HomeLeague = reader.GetInt32(23);
nbaGameInfo.HomeAbbr = reader.GetString(24);
string[] strArray = nbaGameInfo.FinalScore.Split(new string[1]
{
"-"
}, StringSplitOptions.RemoveEmptyEntries);
if (strArray.Length == 2)
{
nbaGameInfo.AwayPTS = Convert.ToInt32(strArray[0]);
nbaGameInfo.HomePTS = Convert.ToInt32(strArray[1]);
}
return(nbaGameInfo);
}
