/// <summary> /// remove createdCategory /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdTest2_Click(object sender, EventArgs e) { CategoryItem categoryItem = default(CategoryItem); //User must select a Category Item. categoryItem = MDSSController <MDSSModel> .SelectCategoryItem(SettingsController <Settings> .Settings.Sheets[0], "Type", "Select a Category Item to Add to existing Sheet Cells.", 0, false); if (categoryItem != null) { //_ValueChanging = true; //move it SettingsController <Settings> .Settings.Sheets[0].AssignCategory("Type", Category.SheetCategoryType.None, categoryItem); //_ValueChanging = false; //refresh //MDSSController<MDSSModel>.Refresh(); dgCells.DataSource = SettingsController <Settings> .Settings.Sheets[0].Cells; //returnValue = true; } //List<CategoryItem> sheetCategoryItems = new List<CategoryItem> { SettingsController<Settings>.Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(ci => ci.Name == "Belts") }; //List<SheetCell> cellsWithSelectedCategoryItem = (from cell in SettingsController<Settings>.Settings.Sheets[0].Cells // where sheetCategoryItems.All(ci1 => cell.CategoryItems.Any(ci2 => ci2 == ci1)) // select cell).ToList<SheetCell>(); //List<SheetCell> cellsWithUnSelectedCategoryItem = (from cell in SettingsController<Settings>.Settings.Sheets[0].Cells // where sheetCategoryItems.All(ci1 => cell.CategoryItems.Any(ci2 => ((ci2.Parent == ci1.Parent) && (ci2.Name != ci1.Name)))) // select cell).ToList<SheetCell>(); }
private void cmdDemote_Click(object sender, EventArgs e) { String categoryName = default(String); if (this.dataGridView2.SelectedRows.Count == 1) { categoryName = this.dataGridView2.SelectedRows[0].Cells[0].Value.ToString(); MDSSController <MDSSModel> .ShiftSheetCategory(SettingsController <Settings> .Settings.Sheets[0], categoryName, ListOfTExtension.ShiftTypes.Demote); } }
/// <summary> /// add createdCategory /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdTest1_Click(object sender, EventArgs e) { CategoryItem categoryItem = default(CategoryItem); //User must select a Category Item. categoryItem = MDSSController <MDSSModel> .SelectCategoryItem(SettingsController <Settings> .Settings.Sheets[0], "Type", "Select a Category Item to Add to existing Sheet Cells.", 0, false); if (categoryItem != null) { //_ValueChanging = true; //move it SettingsController <Settings> .Settings.Sheets[0].AssignCategory("Type", Category.SheetCategoryType.Y, categoryItem); //_ValueChanging = false; //refresh //MDSSController<MDSSModel>.Refresh(); dgCells.DataSource = SettingsController <Settings> .Settings.Sheets[0].Cells; //returnValue = true; } }
private void Form1_Load(object sender, EventArgs e) { //MDSSController<MDSSModel>.New(new Settings()); //create Settings before first use by Model SettingsController <Settings> .New(); MDSSController <MDSSModel> .New(); Category createdCategory = default(Category); //subscribe to notifications this.PropertyChanged += PropertyChangedEventHandler; MDSSController <MDSSModel> .Model.PropertyChanged += PropertyChangedEventHandler; #region Add Sheets // Add sheet to settings SettingsController <Settings> .Settings.Sheets.Add(new Sheet("Sheet1"));//TODO:do to model, not settings #endregion Add Sheets #region Add Categories with CategoryItems //Create categories in settings SettingsController <Settings> .Settings.Sheets[0].Categories.Add ( new Category ( "Year", Category.SheetCategoryType.X ) ); createdCategory = SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year"); createdCategory.Items = new OrderedEquatableBindingList <CategoryItem> { new CategoryItem("2001", createdCategory), new CategoryItem("2002", createdCategory) }; SettingsController <Settings> .Settings.Sheets[0].Categories.Add ( new Category ( "Quarter", Category.SheetCategoryType.X ) ); createdCategory = SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter"); createdCategory.Items = new OrderedEquatableBindingList <CategoryItem> { new CategoryItem("Q1", createdCategory), new CategoryItem("Q2", createdCategory), new CategoryItem("Q3", createdCategory), new CategoryItem("Q4", createdCategory) }; SettingsController <Settings> .Settings.Sheets[0].Categories.Add ( new Category ( "Details", Category.SheetCategoryType.Y ) ); createdCategory = SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details"); createdCategory.Items = new OrderedEquatableBindingList <CategoryItem> { new CategoryItem("Units", createdCategory), new CategoryItem("Price", createdCategory) }; SettingsController <Settings> .Settings.Sheets[0].Categories.Add ( new Category ( "Department", Category.SheetCategoryType.Filter ) ); createdCategory = SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department"); createdCategory.Items = new OrderedEquatableBindingList <CategoryItem> { new CategoryItem("Belts", createdCategory), new CategoryItem("Hats", createdCategory) }; SettingsController <Settings> .Settings.Sheets[0].Categories.Add ( new Category ( "Type", Category.SheetCategoryType.None ) ); createdCategory = SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Type"); createdCategory.Items = new OrderedEquatableBindingList <CategoryItem> { new CategoryItem("TypeA", createdCategory), new CategoryItem("TypeB", createdCategory) }; #endregion Add Categories with CategoryItems #region Add Categories to SheetCategories //Add sheet-categories that are reference to categories //SettingsController<Settings>.Settings.Sheets[0].Categories.Find(c => c.Name == "Year").CategoryType = Category.SheetCategoryType.X; //SettingsController<Settings>.Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").CategoryType = Category.SheetCategoryType.X; //SettingsController<Settings>.Settings.Sheets[0].Categories.Find(c => c.Name == "Department").CategoryType = Category.SheetCategoryType.X; //SettingsController<Settings>.Settings.Sheets[0].Categories.Find(c => c.Name == "Details").CategoryType = Category.SheetCategoryType.Y; //SettingsController<Settings>.Settings.Sheets[0].CategoryX.Add #endregion Add Categories to SheetCategories #region Add SheetCells with Category Items //Add sheet cells with references to sheet-categories SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "100", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "110", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "120", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "130", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "140", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "150", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "160", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "170", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "180", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "190", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "200", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "210", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "220", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "230", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "240", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "250", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Units") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.00", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.10", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.20", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.30", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.40", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.50", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.60", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.70", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Belts"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.80", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "1.90", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "2.00", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "2.10", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2001"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "2.20", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q1"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "2.30", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q2"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "2.40", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q3"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); SettingsController <Settings> .Settings.Sheets[0].Cells.Add ( new SheetCell ( "2.50", new EquatableBindingList <CategoryItem> { SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Year").Items.Find(i => i.Name == "2002"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Quarter").Items.Find(i => i.Name == "Q4"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Department").Items.Find(i => i.Name == "Hats"), SettingsController <Settings> .Settings.Sheets[0].Categories.Find(c => c.Name == "Details").Items.Find(i => i.Name == "Price") } ) ); #endregion Add SheetCells with Category Items SettingsController <Settings> .Settings.Sync(); // Connect the virtual-mode events to event handlers. this.dataGridView1.CellValueNeeded += new DataGridViewCellValueEventHandler(dataGridView1_CellValueNeeded); this.dataGridView1.CellValuePushed += new DataGridViewCellValueEventHandler(dataGridView1_CellValuePushed); this.dgvSheetCategoriesX.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvSheetCategoriesX_CellValueNeeded); this.dgvSheetCategoriesY.CellValueNeeded += new DataGridViewCellValueEventHandler(dgvSheetCategoriesY_CellValueNeeded); // Add columns and rows to the DataGridView. //format cells DataGridViewHelper.RenderSheet(this.dataGridView1, SettingsController <Settings> .Settings.Sheets[0]); //DataGridViewHelper.RenderSheet(this.dataGridView1, (Sheet)null); //SettingsController<Settings>.Settings.Sheets[0].Categories.Find(c => c.Name == "Details").CategoryType = Category.SheetCategoryType.Y; this.dataGridView2.DataSource = SettingsController <Settings> .Settings.Sheets[0].Categories; DataGridViewHelper.RenderSheetCategory(this.dgvSheetCategoriesFilter, SettingsController <Settings> .Settings.Sheets[0], Category.SheetCategoryType.Filter); DataGridViewHelper.RenderSheetCategory(this.dgvSheetCategoriesX, SettingsController <Settings> .Settings.Sheets[0], Category.SheetCategoryType.X); DataGridViewHelper.RenderSheetCategory(this.dgvSheetCategoriesY, SettingsController <Settings> .Settings.Sheets[0], Category.SheetCategoryType.Y); dgCells.DataSource = SettingsController <Settings> .Settings.Sheets[0].Cells; #if debug //debug view menuEditProperties_Click(sender, e); #endif }