public static void CreateZip() { using (var zip = new Ionic.Zip.ZipFile()) { using (FileStream fs = File.Create(SavingPath)) { zip.AddDirectory(OutputPath); zip.Save(fs); } } try { var dir = new DirectoryInfo(OutputPath); dir.Attributes = dir.Attributes & ~FileAttributes.ReadOnly; dir.Delete(true); } catch (IOException ex) { FileParser.LogException(ex); } /*using (var zip = new Ionic.Zip.ZipFile()) * { * zip.AddDirectory(Environment.GetFolderPath( * System.Environment.SpecialFolder.DesktopDirectory) + "\\code"); * FileStream x = File.Create("D:\\Visual Studio\\CommandGenerator\\MyFile.zip"); * zip.Save(x); * x.Close(); * zip.Dispose(); * } */ }
private void ListingNetworks() { SQLiteConnection myconn = new SQLiteConnection(path); try { myconn.Open(); } catch (Exception ex) { FileParser.LogException(ex); MessageBox.Show("Check Network"); } Queries q = new Queries(); DataTable show = new DataTable(); SQLiteDataAdapter adap = new SQLiteDataAdapter(q.ShowNetworks(), myconn); adap.Fill(show); try { NetworkGrid.DataSource = show; } catch (Exception ex) { NetworkGrid.Rows[row].Cells[2].Value = oldip; NetworkGrid.Rows[row].Cells[3].Value = olduser; NetworkGrid.Rows[row].Cells[4].Value = Encrypt(oldpass); NetworkGrid.Rows[row].Cells[5].Value = oldname; // FileParser.LogException(ex); } myconn.Close(); }
public void BrowzeButtonClicked(ComboBox sheetsCB) { try { using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "Excel Workbook 97-2003|*.xls|Excel Workbook|*.xlsx", ValidateNames = true }) { if (ofd.ShowDialog() == DialogResult.OK && !string.IsNullOrEmpty(ofd.FileName)) { workbookProcessor.ReadWorkbook(ofd.FileName, ofd.FilterIndex); sheetsCB.Items.Clear(); foreach (DataTable dt in workbookProcessor.GetSheets()) { sheetsCB.Items.Add(dt.TableName); } workbookProcessor.InitializeStatus(); } } } catch (Exception ex) { FileParser.LogException(ex); } }
public static void SaveResult(string name, string IP, string commandText, string result) { try { string path = Path.GetFullPath(OutputPath); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } path += ("\\" + name); path = Path.GetFullPath(path); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string Filep = "command_" + Ncounter + ".txt"; string file = Path.Combine(path, Filep); string text = name + Environment.NewLine + IP + Environment.NewLine + commandText + Environment.NewLine + result + Environment.NewLine + Environment.NewLine; File.WriteAllText(file, text); string alltxt = OutputPath + "\\AllCommands.txt"; using (StreamWriter w = File.AppendText(alltxt)) { w.WriteLine(text); } Ncounter++; } catch (Exception ex) { FileParser.LogException(ex); } }
public bool Excute(string name, string command) { string[] data = dbr.AccessNetworkElement(name); string IP = data[0]; string username = data[1]; string password = data[2]; try { using (var client = new SshClient(IP, username, password)) { client.Connect(); var cmd = client.RunCommand(command); if (FileParser.SetSavingPath()) { FileParser.CreateDirectory(); FileParser.SaveResult(name, IP, cmd.CommandText, cmd.Result); FileParser.CreateZip(); } client.Disconnect(); return(true); } } catch (Exception ex) { FileParser.LogException(ex); return(false); } }
private bool AddingNetworks(String Username, String Enc_Password, String IP, String Name) { SQLiteConnection myconn = new SQLiteConnection(pathh); try { myconn.Open(); } catch (Exception ex) { FileParser.LogException(ex); MessageBox.Show("Check Network"); } Queries q = new Queries(); DataTable show = new DataTable(); SQLiteCommand cmd = new SQLiteCommand(q.AddNetwork(Username, Enc_Password, IP, Name), myconn); int Result = cmd.ExecuteNonQuery(); myconn.Close(); if (Result > 0) { return(true); } else { return(false); } }
public void RefreshConnection(string name) { try { int position = networkElements.IndexOf(name); if (position >= 0) { int status = dataBaseReference.CheckConn1(name); networkElementsStatus[position] = status; RefreshStatus(name, status); } //networkElementsStatus[position] = dataBaseReference.CheckConn1(name); } catch (Exception ex) { FileParser.LogException(ex); } }
public bool TestConnection(string SSHIp, string Username, string Password) { try { bool res = false; using (var client = new SshClient(SSHIp, Username, Password)) { client.Connect(); res = client.IsConnected; client.Disconnect(); } return(res); } catch (Exception ex) { FileParser.LogException(ex); return(false); } }
private bool Login() { String logname = txt_Username.Text; String Password = User.Encrypt(txt_Password.Text); string[] s = { "\\bin" }; string database = Application.StartupPath.Split(s, StringSplitOptions.None)[0] + "\\Data\\Nokia.db"; string connectionString = "Data Source=" + Path.GetFullPath(database); SQLiteConnection myconn = new SQLiteConnection(connectionString); try { myconn.Open(); Queries q = new Queries(); DataTable show = new DataTable(); SQLiteCommand cmd = new SQLiteCommand(q.Login(logname, Password), myconn); int Result = Convert.ToInt32(cmd.ExecuteScalar()); Console.WriteLine(Result); myconn.Close(); if (Result > 0) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show("PROBLEM RETRIEVING DATA PLEASE TRY AGAIN"); FileParser.LogException(ex); } return(false); }
private void RefreshUsers() { SQLiteConnection myconn = new SQLiteConnection(pathh); myconn.Open(); DataTable show = new DataTable(); SQLiteDataAdapter adap = new SQLiteDataAdapter("Select * from usersTable", myconn); adap.Fill(show); try { usersGrid.DataSource = show; } catch (Exception ex) { usersGrid.Rows[User.row].Cells[2].Value = User.oldUsername; usersGrid.Rows[User.row].Cells[3].Value = User.Encrypt(User.oldPassword); FileParser.LogException(ex); } myconn.Close(); }
private void ListingNetworks() { SQLiteConnection myconn = new SQLiteConnection(pathh); try { myconn.Open(); } catch (Exception ex) { FileParser.LogException(ex); MessageBox.Show("Check Network"); } Queries q = new Queries(); DataTable show = new DataTable(); SQLiteDataAdapter adap = new SQLiteDataAdapter(q.ShowNetworks(), myconn); adap.Fill(show); NetworkGrid.DataSource = show; myconn.Close(); }
//////////--------------------Networks Tab--------------------\\\\\\\\\\ private void NetworkGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { try { string str = NetworkGrid.Rows[e.RowIndex].Cells[5].Value.ToString(); if (MessageBox.Show("Are you sure you want to delete network element '" + str + "' ?", "Confirm Deletion", MessageBoxButtons.YesNo) == DialogResult.Yes) { SQLiteConnection myconnection = new SQLiteConnection(path); myconnection.Open(); SQLiteCommand cmd = new SQLiteCommand(q.DeleteNetwork(str), myconnection); cmd.ExecuteNonQuery(); myconnection.Close(); ListingNetworks(); } } catch (Exception ex) { FileParser.LogException(ex); } } }
private void UsersGrid_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { try { string str = usersGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); if (MessageBox.Show("Are you sure you want to delete user '" + str + "' ?", "Confirm Deletion", MessageBoxButtons.YesNo) == DialogResult.Yes) { SQLiteConnection myconnection = new SQLiteConnection(path); myconnection.Open(); SQLiteCommand cmd = new SQLiteCommand("delete from usersTable where username = @username;", myconnection); cmd.Parameters.Add(new SQLiteParameter("@username", str)); cmd.ExecuteNonQuery(); myconnection.Close(); RefreshUsers(); } } catch (Exception ex) { FileParser.LogException(ex); } } }
private static void MyCommonExceptionHandlingMethod(object sender, ThreadExceptionEventArgs e) { //#comment use your logger FileParser.LogException(e.Exception); throw new NotImplementedException(); }