private void Back_Click(object sender, EventArgs e) { MenuRunner menuRunner = new MenuRunner(); menuRunner.Show(); this.Close(); }
private void button_Cancel_Click(object sender, EventArgs e) { MenuRunner menuRunner = new MenuRunner(); menuRunner.Show(); this.Close(); }
private void Login_Click(object sender, EventArgs e) { try { Connection.connection.Open(); string sqlExp = "select [Email], [Password], [RoleId] from [dbo].[User] where [Email]=@login"; SqlCommand cmd = new SqlCommand(sqlExp, Connection.connection); cmd.Parameters.AddWithValue("@login", textBox_email.Text); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); if ((string)reader[1] == textBox_password.Text) { Connection.userLogin = textBox_email.Text; switch ((string)reader[2]) { case "R": MenuRunner mr = new MenuRunner(); mr.Show(); this.Close(); break; case "C": MenuCoordinator mc = new MenuCoordinator(); mc.Show(); this.Close(); break; case "A": MenuAdmin ma = new MenuAdmin(); ma.Show(); this.Close(); break; default: MessageBox.Show("Нет такой роли"); break; } } else { MessageBox.Show("Неверный пароль"); } } else { MessageBox.Show("Неверный логин"); } reader.Close(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } Connection.connection.Close(); }
private void button_Reg_Click(object sender, EventArgs e) { try { if (comboBox1.Text == "") { MessageBox.Show("Вы не выбрали организацию для пожертвования"); if (textBox_sumVznosa.Text == "") { MessageBox.Show("Вы не ввели сумму пожертвования"); } } if (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == false) { MessageBox.Show("Выбирите хотя бы 1 вид марафона"); } if (radioButton1.Checked == false && radioButton2.Checked == false && radioButton3.Checked == false) { MessageBox.Show("Выбирите комплект"); } else { Connection.connection.Open(); { string SqlExpRunnerId = "select [RunnerId] from [Runner] where [Email]=@email"; SqlCommand cmdRunnerId = new SqlCommand(SqlExpRunnerId, Connection.connection); cmdRunnerId.Parameters.AddWithValue("@email", Connection.userLogin); int runnerid = (int)cmdRunnerId.ExecuteScalar(); string SqlExpCharity = "select [CharityId] from [dbo].[Charity] where [CharityName]=@charityname"; SqlCommand cmdCharity = new SqlCommand(SqlExpCharity, Connection.connection); cmdCharity.Parameters.AddWithValue("@charityname", comboBox1.Text); int charityid = (int)cmdCharity.ExecuteScalar(); string SqlExp = "insert into [dbo].[Registration] ([RunnerId], [RegistrationDateTime], [RaceKitOptionId], [RegistrationStatusId], [Cost], [CharityId], [SponsorshipTarget]) " + "VALUES (@runnerid, getdate(), @rkoid, '1', @cost, @charityid, @sponsorship)"; SqlCommand cmd = new SqlCommand(SqlExp, Connection.connection); char rkoid = '0'; if (radioButton1.Checked) { rkoid = RaceKitOptionId[0].ToCharArray()[0]; } if (radioButton2.Checked) { rkoid = RaceKitOptionId[1].ToCharArray()[0]; } if (radioButton3.Checked) { rkoid = RaceKitOptionId[2].ToCharArray()[0]; } decimal sum = 0; if (checkBox1.Checked) { sum = EventType[0].ToString()[0]; } if (checkBox2.Checked) { sum = EventType[1].ToString()[0]; } if (checkBox3.Checked) { sum = EventType[2].ToString()[0]; } cmd.Parameters.AddWithValue("@runnerid", runnerid); cmd.Parameters.AddWithValue("@rkoid", rkoid); cmd.Parameters.AddWithValue("@cost", sum); cmd.Parameters.AddWithValue("@charityid", charityid); cmd.Parameters.AddWithValue("@sponsorship", textBox_sumVznosa.Text); int i = cmd.ExecuteNonQuery(); if (i == 1) { MessageBox.Show("Данные были внесены"); Connection.connection.Close(); MenuRunner MR = new MenuRunner(); MR.Show(); this.Close(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } Connection.connection.Close(); }
private void button_Save_Click(object sender, EventArgs e) { try { Connection.connection.Open(); if (textBox_LastName.Text != "" && textBox_Name.Text != "" && comboBox_Gender.Text != "" && comboBox_Country.Text != "") { /*Возможно работает некорректно*/ if (DateTime.Now.Year - dateTimePicker_DateOfBirthday.Value.Year >= 10) { string sqlExpUser = "******"; SqlCommand cmdUser = new SqlCommand(sqlExpUser, Connection.connection); cmdUser.Parameters.AddWithValue("@email", Connection.userLogin); cmdUser.Parameters.AddWithValue("@firstname", textBox_Name.Text); cmdUser.Parameters.AddWithValue("@lastname", textBox_LastName.Text); string SqlExpCountryCode = @"select [CountryCode] from [Country] where [CountryName]=@countryname"; SqlCommand cmdCountryCode = new SqlCommand(SqlExpCountryCode, Connection.connection); cmdCountryCode.Parameters.AddWithValue("@countryname", comboBox_Country.Text); string CountryCode = (string)cmdCountryCode.ExecuteScalar(); string sqlExpRunner = "update [Runner] set [Gender]=@gender, [DateOfBirth]=@DateOfBirth, [CountryCode]=@countrycode where [Email]=@email"; SqlCommand cmdRunner = new SqlCommand(sqlExpRunner, Connection.connection); cmdRunner.Parameters.AddWithValue("@email", Connection.userLogin); cmdRunner.Parameters.AddWithValue("@gender", comboBox_Gender.Text); cmdRunner.Parameters.AddWithValue("@DateOfBirth", dateTimePicker_DateOfBirthday.Value); cmdRunner.Parameters.AddWithValue("@countrycode", CountryCode); if (textBox_Password.Text == "") { int i = cmdUser.ExecuteNonQuery(); if (i == 1) { int j = cmdRunner.ExecuteNonQuery(); if (j == 1) { MessageBox.Show("Данные были изменены"); Connection.connection.Close(); MenuRunner MR = new MenuRunner(); MR.Show(); this.Close(); } } } else if (textBox_Password.Text.Length >= 6 && textBox_Password.Text.Any(char.IsUpper) && textBox_Password.Text.Any(char.IsDigit) && textBox_Password.Text.IndexOfAny(new char[] { '!', '@', '#', '$', '%', '^' }) > 0) { if (textBox_Password.Text == textBox_RepeatPassword.Text) { string sqlExpUserPassword = "******"; SqlCommand cmdUserPassword = new SqlCommand(sqlExpUserPassword, Connection.connection); cmdUserPassword.Parameters.AddWithValue("@email", Connection.userLogin); cmdUserPassword.Parameters.AddWithValue("@password", textBox_Password.Text); int i = cmdUser.ExecuteNonQuery(); if (i == 1) { int k = cmdUserPassword.ExecuteNonQuery(); if (k == 1) { int j = cmdRunner.ExecuteNonQuery(); if (j == 1) { MessageBox.Show("Данные были изменены"); Connection.connection.Close(); MenuRunner MR = new MenuRunner(); MR.Show(); this.Close(); } } } } else { MessageBox.Show("Пароли не совпадают"); } } else { MessageBox.Show("Пароль должен соответвтвовать следующим параметрам: \n" + "• Минимум 6 символов \n" + "• Минимум 1 прописная буква \n" + "• Минимум 1 цифра \n" + "• По крайней мере один из следующих символов: ! @ # $ % ^ \n"); } } else { MessageBox.Show("Для того, чтобы зарегистрироваться, ваш возраст должен быть выше 10 лет"); } } else { MessageBox.Show("Не все поля заполнены"); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } Connection.connection.Close(); }