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); }