public static Room GetRoomByTournamentID(Cxt cxt, ChessTypeE chessTypeE)
{
Room Room = null;
if (chessTypeE == ChessTypeE.Human)
{
Room = new Room(cxt, BaseCollection.SelectItem(InfiChess.Room, "ParentID = 7 and (TournamentID is NULL or TournamentID = 0) "));
}
else if (chessTypeE == ChessTypeE.Engine)
{
Room = new Room(cxt, BaseCollection.SelectItem(InfiChess.Room, "ParentID = 12 and (TournamentID is NULL or TournamentID = 0) "));
}
return(Room);
}
public static Challenge CreateChallenge(TournamentMatch m)
{
Challenge c = new Challenge(m.Cxt, BaseCollection.SelectItem(InfiChess.Challenge, "TournamentMatchID", m.TournamentMatchID));
c.ChallengerUserID = m.WhiteUserID;
c.OpponentUserID = m.BlackUserID;
c.ChessTypeIDE = m.Tournament.ChessTypeIDE;
c.ChallengeTypeIDE = ChallengeTypeE.Challenge;
c.IsRated = m.Tournament.Rated;
c.WithClock = true;
c.IsChallengerSendsGame = false;
c.GameTypeIDE = Game.GetGameType(m.TimeMin, m.TimeSec);
c.ColorIDE = ColorE.White;
c.TournamentMatchID = m.TournamentMatchID;
if (m.TournamentMatchTypeE == TournamentMatchTypeE.SuddenDeath)
{
Tournament t = new Tournament(m.Cxt, m.TournamentID);
c.TimeMin = t.SuddenDeathWhiteMin;
c.GainPerMoveMin = t.SuddenDeathSec;
}
else
{
c.TimeMin = m.TimeMin;
c.GainPerMoveMin = m.TimeSec;
}
if (m.Tournament.RoomID > 0)
{
c.RoomID = m.Tournament.RoomID;
}
if (m.IsNotBye)
{
c.ChallengeStatusIDE = ChallengeStatusE.Seeking;
c.StatusIDE = StatusE.Active;
}
else
{
c.ChallengeStatusIDE = ChallengeStatusE.Accepted;
c.StatusIDE = StatusE.Inactive;
}
return(c);
}
public static UserVoucher GetUserVoucher(Cxt cxt, int orderID)
{
return(new UserVoucher(cxt, BaseCollection.SelectItem(InfiChess.UserVoucher, orderID)));
}
public static TournamentWantinUser GetTournamentWantinUserById(Cxt cxt, int tournamentWantinUserId)
{
return(new TournamentWantinUser(cxt, BaseCollection.SelectItem(InfiChess.TournamentWantinUser, tournamentWantinUserId)));
}
public static UserMessage GetMessageById(Cxt cxt, int userMessageId)
{
return(new UserMessage(cxt, BaseCollection.SelectItem(InfiChess.UserMessage, userMessageId)));
}
public static Challenge GetChallangeById(Cxt cxt, int challengeID)
{
return(new Challenge(cxt, BaseCollection.SelectItem(InfiChess.Challenge, challengeID)));
}
public static Event GetEventByTournamentID(Cxt cxt, int tournamentID)
{
return(new Event(cxt, BaseCollection.SelectItem(InfiChess.Event, " EventObjectID= " + tournamentID)));
}
public static News GetNewsById(Cxt cxt, int newsId)
{
return(new News(cxt, BaseCollection.SelectItem(InfiChess.News, newsId)));
}
public static TournamentMatch GetTournamntMatchByTournamentAndPlayerID(Cxt cxt, int tournamentMatchID)
{
return(new TournamentMatch(cxt, BaseCollection.SelectItem(InfiChess.TournamentMatch, tournamentMatchID)));
}
public static Room GetRoomByTournamentID(Cxt cxt, int tournamentID)
{
return(new Room(cxt, BaseCollection.SelectItem(InfiChess.Room, "TournamentID =" + tournamentID)));
}
public static Room GetRoomByName(Cxt cxt, int roomName)
{
return(new Room(cxt, BaseCollection.SelectItem(InfiChess.Room, "Name = " + roomName)));
}
public static Room GetRoomById(Cxt cxt, int roomId)
{
return(new Room(cxt, BaseCollection.SelectItem(InfiChess.Room, roomId)));
}
public static UserFormula GetUserFormulaByUserID(Cxt cxt, int userID)
{
return(new UserFormula(cxt, BaseCollection.SelectItem(InfiChess.UserFormula, "UserID =" + userID)));
}
public static UserFormula GetUserFormulaById(Cxt cxt, int UserFormulaId)
{
return(new UserFormula(cxt, BaseCollection.SelectItem(InfiChess.UserFormula, UserFormulaId)));
}
public static ScheduledJob GetScheduledJobById(Cxt cxt, int ScheduledJobID)
{
return(new ScheduledJob(cxt, BaseCollection.SelectItem(InfiChess.ScheduledJob, ScheduledJobID)));
}
public static OrderDetail GetOrderDetail(Cxt cxt, int orderID)
{
return(new OrderDetail(cxt, BaseCollection.SelectItem(InfiChess.OrderDetail, "OrderID = " + orderID)));
}
public static BlockedIP GetBlockedIPsById(Cxt cxt, int BlockedIPsId)
{
return(new BlockedIP(cxt, BaseCollection.SelectItem(InfiChess.BlockedIP, BlockedIPsId)));
}
public static Game GetGameByID(Cxt cxt, int tournamentMatchID)
{
return(new Game(cxt, BaseCollection.SelectItem(InfiChess.Game, "TournamentMatchID", tournamentMatchID)));
}
public static Order GetOrderByID(Cxt cxt, int orderID)
{
return(new Order(cxt, BaseCollection.SelectItem(InfiChess.Order, orderID)));
}
public static Event GetEventID(Cxt cxt, int eventID)
{
return(new Event(cxt, BaseCollection.SelectItem(InfiChess.Event, eventID)));
}
public static ServerEventLog GetServerEventLogById(Cxt cxt, int ServerEventLogById)
{
return(new ServerEventLog(cxt, BaseCollection.SelectItem(InfiChess.ServerEventLog, ServerEventLogById)));
}
public static SendMessage GetMessageById(Cxt cxt, int SendMessageId)
{
return(new SendMessage(cxt, BaseCollection.SelectItem(InfiChess.SendMessage, SendMessageId)));
}
private static Game GetGame(Cxt cxt, TournamentMatch m)
{
return(new Game(m.Cxt, BaseCollection.SelectItem(InfiChess.Game, "TournamentMatchID", m.TournamentMatchID)));
}
public static Challenge GetChallangeByMatchId(Cxt cxt, int matchID)
{
return(new Challenge(cxt, BaseCollection.SelectItem(InfiChess.Challenge, "TournamentMatchID=" + matchID)));
}
public static Contact GetContactById(Cxt cxt, int contactID)
{
return(new Contact(cxt, BaseCollection.SelectItem(InfiChess.Contact, contactID)));
}
public static UserMessage GetMessagesByUserID(Cxt cxt, int userID)
{
return(new UserMessage(cxt, BaseCollection.SelectItem(InfiChess.UserMessage, "UserIDFrom=" + userID + " OR UserIDTo=" + userID)));
}
public static TournamentRound GetTournamentRoundById(Cxt cxt, int TournamentRoundId)
{
return(new TournamentRound(cxt, BaseCollection.SelectItem(InfiChess.TournamentRound, TournamentRoundId)));
}
public static TournamentWantinUser GetTournamentWantinUserById(Cxt cxt, int tournamentID, int userID)
{
return(new TournamentWantinUser(cxt, BaseCollection.SelectItem(InfiChess.TournamentWantinUser, "TournamentID = " + tournamentID + " AND UserID = " + userID)));
}
public static TournamentUser GetTournamentUserById(Cxt cxt, int TournamentID, int UserID)
{
return(new TournamentUser(cxt, BaseCollection.SelectItem(InfiChess.TournamentUser, "TournamentID = " + TournamentID + " and UserID = " + UserID)));
}