public void Read() { string sql = "SELECT * FROM Servers"; //using (SQLiteConnection conn = new SQLiteConnection()) //{ //} string result = base.ExecuteQuery(sql, null); this.ArrayListServers.Clear(); if (result == string.Empty) { if (base.Database.Reader.HasRows) { while (base.Database.Reader.Read()) { Model_ServerDetails sd = new Model_ServerDetails() { UID = base.Database.Reader["uid"].ToString(), GroupID = int.Parse(base.Database.Reader["groupid"].ToString()), ServerName = base.Database.Reader["servername"].ToString(), Server = base.Database.Reader["server"].ToString(), Domain = base.Database.Reader["domain"].ToString(), Port = int.Parse(base.Database.Reader["port"].ToString()), Username = base.Database.Reader["username"].ToString(), Password = (new Func <string>(() => { string pword = base.Database.Reader["password"].ToString(); if (pword != string.Empty) { pword = RijndaelSettings.Decrypt(pword); } return(pword); }).Invoke()), Description = base.Database.Reader["description"].ToString(), ColorDepth = int.Parse(base.Database.Reader["colordepth"].ToString()), DesktopWidth = int.Parse(base.Database.Reader["desktopwidth"].ToString()), DesktopHeight = int.Parse(base.Database.Reader["desktopheight"].ToString()), Fullscreen = int.Parse(base.Database.Reader["fullscreen"].ToString()) == 1 ? true : false }; this.ArrayListServers.Add(sd); } } } else { base.Database.CloseConnection(); System.Diagnostics.Debug.WriteLine(result); throw new Exception(result); } base.Database.CloseConnection(); }
public Password(string value, bool isEncrypted) { IsEmpty = true; Encrypted = null; if (!string.IsNullOrEmpty(value)) { IsEmpty = false; Encrypted = isEncrypted ? value : RijndaelSettings.Encrypt(value); } }
public void Read() { string sql = "SELECT * FROM Servers"; //using (SQLiteConnection conn = new SQLiteConnection()) //{ //} SQLiteDataReader reader; string result = ExecuteQuery(sql, null, out reader); this._alServes.Clear(); if (result == string.Empty) { while (reader.Read()) { ServerDetails sd = new ServerDetails(); sd.UID = reader["uid"].ToString(); sd.GroupID = int.Parse(reader["groupid"].ToString()); sd.ServerName = reader["servername"].ToString(); sd.Server = reader["server"].ToString(); sd.Domain = reader["domain"].ToString(); sd.Port = int.Parse(reader["port"].ToString()); sd.Username = reader["username"].ToString(); string pword = reader["password"].ToString(); if (pword != string.Empty) { pword = RijndaelSettings.Decrypt(pword); } sd.Password = pword; sd.Description = reader["description"].ToString(); sd.ColorDepth = int.Parse(reader["colordepth"].ToString()); sd.DesktopWidth = int.Parse(reader["desktopwidth"].ToString()); sd.DesktopHeight = int.Parse(reader["desktopheight"].ToString()); sd.Fullscreen = int.Parse(reader["fullscreen"].ToString()) == 1 ? true : false; this._alServes.Add(sd); } reader.Close(); } else { CloseConnection(); System.Diagnostics.Debug.WriteLine(result); throw new Exception(result); } CloseConnection(); }
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(); }