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 = "";
}
}
