public ActionResult ConfirmDelete(int id) { ProductComposition productComposition = db.ProductCompositions.Find(id); var products = db.Products.Where(p => p.Id == productComposition.ProductId).First(); var materials = db.Materials.Where(p => p.Id == productComposition.MaterialId).First(); ProductCompositionViewModel viewModel = new ProductCompositionViewModel { ProductName = productComposition.Product.Name, MaterialName = productComposition.Material.Name, Quantity = productComposition.Quantity, }; ProductCompositionsViewModel productCompositionsViewModel = new ProductCompositionsViewModel { ProductCompositionViewModel = viewModel }; if (productComposition == null) { return(View("NotFound")); } else { return(View(productCompositionsViewModel)); } }
public IActionResult Index(string name, int page = 1, SortState sortOrder = SortState.ProductCompositionIdAsc) { int pageSize = 10; IQueryable <ProductComposition> source = db.ProductCompositions.Include(p => p.Material).Include(p => p.Product); if (!String.IsNullOrEmpty(name)) { source = source.Where(p => p.Product.Name.Equals(name)); } switch (sortOrder) { case SortState.ProductCompositionIdDec: source = source.OrderByDescending(s => s.Id); break; case SortState.ProductCompositionProductNameDec: source = source.OrderByDescending(s => s.Product.Name); break; case SortState.ProductCompositionMaterialNameDec: source = source.OrderByDescending(s => s.Material.Name); break; case SortState.ProductCompositionQuantityDec: source = source.OrderByDescending(s => s.Quantity); break; case SortState.ProductCompositionProductNameAsc: source = source.OrderBy(s => s.Product.Name); break; case SortState.ProductCompositionMaterialNameAsc: source = source.OrderBy(s => s.Material.Name); break; case SortState.ProductCompositionQuantityAsc: source = source.OrderBy(s => s.Quantity); break; } var count = source.Count(); var items = source.Skip((page - 1) * pageSize).Take(pageSize).ToList(); PageViewModel pageViewModel = new PageViewModel(count, page, pageSize); ProductCompositionsViewModel viewModel = new ProductCompositionsViewModel { PageViewModel = pageViewModel, ProductCompositions = items, ProductCompositionViewModel = productCompositionViewModel, SortViewModel = new ProductComposotionSortViewModel(sortOrder), FilterViewModel = new WebApplicationSewingStudio.ViewModels.ProductCompositionsViewModels.FilterViewModel(name) }; return(View(viewModel)); }
public ActionResult Edit(int?id) { var items = db.ProductCompositions.Include(p => p.Material).Include(p => p.Product).Where(p => p.Id == id).ToList(); var productList = new SelectList(db.Products, "Id", "Name", items.First().ProductId); var materialList = new SelectList(db.Materials, "Id", "Name", items.First().MaterialId); ProductCompositionsViewModel viewModel = new ProductCompositionsViewModel { ProductCompositions = items, ProductCompositionViewModel = productCompositionViewModel, ProductsList = productList, MaterialsList = materialList }; return(View(viewModel)); }