示例#1
0
        private void Add_Group_Submit(object sender, RoutedEventArgs e)
        {
            var Group = Group_Textbox.Text;

            ServerDB.ExecuteDB("INSERT INTO server_groups ('name') VALUES ('" + Group + "');");
            PopulateList();
        }
示例#2
0
        private void ServerList_NodeMouseClick(object sender, MouseButtonEventArgs e)
        {
            TreeViewItem nodeItem = ServerList.SelectedItem as TreeViewItem;

            if (nodeItem == null)
            {
                return;
            }

            Config.groupId = nodeItem.DataContext.ToString();
            DataTable Servers     = ServerDB.ExecuteDB("SELECT * FROM servers WHERE group_id = " + nodeItem.DataContext ?? "1");
            var       serversJSON = JsonConvert.SerializeObject(Servers);
            dynamic   server      = JsonConvert.DeserializeObject(serversJSON);

            Config.Hostname      = server[0]["hostname"];
            Config.Username      = server[0]["username"];
            Config.Password      = new String[] { server[0]["password"] };
            Config.Port          = server[0]["port"];
            ActiveServer.Content = "Connect to server: " + Config.Hostname;
            Console.WriteLine(Config.Hostname);
            DataTable CommandList = ServerDB.ExecuteDB("SELECT * FROM commands WHERE group_id = " + nodeItem.DataContext ?? "1");
            //CommandListGrid.ItemsSource = CommandList.DefaultView;
            DataTable SoftwareList = ServerDB.ExecuteDB("SELECT * FROM software WHERE group_id = " + nodeItem.DataContext ?? "1");

            SoftwareListGrid.ItemsSource = SoftwareList.DefaultView;
            PopulateDataGrid();
            Username.Text   = Config.Username;
            Port.Text       = Config.Port;
            ServerName.Text = Config.Hostname;

            //ServerGroupDropdown.SelectedIndex = 1;
            //SoftwareDropdown();
        }
示例#3
0
        private void ExecuteCommand()
        {
            if (client == null)
            {
                MessageBox.Show("Select a server from the list to the left and click 'Connect' before continuing.",
                                "Not Connected");
                return;
            }

            string currentGroupId  = Config.groupId ?? "1";
            string sshCommand      = CommandTextbox.Text;
            string originalCommand = CommandTextbox.Text;

            sshCommand = sshCommand.Replace("[[Username]]", Regex_Username.Text ?? "");
            sshCommand = sshCommand.Replace("[[OldPassword]]", Regex_Old_Password.Text ?? "");
            sshCommand = sshCommand.Replace("[[NewPassword]]", Regex_New_Password.Text ?? "");
            sshCommand = sshCommand.Replace("[[Custom1]]", Regex_Custom_1.Text ?? "");
            sshCommand = sshCommand.Replace("[[Custom2]]", Regex_Custom_2.Text ?? "");
            sshCommand = sshCommand.Replace("[[Custom3]]", Regex_Custom_3.Text ?? "");

            try
            {
                Thread.Sleep(100);
                reader.ReadToEnd();
                Thread.Sleep(100);
                sh.WriteLine(sshCommand);
                Thread.Sleep(500);
                ReturnedString = reader.ReadToEnd();

                Console.WriteLine(ReturnedString);

                Console.WriteLine("Return Value = {0}", ReturnedString);
            }
            catch
            {
                Console.WriteLine("Fail");
            }

            ServerDB.ExecuteDB("INSERT INTO commands ('group_id', 'command', 'expected_response') VALUES ('" +
                               currentGroupId + "', '" + originalCommand + "', '" + ReturnedString.Replace("'", "''") +
                               "');");
            items.Insert(items.Count,
                         new CommandGridItems()
            {
                Delete   = false,
                Command  = sshCommand,
                Response = ReturnedString.Replace("'", "''"),
                Results  = ""
            });
            CommandRows2.ItemsSource = items;
            CommandRows2.Items.Refresh();
            PopulateDataGrid();
        }
示例#4
0
 private void Delete_Commands(object sender, RoutedEventArgs e)
 {
     foreach (CommandGridItems item in CommandRows2.ItemsSource)
     {
         if (((CheckBox)Delete.GetCellContent(item)).IsChecked == true)
         {
             var rowId = ID.GetCellContent(item) as TextBlock;
             ((CheckBox)Delete.GetCellContent(item)).Uid = rowId.Text;
             ServerDB.ExecuteDB("DELETE FROM commands where id = " + rowId.Text);
             PopulateDataGrid();
         }
     }
 }
