private void zeroitShinnyButton1_Click(object sender, EventArgs e)
{
DataBase db = new DataBase();
DataTable dt = new DataTable();
string nick = materialSingleLineTextField3.Text;
string pass = materialSingleLineTextField5.Text;
MySqlDataAdapter ad = new MySqlDataAdapter();
MySqlCommand com = new MySqlCommand("SELECT * FROM `users` WHERE `nickname`=@uNick AND `pass`=@uPass", db.getConnection());
com.Parameters.Add("@uNick", MySqlDbType.VarChar).Value = nick;
com.Parameters.Add("@uPass", MySqlDbType.VarChar).Value = pass;
ad.SelectCommand = com;
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
Informer form = new Informer();
form.label1.Text = "Login successful";
form.Show();
}
else
{
Informer form = new Informer();
form.label1.Text = "Login denied";
form.Show();
}
}
private void zeroitShinnyButton1_Click(object sender, EventArgs e)
{
if (zeroitShinnyButton1.Text == "SEND CODE")
{
email = materialSingleLineTextField4.Text;
MailAddress from = new MailAddress("*****@*****.**", "HelperApp");
MailAddress to = new MailAddress(email);
MailMessage mes = new MailMessage(from, to);
mes.Subject = "Verification Code";
mes.Body = $"Your verification code is {code}";
mes.IsBodyHtml = false;
SmtpClient smtp = new SmtpClient("smtp.yandex.ru", 587);
smtp.Credentials = new NetworkCredential("*****@*****.**", "vovka1336");
smtp.EnableSsl = true;
smtp.Send(mes);
materialSingleLineTextField1.Visible = true;
zeroitShinnyButton1.Text = "CHECK CODE";
}
if (materialSingleLineTextField1.Visible == true)
{
if (materialSingleLineTextField1.Text == code)
{
DataBase db = new DataBase();
DataTable dt = new DataTable();
MySqlDataAdapter ad = new MySqlDataAdapter();
MySqlCommand com = new MySqlCommand("SELECT * FROM `users` WHERE `nickname`=@uMail", db.getConnection());
com.Parameters.Add("@uMail", MySqlDbType.VarChar).Value = materialSingleLineTextField2.Text;
ad.SelectCommand = com;
ad.Fill(dt);
if (dt.Rows.Count > 0)
{
Informer info = new Informer();
info.label1.Text = $"Your password is {dt.Rows[0]["pass"].ToString()}";
info.Show();
}
//string password = row[0]["pass"].ToString();
}
}
}