private void login_Click(object sender, EventArgs e)
{
if (email.Text.Trim() == "" || password.Text.Trim() == "")
{
MessageBox.Show("Заполните все поля");
}
else
{
using (MarathonEntities context = new MarathonEntities())
{
IQueryable <User> users = from user in context.User where user.RoleId == role select user;
if (users.Count() > 0)
{
string userEmail = users.First().Email;
switch (role)
{
case "R":
runnerMenu runnerMenu = new runnerMenu();
runnerMenu.email = userEmail;
this.Close();
runnerMenu.Show();
break;
case "C":
coordinatorMenu coordinatorMenu = new coordinatorMenu();
coordinatorMenu.userEmail = userEmail;
this.Close();
coordinatorMenu.Show();
break;
case "A":
administratorMenu administratorMenu = new administratorMenu();
administratorMenu.userEmail = userEmail;
this.Close();
administratorMenu.Show();
break;
}
}
else
{
MessageBox.Show("Пользователь не найден");
}
}
}
}
private void registration_Click(object sender, EventArgs e)
{
DateTime now = DateTime.Now;
using (MarathonEntities context = new MarathonEntities())
{
IQueryable <Charity> charities = from charity in context.Charity where charity.CharityName == selectCharity.Text select charity;
if ((fullDistance.Checked == false && mediumDistance.Checked == false && ShortDistance.Checked == false) || (variantA.Checked == false && variantB.Checked == false && variantC.Checked == false) || selectCharity.SelectedIndex == -1 || SponsorshipTarget.Text.Trim() == "")
{
MessageBox.Show("Заполните все поля");
}
else if (decimal.Parse(SponsorshipTarget.Text) < 0)
{
MessageBox.Show("Сумма вклада не может быть отрицательной");
}
else
{
Registration registration = new Registration()
{
RunnerId = runnerId,
RegistrationDateTime = now,
RaceKitOptionId = raceKit,
RegistrationStatusId = 1,
Cost = count,
CharityId = charities.First().CharityId,
SponsorshipTarget = decimal.Parse(SponsorshipTarget.Text)
};
try
{
context.Registration.Add(registration);
context.SaveChanges();
registrationConfirmation confirmation = new registrationConfirmation();
confirmation.runnerId = runnerId;
this.Close();
confirmation.Show();
}
catch
{
MessageBox.Show("Ошибка сервера");
}
}
}
}
private void newRunnerRegistration_Load(object sender, EventArgs e)
{
using (MarathonEntities context = new MarathonEntities())
{
IQueryable <Gender> genders = from gender in context.Gender select gender;
IQueryable <Country> countries = from country in context.Country select country;
foreach (var gender in genders)
{
selectGender.Items.Add(gender.Gender1);
}
foreach (var country in countries)
{
selectCountry.Items.Add(country.CountryName);
}
}
}
private void runnerManagement_Load(object sender, EventArgs e)
{
using (MarathonEntities context = new MarathonEntities())
{
IQueryable <User> users = from user in context.User where user.RoleId == "R" select user;
totalRunners.Text = "Total runners: " + users.Count().ToString();
DataTable workTable = new DataTable("Runners");
foreach (var user in users)
{
DataRow dr = dt.NewRow();
dr["Имя"] = user.FirstName;
dr["Фамилия"] = user.LastName;
dr["Email"] = user.Email;
dt.Rows.Add(dr);
}
}
}
private void eventRegistration_Load(object sender, EventArgs e)
{
try
{
using (MarathonEntities context = new MarathonEntities())
{
IQueryable <Runner> runners = from runner in context.Runner where runner.Email == runnerEmail select runner;
runnerId = runners.First().RunnerId;
IQueryable <Charity> charities = from charity in context.Charity select charity;
foreach (var charity in charities)
{
selectCharity.Items.Add(charity.CharityName);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Ошибка сервера" + ex.ToString());
}
}
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("Ошибка подключения к базе данных");
}
}
