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();
}
}
