private void zeroitShinnyButton1_Click(object sender, EventArgs e)
{
if (checkInput() == 0)
{
DataBase db = new DataBase();
string name = materialSingleLineTextField1.Text;
string surname = materialSingleLineTextField2.Text;
string nickname = materialSingleLineTextField3.Text;
string email = materialSingleLineTextField4.Text;
string pass = materialSingleLineTextField5.Text;
int type = materialRadioButton1.Checked == true ? 1 : 0;
MySqlCommand com = new MySqlCommand($"INSERT INTO `users` (`userID`, `name`, `surname`, `nickname`, `email`, `pass`, `type`) VALUES (NULL,@uName,@uSur,@uNick,@uMail,@uPass,@uType)", db.getConnection());
com.Parameters.Add("@uMail", MySqlDbType.VarChar).Value = email;
com.Parameters.Add("@uSur", MySqlDbType.VarChar).Value = surname;
com.Parameters.Add("@uNick", MySqlDbType.VarChar).Value = nickname;
com.Parameters.Add("@uType", MySqlDbType.VarChar).Value = type;
com.Parameters.Add("@uName", MySqlDbType.VarChar).Value = name;
com.Parameters.Add("@uPass", MySqlDbType.VarChar).Value = pass;
db.startConnection();
if (com.ExecuteNonQuery() == 1)
{
Informer form = new Informer();
form.label1.Text = "User was added successfully";
if (form.ShowDialog() == DialogResult.Cancel)
{
Login form1 = new Login();
form1.Show();
}
}
db.closeConnection();
this.Hide();
}
}
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();
}
}
}
