private void btn_rigistration_marathon_Click(object sender, EventArgs e)
{
var form = new Register_for_an_event(email);
Hide();
form.Show();
}
private void btn_registration_Click(object sender, EventArgs e)
{
var path_img = "";
if (tb_path_img.Text == "")
{
path_img = Application.StartupPath.Replace("\\bin\\Debug", "") + "\\Resources\\unnamed.jpg";
}
else
{
path_img = openFileDialog1.FileName;
}
if (tb_name.Text != "" && tb_last.Text != "" && Password() && Date() && tb_email.Text != "")
{
string SQL1 = $"set language english insert Runner (Email,Gender,DateOfBirth,CountryCode) values(N'{tb_email.Text}',N'{cb_sex.SelectedItem}',CAST(N'{tb_date.Value.ToString("yyyy-MM-dd HH:mm:ss") + ".000"}' AS DateTime),N'{tb_country.SelectedValue}')";
string SQL = $"insert [User] values(N'{tb_email.Text}',N'{tb_password.Text}',N'{tb_name.Text}',N'{tb_last.Text}',N'R',@img)";
var img_byte = File.ReadAllBytes(path_img);
var conect = new SqlConnection(Properties.Resources.connection);
try
{
conect.Open();
var command = new SqlCommand(SQL, conect);
command.Parameters.Add(new SqlParameter("@img", img_byte));
command.ExecuteNonQuery();
command = new SqlCommand(SQL1, conect);
command.ExecuteNonQuery();
Hide();
var form = new Register_for_an_event(tb_email.Text);
form.Show();
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
}
finally
{
conect.Close();
}
path_img = "";
}
}
