public DataSet SetUserEngine() { int userID = base.Kv.GetInt32("UserID"); string engineName = base.Kv.Get("EngineName"); string userStatus = base.Kv.Get("UserStatus"); DataSet ds = new DataSet(); if (userID != 0) { Engine eng; DataTable dt = Engine.GetEngineByName(base.Kv.Cxt, engineName); if (dt.Rows.Count > 0) { eng = new Engine(base.Kv.Cxt, dt.Rows[0]); } else { eng = new Engine(); eng.Name = engineName.Trim(); eng.Description = engineName; eng.Save(); } User user = new User(base.Kv.Cxt, userID); user.EngineID = eng.EngineID; user.UserStatusID = UData.ToInt32(userStatus); user.Save(); } return(ds); }
public DataTable AddUser() { base.Kv.Cxt.CurrentUserID = 1; // New users are added by Admin = 1 User item = new User(); item.Cxt = base.Kv.Cxt; if (CountryID != 0) { item.CountryID = CountryID; } item.NearestCityID = NearestCityID; item.GenderID = GenderID; item.FideTitleID = FideTitleID; item.IccfTitleID = IccfTitleID; item.UserName = UserName; item.Email = Email; item.FirstName = FirstName; item.LastName = LastName; item.EngineID = 1; item.PasswordHint = PasswordHint; item.PersonalNotes = PersonalNotes; item.Url = Url; if (DateLastLogin != string.Empty) { item.DateLastLogin = Convert.ToDateTime(DateLastLogin); } if (DateOfBirth != string.Empty) { item.DateOfBirth = Convert.ToDateTime(DateOfBirth); } item.Password = Password; item.HumanRankIDE = RankE.Pawn; item.EngineRankIDE = RankE.Pawn; item.CentaurRankIDE = RankE.Pawn; item.CorrespondenceRankIDE = RankE.Pawn; item.StatusIDE = StatusE.Active; item.RoomID = 3; item.SocialID = 1; item.UserStatusIDE = UserStatusE.Blank; item.IsIdle = false; item.IsPause = false; item.Cxt.CurrentUserID = base.Kv.Cxt.CurrentUserID; item.Save(); if (!string.IsNullOrEmpty(UserImage)) { SaveUserImage(Ap.WebFolderUserImages + item.UserID); } DataTable roles = User.GetRolesTable(item.UserID); Kv kv1 = new Kv(); kv1.Set("MsgId", -1); kv1.Set("UserData", UData.ToString(item.DataRow.Table)); kv1.Set("RolesData", UData.ToString(roles.Copy())); return(kv1.DataTable); }
private UserGameType CalculateRating(UserGameType item, double result, double eResult, int userID, SqlTransaction t) { //Calculate K-Factor of both player RatingKFactor kFactor; //UserGameType item; //Calculate Rating kFactor = RatingKFactors.Instance.GetRatingKFactor(item.EloRating, item.NoOfGames); item.NoOfGames = item.NoOfGames + 1; item.EloRating = item.EloRating + UData.ToInt32(System.Math.Round(kFactor.KFactor * (result - eResult))); item.StoredMatches = item.StoredMatches + 1; //SqlTransaction t = null; try { //t = SqlHelper.BeginTransaction(Config.ConnectionString); //Save Rating item.Save(t); //Calculate Ranking -> Save Ranking CalculateRanking(item, t); //SqlHelper.CommitTransaction(t); } catch (Exception ex) { //SqlHelper.RollbackTransaction(t); throw ex; } return(item); }
public void Paste(string moves) { Flags.IsExamineMode = true; DataTable dt = UData.LoadDataTable(Notations.Game.Moves.DataTable.Clone(), moves); Paste(dt); Flags.IsExamineMode = false; }
private void SaveObject() { string path = Ap.FolderDataKv + "Obj.xml"; UData.WriteXmlDecrypted((DataTable)this.dgData.DataSource, path); MessageForm.Show("File saved successfully.\n\n" + path); }
public string GetGameXml(GameData gameData) { if (gameData == null) { return(""); } return(UData.ToString(gameData.Kv.DataTable)); }
public RsListItems(string[] dataKeyNames) { DataKeyNames = dataKeyNames; LoadXsdRes(UWeb.ResNameCtrl(typeof(RsList), "RsListItem.xsd")); UData.AddColumns(base.DataTable, dataKeyNames); }
public static void DeclineChallenges(DataTable dt) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.DeclineChallenges); kv.Set(StdKv.CurrentUserID, Ap.CurrentUserID); kv.Set("ChallengesData", UData.ToString(dt)); SocketClient.Instance.InvokeAsync(kv.DataTable.Copy()); }
public static DataTable Select(string tableName, params object[] whereColVals) { string sql = UData.ToSelect(tableName, whereColVals); DataTable table = SqlHelper.ExecuteDataset(Config.ConnectionString, CommandType.Text, sql).Tables[0]; table.TableName = tableName; return(table); }
public static string AddAudienceAsync(string uData) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.AddAudienceAsync); kv.Set("AudienceData", uData); string data = UData.ToString(kv.DataTable); return(data); }
public static string RemoveAudience(int userID) { Kv kv = new Kv(); kv.Set("MethodName", (int)MethodNameE.RemoveAudience); kv.Set("UserID", userID); string data = UData.ToString(kv.DataTable); return(data); }
public MoveLog(MoveComments moveComments) { Game = moveComments.Move.Game; DataTable = GetMoveLogTable(); this.MoveComments = moveComments; UData.LoadDataTable(DataTable, this.MoveComments[MoveCommentTypeE.MoveLog]); }
private string GetUserImage(string filePath) { string imagetype = ""; if (UFile.Exists(filePath + ".bmp")) { imagetype = ".bmp"; } else if (UFile.Exists(filePath + ".jpeg")) { imagetype = ".jpeg"; } else if (UFile.Exists(filePath + ".jpg")) { imagetype = ".jpg"; } else if (UFile.Exists(filePath + ".gif")) { imagetype = ".gif"; } else { return(string.Empty); } byte[] UserImageBytes = UImage.GetImageBytes(filePath + imagetype); //UserImageType = System.IO.Path.GetExtension(filePath); DataTable userImageTable = new DataTable("UserImageTable"); DataColumn nameColumn; nameColumn = new DataColumn(); nameColumn.DataType = System.Type.GetType("System.String"); nameColumn.ColumnName = "ImageName"; userImageTable.Columns.Add(nameColumn); DataColumn imageColumn; imageColumn = new DataColumn(); imageColumn.DataType = System.Type.GetType("System.Byte[]"); imageColumn.ColumnName = "ImageBytes"; userImageTable.Columns.Add(imageColumn); DataColumn typeColumn; typeColumn = new DataColumn(); typeColumn.DataType = System.Type.GetType("System.String"); typeColumn.ColumnName = "ImageType"; userImageTable.Columns.Add(typeColumn); DataRow dr = userImageTable.NewRow(); dr["ImageName"] = "UserImage"; dr["ImageBytes"] = UserImageBytes; dr["ImageType"] = imagetype; userImageTable.Rows.Add(dr); return(UData.ToString(userImageTable)); }
private void ProcessData(string str, UserSession us) { if (UData.IsValidXml(str)) { DataTable dt = UData.LoadDataTable(UData.LoadXsdText(str), str); Kv kv = new Kv(dt); Ap.MsgQueue.Enqueue(kv); } }
public void Union(string moves) { if (moves == "") { return; } DataTable dt = UData.LoadDataTable(Notations.Game.Moves.DataTable.Clone(), moves); AddMoves(dt); }
public PiecesTheme() { PiecesThemeData = UData.ToTable2("PiecesThemeData", "ThemeID", "PieceID", "PieceXaml"); ColorSchemeData = UData.ToTable2("ColorSchemeData", "ColorScheme", "BorderColor", "WhitePiecesColor", "BlackPiecesColor", "LightSquaresColor", "DarkSquaresColor"); KvBackground = new Kv(KvType.BackgroundThemes); KvColors = new Kv(KvType.ColorSchemes); KvPieces = new Kv(KvType.PiecesThemes); Load(); }
public void Load(string kvXml) { if (String.IsNullOrEmpty(kvXml)) { CreateKv(); } else { DataTable = UData.LoadDataTable(kvXml, kvXml); } }
public Kv(KvType type) { if (type == KvType.Web) { DataTable = UData.ToTable2("Kv", "k", "v"); } else { string path = GetFilePath(type); DataTable = UData.LoadDataTable5(path); } }
public static DataTable GetDataTable(DataTable table, string key) { try { string s = Get(table, key); return(UData.LoadDataTable(s)); } catch { return(null); } }
public string GetLastMoveXml() { DataRow dr = Moves.Last.DataRow; if (dr != null) { return(UData.ToString(dr)); } else { return(""); } }
public string GetOnlineGameXml() { DataRow dr = Notations.GetLastRow(); if (dr != null) { return(UData.ToString(dr)); } else { return(""); } }
//public DataSet SendSync(string data) public DataSet SendSync(string data) { try { if (SynSocket != null) { if (SynSocket.Connected) { SyncData = new StringBuilder(); int i = SynSocket.Receive(SyncBuffer); while (true) { SyncData.Append(System.Text.ASCIIEncoding.ASCII.GetString(SyncBuffer, 0, i)); if (!SyncData.ToString().Contains("\0")) { i = SynSocket.Receive(SyncBuffer); } else { break; } } if (UData.IsValidXml(SyncData.ToString())) { return(UData.LoadDataSet(SyncData.ToString())); } else { DataSet ds = new DataSet(); return(ds); } } else { return(new DataSet()); } } else { return(new DataSet()); } } catch (Exception ex) { return(new DataSet()); } }
public void SendAsync(DataTable dt) { try { if (userSession.AsynSocket != null) { byte[] data = System.Text.ASCIIEncoding.ASCII.GetBytes(UData.ToString(dt) + "\0"); userSession.AsynSocket.Send(data); } } catch (Exception ex) { OnServerDownError(ex); } }
public virtual void Add(TC items) { if (items == null) { return; } if (DataTable == null) { DataTable = items.DataTable.Copy(); return; } UData.ImportTable(DataTable, items.DataTable); }
public string GetGameXml() { if (GameData == null) { return(""); } if (string.IsNullOrEmpty(GameData.Guid)) { GameData.Guid = System.Guid.NewGuid().ToString(); } GameData.InitialBoardFen = InitialBoardFen; GameData.Moves = UData.ToString(Notations.Game.Moves.DataTable); switch (GameType) { case GameType.Bullet: case GameType.Blitz: case GameType.Rapid: case GameType.NoClock: GameData.OptionsBlitzClock = Ap.OptionsBlitzClock.Kv.ToDataTableString; break; case GameType.Long: GameData.OptionsLongClock = Ap.OptionsLongClock.Kv.ToDataTableString; break; } if (GameMode == GameMode.Kibitzer) { GameData.GameMode = GameMode.HumanVsHuman; } else { GameData.GameMode = GameMode; } GameData.GameType = GameType; ///////////////// GameData.Flags = this.Flags.Flags; GameData.GameResult = this.GameResult; ///////////////// return(UData.ToString(GameData.Kv.DataTable)); }
private bool SendSync(DataTable dt) { try { if (userSession.SynSocket != null) { byte[] data = System.Text.ASCIIEncoding.ASCII.GetBytes(UData.ToString(dt) + "\0"); userSession.SynSocket.Send(data); } } catch (Exception ex) { OnServerDownError(ex); return(false); } return(true); }
private void AddGame(Kv kvGame, Kv kvMoves) { GameData gameData = GetGameData(kvGame); Moves moves = GetMoves(kvMoves); if (isPgnToIcbConversion) { GameItem item = new GameItem(gameData, moves); book.ImportGame(item); } else { gameData.Guid = System.Guid.NewGuid().ToString(); gameData.Moves = UData.ToString(moves.DataTable); string gameXml = this.Game.GetGameXml(gameData); Ap.Database.AppendGame(gameXml); } }
public static DataTable LoadDataTable5(string xmlPath) { DataTable table = null; try { if (UFile.Exists(xmlPath)) { string content = InfinityStreamsManager.ReadFromFile(xmlPath); table = UData.LoadDataTable(content, content); } } catch (Exception ex) { throw ex; } return(table); }
public void GetUserGamesRating() { int totalGames = userGamesRating.Select().Count(); int whiteGames = userGamesRating.Select("WhiteUserID=" + Ap.CurrentUserID).Count(); int winGames = userGamesRating.Select("WhiteUserID=" + Ap.CurrentUserID + " AND GameResultID=1").Count(); winGames = winGames + userGamesRating.Select("BlackUserID=" + Ap.CurrentUserID + " AND GameResultID=2").Count(); int drawGames = userGamesRating.Select("WhiteUserID=" + Ap.CurrentUserID + " AND BlackUserID=" + Ap.CurrentUserID + " AND GameResultID=4").Count(); int lossesGames = totalGames - (winGames + drawGames); float res = ((float)(((float)drawGames / 2) + winGames) / totalGames) * 100; int nOpponent = (from DataRow dr in userGamesRating.Rows where (string)dr["WhiteUserID"] != Ap.CurrentUserID.ToString() select(string) dr["WhiteUserID"]).Distinct().Union((from DataRow dr in userGamesRating.Rows where (string)dr["WhiteUserID"] != Ap.CurrentUserID.ToString() select(string) dr["WhiteUserID"]).Distinct()).Count(); int rating = UData.ToInt32(userGamesRating.Select().FirstOrDefault()["EloRating"].ToString()); string str = (from DataRow dr in userGamesRating.Rows orderby dr["StartDate"] descending select(string) dr["StartDate"]).FirstOrDefault(); }
protected override void OnRowDataBound(GridViewRowEventArgs e) { base.OnRowDataBound(e); if (e.Row.RowType != DataControlRowType.DataRow) { return; } if (!ShowCheckBox || dataSourceSelected == null) { return; } if (UData.Contains((DataTable)dataSourceSelected, DataKeyNames.GetValue(0).ToString(), UWeb.ToString(e, DataKeyNames.GetValue(0).ToString()))) { CheckBox chk = e.Row.FindControl("chk") as CheckBox; chk.Checked = true; } }