/// <summary> /// cmdInsertRow.Execute /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void InsertRowCmdExecuted(object sender, ExecutedRoutedEventArgs e) { CompGroups.Add(new GroupItemLocalWorkbook(SelectedComp) { StartDate = SelectedComp.StartDate, EndDate = SelectedComp.EndDate, SheetName = SheetNames.FirstOrDefault(), PersonalDataColumnIndex = 1, TeamColumnIndex = 2, YoBColumnIndex = 3, GradeColumnIndex = 4 }); }
private void Window_Loaded(object sender, RoutedEventArgs e) { descriptionViewSource = ((CollectionViewSource)(this.FindResource("descriptionViewSource"))); descriptionCollection = new ObservableCollectionEx <description>(Entities.description); descriptionViewSource.Source = descriptionCollection; descriptionCollection.CollectionChanged += descriptionCollection_CollectionChanged; //groupsViewSource = ((CollectionViewSource)(this.FindResource("groupsViewSource"))); //groupsViewSource.Source = Entities.groups; // Формируем запрос для вывода его в queryResultsDataGrid queryResults = from Desc in Entities.description join Group in Entities.groups on Desc.id_desc equals Group.desc into CompGroups from CompGroup in CompGroups.DefaultIfEmpty() select new { desc_name = Desc.name, Desc.start_date, Desc.end_date, group_name = CompGroup.name, CompGroup.start_year, CompGroup.end_year }; queryResultsCollection.AddRange(queryResults); queryResultsViewSource = new CollectionViewSource(); (queryResultsViewSource as ISupportInitialize).BeginInit(); queryResultsViewSource.CollectionViewType = typeof(ListCollectionView); queryResultsViewSource.Source = queryResultsCollection; (queryResultsViewSource as ISupportInitialize).EndInit(); Binding myBinding = new Binding() { Source = queryResultsViewSource }; BindingOperations.SetBinding(queryResultsDataGrid, DataGrid.ItemsSourceProperty, myBinding); }
private bool CheckSettings() { if (cmbComp.SelectedItem == null) { MessageBox.Show(this, Properties.Resources.resNoSelectedComp, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (CompGroups.Count == 0) { MessageBox.Show(this, Properties.Resources.resNoGroupsInComp, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if ((from gr in CompGroups group gr by gr.WorkbookName into groupNames where groupNames.Count() > 1 select groupNames.Key) .Any()) { MessageBox.Show(this, Properties.Resources.resDuplicateWorkbookNames, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (CompGroups.Any( arg => (string.IsNullOrWhiteSpace(arg.WorkbookName) || arg.WorkbookName.IndexOfAny(System.IO.Path.GetInvalidFileNameChars()) != -1))) { MessageBox.Show(this, string.Format(Properties.Resources.resfmtInvalidWorkbookNames, string.Join(", ", System.IO.Path.GetInvalidFileNameChars())), Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (!File.Exists(SelectedComp.SourceWorkbookName) && System.IO.Path.GetExtension(SelectedComp.SourceWorkbookName) != GlobalDefines.MAIN_WBK_EXTENSION && System.IO.Path.GetExtension(SelectedComp.SourceWorkbookName) != GlobalDefines.XLS_EXTENSION && System.IO.Path.GetExtension(SelectedComp.SourceWorkbookName) != GlobalDefines.XLSX_EXTENSION) { MessageBox.Show(this, Properties.Resources.resInvalidSourceWorkbookName, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (CompGroups.Any(arg => string.IsNullOrWhiteSpace(arg.SheetName) || string.IsNullOrWhiteSpace(arg.TLCell) || string.IsNullOrWhiteSpace(arg.BRCell) || arg.PersonalDataColumnIndex <= 0 || arg.TeamColumnIndex <= 0 || arg.YoBColumnIndex <= 0 || arg.GradeColumnIndex <= 0)) { MessageBox.Show(this, Properties.Resources.resInvalidSourceRangeForExporting, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (CompGroups.Any(arg => arg.EndYear.HasValue && arg.EndYear != (int)enEndYearSpecVals.AndElder && arg.EndYear != (int)enEndYearSpecVals.AndYounger && arg.StartYear >= arg.EndYear)) { MessageBox.Show(this, Properties.Resources.resInvalidGroupYears, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (CompGroups.Any(arg => arg.EndDate.HasValue && arg.StartDate != arg.EndDate)) { MessageBox.Show(this, Properties.Resources.resInvalidGroupDates, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (string.IsNullOrEmpty(SelectedComp.DestCompFolder) || (SelectedComp.DestCompFolder.IndexOfAny(System.IO.Path.GetInvalidPathChars()) != -1)) { MessageBox.Show(this, Properties.Resources.resInvalidDestCompFolder, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } if (!Directory.Exists(DBManagerApp.m_AppSettings.m_Settings.WorkbookTemplateFolder)) { MessageBox.Show(this, Properties.Resources.resInvalidWorkbookTemplateFolder, Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } string WorkbookTemplateFullPath = System.IO.Path.Combine(DBManagerApp.m_AppSettings.m_Settings.WorkbookTemplateFolder, DBManagerApp.m_AppSettings.m_Settings.WorkbookTemplateName); if (!File.Exists(WorkbookTemplateFullPath)) { MessageBox.Show(this, string.Format(Properties.Resources.resfmtInvalidWorkbookTemplateName, WorkbookTemplateFullPath), Title, MessageBoxButton.OK, MessageBoxImage.Error); return(false); } return(true); }
/// <summary> /// cmdDelRow.Execute /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DelRowCmdExecuted(object sender, ExecutedRoutedEventArgs e) { CompGroups.RemoveAt(lstvGroups.SelectedIndex); }