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 ShowEquipmentInformation()
{
using (var db = new FurnitureShopEntitie())
{
List <Spec> listS = new List <Spec>();
var list = db.Equipment.Select(p => new { p.Marking, p.Name, p.Equipment_type });
var q = from f in db.Equipment_specification select f;
list.ToList();
q.ToList();
foreach (var l in list)
{
Spec spec = new Spec(l.Marking, l.Name, l.Equipment_type);
foreach (var s in q)
{
if (l.Marking == s.Marking)
{
spec.Specification.Add(s.Specification_name + ": " + s.Specification_value);
}
}
listS.Add(spec);
}
EquipmentDataGrid.ItemsSource = null;
EquipmentDataGrid.ItemsSource = listS;
}
}
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 Authication_Click(object sender, RoutedEventArgs e)
{
if (LoginTextBox.Text.ToString() == "")
{
MessageBox.Show("Введите логин", Error);
}
else if (PasswordPasswordBox.Password.ToString() == "")
{
MessageBox.Show("Введите пароль", Error);
}
else if (CapchaTextBox.Text.ToString() != captcha.CaptchaString)
{
MessageBox.Show("Неправильной ввод капчи", Error);
}
else
{
bool enter = false;
using (var db2 = new FurnitureShopEntitie())
{
foreach (var log in from f in db2.User select f)
{
if (log.Login.ToString() == LoginTextBox.Text.ToString() && log.Password.ToString() == PasswordPasswordBox.Password.ToString())
{
enter = true;
user = log;
break;
}
}
;
}
if (enter)
{
switch (user.RoleId.ToString())
{
case "1": CustomerGrid.Visibility = Visibility.Visible; break;
case "2": MasterGrid.Visibility = Visibility.Visible; break;
case "3": DirectorGrid.Visibility = Visibility.Visible; break;
case "4": DeputyDirectorGrid.Visibility = Visibility.Visible; break;
case "5": ManagerGrid.Visibility = Visibility.Visible; break;
}
AuthGrid.Visibility = Visibility.Hidden;
}
else
{
MessageBox.Show("Неправильный логин или пароль", Error);
CapchaChange();
}
}
}
private void AddInformationToEquipment()
{
using (var db = new FurnitureShopEntitie())
{
List <string> list = new List <string>();
foreach (var v in from f in db.Equipment_type select f.Equipment_type_name)
{
list.Add(v);
}
EquipmentTypeComboBox.ItemsSource = list;
}
}
private void AddMaterialGrid_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e)
{
using (var db = new FurnitureShopEntitie())
{
var list = from f in db.Edinica_izmerenia select f.Edinica_izmerenia_name;
MaterialEdIzmComboBox.ItemsSource = list.ToList();
MaterialEdIzmComboBox.SelectedIndex = 0;
list = from f in db.Type_material select f.Type_material_name;
MaterialTypeComboBox.ItemsSource = list.ToList();
MaterialTypeComboBox.SelectedIndex = 0;
}
MaterialArticylTextBox.Text = "";
MaterialNameTextBox.Text = "";
MaterialQuantityTextBox.Text = "";
MaterialPriceTextBox.Text = "";
}
private void ShowMaterials(string quality)
{
using (var db = new FurnitureShopEntitie())
{
var k = from m in db.Materials
where m.Quality1.QualityName == quality || quality == MaterialQualityAll
select new Materials2
{
Articyl = m.Articyl,
Name = m.Name,
Kolichestvo = m.Kolichestvo,
Edinica_izmerenia_name = m.Edinica_izmerenia1.Edinica_izmerenia_name,
Price = m.Price,
Shipper_name = m.Shipper.Shipper_name,
DateShip = m.DateShip,
QualityName = m.Quality1.QualityName
};
if (quality == MaterialQualityAll)
{
listMaterials = k.ToList();
MaterialsAll = listMaterials.Count;
MaterialsShowLabel.Content = MaterialsAll;
}
else
{
listMaterials = new List <Materials2>();
foreach (var l in k)
{
if (l.QualityName == quality)
{
listMaterials.Add(l);
}
}
MaterialsShowLabel.Content = listMaterials.Count;
}
MaterialsAllLabel.Content = MaterialsAll;
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);
}
}
}
}
}
}
