private void CountryDepartureBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (PTLEntities db = new PTLEntities())
{
RegionDepartureBox.ItemsSource = db.Region.Select(x => x.Title);
}
}
private void InitializeWindow()
{
if (PersonId != 0)
{
WindowTitle.Text = "Редактирование персоны";
DeleteBtn.Visibility = Visibility.Visible;
AddBtn.Content = "Сохранить";
try
{
using (PTLEntities db = new PTLEntities())
{
Person = db.Person.Find(PersonId);
SurnameBox.Text = Person.Surname;
NameBox.Text = Person.Name;
PatBox.Text = Person.Patronymic;
PhoneBox.Text = Person.Phone;
PassportBox.Text = Person.PassportNumber;
CountryComboBox.ItemsSource = db.Country.Select(x => x.Title).ToList();
CountryComboBox.Text = Person.Country.Title;
}
}
catch (System.Exception ex)
{
MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
using (PTLEntities db = new PTLEntities())
{
CountryComboBox.ItemsSource = db.Country.Select(x => x.Title).ToList();
CountryComboBox.Text = CountryComboBox.Items[0].ToString();
}
}
}
private void LoadComboBoxes()
{
var countries = new Dictionary <int, string>();
using (PTLEntities db = new PTLEntities())
{
foreach (var item in places)
{
}
countries = db.Country.Select(x => new
{
countryId = x.Country_Id,
title = x.Title
}).AsEnumerable().Select(x => new Country
{
Country_Id = x.countryId,
Title = x.title
}).ToDictionary(k => k.Country_Id, v => v.Title);
CountryDepartureBox.ItemsSource = countries.Values;
CountryArrivalBox.ItemsSource = db.Country.Select(x => x.Title).ToList();
CityArrivalBox.ItemsSource = db.City.Select(x => x.Title).ToList();
CityDepartureBox.ItemsSource = db.City.Select(x => x.Title).ToList();
RegionArrivalBox.ItemsSource = db.Region.Select(x => x.Title).ToList();
RegionDepartureBox.ItemsSource = db.Region.Select(x => x.Title).ToList();
}
}
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 LoadCountries()
{
try
{
using (PTLEntities db = new PTLEntities())
{
var coutries = db.Country.Select(x => x.Title).ToList();
Country.ItemsSource = coutries;
Country.Text = Country.Items[0].ToString();
}
}
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);
}
}
}
public void LoadData()
{
try
{
using (PTLEntities db = new PTLEntities())
{
var Table = db.Person
.Where(x => x.User_Id == UserId)
.OrderByDescending(x => x.IsPrimary)
.Select(x => new
{
surname = x.Surname,
name = x.Name,
patronymic = x.Patronymic,
country = x.Country.Title,
phone = x.Phone,
passport = x.PassportNumber,
isprimary = x.IsPrimary,
personid = x.Person_Id
}).AsEnumerable().Select(x => new Persons
{
Surname = x.surname,
Name = x.name,
Patronymic = x.patronymic,
Country = x.country,
Phone = x.phone,
PassportNumber = x.passport,
IsPrimary = x.isprimary,
Person_Id = x.personid
}).ToList();
User = db.User.Find(UserId);
UsernameBox.Text = User.Login;
PasswordBox.Password = User.PasswordHash;
DataGrid.ItemsSource = Table;
}
}
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 bool Verification(string password, string login)
{
var hashedPassword = Sha256Encrypt(password);
try
{
using (PTLEntities db = new PTLEntities())
{
User = db.User.Where(x => x.Login == login && x.PasswordHash == hashedPassword).FirstOrDefault();
if (Equals(User, null))
{
return(false);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
return(true);
}
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);
}
}
}
private void LoadData()
{
try
{
using (PTLEntities db = new PTLEntities())
{
var Table = db.User.Include("Person").SelectMany(x => x.Person)
.Where(x => x.IsPrimary == 1)
.Select(x => new
{
userid = x.User_Id,
login = x.User.Login,
surname = x.Surname,
name = x.Name,
country = x.Country.Title
}).ToList();
DataGrid.ItemsSource = Table;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
