private void AddBtn_Click(object sender, RoutedEventArgs e) { try { using (PTLEntities db = new PTLEntities()) { var countryId = db.Country.Where(x => x.Title == CountryComboBox.Text).FirstOrDefault().Country_Id; if (Validation()) { if (PersonId == 0) { Person person = new Person { Surname = SurnameBox.Text, Name = NameBox.Text, Patronymic = PatBox.Text, Phone = PhoneBox.Text, PassportNumber = PassportBox.Text, IsPrimary = 0, Country_Id = countryId, User_Id = UserId }; db.Person.Add(person); } else { var person = db.Person.Find(PersonId); person.Surname = SurnameBox.Text; person.Name = NameBox.Text; person.Patronymic = PatBox.Text; person.Phone = PhoneBox.Text; person.PassportNumber = PassportBox.Text; person.Country_Id = countryId; } db.SaveChanges(); var ownerWindow = Owner as EditUser; ownerWindow.LoadData(); Close(); } else { MessageBox.Show("Validation Error"); } } } catch (System.Exception ex) { MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error); } }
private void Button_Click(object sender, RoutedEventArgs e) { if (!IsTextBoxEmpty() && IsLengthCorrect()) { try { using (PTLEntities db = new PTLEntities()) { var login = db.User.Where(x => x.Login == Login.Text).FirstOrDefault(); if (Equals(login, null)) { var countryId = db.Country.Where(x => x.Title == Country.Text).Select(x => x.Country_Id).FirstOrDefault(); string hashPassword = MainWindow.Sha256Encrypt(Password.Text); User user = new User() { IsAdmin = 0, Login = Login.Text, PasswordHash = hashPassword }; var person = new Person { Name = PersonName.Text, Surname = Surname.Text, Patronymic = Patronymic.Text, IsPrimary = 1, Phone = Phone.Text, PassportNumber = PassportNumber.Text, Country_Id = countryId, User_Id = user.User_Id }; db.User.Add(user); db.Person.Add(person); db.SaveChanges(); Close(); } else { MessageBox.Show("Такой пользователь уже существует!"); } } } catch (System.Exception ex) { MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void ChangePassBtn_Click(object sender, RoutedEventArgs e) { if (CurrentPassVer() && MatchVer() && LengthVer()) { try { using (PTLEntities db = new PTLEntities()) { var user = db.User.Find(UserId); user.PasswordHash = MainWindow.Sha256Encrypt(NewBox.Password); db.SaveChanges(); Close(); } } catch (System.Exception ex) { MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void SelectMainBtn_Click(object sender, RoutedEventArgs e) { if (DataGrid.SelectedCells.Count != 0) { DataGridRow row = (DataGridRow)DataGrid.ItemContainerGenerator.ContainerFromIndex(DataGrid.SelectedIndex); if (row.GetIndex() != 0) { MessageBoxResult result = MessageBox.Show("Сменить основную персону?", "Confirm", MessageBoxButton.YesNoCancel, MessageBoxImage.Asterisk); if (result == MessageBoxResult.Yes) { try { using (PTLEntities db = new PTLEntities()) { var data = DataGrid.ItemsSource as List <Persons>; var personId = data[DataGrid.SelectedIndex].Person_Id; var selectedPerson = db.Person.Where(x => x.Person_Id == personId).FirstOrDefault(); var currentMainPerson = db.Person.Where(x => User.User_Id == x.User_Id).Where(x => x.IsPrimary == 1) .FirstOrDefault(); currentMainPerson.IsPrimary = 0; selectedPerson.IsPrimary = 1; db.SaveChanges(); LoadData(); } } catch (System.Exception ex) { MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error); } } } else { MessageBox.Show("Персона уже является основной"); } } else { MessageBox.Show("Строка не выбрана"); } }
private void DeleteBtn_Click(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Удалить персону?", "Подтверждение", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { try { using (PTLEntities db = new PTLEntities()) { db.Person.Remove(db.Person.Find(PersonId)); db.SaveChanges(); var ownerWindow = Owner as EditUser; ownerWindow.LoadData(); Close(); } } catch (System.Exception ex) { MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error); } } }