private void Add(object sender, RoutedEventArgs e) { try { Extradition extradition = new Extradition(); extradition.IdEquipment = Convert.ToInt32(txtIdEquipmentAdd.Text); extradition.Quantity = Convert.ToInt32(txtQuantityAdd.Text); extradition.IdStorages = Convert.ToInt32(txtIdStoragesAdd.Text); extradition.IdPersonnel = Convert.ToInt32(txtIdPersonnelAdd.Text); extradition.IdUsers = Convert.ToInt32(txtIdUsersAdd.Text); extradition.Date = Convert.ToString(txtDateAdd.Text); db.Extradition.Add(extradition); db.SaveChanges(); ExtraditionDB.ItemsSource = db.Extradition.ToList(); txtIdEquipmentAdd.Clear(); txtQuantityAdd.Clear(); txtIdStoragesAdd.Clear(); txtIdPersonnelAdd.Clear(); txtIdUsersAdd.Clear(); txtDateAdd.Clear(); } catch { MessageBox.Show("Ошибка ввода данных!"); } }
public int FunAdd(string login, string password, string post, string last, string first, string middle) { try { Users users = new Users(); users.Login = login; users.Password = password; users.Post = post; users.LastName = last; users.FirstName = first; users.MiddleName = middle; db.Users.Add(users); db.SaveChanges(); UsersDB.ItemsSource = db.Users.ToList(); txtLoginAdd.Clear(); txtPasswordAdd.Clear(); txtPostAdd.Clear(); txtLastAdd.Clear(); txtFirstAdd.Clear(); txtMiddleAdd.Clear(); return(1); } catch { MessageBox.Show("Ошибка ввода данных!"); return(0); } }
private void deleteButton_Click(object sender, RoutedEventArgs e) { try { int num = Convert.ToInt32(txtIdDelete.Text); var dRow = db.Equipment.Where(w => w.Id == num).FirstOrDefault(); db.Equipment.Remove(dRow); db.SaveChanges(); EquipmentBD.ItemsSource = db.Equipment.ToList(); txtIdDelete.Clear(); } catch { MessageBox.Show("Ошибка ввода данных!"); } }
public int FunAdd(string name) { try { Storages storages = new Storages(); storages.Name = name; db.Storages.Add(storages); db.SaveChanges(); StoragesDB.ItemsSource = db.Storages.ToList(); return(1); } catch { MessageBox.Show("Ошибка ввода данных!"); return(0); } }
private void Change(object sender, RoutedEventArgs e) { try { int num = Convert.ToInt32(txtIdChange.Text); var uRow = db.TypeEquipment.Where(w => w.Id == num).FirstOrDefault(); uRow.Name = txtNameChange.Text; db.SaveChanges(); TypeEquipmentDB.ItemsSource = db.TypeEquipment.ToList(); txtNameChange.Clear(); txtIdChange.Clear(); } catch { MessageBox.Show("Ошибка ввода данных!"); } }
public int FunAdd(string last, string first, string middle, string post) { try { Personnel personnel = new Personnel(); personnel.LastName = last; personnel.FirstName = first; personnel.MiddleName = middle; personnel.Post = post; db.Personnel.Add(personnel); db.SaveChanges(); PersonnelDB.ItemsSource = db.Personnel.ToList(); return(1); } catch { MessageBox.Show("Ошибка ввода данных!"); return(0); } }