public static DataTable GetTournamentUsersWithCreatedDate(StatusE statusID, int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and StatusID = " + statusID.ToString("d") + " ORDER BY DateCreated ASC"));
}
public static DataTable GetTournamentUsersByTournamentID(int TeamA, int TeamB, int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and (TeamID = " + TeamA + " or TeamID = " + TeamB + ")"));
}
public static DataTable GetTournamentUsersByTournamentID(int statusID, int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and StatusID = " + statusID.ToString()));
}
/// <summary>
/// for online client
/// </summary>
/// <param name="statusID"></param>
/// <param name="tournamentID"></param>
/// <returns></returns>
public static DataTable GetTournamentUsersByTournamentID(StatusE statusID, int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentUser, "TournamentID = " + tournamentID + " and StatusID = " + statusID.ToString("d") + " ORDER BY EloBefore DESC"));
}
public static DataTable GetTournamntPlayers(int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentMatch, "GameResultID not in (1, 5, 6) and TournamentID = " + tournamentID + " and statusID <> 4"));
}
public static DataTable GetTournamntMatchesByParentID(int tournamentMatchParentID)
{
return(BaseCollection.Select(InfiChess.TournamentMatch, "ParentMatchID = " + tournamentMatchParentID));
}
public static DataTable GetWinnerTournamntMatch(int tournamentID, int round)
{
return(BaseCollection.Select(InfiChess.TournamentMatch, "GameResultID not in (1, 5, 6) and TournamentID = " + tournamentID + " and Round = " + round + " and statusID <> 4"));
}
public static DataTable GetTournamntMatchByParentID(int parentMatchID)
{
return(BaseCollection.Select(InfiChess.TournamentMatch, "ParentMatchID", parentMatchID.ToString(), "StatusID", (int)StatusE.Active));
}
public static DataTable GetTournamentMatchByRound(int tournamentID, int round)
{
return(BaseCollection.Select(InfiChess.TournamentMatch, "TournamentID", tournamentID, "Round", round, "StatusID", (int)StatusE.Active));
}
public static DataTable GetTournamntMatchByTournamentID(int tournamentID)
{
return(BaseCollection.Select(InfiChess.TournamentMatch, "TournamentID", tournamentID, "StatusID", (int)StatusE.Active));
}
public static DataTable GetTournamntMatch()
{
return(BaseCollection.Select(InfiChess.TournamentMatch, 0));
}
