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