public DataTable ModifyChallenge() { Challenge item; try { item = new Challenge(Kv.Cxt, ChallengeID); item.Cxt = base.Kv.Cxt; item.ChallengerUserID = ChallengerUserID; item.ChallengeTypeID = ChallengeTypeID; item.ChessTypeID = ChessTypeID; item.ColorID = ColorID; item.IsRated = IsRated; item.WithClock = WithClock; item.IsChallengerSendsGame = IsChallengerSendsGame; item.Description = Description; item.GameTypeID = GameTypeID; item.OpponentUserID = OpponentUserID; item.RoomID = RoomID; item.StatusID = StatusID; item.TimeMin = TimeMin; item.GainPerMoveMin = GainPerMoveMin; item.ChallengeStatusIDE = ChallengeStatusE.Seeking; item.Cxt.CurrentUserID = Kv.Cxt.CurrentUserID; item.Save(); } catch (Exception ex) { throw ex; } return(Challenges.GetChallengesByRoomID(item.Cxt, RoomID, item.Cxt.CurrentUserID)); }
public DataTable UpdateFormula() { UserFormula item; try { string selectQuery; DataTable table; selectQuery = "SELECT TOP 1 * FROM UserFormula WHERE UserID = @p1"; table = BaseCollection.ExecuteSql(InfiChess.UserFormula, selectQuery, UserID); if (table != null && table.Rows.Count > 0) { item = new UserFormula(base.Kv.Cxt, table.Rows[0]); } else { item = new UserFormula(); } item.Cxt = base.Kv.Cxt; item.UserID = UserID; item.IsUnrated = IsUnrated; item.IsRated = IsRated; item.IsDucate = IsDucate; item.IsNoComputer = IsNoComputer; item.IsNoCentaur = IsNoCentaur; item.IsFastInternetOnly = IsFastInternetOnly; item.MinElo = MinElo; item.MaxElo = MaxElo; item.MinTime = MinTime; item.MaxTime = MaxTime; item.MinGainPerMove = MinGainPerMove; item.MaxGainPerMove = MaxGainPerMove; item.RankID = RankID; item.DucatesToOverride = DucatesToOverride; item.IsActive = IsActive; item.Cxt.CurrentUserID = base.Kv.Cxt.CurrentUserID; item.Save(); } catch (Exception ex) { throw ex; } return(Challenges.GetChallengesByRoomID(item.Cxt, base.Kv.GetInt32("RoomID"), item.Cxt.CurrentUserID)); }
public DataTable AddChallenge() { Challenge item; try { string selectQuery; DataTable table; if (OpponentUserID != 0) { selectQuery = "SELECT TOP 1 * FROM Challenge WHERE ChallengerUserID = @p1 AND OpponentUserID = @p2 AND ChallengeStatusID = 1 AND StatusID = 1"; table = BaseCollection.ExecuteSql(InfiChess.Challenge, selectQuery, ChallengerUserID, OpponentUserID); } else { selectQuery = "SELECT TOP 1 * FROM Challenge WHERE ChallengerUserID = @p1 AND OpponentUserID IS NULL AND ChallengeStatusID = 1 AND StatusID = 1"; table = BaseCollection.ExecuteSql(InfiChess.Challenge, selectQuery, ChallengerUserID, null); } if (table != null && table.Rows.Count > 0) { item = new Challenge(base.Kv.Cxt, table.Rows[0]); } else { item = new Challenge(); } item.Cxt = base.Kv.Cxt; item.ChallengerUserID = ChallengerUserID; item.ChallengeTypeID = ChallengeTypeID; item.ChessTypeID = ChessTypeID; item.ColorID = ColorID; item.IsRated = IsRated; item.WithClock = WithClock; item.IsChallengerSendsGame = IsChallengerSendsGame; item.Description = Description; item.GameTypeID = GameTypeID; if (OpponentUserID > 0) { item.OpponentUserID = OpponentUserID; } item.RoomID = RoomID; item.StatusID = StatusID; item.TimeMin = TimeMin; item.GainPerMoveMin = GainPerMoveMin; item.ChallengeStatusIDE = ChallengeStatusE.Seeking; item.Stake = Stake; item.Flate = Flate; item.Cxt.CurrentUserID = Kv.Cxt.CurrentUserID; item.Save(); } catch (Exception ex) { throw ex; } return(Challenges.GetChallengesByRoomID(item.Cxt, RoomID, item.Cxt.CurrentUserID)); }