//**************************************************************************************************
public void ExpandGroup(Group group)
{
group.Expanded = true;
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter("ID", group.ID);
sql.ExecuteTX("UPDATE groups SET Expanded=1 WHERE ID=@ID");
}
}
//**************************************************************************************************
public void DeleteServer(Server server)
{
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter("ID", server.ID);
sql.ExecuteTX("DELETE FROM servers WHERE ID=@ID");
}
Refresh();
}
//**************************************************************************************************
public void SetServerFavourite(Server server)
{
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter("ID", server.ID);
sql.ExecuteTX("UPDATE servers SET Favorite=1 WHERE id=@ID");
}
Refresh();
}
//*************************************************************************************************************
private void butRemovePass_Click(object sender, EventArgs e)
{
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.ChangePassword("");
Config.MasterPassword = "";
}
MessageBox.Show("Password removed", "XwRemote", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
//**************************************************************************************************
public void DeleteGroup(Group group)
{
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter("ID", group.ID);
sql.ExecuteTX("UPDATE servers SET GroupID=0 WHERE GroupID=@ID", false);
sql.ExecuteTX("DELETE FROM groups WHERE ID=@ID");
}
Refresh();
}
//**************************************************************************************************
public void SetValue(string key, string value)
{
values[key] = value;
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter(@"KEY", key);
sql.AddParameter(@"VALUE", value);
sql.ExecuteTX(@"INSERT OR REPLACE INTO System (SystemKey,SystemValue) VALUES (@KEY,@VALUE)");
}
}
//**************************************************************************************************
private void LoadValues()
{
values.Clear();
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.ExecuteTX("SELECT SystemKey, SystemValue FROM System");
while (sql.Read())
{
values.Add(sql.Value("SystemKey").ToString(), sql.Value("SystemValue").ToString());
}
}
}
//*************************************************************************************************************
public void SaveServer(Server server)
{
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter("Name", server.Name);
sql.AddParameter("Host", server.Host);
sql.AddParameter("Username", server.Username);
sql.AddParameter("Password", server.Password);
sql.AddParameter("Favorite", server.IsFavorite);
sql.AddParameter("ServerType", (int)server.Type);
sql.AddParameter("GroupID", server.GroupID);
sql.AddParameter("Color", server.Color);
sql.AddParameter("SendKeys", server.SendKeys);
sql.AddParameter("Sound", server.UseSound);
sql.AddParameter("Drives", server.ConnectDrives);
sql.AddParameter("Port", server.Port);
sql.AddParameter("X", server.Width);
sql.AddParameter("Y", server.Height);
sql.AddParameter("AutoScale", server.AutoScale);
sql.AddParameter("SSH1", server.SSH1);
sql.AddParameter("Passive", server.Passive);
sql.AddParameter("Themes", server.Themes);
sql.AddParameter("Certificates", server.Certificates);
sql.AddParameter("UseHtmlLogin", server.UseHtmlLogin);
sql.AddParameter("HtmlUserBox", server.HtmlUserBox);
sql.AddParameter("HtmlPassBox", server.HtmlPassBox);
sql.AddParameter("HtmlLoginBtn", server.HtmlLoginBtn);
sql.AddParameter("TabColor", server.TabColor);
sql.AddParameter("Notes", server.Notes);
sql.AddParameter("SshTerminal", server.SshTerminal);
sql.AddParameter("Encryption", server.Encryption);
sql.AddParameter("SshKey", server.SshKey);
sql.AddParameter("FtpDataType", server.FtpDataType);
if (server.ID == 0)
{
sql.Make(MakeType.INSERT, "Servers");
}
else
{
sql.AddParameter("ID", server.ID);
sql.Make(MakeType.UPDATE, "Servers", "id=@ID");
}
sql.ExecuteMK();
}
Refresh();
}
//**************************************************************************************************
private void LoadGroups()
{
groups.Clear();
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.ExecuteTX("SELECT id,name,expanded FROM groups ORDER BY name COLLATE NOCASE");
while (sql.Read())
{
Group group = new Group();
group.ID = sql.Value("id").ToInt32();
group.Name = sql.Value("name").ToString();
group.Expanded = sql.Value("expanded").ToBoolean();
groups.Add(group);
}
}
}
//**************************************************************************************************
public void SaveGroup(Group group)
{
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.AddParameter("Name", (group.Name == null) ? "New Group" : group.Name);
sql.AddParameter("Expanded", group.Expanded);
if (group.ID == 0)
{
sql.Make(MakeType.INSERT, "Groups");
}
else
{
sql.AddParameter("@ID", group.ID);
sql.Make(MakeType.UPDATE, "Groups", "id=@ID");
}
sql.ExecuteMK();
}
Refresh();
}
//*************************************************************************************************************
private void butSetPassword_Click(object sender, EventArgs e)
{
if (textMasterPassword.Text == "")
{
MessageBox.Show("Passwords must not be empty", "XwRemote", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (textMasterPassword.Text != textPasswordRepeat.Text)
{
MessageBox.Show("Passwords do not match", "XwRemote", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.ChangePassword(textMasterPassword.Text);
Config.MasterPassword = textMasterPassword.Text;
}
MessageBox.Show("Password added", "XwRemote", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//**************************************************************************************************
private void LoadServers()
{
Main.servers.Clear();
using (XwDbCommand sql = new XwDbCommand(Config.GetConnectionString(), "Data.SQLite"))
{
sql.ExecuteTX($@"SELECT
id
,name
,host
,ServerType
,Username
,Password
,port
,Sendkeys
,sound
,drives
,favorite
,groupid
,color
,X
,Y
,Console
,AutoScale
,SSH1
,Passive
,Themes
,Certificates
,UseHtmlLogin
,HtmlUserBox
,HtmlPassBox
,HtmlLoginBtn
,TabColor
,Notes
,SshTerminal
,Encryption
,SshKey
FROM Servers
ORDER BY name
COLLATE NOCASE");
while (sql.Read())
{
ServerType type = (ServerType)sql.Value("ServerType").ToInt32();
var server = Server.GetServerInstance(type);
server.ID = sql.Value("id").ToInt32();
server.Type = type;
server.Name = sql.Value("name").ToString();
server.Host = sql.Value("host").ToString();
server.Username = sql.Value("username").ToString();
server.Password = sql.Value("password").ToString();
server.Port = sql.Value("port").ToInt32();
server.SendKeys = sql.Value("sendkeys").ToBoolean();
server.UseSound = sql.Value("sound").ToBoolean();
server.ConnectDrives = sql.Value("drives").ToBoolean();
server.IsFavorite = sql.Value("favorite").ToBoolean();
server.GroupID = sql.Value("GroupID").ToInt32();
server.Color = sql.Value("Color").ToInt32();
server.Width = sql.Value("X").ToInt32();
server.Height = sql.Value("Y").ToInt32();
server.Console = sql.Value("Console").ToBoolean();
server.AutoScale = sql.Value("AutoScale").ToBoolean();
server.SSH1 = sql.Value("SSH1").ToBoolean();
server.Passive = sql.Value("Passive").ToBoolean();
server.Themes = sql.Value("Themes").ToBoolean();
server.Certificates = sql.Value("Certificates").ToBoolean();
server.UseHtmlLogin = sql.Value("UseHtmlLogin").ToBoolean();
server.HtmlUserBox = sql.Value("HtmlUserBox").ToString();
server.HtmlPassBox = sql.Value("HtmlPassBox").ToString();
server.HtmlLoginBtn = sql.Value("HtmlLoginBtn").ToString();
server.TabColor = sql.Value("TabColor").ToInt32();
server.Notes = sql.Value("Notes").ToString();
server.SshTerminal = sql.Value("SshTerminal").ToInt32();
server.Encryption = sql.Value("Encryption").ToBoolean();
server.SshKey = sql.Value("SshKey").ToString();
Main.servers.Add(server);
}
}
}
