public static Encrypt ( string PlainText ) : string | ||
PlainText | string | |
Результат | string |
public Password(string value, bool isEncrypted) { IsEmpty = true; Encrypted = null; if (!string.IsNullOrEmpty(value)) { IsEmpty = false; Encrypted = isEncrypted ? value : RijndaelSettings.Encrypt(value); } }
private void Save(ServerDetails server_details) { #region sql string sql = "INSERT INTO Servers(uid, groupid, servername, server, domain, port, username, password, description, colordepth, desktopwidth, desktopheight, fullscreen) "; sql += "VALUES(@uid, @gid, @sname, @server, @domain, @port, @uname, @pword, @desc, @cdepth, @dwidth, @dheight, @fscreen)"; #endregion #region params if (server_details.Password != string.Empty) { server_details.Password = RijndaelSettings.Encrypt(server_details.Password); } SQLiteParameter[] parameters = { new SQLiteParameter("@uid", server_details.UID), new SQLiteParameter("@gid", server_details.GroupID), new SQLiteParameter("@sname", server_details.ServerName), new SQLiteParameter("@server", server_details.Server), new SQLiteParameter("@domain", server_details.Domain), new SQLiteParameter("@port", server_details.Port), new SQLiteParameter("@uname", server_details.Username), new SQLiteParameter("@pword", server_details.Password), new SQLiteParameter("@desc", server_details.Description), new SQLiteParameter("@cdepth", server_details.ColorDepth), new SQLiteParameter("@dwidth", server_details.DesktopWidth), new SQLiteParameter("@dheight", server_details.DesktopHeight), new SQLiteParameter("@fscreen", server_details.Fullscreen) }; #endregion string result = ExecuteNonQuery(sql, parameters); if (result == string.Empty) { } else { CloseConnection(); System.Diagnostics.Debug.WriteLine(result); if (result.Contains("Abort due to constraint violation")) { throw new DatabaseException(DatabaseException.ExceptionTypes.DUPLICATE_ENTRY); } else { throw new Exception(result); } } CloseConnection(); }
private void Update(Model_ServerDetails server_details) { #region sql string sql = @" UPDATE Servers SET uid=@uid, groupid=@gid, servername=@sname, server=@server, domain=@domain, port=@port, username=@uname, password=@pword, description=@desc, colordepth=@cdepth, desktopwidth=@dwidth, desktopheight=@dheight, fullscreen=@fscreen WHERE uid=@uid"; #endregion #region params if (server_details.Password != string.Empty) { server_details.Password = RijndaelSettings.Encrypt(server_details.Password); } SQLiteParameter[] parameters = { new SQLiteParameter("@uid", server_details.UID), new SQLiteParameter("@gid", server_details.GroupID), new SQLiteParameter("@sname", server_details.ServerName), new SQLiteParameter("@server", server_details.Server), new SQLiteParameter("@domain", server_details.Domain), new SQLiteParameter("@port", server_details.Port), new SQLiteParameter("@uname", server_details.Username), new SQLiteParameter("@pword", server_details.Password), new SQLiteParameter("@desc", server_details.Description), new SQLiteParameter("@cdepth", server_details.ColorDepth), new SQLiteParameter("@dwidth", server_details.DesktopWidth), new SQLiteParameter("@dheight", server_details.DesktopHeight), new SQLiteParameter("@fscreen", server_details.Fullscreen) }; #endregion string result = base.ExecuteNonQuery(sql, parameters); if (result == string.Empty) { } else { base.Database.CloseConnection(); System.Diagnostics.Debug.WriteLine(result); if (result.Contains("Abort due to constraint violation")) { throw new DatabaseException(DatabaseException.ExceptionTypes.DUPLICATE_ENTRY); } else { throw new Exception(result); } } base.Database.CloseConnection(); }