public static void LoadDatabase()
{
var m_read_entry = new SQLiteConnection("Data Source=" + getPath() + "settings.sqlite;Version=3;");
m_read_entry.Open();
string sql = "select * from managers order by alias desc";
SQLiteCommand command = new SQLiteCommand(sql, m_read_entry);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
MainWindow.ColumnLoader(reader["alias"].ToString());
torrentClients.ClientType client_type = (torrentClients.ClientType)Enum.Parse(typeof(torrentClients.ClientType), reader["type"].ToString());
torrentClients.client.AddUser(
reader["alias"].ToString(),
reader["hostname"].ToString(),
reader["port"].ToString(),
reader["username"].ToString(),
reader["password"].ToString(),
client_type,
reader["path"].ToString(),
reader["label"].ToString());
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
if (ValidateFields())
{
torrentClients.ClientType client_type = (torrentClients.ClientType)Enum.Parse(typeof(torrentClients.ClientType), type_comboBox.Text);
SqliteDatabase.AddEntry(
alias_textBox.Text,
hostname_textBox.Text,
port_textBox.Text,
username_textBox.Text,
passwordBox.Password,
type_comboBox.Text,
Custom_Path.Text,
label_textBox.Text);
torrentClients.client.AddUser(alias_textBox.Text,
hostname_textBox.Text,
port_textBox.Text,
username_textBox.Text,
passwordBox.Password,
client_type, Custom_Path.Text,
label_textBox.Text);
ClientWindow.RefreshClients();
MainWindow.ColumnLoader(alias_textBox.Text);
}
}
