public void Save(bool isNew, ServerDetails server_details)
{
if (isNew)
{
Save(server_details);
}
else
{
Update(server_details);
}
}
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();
}
public void Read()
{
string sql = "SELECT * FROM Servers";
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);
}
}
else
{
CloseConnection();
System.Diagnostics.Debug.WriteLine(result);
throw new Exception(result);
}
CloseConnection();
}
private void Update(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 = 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();
}