private void AddEquipment(object sender, RoutedEventArgs e) { if (EquipmentMarkingTextBox.Text == "") { MessageBox.Show("Введите маркировку", Error); } else if (EquipmentNameTextBox.Text == "") { MessageBox.Show("Введите название", Error); } else if (EquipmentTypeComboBox.Text == "") { MessageBox.Show("введите тип оборудования", Error); } else if (EquipmentDatePurchaseDatePicker.Text == "") { MessageBox.Show("Введите дату покупки", Error); } else { using (var db = new FurnitureShopEntitie()) { bool enter = true; foreach (var v in from f in db.Equipment select f.Marking) { if (EquipmentMarkingTextBox.Text == v.Trim()) { MessageBox.Show("Такая маркировка уже зарегистрирована", Error); enter = false; break; } } if (enter) { Equipment equipment = new Equipment() { Marking = EquipmentMarkingTextBox.Text, Name = EquipmentNameTextBox.Text, Equipment_type = EquipmentTypeComboBox.Text, Date_purchase = EquipmentDatePurchaseDatePicker.SelectedDate }; db.Equipment.Add(equipment); db.SaveChanges(); foreach (var v in equipmentSpecifications) { Equipment_specification specification = new Equipment_specification() { Marking = equipment.Marking.Trim(), Specification_name = v.Name.Trim(), Specification_value = v.Value.Trim() }; db.Equipment_specification.Add(specification); } db.SaveChanges(); MessageBox.Show("Информация об оборудовании сохранена", Error); } } } }
private void Button_Click_2(object sender, RoutedEventArgs e) { MessageBoxResult res = MessageBox.Show("Удалить выбранную строку?", "Внимание!", MessageBoxButton.YesNo); if (res == MessageBoxResult.Yes) { Materials2 o = (Materials2)MaterialsDataGrid.Items.CurrentItem; listMaterials.Remove((Materials2)MaterialsDataGrid.Items.CurrentItem); using (var db = new FurnitureShopEntitie()) { var obj = from f in db.Materials select f; foreach (var c in obj) { if (c.Articyl == o.Articyl) { db.Materials.Remove(c); break; } } db.SaveChanges(); } MaterialsDataGrid.ItemsSource = null; MaterialsDataGrid.ItemsSource = listMaterials; } }
private void AddMaterialButton_Click(object sender, RoutedEventArgs e) { decimal b = 0; int a = 0; if (MaterialArticylTextBox.Text == "") { MessageBox.Show("Артикул не указан", Error); } else if (MaterialNameTextBox.Text == "") { MessageBox.Show("Название не указано", Error); } else if (MaterialQuantityTextBox.Text == "") { MessageBox.Show("Количество не указано", Error); } else if (MaterialPriceTextBox.Text == "") { MessageBox.Show("Цена не указана", Error); } else { if (MaterialQuantityTextBox.Text != "0") { Int32.TryParse(MaterialQuantityTextBox.Text, out a); if (a == 0) { MessageBox.Show("Количество указано неверно", Error); return; } } if (MaterialPriceTextBox.Text != "0") { Decimal.TryParse(MaterialPriceTextBox.Text, out b); if (b == 0) { MessageBox.Show("Цена указана неверно", Error); return; } } using (var db = new FurnitureShopEntitie()) { var mat = db.Materials; foreach (var m in mat) { if (m.Articyl == MaterialArticylTextBox.Text) { MessageBox.Show("Материал с таким артикулом уже существует", Error); return; } } var EI = from f in db.Edinica_izmerenia where f.Edinica_izmerenia_name == MaterialEdIzmComboBox.SelectedItem.ToString() select f.Edinica_izmerenia_id; int ei = 1; foreach (var v in EI) { ei = v; } var MT = from f in db.Type_material where f.Type_material_name == MaterialTypeComboBox.SelectedItem.ToString() select f.Type_material_id; int mt = 1; foreach (var v in MT) { mt = v; } Materials materials = new Materials() { Articyl = MaterialArticylTextBox.Text, Name = MaterialNameTextBox.Text, Edinica_izmerenia = ei, Kolichestvo = a, Type_material = mt, Price = b }; db.Materials.Add(materials); if (db.SaveChanges() == 0) { MessageBox.Show("Не удалось добавить материал", Error); } else { MessageBox.Show("Материал добавлен"); Button_Click_4(null, null); ShowMaterials(MaterialQualityAll); } } } }
private void Registrate(object sender, RoutedEventArgs e) { Password password = new Password(PasswordRegistrationPasswordBox.Password.ToString()); if (LoginRegistrationTextBox.Text.ToString() == "") { MessageBox.Show("Введите логин", Error); } else { string mistake = password.CheckPassword(); if (mistake != "") { MessageBox.Show(mistake, Error); } else if (password.Pas != PasswordRegistration2PasswordBox.Password.ToString()) { MessageBox.Show("Пароли не совпадают", Error); } else { using (var d1 = new FurnitureShopEntitie()) { bool enter = false; foreach (var log in from f in d1.User select f) { if (LoginRegistrationTextBox.Text.ToString() == log.Login.ToString()) { enter = true; MessageBox.Show("Пользователь с таким логином уже существует", Error); break; } } if (!enter) { User user = new User() { Login = LoginRegistrationTextBox.Text.ToString(), RoleId = 1, Password = password.Pas }; if (FirstNameTextBox.Text.ToString() == "") { user.FirstName = null; } else { user.FirstName = FirstNameTextBox.Text.ToString(); } if (LastNameTextBox.Text.ToString() == "") { user.LastName = null; } else { user.LastName = LastNameTextBox.Text.ToString(); } if (SecondNameTextBox.Text.ToString() == "") { user.SecondName = null; } else { user.SecondName = SecondNameTextBox.Text.ToString(); } if (PhotoRegistarationTextBox.Text.ToString() != "") { try { user.Photo = ImageToByteArray(System.Drawing.Image.FromFile(PhotoRegistarationTextBox.Text.ToString())); } catch (FileNotFoundException) { MessageBox.Show("Не удалось загрузить фотографию", Error); } } d1.User.Add(user); if (d1.SaveChanges() == 1) { MessageBox.Show("Регистрация завершена успешно", Error); } else { MessageBox.Show("Регистрация не удалась", Error); } } } } } }