public void UpdateGame()
{
App.Model.Db.Game item = new App.Model.Db.Game(base.Kv.Cxt, Kv.GetInt32("GameID"));
if (!string.IsNullOrEmpty(Kv.Get("GameXml")))
{
item.GameXml = Kv.Get("GameXml");
}
item.GameResultID = Kv.GetInt32("GameResult");
item.GameFlags = Kv.Get("GameFlags");
item.Save();
}
public override void Save()
{
SqlTransaction trans = null;
this.DtTournamentUsersMatch = TournamentUsers.GetTournamentUsersByTournamentID(StatusE.Active, this.Tournament.TournamentID);
try
{
for (int i = 0; i < this.Count; i++)
{
trans = SqlHelper.BeginTransaction(Config.ConnectionString);
TournamentMatch tournamentMatch = this[i];
this.Save(trans);
Challenge Challenge = CreateChallenge(tournamentMatch);
Challenge.Save(trans);
Game Game = null;
//if (this.teamLooseStatusE != TeamLooseStatusE.None)
//{
// Game = CreateGame(this, Challenge);
Game.Save(trans);
//}
if (this.Tournament.TournamentStartDate == new DateTime())
{
this.Tournament.TournamentStartDate = DateTime.Now;
this.Tournament.TournamentStartTime = DateTime.Now;
this.Tournament.Save(trans);
}
SqlHelper.CommitTransaction(trans);
trans = SqlHelper.BeginTransaction(Config.ConnectionString);
//if (this.teamLooseStatusE != TeamLooseStatusE.None)
//{
Elo Elo = new Elo(Game);
if (Game.IsEloWhiteUpated && Game.IsEloBlackUpated)
{
Elo.Update(trans);
}
//}
SqlHelper.CommitTransaction(trans);
}
}
catch (Exception ex)
{
SqlHelper.RollbackTransaction(trans);
Log.Write(base.Cxt, ex);
}
}
public static Game RestartGameByMoveID(Cxt cxt, int gameID, int moveID, int wMin, int wSec, int bMin, int bSec)
{
Game g = new Game(cxt, gameID);
Moves moves = new Moves(g.GameXml);
moves.TruncateAfter(moveID);
Move ml = moves.Last;
ml.MoveTimeWhite = wMin + wSec;
ml.MoveTimeBlack = bMin + bSec;
g.GameXml = GetGameXML(UData.ToString(moves.DataTable));
g.Save();
return(g);
}
public DataSet AddGame(bool isOfferedReMatch)
{
try
{
#region Get Game Data
int challengeID = Kv.GetInt32("ChallengeID");
int currentUserID = Kv.GetInt32(StdKv.CurrentUserID); //opponent user id //using StdKv.CurrentUserID because of some reason -----base.Kv.Cxt.CurrentUserID
int opponentChessTypeID = Kv.GetInt32("ChessTypeID");
DataSet gds = App.Model.Db.Game.GetGameData(challengeID, currentUserID, opponentChessTypeID, isOfferedReMatch);
if (gds.Tables.Count < 2)
{
return(null);
}
gds.Tables[0].TableName = "Challenge";
gds.Tables[1].TableName = "Users";
gds.Tables[2].TableName = "UserGameTypes";
gds.Tables[3].TableName = "Engines";
if (gds.Tables.Count > 4)
{
gds.Tables[4].TableName = "TournamentMatch";
gds.Tables[5].TableName = "Tournament";
}
Challenge c = new Challenge(base.Kv.Cxt, gds.Tables["Challenge"].Rows[0]);
Users us = new Users(base.Kv.Cxt, gds.Tables["Users"]);
User uc = us[0];
User uo = us[1];
//if (currentUserID == uc.UserID)
//{
// if (uo.UserStatusIDE == UserStatusE.Playing || uo.UserStatusIDE == UserStatusE.Gone || uo.UserStatusIDE == UserStatusE.Kibitzer)
// {
// return null;
// }
//}
//else
//{
// if (uc.UserStatusIDE == UserStatusE.Playing || uc.UserStatusIDE == UserStatusE.Gone || uc.UserStatusIDE == UserStatusE.Kibitzer)
// {
// return null;
// }
//}
UserGameTypes ugts = new UserGameTypes(base.Kv.Cxt, gds.Tables["UserGameTypes"]);
UserGameType ugtc = new UserGameType();
UserGameType ugto = new UserGameType();
switch (ugts.Count)
{
case 1:
ugtc = ugts[0];
break;
case 2:
ugtc = ugts[0];
ugto = ugts[1];
break;
}
if (c.ChallengerUserID != ugtc.UserID)
{
UserGameType ugtt = ugtc;
ugtc = ugto;
ugto = ugtt;
}
if (c.ChallengerUserID != uc.UserID)
{
User ut = uc;
uc = uo;
uo = ut;
}
#endregion
#region Save Game
SqlTransaction t = null;
App.Model.Db.Game item = new App.Model.Db.Game();
if (c.ChessTypeIDE == ChessTypeE.Engine || c.ChessTypeIDE == ChessTypeE.Centaur)
{
if (ugtc.EloRating == 0)
{
ugtc.EloRating = 2200;
}
}
else
{
if (ugtc.EloRating == 0)
{
ugtc.EloRating = 1500;
}
}
if ((ChessTypeE)opponentChessTypeID == ChessTypeE.Engine || (ChessTypeE)opponentChessTypeID == ChessTypeE.Centaur)
{
if (ugto.EloRating == 0)
{
ugto.EloRating = 2200;
}
}
else
{
if (ugto.EloRating == 0)
{
ugto.EloRating = 1500;
}
}
try
{
switch (c.ColorIDE)
{
//case ColorE.Autometic:
case ColorE.White:
item.WhiteUserID = ugtc.UserID == 0 ? c.ChallengerUserID : ugtc.UserID;
item.BlackUserID = ugto.UserID == 0 ? currentUserID : ugto.UserID;
item.EloWhiteBefore = ugtc.EloRating;
item.EloBlackBefore = ugto.EloRating;
item.WhiteEngineID = uc.EngineID;
item.BlackEngineID = uo.EngineID;
item.WhiteChessTypeID = c.ChessTypeID;
item.BlackChessTypeID = opponentChessTypeID;
break;
case ColorE.Black:
item.BlackUserID = ugtc.UserID == 0 ? c.ChallengerUserID : ugtc.UserID;
item.WhiteUserID = ugto.UserID == 0 ? currentUserID : ugto.UserID;
item.EloBlackBefore = ugtc.EloRating;
item.EloWhiteBefore = ugto.EloRating;
item.BlackEngineID = uc.EngineID;
item.WhiteEngineID = uo.EngineID;
item.WhiteChessTypeID = opponentChessTypeID;
item.BlackChessTypeID = c.ChessTypeID;
break;
}
item.IsRated = c.IsRated;
item.IsChallengerSendsGame = c.IsChallengerSendsGame;
item.ChallengeID = c.ChallengeID;
item.GameResultIDE = GameResultE.InProgress;
item.GameTypeID = c.GameTypeID;
item.StartDate = DateTime.Now;
item.TimeMin = c.TimeMin;
item.GainPerMoveMin = c.GainPerMoveMin;
item.RoomID = c.RoomID;
item.GameXml = "";
if (c.TournamentMatchID != 0)
{
item.TournamentMatchID = c.TournamentMatchID;
}
t = SqlHelper.BeginTransaction(Config.ConnectionString);
Challenges.UpdateAllChallenges(t, c.ID, currentUserID, c.ChallengerUserID);
item.Save(t);
SqlHelper.CommitTransaction(t);
}
catch (Exception ex)
{
SqlHelper.RollbackTransaction(t);
//throw ex;
Log.Write(base.Kv.Cxt, ex);
}
#endregion
#region Return Game DataSet
item.DataRow.Table.TableName = "Game";
gds.Tables.Add(item.DataRow.Table.Copy());
gds.Tables.Remove("UserGameTypes");
return(gds);
#endregion
}
catch (Exception ex)
{
Log.Write(Kv.Cxt, ex);
return(null);
}
}
//public static void UpdateTournamentMatchStatus(Cxt cxt, int tournamentID, int tournamentMatchStatusID, string matchIDs)
//{
// string[] matches = matchIDs.Split(',');
// foreach (string item in matches)
// {
// UpdateTournamentMatchStatus(cxt, tournamentMatchStatusID, Convert.ToInt32(item));
// }
//}
#region Update Match Status
public static void UpdateTournamentMatchStatus(Cxt cxt, TournamentMatchStatusE tournamentMatchStatusID, TournamentMatch m)
{
SqlTransaction t = null;
Game g = null;
Challenge c = null;
DataTable dtMatches = TournamentMatches.GetTournamentsMatchByTournamentID(m.TournamentID);
TournamentMatches matches = new TournamentMatches(cxt, dtMatches);
DataTable dtGame = Games.GetAllGamesByTournamentID(cxt, m.TournamentID);
DataTable dtTUser = TournamentUsers.GetTournamentUsersByTournamentID(StatusE.Active, m.TournamentID);
try
{
if (!TournamentMatchRules.Instance.CanChangeStatus(m.TournamentMatchStatusE, tournamentMatchStatusID))
{
return;
}
m.EloBlackBefore = (m.EloBlackBefore == 0) ? 1500 : m.EloBlackBefore;
m.EloWhiteBefore = (m.EloWhiteBefore == 0) ? 1500 : m.EloWhiteBefore;
m.TournamentMatchStatusE = tournamentMatchStatusID;
if (GetGameResultID((TournamentMatchStatusE)tournamentMatchStatusID) != GameResultE.None)
{
m.GameResultIDE = GetGameResultID((TournamentMatchStatusE)tournamentMatchStatusID);
}
if (m.TournamentMatchStatusE == TournamentMatchStatusE.InProgress || m.IsBye || m.IsForced)
{
c = CreateChallenge(m);
}
t = SqlHelper.BeginTransaction(Config.ConnectionString);
m.Save(t);
if (c != null)
{
if (c.IsNew)
{
c.Save(t);
}
}
if (m.IsBye || m.IsForced)
{
if (c != null)
{
c.ChallengeStatusIDE = ChallengeStatusE.Decline;
c.StatusIDE = StatusE.Inactive;
c.Save(t);
}
TournamentUserResult(cxt, dtTUser, m, matches, dtGame).Save(t);
g = GetGame(cxt, m);
if (!g.IsNew)
{
g.GameResultIDE = m.GameResultIDE;
g.GameFlags = "";
g.Save(t);
}
}
SqlHelper.CommitTransaction(t);
switch (m.TournamentMatchStatusE)
{
case TournamentMatchStatusE.Draw:
case TournamentMatchStatusE.WhiteBye:
case TournamentMatchStatusE.BlackBye:
case TournamentMatchStatusE.ForcedWhiteWin:
case TournamentMatchStatusE.ForcedWhiteLose:
case TournamentMatchStatusE.ForcedDraw:
TournamentMatch.CreateChildMatchIfRequired(cxt, m, dtTUser);
break;
default:
break;
}
}
catch (Exception ex)
{
SqlHelper.RollbackTransaction(t);
Log.Write(cxt, ex);
}
}