private void picClose_Click(object sender, EventArgs e) //Переход к авторизации, по нажатию на крестик
{
this.Hide();
Autorization autorization = new Autorization();
autorization.Show();
}
private void picClose_Click(object sender, EventArgs e)
{
this.Close();
GC.Collect();
Autorization autorization = new Autorization();
autorization.Visible = true;
autorization.ShowInTaskbar = true;
}//Переход к форме авторизации при нажатии на крестик
//Переходы к соответствующим формам
private void picClose_Click(object sender, EventArgs e)
{
this.Close();
GC.Collect();
Autorization autorization = new Autorization();
autorization.Visible = true;
autorization.ShowInTaskbar = true;
}
}//Переход к форме авторизации при нажатии на крестик
private void btnRegistration_Click(object sender, EventArgs e) //Добавление записи о пользователи при нажатии на кнопку зарегистрироваться
{
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-O3331SL\SQLEXPRESS;Initial Catalog=PharmPanaceya;Integrated Security=True"))
{
try
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "insert into [Users] values(@Email,@Password,@Surname,@Name,@Patronymic,@Birthday,@NumberPhone,@Roled)";
cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
cmd.Parameters.AddWithValue("@Surname", txtSurname.Text);
cmd.Parameters.AddWithValue("@Name", txtName.Text);
cmd.Parameters.AddWithValue("@Patronymic", txtPatronymic.Text);
cmd.Parameters.AddWithValue("@Birthday", dateOfBirth.Value);
cmd.Parameters.AddWithValue("@NumberPhone", txtPhone.Text);
cmd.Parameters.AddWithValue("@Roled", "U");
cmd.ExecuteNonQuery();
string query = "Select IDUser From Users Where Email = @Email";
SqlCommand cmd2 = new SqlCommand(query, con);
cmd2.Parameters.AddWithValue("@Email", txtEmail.Text);
int ID = Convert.ToInt32(cmd2.ExecuteScalar());
string query2 = "insert into Baskets values(@IDUser)";
SqlCommand cmd3 = new SqlCommand(query2, con);
cmd3.Parameters.AddWithValue("@IDUser", ID);
cmd3.ExecuteScalar();
Autorization menu = new Autorization();
menu.Show();
this.Close();
MessageBox.Show("Вы успешно зарегистрированы, войдите!");
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
finally
{
con.Close();
}
}
}