private void BtnSave_Click(object sender, RoutedEventArgs e) { StringBuilder errorstring = new StringBuilder(); _currentWorkPlace.FK_Room = 15; if (errorstring.Length > 0) { MessageBox.Show(errorstring.ToString()); return; } if (_currentWorkPlace.id == 0) { AccountingForConsumablesEntities.GetContext().WorkPlace.Add(_currentWorkPlace); } try { AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public void loadWorker() { Worker Wrk = AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.id == SenderMail.IntId).FirstOrDefault(); if (Wrk.Position.PositionName == "Менеджер по персоналу") { WorkerBtn.Visibility = Visibility.Visible; OrderBtn.Visibility = Visibility.Collapsed; ConsumableBtn.Visibility = Visibility.Collapsed; RoomBtn.Visibility = Visibility.Collapsed; ManagerOfFrame.MainFrame.Navigate(new WorkersS()); } else if (Wrk.Position.PositionName.Contains("Администратор")) { WorkerBtn.Visibility = Visibility.Visible; OrderBtn.Visibility = Visibility.Visible; ConsumableBtn.Visibility = Visibility.Visible; RoomBtn.Visibility = Visibility.Visible; FrameOfVision.Navigate(new ConsumPageAbout()); } else { WorkerBtn.Visibility = Visibility.Collapsed; OrderBtn.Visibility = Visibility.Visible; ConsumableBtn.Visibility = Visibility.Visible; RoomBtn.Visibility = Visibility.Visible; FrameOfVision.Navigate(new ConsumPageAbout()); } if (Wrk.CheckFirstVisit == true) { PasswordWindow psd = new PasswordWindow(); psd.ShowDialog(); } }
private void BtnDel_Click(object sender, RoutedEventArgs e) { var EquipmentForRemoving = DGridConsumable.SelectedItems.Cast <MaterialCard>().ToList(); if (CheckForDel(EquipmentForRemoving.Count) == true) { if (MessageBox.Show($"Вы точно хотите удалить следующие {EquipmentForRemoving.Count} элементов?", "Внимание", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { try { AccountingForConsumablesEntities.GetContext().MaterialCard.RemoveRange(EquipmentForRemoving); AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Данные удалены"); DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().MaterialCard.ToList(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } } else { return; } }
private void Manufacturer_DropDownClosed(object sender, EventArgs e) { var name1 = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Distinct().ToList(); var name = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Select(s => s.MaterialCard.id).Distinct().ToArray(); for (int i = 0; i < name.Count(); i++) { int stdasd = name[i]; int tbs = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Where(w => w.FK_MaterialCard == stdasd).Sum(s => s.OrderedQuantity); OrderedMaterial tasd = name1.Where(s => s.FK_MaterialCard == stdasd).FirstOrDefault(); OrderedMaterial card = new OrderedMaterial() { FK_MaterialCard = tasd.FK_MaterialCard, MaterialCard = tasd.MaterialCard, counter = tbs, FK_Order = 1 }; tbd.Add(card); } if (ManufacturerCmb.SelectedIndex == 0) { DGridConsumable.ItemsSource = tbd; } else if (NameTxt.Text == "") { DGridConsumable.ItemsSource = tbd. Where(w => w.MaterialCard.Materials.Manufacturer.ManufacturerName == ManufacturerCmb.Text).ToList(); } else { DGridConsumable.ItemsSource = tbd.Where(w => w.MaterialCard.Materials.MaterialName.StartsWith(NameTxt.Text) && w.MaterialCard.Materials.Manufacturer.ManufacturerName == ManufacturerCmb.Text).ToList(); } }
private void BtnSave_Click(object sender, RoutedEventArgs e) { StringBuilder errors = new StringBuilder(); if (errors.Length > 0) { MessageBox.Show(errors.ToString()); return; } if (_currentMat.id == 0) { AccountingForConsumablesEntities.GetContext().ReplenishmentOfMaterials.Add(_currentMat); } try { AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void BtnSave_Click(object sender, RoutedEventArgs e) { StringBuilder errorstring = new StringBuilder(); _currentMaterialCard.DateOfDelivery = DateTime.Now; if (string.IsNullOrWhiteSpace(_currentMaterialCard.InventNumber)) { errorstring.AppendLine("Укажите инвентаризационный номер"); } if (errorstring.Length > 0) { MessageBox.Show(errorstring.ToString()); return; } if (_currentMaterialCard.id == 0) { AccountingForConsumablesEntities.GetContext().MaterialCard.Add(_currentMaterialCard); } try { AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
/// <summary> /// Обработка нажатие на кнопку сохранить /// Производится проверка на пустые поля и выборы из списков /// После успешной проверки добавляется либо новая запись либо редактируется существующая /// </summary> private void BtnSave_Click(object sender, RoutedEventArgs e) { string Operations = "Редкатирование данных"; StringBuilder errorstring = new StringBuilder(); _currentWorkPlace.FK_Room = 15; if (string.IsNullOrEmpty(_currentWorkPlace.NumberPlace.ToString())) { errorstring.AppendLine("Номер"); } if (FIOBox.SelectedItem == null) { errorstring.AppendLine("ФИО"); } if (errorstring.Length > 0) { if (errorstring.ToString().Contains("ФИО")) { FIOFail.Visibility = Visibility.Visible; FIOFail.Content = "Выберите ФИО сотрудника"; } else { FIOFail.Visibility = Visibility.Collapsed; } if (errorstring.ToString().Contains("Номер")) { WorkPlaceFail.Visibility = Visibility.Visible; WorkPlaceFail.Content = "Введите номер рабочего места"; } else { WorkPlaceFail.Visibility = Visibility.Collapsed; } return; } if (_currentWorkPlace.id == 0) { AccountingForConsumablesEntities.GetContext().WorkPlace.Add(_currentWorkPlace); Operations = "Добавление нового помещения"; } try { AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); AccountingForConsumablesEntities.GetContext().OperationHystory.Add(new OperationHystory() { FK_Worker = SenderMail.IntId, Operation = Operations, DateTimeOfOperation = DateTime.Now }); AccountingForConsumablesEntities.GetContext().SaveChanges(); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public static AccountingForConsumablesEntities GetContext() { if (_context == null) { _context = new AccountingForConsumablesEntities(); } return(_context); }
/// <summary> /// Инициализация компонентов /// </summary> public InventarizationPageAbout(Inventarization currentInventarization) { InitializeComponent(); CmbFIO.Text = currentInventarization.Worker.FIO; CmbPlace.Text = currentInventarization.Warehouse.id.ToString(); CmbPosition.Text = currentInventarization.Worker.Position.PositionName; DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().MaterialInInventarization.Where(w => w.FK_Inventarization == currentInventarization.id).ToList(); }
private void Page_IsVisibleChanged(object sender, DependencyPropertyChangedEventArgs e) { if (Visibility == Visibility.Visible) { AccountingForConsumablesEntities.GetContext().ChangeTracker.Entries().ToList().ForEach(p => p.Reload()); DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().MaterialCard.ToList(); } }
/// <summary> /// Инициализация компонентов /// </summary> public OrderMorePage(Order SelectedMat) { InitializeComponent(); DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Where(w => w.FK_Order == SelectedMat.id).ToList(); _currentMat = SelectedMat; DataContext = _currentMat; CmbFIO.ItemsSource = AccountingForConsumablesEntities.GetContext().Worker.ToList(); CmbPlace.ItemsSource = AccountingForConsumablesEntities.GetContext().WorkPlace.ToList(); CmbPosition.ItemsSource = AccountingForConsumablesEntities.GetContext().Position.ToList(); }
public OperationHistoryPage() { InitializeComponent(); WorkerLst = AccountingForConsumablesEntities.GetContext().Worker.ToList(); WorkerLst.Insert(0, new Worker { FirstName = "All" }); FIOCmb.ItemsSource = WorkerLst; DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().OperationHystory.ToList(); }
public ConsumablePage() { InitializeComponent(); DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().MaterialCard.ToList(); ManufacturerLst = AccountingForConsumablesEntities.GetContext().Manufacturer.ToList(); ManufacturerLst.Insert(0, new Manufacturer { ManufacturerName = "All" }); ManufacturerCmb.ItemsSource = ManufacturerLst; }
/// <summary> /// Инициализация компонентов /// </summary> public WorkersS() { InitializeComponent(); DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().Worker.ToList(); GenderLst = AccountingForConsumablesEntities.GetContext().Gender.ToList(); GenderLst.Insert(0, new Gender { GenderName = "All" }); GenderCmb.ItemsSource = GenderLst; }
public InventarizationPageAbout(Inventarization currentInventarization) { InitializeComponent(); if (currentInventarization != null) { _currentMat = AccountingForConsumablesEntities.GetContext().MaterialInInventarization.Where(w => w.FK_Inventarization == currentInventarization.id).FirstOrDefault(); } DataContext = _currentMat; DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().MaterialInInventarization.Where(w => w.FK_Inventarization == currentInventarization.id).ToList(); }
/// <summary> /// Инициализация компонентов /// </summary> public OrderInWarehouse() { InitializeComponent(); WorkerLst = AccountingForConsumablesEntities.GetContext().Worker.ToList(); WorkerLst.Insert(0, new Worker { FirstName = "All" }); FIOCmb.ItemsSource = WorkerLst; DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().ReplenishmentOfMaterials.ToList(); }
/// <summary> /// Логика взаимодействия для WorkWithWorkersData.xaml /// </summary> public EditRoom(Room selectedRoom) { InitializeComponent(); if (selectedRoom != null) { _currentRoom = selectedRoom; } DataContext = _currentRoom; TypeOfRoomCmb.ItemsSource = AccountingForConsumablesEntities.GetContext().TypeOfRoom.ToList(); }
public EditOrderInWarehouse(ReplenishmentOfMaterials selectedMat) { InitializeComponent(); if (selectedMat != null) { _currentMat = selectedMat; } DataContext = _currentMat; Fasds.ItemsSource = AccountingForConsumablesEntities.GetContext().Worker.ToList(); }
public void loadWorker() { Worker Wrk = AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.id == SenderMail.IntId).FirstOrDefault(); if (Wrk.CheckFirstVisit == true) { PasswordWindow psd = new PasswordWindow(); psd.ShowDialog(); } }
public WorkWithOrder(WorkPlace SelectedWork) { InitializeComponent(); if (SelectedWork != null) { _currentWorkPlace = SelectedWork; } DataContext = _currentWorkPlace; FIOBox.ItemsSource = AccountingForConsumablesEntities.GetContext().Worker.ToList(); }
/// <summary> /// Инициализация компонентов /// </summary> public NewInventPAge(Inventarization SelectedInvent) { InitializeComponent(); if (SelectedInvent != null) { _currentInventarization = SelectedInvent; } DataContext = _currentInventarization; WarehouseCmb.ItemsSource = AccountingForConsumablesEntities.GetContext().Warehouse.ToList(); FIOCmb.ItemsSource = AccountingForConsumablesEntities.GetContext().Worker.ToList(); }
/// <summary> /// Блоки сортировки и поиска данных по тексту /// </summary> private void FIO_DropDownClosed(object sender, EventArgs e) { if (FIOCmb.SelectedIndex == 0) { DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().ReplenishmentOfMaterials.ToList(); } else { DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().ReplenishmentOfMaterials.Where(w => w.Worker.FIO.StartsWith(FIOCmb.Text.Substring(0, FIOCmb.Text.Length - 4))).ToList(); } }
private void FIOCmb_DropDownClosed(object sender, EventArgs e) { if (FIOCmb.SelectedIndex == 0) { DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().OperationHystory.ToList(); } else { DGridConsumable.ItemsSource = AccountingForConsumablesEntities.GetContext().OperationHystory.Where(w => w.Worker.FirstName.StartsWith(FIOCmb.Text.Substring(0, FIOCmb.Text.Length - 4))).ToList(); } }
public WorkWithInvent(Inventarization SelectedWork) { InitializeComponent(); if (SelectedWork != null) { _currentWorkPlace = SelectedWork; } DataContext = _currentWorkPlace; FIOBox.ItemsSource = AccountingForConsumablesEntities.GetContext().Worker.ToList(); WarehouseCmb.ItemsSource = AccountingForConsumablesEntities.GetContext().Warehouse.ToList(); }
/// <summary> /// Инициализация компонентов /// </summary> public WorkWithWorkersData(Worker SelectedWork) { InitializeComponent(); if (SelectedWork != null) { _currentWorker = SelectedWork; } DataContext = _currentWorker; ComboPosition.ItemsSource = AccountingForConsumablesEntities.GetContext().Position.ToList(); ComboStatus.ItemsSource = AccountingForConsumablesEntities.GetContext().StatusOfWorker.ToList(); GenderBox.ItemsSource = AccountingForConsumablesEntities.GetContext().Gender.ToList(); }
/// <summary> /// Обработка нажатие на кнопку сохранить /// Производится проверка на пустые поля и выборы из списков /// После успешной проверки добавляется либо новая запись либо редактируется существующая /// </summary> private void BtnSave_Click(object sender, RoutedEventArgs e) { string Operations = "Добавление новой инвентаризации"; StringBuilder errors = new StringBuilder(); if (WarehouseCmb.SelectedItem == null) { errors.AppendLine("Хранилище"); } if (FIOCmb.SelectedItem == null) { errors.AppendLine("ФИО"); } if (errors.ToString().Length > 0) { if (errors.ToString().Contains("Хранилище")) { WarehouseFail.Visibility = Visibility.Visible; WarehouseFail.Content = "Выберите номер хранилища"; } else { WarehouseFail.Visibility = Visibility.Collapsed; } if (errors.ToString().Contains("ФИО")) { FIOFail.Visibility = Visibility.Visible; FIOFail.Content = "Выберите сотрудника"; } else { FIOFail.Visibility = Visibility.Collapsed; } return; } try { AccountingForConsumablesEntities.GetContext().Inventarization.Add(_currentInventarization); AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); AccountingForConsumablesEntities.GetContext().OperationHystory.Add(new OperationHystory() { FK_Worker = SenderMail.IntId, Operation = Operations, DateTimeOfOperation = DateTime.Now }); AccountingForConsumablesEntities.GetContext().SaveChanges(); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
/// <summary> /// Обработка нажатие на кнопку сохранить /// Производится проверка на пустые поля и выборы из списков /// После успешной проверки добавляется либо новая запись либо редактируется существующая /// </summary> private void BtnSave_Click(object sender, RoutedEventArgs e) { StringBuilder errorstring = new StringBuilder(); if (TypeOfRoomCmb.SelectedItem == null) { errorstring.AppendLine("Тип"); } if (string.IsNullOrEmpty(_currentRoom.NumberOfRoom.ToString())) { errorstring.AppendLine("Номер"); } if (errorstring.Length > 0) { if (errorstring.ToString().Contains("Тип")) { TypeOfRoomFail.Visibility = Visibility.Visible; TypeOfRoomFail.Content = "Выберите тип помещения"; } else { TypeOfRoomFail.Visibility = Visibility.Collapsed; } if (errorstring.ToString().Contains("Номер")) { NumberFail.Visibility = Visibility.Visible; NumberFail.Content = "Введите номер"; } else { NumberFail.Visibility = Visibility.Collapsed; } return; } if (_currentRoom.id == 0) { AccountingForConsumablesEntities.GetContext().Room.Add(_currentRoom); } try { AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
public ConsumablePageWorkWithData(MaterialCard SelectedMCard) { InitializeComponent(); if (SelectedMCard != null) { _currentMaterialCard = SelectedMCard; } DataContext = _currentMaterialCard; CmbGroup.ItemsSource = AccountingForConsumablesEntities.GetContext().MaterialGroup.ToList(); CmbManufacturer.ItemsSource = AccountingForConsumablesEntities.GetContext().Manufacturer.ToList(); CmbUnit.ItemsSource = AccountingForConsumablesEntities.GetContext().Unit.ToList(); CmbNameMaterial.ItemsSource = AccountingForConsumablesEntities.GetContext().Materials.ToList(); }
/// <summary> /// Блок проверки введеных данных /// После проверки данных данные необходимые грузятся в приложение /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click(object sender, RoutedEventArgs e) { var idCheck = AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.Login.Equals(LoginTextBX.Text) && w.Password.Equals(PasswordTextBX.Password)).Select(s => s.id).FirstOrDefault(); var idChecklogin = AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.Login.Equals(LoginTextBX.Text)).Select(s => s.id).FirstOrDefault(); if (AuPage.LoginCheck(LoginTextBX.Text) && AuPage.PasswordCheck(PasswordTextBX.Password)) { Fail1.Visibility = Visibility.Visible; Fail1.Content = "Введите логин"; Fail2.Visibility = Visibility.Visible; Fail2.Content = "Введите пароль"; } else if (AuPage.LoginCheck(LoginTextBX.Text)) { Fail1.Visibility = Visibility.Visible; Fail1.Content = "Введите логин"; } else if (AuPage.PasswordCheck(PasswordTextBX.Password)) { Fail2.Content = "Введите пароль"; Fail2.Visibility = Visibility.Visible; } else { if (idChecklogin == 0) { GlobarFail.Visibility = Visibility.Visible; GlobarFail.Content = "Пользователь не найден"; } else { if (idCheck == 0) { GlobarFail.Visibility = Visibility.Visible; } else { string Code = Class.SenderCode(); Class.senderMAil(AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.id == idCheck).Select(s => s.Email).FirstOrDefault(), Code); SenderMail.IntId = AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.id == idCheck).Select(s => s.id).FirstOrDefault(); SenderMail.PosName = AccountingForConsumablesEntities.GetContext().Worker.Where(w => w.id == idCheck).Select(s => s.Position.PositionName).FirstOrDefault(); AccountingForConsumablesEntities.GetContext().OperationHystory.Add(new OperationHystory() { FK_Worker = SenderMail.IntId, Operation = "Авторизация в системе", DateTimeOfOperation = DateTime.Now }); AccountingForConsumablesEntities.GetContext().SaveChanges(); ManagerOfFrame.LogFrame.Navigate(new AutherizationPage(Code)); } } } }
private void BtnSave_Click(object sender, RoutedEventArgs e) { try { AccountingForConsumablesEntities.GetContext().SaveChanges(); MessageBox.Show("Информация сохранена"); ManagerOfFrame.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }