private void bttnConfirm_Click(object sender, EventArgs e)
{
connection = new MySqlConnection("server = 127.0.0.1; port = 3306; user = root; password = Vfhnvfhn23@; database = tinkoffbudget; sslmode = none");
connection.Open();
string Password = HashingPsw.HashPassword(tbPassword.Text);
MySqlCommand cSelect = new MySqlCommand("SELECT Логин, Пароль FROM пользователи WHERE Логин= '" + tbLogin.Text + "' AND Пароль= '" + Password + "'", connection);
MySqlDataAdapter daSelect = new MySqlDataAdapter(cSelect);
DataTable dtSelect = new DataTable();
daSelect.Fill(dtSelect);
if (dtSelect.Rows.Count > 0)
{
//Active user
MySqlCommand cUserID = new MySqlCommand("SELECT `ID пользователя` FROM пользователи WHERE Логин = '" + tbLogin.Text + "'", connection);
object userIDObj = cUserID.ExecuteScalar();
string userID = userIDObj.ToString();
Hide();
frmMainMenu FMA = new frmMainMenu(userID);
FMA.ShowDialog();
}
else
{
MessageBox.Show("Пожалуйста, проверьте правильность написания логина и пароля.");
connection.Close();
}
}
private void bttnConfirm_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(tbLogin.Text))
{
MessageBox.Show("Строка \"Логин\" не может быть пустой");
}
else if (string.IsNullOrWhiteSpace(tbPassword.Text))
{
MessageBox.Show("Строка \"Пароль\" не может быть пустой");
}
else
{
MySqlConnection connection = new MySqlConnection("server = 127.0.0.1; port = 3306; user = root; password = Vfhnvfhn23@; database = tinkoffbudget; sslmode = none");
connection.Open();
string password = HashingPsw.HashPassword(tbPassword.Text);
MySqlCommand cAdd = new MySqlCommand("INSERT INTO пользователи(Логин, Пароль) VALUES ('" + tbLogin.Text + "', '" + password + "')", connection);
if (cAdd.ExecuteNonQuery() == 1)
{
connection.Close();
Close();
}
}
}
