public void Execute(object parameter) { List <DbModel.Item> Items; using (var context = new DbModel.CodeFirstContext()) { Services.GenericCRUD <DbModel.Item> ItemsCRUD = new Services.GenericCRUD <DbModel.Item>(context); Items = ItemsCRUD.Read(); Console.WriteLine($"{ parameter}"); if (parameter.ToString() == "All") { _VM.Items = Items; } else if (parameter.ToString() == "Assepted") { _VM.Items = (Items.Where(item => item.Category.Name == "Assepted")).ToList <DbModel.Item>(); } else if (parameter.ToString() == "OnStore") { _VM.Items = (Items.Where(item => item.Category.Name == "OnStore")).ToList <DbModel.Item>(); } else if (parameter.ToString() == "Sold") { _VM.Items = (Items.Where(item => item.Category.Name == "Sold")).ToList <DbModel.Item>(); } else if (parameter.ToString() == "DatePeriod") { } } }
public void Execute(object parameter) { if (parameter.ToString() == "Add") { Views.InsertItemPage window = ((Views.InsertItemPage)_viewmodel.childWindow); string ItemTitle = window.TextBox_ItemTitle.Text; int ItemPrice = Convert.ToInt32(window.TextBox_ItemPrice.Text); DbModel.Item NewItem = new DbModel.Item { Title = ItemTitle, Price = ItemPrice, CategoryId = 1, MovingToCategoryDate = DateTime.Now, StorageId = 1 }; using (var context = new DbModel.CodeFirstContext()) { Services.GenericCRUD <DbModel.Item> ItemsCRUD = new Services.GenericCRUD <DbModel.Item>(context); ItemsCRUD.Create(NewItem); } _viewmodel.FilterGridCommand.Execute("Assepted"); } else if (parameter.ToString() == "MoveOnStore") { Views.MoveItemToStoreView window = ((Views.MoveItemToStoreView)_viewmodel.childWindow); DbModel.Item SelectedItem = (DbModel.Item)window.ComboBox_ItemSelector.SelectedItem; /// Correct UPDATING ! using (var context = new DbModel.CodeFirstContext()) { var item = context.Items.Where(i => i.ItemId == SelectedItem.ItemId).FirstOrDefault(); item.CategoryId = 2; context.SaveChanges(); } _viewmodel.FilterGridCommand.Execute("Assepted"); } else if (parameter.ToString() == "Sell") { Views.SellingItemView window = ((Views.SellingItemView)_viewmodel.childWindow); DbModel.Item SelectedItem = (DbModel.Item)window.ComboBox_ItemSelector.SelectedItem; /// Correct UPDATING ! using (var context = new DbModel.CodeFirstContext()) { var item = context.Items.Where(i => i.ItemId == SelectedItem.ItemId).FirstOrDefault(); item.CategoryId = 3; context.SaveChanges(); } _viewmodel.FilterGridCommand.Execute("OnStore"); } _viewmodel.childWindow.Close(); }
public ViewModelBase() { SpawnWindowCommand = new Commands.SpawnWindowCommand(this); FilterGridCommand = new Commands.FilterGridCommand(this); CRUDCommand = new Commands.CRUDCommand(this); using (var context = new DbModel.CodeFirstContext()) { ItemsCRUD = new Services.GenericCRUD <DbModel.Item>(context); this.Items = ItemsCRUD.Read(); CategoriesCRUD = new Services.GenericCRUD <DbModel.Category>(context); this.Categories = CategoriesCRUD.Read(); StoragesCRUD = new Services.GenericCRUD <DbModel.Storage>(context); this.Storages = StoragesCRUD.Read(); //Items.ForEach(i => Console.WriteLine(i.Title)); //Categories.ForEach(i => Console.WriteLine(i.Name)); //Storages.ForEach(i => Console.WriteLine(i.Name)); } }