private void Button_Click(object sender, RoutedEventArgs e) { //добавление данных о пользователе в БД, если все данные введены верно if (PasswordTB.Password == RepPasswordTB.Password) { DB dB = new DB(Properties.Settings.Default.CinemaDBConnectionString); object login = dB.ExecuteScalarQuery($"SELECT Логин FROM Пользователь WHERE Логин = '{LoginTB.Text}'"); if (login == null) { int rows = dB.ExecuteQuery($"INSERT INTO [Пользователь] Values(N'{LoginTB.Text}', N'{PasswordTB.Password}', N'{EmailTB.Text}', N'{PhoneTB.Text}', 0, 0, N'{LastNameTB.Text}', N'{FirstNameTB.Text}', N'{MiddleNameTB.Text}')"); if (rows == 1) { MessageBox.Show("Регистрация прошла успешно!"); LastNameTB.Clear(); FirstNameTB.Clear(); MiddleNameTB.Clear(); EmailTB.Clear(); PhoneTB.Clear(); LoginTB.Clear(); PasswordTB.Clear(); RepPasswordTB.Clear(); AddText(); } } else { MessageBox.Show("Такой логин уже существует!"); } } else { MessageBox.Show("Пароли не совпадают!"); } }
private void AddButton_Click(object sender, RoutedEventArgs e) { if(StudentListBox.SelectedItem == null) { var sID = int.TryParse(StudentIDTB.Text, out int studentID); if (sID == false) { MessageBox.Show("Invalid Entry. Please enter a valid number"); } var sFirstName = FirstNameTB.Text; var sLastName = LastNameTB.Text; var age = int.TryParse(AgeTB.Text, out int sAge); var allergies = AllergiesTB.Text; var parentName = ParentNameTB.Text; var parentContact = ParentContactNoTB.Text; var parentEmail = ParentEmailTB.Text; var classID = int.TryParse(ClassIDTB.Text, out int sClassID); _crudManager.AddStudent(studentID, sFirstName, sLastName, sAge, allergies, parentName, parentContact, parentEmail, sClassID); } PopulateStudentListBox(); StudentIDTB.Clear(); FirstNameTB.Clear(); LastNameTB.Clear(); AgeTB.Clear(); AllergiesTB.Clear(); ParentNameTB.Clear(); ParentContactNoTB.Clear(); ParentEmailTB.Clear(); ClassIDTB.Clear(); }
public SignUpPage() { InitializeComponent(); LastNameTB.Focus(); Keyboard.Focus(LastNameTB); DataContext = new SignUpViewModel(this); }
public Customer_Login() { InitializeComponent(); //Initial hidden objects label4.Hide(); label5.Hide(); FirstNameTB.Hide(); LastNameTB.Hide(); }
private void button1_Click(object sender, EventArgs e) { newUser = true; button1.Enabled = false; label2.Text = "New Username:"******"New Password:"; label4.Show(); label5.Show(); FirstNameTB.Show(); LastNameTB.Show(); }
private void ResetBt_Click(object sender, RoutedEventArgs e) { StudentIDTB.Clear(); FirstNameTB.Clear(); LastNameTB.Clear(); AgeTB.Clear(); AllergiesTB.Clear(); ParentNameTB.Clear(); ParentContactNoTB.Clear(); ParentEmailTB.Clear(); ClassIDTB.Clear(); }
private void DeleteBt_Click(object sender, RoutedEventArgs e) { _crudManager.DeleteStudent(int.Parse(StudentIDTB.Text)); StudentIDTB.Clear(); FirstNameTB.Clear(); LastNameTB.Clear(); AgeTB.Clear(); AllergiesTB.Clear(); ParentNameTB.Clear(); ParentContactNoTB.Clear(); ParentEmailTB.Clear(); ClassIDTB.Clear(); StudentListBox.ItemsSource = null; PopulateStudentListBox(); }
private void Button_Click(object sender, RoutedEventArgs e) { if (FirstNameTB.Text != "" || EmailTB.Text != "" || PhoneTB.Text != "" || LoginTB.Text != "" || PasswordTB.Password != "" || RepPasswordTB.Password != "") { if (PasswordTB.Password == RepPasswordTB.Password) { using (SqlConnection connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\OlineCinema\OlineCinema\CinemaDB.mdf;Integrated Security=True")) { try { connection.Open(); } catch { MessageBox.Show("Ошибка соединения с базой данных!"); return; } string query = $"INSERT INTO [Пользователь] Values('{LoginTB.Text}', '{PasswordTB.Password}', '{EmailTB.Text}', '{PhoneTB.Text}', 0, 0, '{LastNameTB.Text}', '{FirstNameTB.Text}', '{MiddleNameTB.Text}')"; SqlCommand command = new SqlCommand(query, connection); command.ExecuteNonQuery(); MessageBox.Show("Регистрация прошла успешно!"); LastNameTB.Clear(); FirstNameTB.Clear(); MiddleNameTB.Clear(); EmailTB.Clear(); PhoneTB.Clear(); LoginTB.Clear(); PasswordTB.Clear(); RepPasswordTB.Clear(); } } else { MessageBox.Show("Пароли не свопадают!"); } } else { MessageBox.Show("Есть незаполненные поля!"); } }
private void LastNameTBGotFocus(object sender, RoutedEventArgs e) { LastNameTB.Clear(); }