public ExportRankLeague(XLWorkbook workbook) { ConnectionPostgreSQL accion = new ConnectionPostgreSQL(); connection = accion.OpenConnection(); DataTable dataRank = GenerateData(connection); AddRankLeague(workbook, dataRank); }
static void Main(string[] args) { ConnectionPostgreSQL bd = new ConnectionPostgreSQL(); //bd.AbreConexion(); string imei = "shell dumpsys iphonesubinfo"; imei = ConnectionPostgreSQL.StartADB(imei); char[] arreglo = imei.TrimEnd('\n').TrimEnd('\r').ToCharArray(); StringBuilder sb = new StringBuilder(); for (int i = arreglo.Length - 15; i < arreglo.Length; i++) { if (arreglo[i] != ' ') { sb.Append(arreglo[i], 1); } } imei = sb.ToString(); double resultimei; resultimei = Convert.ToDouble(imei); bd.guardarimei(resultimei); }
public void btn_Submit_Click(object sender, RoutedEventArgs e) { ConnectionPostgreSQL connPostgres = new ConnectionPostgreSQL(); string idUser = ""; string hashPassFromDB = ""; bool enter = false; if (textboxLogin.Text != "" && textboxPass.Text != "") { try { using (NpgsqlConnection cn = connPostgres.conn) { cn.Open(); sqlCmd = @"select id, password from employees " + "where login='******';"; cmd = new NpgsqlCommand(); cmd.Connection = cn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = sqlCmd; NpgsqlDataReader rdr; if ((rdr = cmd.ExecuteReader()) != null) { while (rdr.Read()) { idUser = rdr.GetValue(0).ToString(); hashPassFromDB = rdr.GetValue(1).ToString(); } bool isValidPassword = BCrypt.Net.BCrypt.Verify(passboxPass.Password, hashPassFromDB); if (isValidPassword) { enter = true; } else { MessageBox.Show("Неверный логин/пароль. \n ", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Неверный логин/пароль. \n ", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } cmd.Dispose(); } } catch (Exception ex) { MessageBox.Show("Не удалось подключиться к базе данных \n" + ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Заполните все поля!!!", "Error", MessageBoxButton.OK, MessageBoxImage.Error); } if (enter) { MessageBox.Show("Вход выполнен успешно", "Success", MessageBoxButton.OK, MessageBoxImage.Information); this.Hide(); MainMenu mainMenu = new MainMenu(idUser); mainMenu.Show(); } }