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