private void toBack_Click(object sender, EventArgs e)
{
eventRegistration eventRegistration = new eventRegistration();
this.Close();
eventRegistration.Show();
}
private void registration_Click(object sender, EventArgs e)
{
try
{
using (MarathonEntities context = new MarathonEntities())
{
IQueryable <User> users = from user in context.User where user.Email == email.Text select user;
if (!emailIsValid(email.Text))
{
MessageBox.Show("Введен неверный email");
}
else if (users.Count() > 0)
{
MessageBox.Show("Участник с такой почтой уже зарегистрирован");
}
else if (password.Text != repeat_password.Text)
{
MessageBox.Show("Пароли не совпадают");
}
else if (email.Text.Trim() == "" || password.Text.Trim() == "" || repeat_password.Text.Trim() == "" || name.Text.Trim() == "" || second_name.Text.Trim() == "" || selectGender.SelectedIndex == -1 || selectCountry.SelectedIndex == -1)
{
MessageBox.Show("Заполните все поля");
}
else
{
IQueryable <Country> countries = from country in context.Country where country.CountryName == selectCountry.Text select country;
User user = new User()
{
Email = email.Text,
Password = password.Text,
FirstName = name.Text,
LastName = second_name.Text,
RoleId = "R"
};
Runner runner = new Runner()
{
Email = email.Text,
Gender = selectGender.Text,
DateOfBirth = birthday.Value,
CountryCode = countries.First().CountryCode
};
context.User.Add(user);
context.Runner.Add(runner);
context.SaveChanges();
eventRegistration eventRegistration = new eventRegistration();
eventRegistration.runnerEmail = email.Text;
this.Close();
eventRegistration.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Ошибка подключения к базе данных");
}
}
