public KeyListPage(Models.Event tatEvent) { InitializeComponent(); tatEvent1 = tatEvent; KeyListDG.ItemsSource = TatarCulturDbEntities.GetContext().Keys.Where(p => p.IdEvent == tatEvent.IdEvent).OrderBy(p => p.KeyEvent).ToList(); DataContext = _currentKey; }
private void BtnSaveClick(object sender, RoutedEventArgs e) { StringBuilder _error = CheckFields(); if (_error.Length > 0) { MessageBox.Show(_error.ToString()); return; } if (_currentType.IdType == 0) { TatarCulturDbEntities.GetContext().Types.Add(_currentType); } try { TatarCulturDbEntities.GetContext().SaveChanges(); MessageBox.Show("Запись Изменена"); Manager.MainFrame.GoBack(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } Manager.MainFrame.GoBack(); }
private void UpdateData() { var _currentObject = TatarCulturDbEntities.GetContext().Objects.OrderBy(p => p.Name).ToList(); if (ComboType.SelectedIndex > 0) { _currentObject = _currentObject.Where(p => p.IdType == (ComboType.SelectedItem as Models.Type).IdType).ToList(); } _currentObject = _currentObject.Where(p => p.Name.ToLower().Contains(TBoxSearch.Text.ToLower())).ToList(); MapTat.Children.Clear(); foreach (Models.Object obj in _currentObject) { Location pinLocation = new Location((double)obj.Latitude, (double)obj.Longitude); Location pinLocationCenter = new Location(55.60307988301807, 49.586290315150926); var pin = new Pushpin(); pin.ToolTip = $"{obj.Name}"; pin.Location = pinLocation; MapTat.Children.Add(pin); MapTat.ZoomLevel = 8; MapTat.Center = pinLocationCenter; } LViewObject.ItemsSource = _currentObject; TextBlockCount.Text = $"Результат запроса: {_currentObject.Count} записей из {_itemcount}"; }
private void BtnSaveClick(object sender, RoutedEventArgs e) { StringBuilder _error = CheckFields(); if (_error.Length > 0) { MessageBox.Show(_error.ToString()); return; } if (_currentKey.IdKey == 0) { _currentKey.IdEvent = tatEvent1.IdEvent; _currentKey.Active = false; TatarCulturDbEntities.GetContext().Keys.Add(_currentKey); } try { TatarCulturDbEntities.GetContext().SaveChanges(); MessageBox.Show($"Ключь {_currentKey.KeyEvent} сохранен!"); } catch (Exception ex) { MessageBox.Show($"{_currentKey.IdKey} {_currentKey.IdEvent} {_currentKey.Active} {_currentKey.KeyEvent}"); MessageBox.Show(ex.Message.ToString()); } Manager.MainFrame.GoBack(); }
public PageUser(User user) { InitializeComponent(); DataContext = user; ListBoxKey.Visibility = Visibility.Collapsed; ListBoxComment.ItemsSource = TatarCulturDbEntities.GetContext().Comments.Where(p => p.IdUser == user.IdUser).OrderBy(p => p.IdComment).ToList(); ListBoxKey.ItemsSource = TatarCulturDbEntities.GetContext().Sales.Where(p => p.IdUser == user.IdUser).OrderBy(p => p.IdSale).ToList(); }
private void BtnDeleteClick(object sender, RoutedEventArgs e) { var selectedUser = UserListDG.SelectedItems.Cast <User>().ToList(); User info = selectedUser[0]; StringBuilder s = new StringBuilder(); if (info.Sales.Count > 0) { s.AppendLine($"Есть связанные записи c истории"); } if (info.Comments.Count > 0) { s.AppendLine($"Есть связанные записи c комментариями"); } if (s.Length > 0) { MessageBox.Show(s.ToString()); } MessageBoxResult messageBoxResult = MessageBox.Show($"Удалить запись???", "Удаление", MessageBoxButton.OKCancel, MessageBoxImage.Question); if (messageBoxResult == MessageBoxResult.OK) { try { User x = selectedUser[0]; if (x.Sales.Count > 0) { var saleUser = TatarCulturDbEntities.GetContext().Sales.Where(p => p.IdUser == x.IdUser).ToList(); Sale sale = saleUser[0]; TatarCulturDbEntities.GetContext().Sales.Remove(sale); } if (x.Comments.Count > 0) { var commentUser = TatarCulturDbEntities.GetContext().Comments.Where(p => p.IdUser == x.IdUser).ToList(); Comment com = commentUser[0]; TatarCulturDbEntities.GetContext().Comments.Remove(com); } TatarCulturDbEntities.GetContext().Users.Remove(x); TatarCulturDbEntities.GetContext().SaveChanges(); MessageBox.Show("Записи удалены"); List <User> users = TatarCulturDbEntities.GetContext().Users.OrderBy(p => p.Login).ToList(); UserListDG.ItemsSource = null; UserListDG.ItemsSource = users; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Ошибка удаления", MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void UpdateData() { var _currentComment = TatarCulturDbEntities.GetContext().Comments.OrderBy(p => p.IdComment).ToList(); _currentComment = _currentComment.Where(p => p.User.Login.ToLower().Contains(TBoxSearch.Text.ToLower())).ToList(); CommentListDG.ItemsSource = _currentComment; TextBlockCount.Text = $"Результат запроса: {_currentComment.Count} записей из {_itemcount-1}"; }
private void btnSaveClick(object sender, RoutedEventArgs e) { try { TatarCulturDbEntities.GetContext().SaveChanges(); MessageBox.Show("Изменения сохранены"); } catch (Exception ex) { MessageBox.Show("Ошибка"); } }
private void UpdateData() { var _currentUser = TatarCulturDbEntities.GetContext().Users.OrderBy(p => p.IdRols).ToList(); if (ComboType.SelectedIndex > 0) { _currentUser = _currentUser.Where(p => p.IdRols == (ComboType.SelectedItem as UserRol).IdRols).ToList(); } _currentUser = _currentUser.Where(p => p.Login.ToLower().Contains(TBoxSearch.Text.ToLower())).ToList(); UserListDG.ItemsSource = _currentUser; TextBlockCount.Text = $"Результат запроса: {_currentUser.Count} записей из {_itemcount-1}"; }
public AddUserPage(User selecetUser, int idUser) { InitializeComponent(); if (selecetUser != null) { _currentUser = selecetUser; _filePath = _currentDirectory + _currentUser.UserPhoto; _fileCompare = _filePath; Title = "Редактирование данных пользователя"; } cmbRol.Visibility = Visibility.Collapsed; RolLabel.Visibility = Visibility.Collapsed; _currentUser.IdRols = idUser; idUser1 = idUser; _photoName = _currentUser.UserPhoto; DataContext = _currentUser; cmbRol.ItemsSource = TatarCulturDbEntities.GetContext().UserRols.ToList(); }
private void BtnEnterClick(object sender, RoutedEventArgs e) { List <User> users = TatarCulturDbEntities.GetContext().Users.ToList(); User user = users.FirstOrDefault(p => p.Login == TbLogin.Text && p.Password == PbPassword.Password); StringBuilder error = new StringBuilder(); if (string.IsNullOrWhiteSpace(TbLogin.Text)) { error.AppendLine("Введите логин"); } if (string.IsNullOrWhiteSpace(PbPassword.Password)) { error.AppendLine("Введите пароль"); } if (error.Length > 0) { MessageBox.Show(error.ToString(), "Ошибка авторизации", MessageBoxButton.OK, MessageBoxImage.Error); return; } if (user != null) { int rols = (int)user.IdRols; Manager.idUser = user.IdUser; MainWindow mainWindow = new MainWindow(rols, user); mainWindow.Owner = this; this.Hide(); mainWindow.Show(); } else if (user == null) { MessageBox.Show("Неверный пароль или логин", "Неверный пароль или логин", MessageBoxButton.OK, MessageBoxImage.Error); PbPassword.Clear(); } }
private void btnDeleteClick(object sender, RoutedEventArgs e) { var selectedKey = KeyListDG.SelectedItems.Cast <Models.Key>().ToList(); MessageBoxResult messageBoxResult = MessageBox.Show($"Удалить {selectedKey.Count()} записей???", "Удаление", MessageBoxButton.OKCancel, MessageBoxImage.Question); if (messageBoxResult == MessageBoxResult.OK) { try { TatarCulturDbEntities.GetContext().Keys.RemoveRange(selectedKey); TatarCulturDbEntities.GetContext().SaveChanges(); MessageBox.Show("Записи удалены"); List <Models.Key> key = TatarCulturDbEntities.GetContext().Keys.OrderBy(p => p.KeyEvent).ToList(); KeyListDG.ItemsSource = key; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } } }
private StringBuilder CheckFields() { StringBuilder s = new StringBuilder(); if (string.IsNullOrWhiteSpace(_currentType.Name)) { s.AppendLine("Название типа невведено!"); } List <Models.Type> types = TatarCulturDbEntities.GetContext().Types.ToList(); Models.Type type = types.FirstOrDefault(p => p.Name == _currentType.Name); if (type != null) { string name = type.Name; if (name == _currentType.Name) { s.AppendLine("Такой тип уже есть!"); } } return(s); }
private void LoadData() { Location pinLocation = new Location(55.7887, 49.1221); MapTat.Center = pinLocation; var type = TatarCulturDbEntities.GetContext().Types.OrderBy(p => p.Name).ToList(); type.Insert(0, new Models.Type { Name = "Все типы" }); ComboType.ItemsSource = type; ComboType.SelectedIndex = 0; var obj = TatarCulturDbEntities.GetContext().Objects.ToList(); LViewObject.ItemsSource = obj; _itemcount = LViewObject.Items.Count; TextBlockCount.Text = $"Результат запроса: {_itemcount} записей из {_itemcount}"; }
private void LViewObjectSelectionChanged(object sender, SelectionChangedEventArgs e) { if (LViewObject.SelectedIndex >= 0) { MapTat.Children.Clear(); StackInfo.Visibility = Visibility.Visible; Models.Object obj = (LViewObject.SelectedItem as Models.Object); var i = TatarCulturDbEntities.GetContext().Objects.Where(x => x.IdObject == obj.IdObject).ToList(); Location pinLocation = new Location((double)obj.Latitude, (double)obj.Longitude); Pushpin pin = new Pushpin(); pin.Location = pinLocation; MapTat.Children.Add(pin); MapTat.ZoomLevel = 15; MapTat.Center = pinLocation; this.DataContext = obj; if (obj.Description == null) { textblockInfo.Text = "Нет информации"; } else if (obj.Description.Length > 250) { int text = obj.Description.Length - 250; var des = obj.Description; des = des.Substring(0, des.Length - text); des = des.Insert(des.Length, " ..."); textblockInfo.Text = des; } else { textblockInfo.Text = obj.Description; } } else { StackInfo.Visibility = Visibility.Collapsed; } }