示例#5
0
        public void PopulateList()
        {
            ServerList.Items.Clear();
            TreeViewItem treeItem = null;



            var     serverGroupList = ServerDB.ExecuteDB("SELECT * FROM server_groups");
            var     json            = JsonConvert.SerializeObject(serverGroupList);
            dynamic dynJson         = JsonConvert.DeserializeObject(json);

            ServerGroupDropdown.Items.Clear();
            foreach (var item in dynJson)
            {
                Console.WriteLine("Adding ServerGroup: " + item.name);
                ComboboxItem DropdownItem = new ComboboxItem();
                DropdownItem.Text  = item.name.ToString();
                DropdownItem.Value = item.id;
                ServerGroupDropdown.Items.Add(DropdownItem);

                treeItem             = new TreeViewItem();
                treeItem.Header      = item.name;
                treeItem.Uid         = item.id;
                treeItem.DataContext = item.id.ToString();
                treeItem.MouseUp    += ServerList_NodeMouseClick;

                var     serverListResults = ServerDB.ExecuteDB("SELECT * FROM servers WHERE group_id = " + item.id);
                var     serversJSON       = JsonConvert.SerializeObject(serverListResults);
                dynamic servers           = JsonConvert.DeserializeObject(serversJSON);
                foreach (var server in servers)
                {
                    treeItem.Items.Add(new TreeViewItem()
                    {
                        Header = server.name, Uid = server.id, DataContext = server.group_id.ToString()
                    });
                }
                ServerList.Items.Add(treeItem);
            }
            foreach (object item in ServerList.Items)
            {
                TreeViewItem treeItems = (TreeViewItem)item;
                if (treeItems != null)
                {
                    ExpandAllNodes(treeItems);
                    treeItems.IsExpanded = true;
                }
            }
        }
示例#6
0
        public static string RunCommands()
        {
            var     serverListResults = ServerDB.ExecuteDB("SELECT * FROM servers");
            var     serversJSON       = JsonConvert.SerializeObject(serverListResults);
            dynamic servers           = JsonConvert.DeserializeObject(serversJSON);

            foreach (var server in servers)
            {
                Console.WriteLine("Connecting to: " + server.name);
                string[]   password          = new string[] { server.password };
                Encryption decryptor         = new Encryption();
                string[]   decryptedPassword = decryptor.StartDecryption(password);
                string     serverPassword    = decryptedPassword[0];
                string     hostname          = server.hostname;
                string     username          = server.username;
                string     groupID           = server.group_id;


                using (var client = new SshClient(hostname, username, serverPassword))
                {
                    try
                    {
                        client.Connect();
                        var     serverCommandsList = ServerDB.ExecuteDB("SELECT * FROM commands where group_id = " + groupID);
                        var     json    = JsonConvert.SerializeObject(serverCommandsList);
                        dynamic dynJson = JsonConvert.DeserializeObject(json);
                        foreach (var command in dynJson)
                        {
                            var cmd = command.command.ToString();
                            Console.WriteLine("Command>" + cmd);
                            var run = client.CreateCommand(cmd);
                            run.Execute();
                            Console.WriteLine("Return Value = {0}", run.Result);
                            client.Disconnect();
                            string returnedResults = run.Result.ToString();
                            ServerDB.ExecuteDB("UPDATE commands set response = '" + returnedResults + "' WHERE id = " + command.id);
                        }
                    }
                    catch
                    {
                        Console.WriteLine("Fail");
                        return("Failure");
                    }
                }
            }

            return("true");
        }
示例#7
0
        private void Server_Add(object sender, RoutedEventArgs e)
        {
            var          selectedItem = ServerGroupDropdown.SelectedItem;
            ComboBoxItem cbi          = ServerGroupDropdown.ItemContainerGenerator.ContainerFromItem(selectedItem) as ComboBoxItem;
            var          json         = JsonConvert.SerializeObject(cbi);
            dynamic      dynJson      = JsonConvert.DeserializeObject(json);
            Encryption   decryptor    = new Encryption();

            string[] arr1 = new string[] { Password.Password };
            string[] encryptedPassword = decryptor.StartEncryption(arr1);
            // string[] dec = decryptor.StartDecryption(encryptedPassword);
            ServerDB.ExecuteDB("INSERT INTO servers (`group_id`, `name`, `hostname`, `port`, `type`, `username`, `password`) VALUES (" +
                               dynJson.Content.Value + ", '" + ServerName.Text + "', '" + ServerName.Text + "', " + Port.Text + ", 'ssh', '" +
                               Username.Text + "', '" + encryptedPassword[0] + "')");
            ServerList.Items.Clear();
            PopulateList();
        }
