private void update_button_Click(object sender, RoutedEventArgs e)
{
using (UserEntities db = new UserEntities())
{
try
{
User selected_user = (User)dataGrid1.SelectedItem;
int selected_user_id = selected_user.Id;
User updating_user = (from u in db.Users where u.Id == selected_user_id select u).First();
updating_user.Name = selected_user.Name;
updating_user.LastName = selected_user.LastName;
updating_user.FathersName = selected_user.FathersName;
updating_user.Age = selected_user.Age;
updating_user.Position = selected_user.Position;
updating_user.Gender = selected_user.Gender;
updating_user.Married = selected_user.Married;
db.SaveChanges();
MessageBox.Show($"User {selected_user.Name} was updated");
show_table();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
public void show_table()
{
using (UserEntities db = new UserEntities())
{
var users = db.Users;
dataGrid1.ItemsSource = users.ToList();
}
}
private void delete_button_clicked(object sender, RoutedEventArgs e)
{
using (UserEntities db = new UserEntities())
{
try
{
User selected_user = (User)dataGrid1.SelectedItem;
int selected_user_id = selected_user.Id;
User removing_user = (from u in db.Users where u.Id == selected_user_id select u).First();
MessageBox.Show($"User {selected_user.Name} was deleted");
db.Users.Remove(removing_user);
db.SaveChanges();
show_table();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void insert_button_clicked(object sender, RoutedEventArgs e)
{
bool married = false;
if (Married.IsChecked == true)
{
married = true;
}
if (!Regex.IsMatch(Name.Text, @"^[a-zA-Z]+$") || !Regex.IsMatch(LastName.Text, @"^[a-zA-Z]+$") || !Regex.IsMatch(FathersName.Text, @"^[a-zA-Z]+$") || !Regex.IsMatch(Age.Text, @"^[0-9]{2}$"))
{
MessageBox.Show("Введите корректно ваши данные!");
}
else
{
try
{
using (UserEntities db = new UserEntities())
{
User new_user = new User();
new_user.Name = Name.Text;
new_user.LastName = LastName.Text;
new_user.FathersName = FathersName.Text;
new_user.Age = Convert.ToInt32(Age.Text);
new_user.Position = Position.Text;
new_user.Gender = Gender.Text;
new_user.Married = married;
db.Users.Add(new_user);
db.SaveChanges();
show_table();
Name.Text = "";
LastName.Text = "";
FathersName.Text = "";
Age.Text = "";
}
}catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
