/// <summary> /// Get score in table GameTextScore By GameID and TeamID. /// </summary> /// <param name="gameID">GameID</param> /// <param name="teamID">TeamID</param> /// <returns>Score if exists or 0 if not exist.</returns> public static ScoreGameInfo GetTeamInfoGTSByGameIDTeamIDVisitor(int gameID, int teamID) { MlbEntities mlb = new MlbEntities(); var query = (from rgi in mlb.RealGameInfo where rgi.GameID == gameID && rgi.VisitorTeamID == teamID select new ScoreGameInfo { GameID = rgi.GameID, TeamID = teamID, Inning = null, TB = null, R = rgi.VisitorScore }).FirstOrDefault(); ScoreGameInfo scoreInfo = new ScoreGameInfo(); if (query == null) { scoreInfo.GameID = gameID; scoreInfo.TeamID = teamID; scoreInfo.Inning = 0; scoreInfo.TB = 0; scoreInfo.R = 0; return scoreInfo; } else { return query; } }
/// <summary> /// Get score in table GameTextScore By GameID and TeamID. /// </summary> /// <param name="gameID">GameID</param> /// <param name="teamID">TeamID</param> /// <returns>Score if exists or 0 if not exist.</returns> public static ScoreGameInfo GetTeamInfoGTSByGameIDTeamID(int gameID, int teamID) { JlgEntities Jlg = new JlgEntities(); var query = (from grl in Jlg.GameReportLG join til in Jlg.TeamInfoLG on grl.GameReportLGId equals til.GameReportLGId where grl.GameID == gameID && til.ID == teamID select new ScoreGameInfo { GameID = grl.GameID, TeamID = teamID, R = til.Score }).FirstOrDefault(); ScoreGameInfo scoreInfo = new ScoreGameInfo(); if (query == null) { scoreInfo.GameID = gameID; scoreInfo.TeamID = teamID; return scoreInfo; } else { return query; } }
/// <summary> /// Get score in table GameTextScore By GameID and TeamID. /// </summary> /// <param name="gameID">GameID</param> /// <param name="teamID">TeamID</param> /// <returns>Score if exists or 0 if not exist.</returns> public static ScoreGameInfo GetTeamInfoGTSByGameIDTeamID(int gameID, int teamID) { NpbEntities npb = new NpbEntities(); var query = (from gi in npb.GameInfoGTS join ti in npb.TeamInfoGTS on gi.GameInfoGTSId equals ti.GameInfoGTSId where gi.GameID == gameID && ti.ID == teamID select new ScoreGameInfo { GameID = gi.GameID, TeamID = ti.ID, Inning = gi.Inning == null ? 0 : gi.Inning, TB = gi.TB == null ? 0 : gi.TB, R = ti.R }).FirstOrDefault(); ScoreGameInfo scoreInfo = new ScoreGameInfo(); if (query == null) { scoreInfo.GameID = gameID; scoreInfo.TeamID = teamID; scoreInfo.Inning = 0; scoreInfo.TB = 0; scoreInfo.R = 0; return scoreInfo; } else { return query; } }