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