private void DeleteA_Click(object sender, EventArgs e) { DeleteClient del = new DeleteClient(); Testingcards Form = (Testingcards)this.Parent; Form.Close(); }
private void Log_in_Click(object sender, EventArgs e) { if (FirstName.Text == "") { this.label1.ForeColor = System.Drawing.Color.LightCoral; label1.Text = Convert.ToString("Введите имя!"); } if (LastName.Text == "") { this.label2.ForeColor = System.Drawing.Color.LightCoral; label2.Text = Convert.ToString("Введите фамилию!"); } if (Password.Text == "") { this.label3.ForeColor = System.Drawing.Color.LightCoral; label3.Text = Convert.ToString("Вы не ввели пароль!"); } if ((FirstName.Text == LastName.Text) && (FirstName.Text != "") && (LastName.Text != "")) { this.label1.ForeColor = System.Drawing.Color.LightCoral; label1.Text = Convert.ToString("Введены одиннаковые данные!"); this.label2.ForeColor = System.Drawing.Color.LightCoral; label2.Text = Convert.ToString("Введены одиннаковые данные!"); } if ((FirstName.Text != "") && (LastName.Text != "") && (Password.Text != "")) { string CommandText = "SELECT FirstName FROM users WHERE FirstName=@FirstName"; string CommandText1 = "SELECT Lastname FROM users WHERE Lastname=@Lastname"; string CommandText2 = "SELECT PasswordOfStud FROM users WHERE PasswordOfStud=@PasswordOfStud"; MySqlConnection myConnection = new MySqlConnection(Connect); myConnection.Open(); var myCommand = new MySqlCommand(CommandText, myConnection); myCommand.Parameters.AddWithValue("@FirstName", FirstName.Text); var myCommand1 = new MySqlCommand(CommandText1, myConnection); myCommand1.Parameters.AddWithValue("@LastName", LastName.Text); var myCommand2 = new MySqlCommand(CommandText2, myConnection); myCommand2.Parameters.AddWithValue("@PasswordOfStud", Password.Text); myCommand.ExecuteNonQuery(); myCommand1.ExecuteNonQuery(); myCommand2.ExecuteNonQuery(); string rez = (string)myCommand.ExecuteScalar(); //результат запроса string rez1 = (string)myCommand1.ExecuteScalar(); //результат запроса string rez2 = (string)myCommand2.ExecuteScalar(); //результат запроса GetData.Password = rez2; GetData.User = rez + " " + rez1; if ((rez == FirstName.Text) && (rez1 == LastName.Text) && (rez2 == Password.Text)) { Testingcards newForm = new Testingcards(this.FirstName.Text + Convert.ToString(" ") + this.LastName.Text); newForm.Show(); } else { label6.Text = Convert.ToString("Ошибка входа! Неправильно ведены данные!"); } myConnection.Close(); FirstName.Text = ""; LastName.Text = ""; Password.Text = ""; } }
private void Sign__up_Click(object sender, EventArgs e) { if (FirstName.Text == "") { this.label1.ForeColor = System.Drawing.Color.LightCoral; label1.Text = Convert.ToString("Введите имя!"); } if (LastName.Text == "") { this.label2.ForeColor = System.Drawing.Color.LightCoral; label2.Text = Convert.ToString("Введите фамилию!"); } if (Password.Text == "") { this.label3.ForeColor = System.Drawing.Color.LightCoral; label3.Text = Convert.ToString("Вы не ввели пароль!"); } if (Password2.Text == "") { this.label5.ForeColor = System.Drawing.Color.LightCoral; label5.Text = Convert.ToString("Вы не ввели пароль!"); } if ((FirstName.Text == LastName.Text) && (FirstName.Text != "") && (LastName.Text != "")) { this.label1.ForeColor = System.Drawing.Color.LightCoral; label1.Text = Convert.ToString("Введены одиннаковые данные!"); this.label2.ForeColor = System.Drawing.Color.LightCoral; label2.Text = Convert.ToString("Введены одиннаковые данные!"); } if (Password.Text != Password2.Text) { this.label3.ForeColor = System.Drawing.Color.LightCoral; this.label5.ForeColor = System.Drawing.Color.LightCoral; label3.Text = Convert.ToString("Пароли не сопадают!"); label5.Text = Convert.ToString("Пароли не сопадают!"); } if ((FirstName.Text != "") && (LastName.Text != "") && (Password.Text != "") && (Password2.Text != "") && (Password.Text == Password2.Text)) { string CommandText = "INSERT INTO Users (FirstName, Lastname, PasswordOfStud) VALUES (@FirstName, @LastName, @PasswordOfStud)"; MySqlConnection myConnection = new MySqlConnection(Connect); myConnection.Open(); var myCommand = new MySqlCommand(CommandText, myConnection); myCommand.Parameters.AddWithValue("@FirstName", FirstName.Text); myCommand.Parameters.AddWithValue("@LastName", LastName.Text); myCommand.Parameters.AddWithValue("@PasswordOfStud", Password.Text); try { myCommand.ExecuteNonQuery(); } catch { label6.Text = Convert.ToString("Такой пароль уже существует!"); Password.Text = ""; Password2.Text = ""; return; } GetData.Password = Password.Text; GetData.User = FirstName.Text + " " + LastName.Text; Testingcards newForm = new Testingcards(this.FirstName.Text + Convert.ToString(" ") + this.LastName.Text); newForm.Show(); myConnection.Close(); FirstName.Text = ""; LastName.Text = ""; Password.Text = ""; Password2.Text = ""; } }