示例#8
0
        public MainWindow()
        {
            if (!File.Exists("zzz.sqlite"))
            {
                SQLiteConnection.CreateFile("zzz.sqlite");
                ServerDB.ExecuteDB(
                    "create table IF NOT EXISTS  servers (id INTEGER PRIMARY KEY AUTOINCREMENT, group_id int, name varchar(60), hostname varchar(60), port int, type varchar(6), username varchar(60), password varchar(200), description varchar(60))");
                ServerDB.ExecuteDB(
                    "create table IF NOT EXISTS server_groups (id  INTEGER PRIMARY KEY AUTOINCREMENT, name varchar(60))");
                ServerDB.ExecuteDB(
                    "CREATE TABLE IF NOT EXISTS 'commands'( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `group_id` INTEGER, `command` TEXT, `expected_response` TEXT, `response` TEXT, `sort_order` INTEGER)");
                ServerDB.ExecuteDB(
                    "CREATE TABLE IF NOT EXISTS `software` (`id`	INTEGER PRIMARY KEY AUTOINCREMENT,`group_id`	INTEGER,`name`	TEXT)");
                ServerDB.ExecuteDB("INSERT INTO server_groups VALUES (1, 'Server Group')");
                //ServerDB.ExecuteDB("INSERT INTO servers VALUES (1, 1, 'localhost', '127.0.0.1', 22, 'ssh', 'root', '', '')");
                //ServerDB.ExecuteDB("INSERT INTO software VALUES (1, 1, 'Shell')");
            }

            WindowStartupLocation = WindowStartupLocation.Manual;
            Left = -4500;
            Top  = -966;
            InitializeComponent();
            PopulateList();
            SoftwareSelection.SelectedIndex = 0;

            //using (var client = new SshClient(hostname, username, serverPassword))
            //{
            //    client.Connect();
            //    var sh = client.CreateShellStream("alan", 0, 0, 0,0,0);
            //    var reader = new StreamReader(sh);
            //    sh.WriteLine("mysql");
            //    Thread.Sleep(500);
            //    sh.WriteLine("show databases;");
            //    Thread.Sleep(500);

            //    Console.WriteLine(reader.ReadToEnd());
            //    //sh.WriteLine("quit;");
            //    client.Disconnect();
            //}
        }
示例#9
0
        public void PopulateDataGrid()
        {
            items = new List <CommandGridItems>();
            var     serverCommandsList = ServerDB.ExecuteDB("SELECT * FROM commands where group_id = " + Config.groupId);
            var     json    = JsonConvert.SerializeObject(serverCommandsList);
            dynamic dynJson = JsonConvert.DeserializeObject(json);

            foreach (var command in dynJson)
            {
                items.Insert(items.Count,
                             new CommandGridItems()
                {
                    Delete     = false,
                    Command    = command.command.ToString(),
                    Response   = command.expected_response.ToString(),
                    Results    = "",
                    Command_ID = command.id.ToString()
                });
            }

            CommandRows2.ItemsSource = items;
            CommandRows2.Items.Refresh();
        }
示例#10
0
 private void CopyItem(TreeViewItem _sourceItem, TreeViewItem _targetItem)
 {
     try
     {
         //adding dragged TreeViewItem in target TreeViewItem
         addChild(_sourceItem, _targetItem);
         ServerDB.ExecuteDB("UPDATE servers SET group_id = " + _targetItem.Uid + " WHERE id = " + _sourceItem.Uid);
         //finding Parent TreeViewItem of dragged TreeViewItem
         TreeViewItem ParentItem = FindVisualParent <TreeViewItem>(_sourceItem);
         // if parent is null then remove from TreeView else remove from Parent TreeViewItem
         if (ParentItem == null)
         {
             ServerList.Items.Remove(_sourceItem);
         }
         else
         {
             ParentItem.Items.Remove(_sourceItem);
         }
     }
     catch
     {
     }
 }
示例#11
0
        private void Add_Software_Submit(object sender, RoutedEventArgs e)
        {
            var Software = AddSoftwareTextBox.Text;

            ServerDB.ExecuteDB("INSERT INTO software ('group_id', 'name') VALUES ('" + Config.groupId + "','" + Software + "');");
        }