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);
}
}
}
