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("Ошибка подключения к базе данных"); } }