public IActionResult Details(int?id) { var customscontext = db.Customs_werehouses.Include(d => d.Types_of_goods); var items = customscontext.Where(d => d.WerehouseID == id).ToList(); var goods = new SelectList(db.Types_of_goods, "Types_of_goodsID", "Name"); Customs_werehouseViewModel werehouseView = new Customs_werehouseViewModel { WerehouseID = items.First().WerehouseID, Name = items.First().Types_of_goods.Name }; Customs_werehousesViewModel werehousis = new Customs_werehousesViewModel { Customs_Werehouses = items, Customs_werehouseViewModel = _werehouse, Type_of_GoodsList = goods }; if (items == null) { return(View("NotFound")); } else { return(View(werehousis)); } }
public IActionResult Edit(int?id) { var customscontext = db.Customs_werehouses.Include(c => c.Types_of_goods); var items = customscontext.Where(d => d.WerehouseID == id).ToList(); var goods = new SelectList(db.Types_of_goods, "Types_of_goodsID", "Name", items.First().Types_of_goodsID); Customs_werehousesViewModel customsWerehouse = new Customs_werehousesViewModel { Customs_Werehouses = items, Customs_werehouseViewModel = _werehouse, Type_of_GoodsList = goods }; return(View(customsWerehouse)); }
public IActionResult Index(int?name, int page = 1, SortState sortOrder = SortState.WerehouseIDAsc) { int pageSize = 10; IQueryable <Customs_werehouses> source = db.Customs_werehouses.Include(d => d.Types_of_goods); if (name != null && name != 0) { source = source.Where(p => p.Types_of_goods.Types_of_goodsID == name); } switch (sortOrder) { case SortState.WerehouseIDDesc: source = source.OrderByDescending(s => s.WerehouseID); break; case SortState.NameAsc: source = source.OrderBy(s => s.Types_of_goods.Name); break; case SortState.NameDesc: source = source.OrderByDescending(s => s.Types_of_goods.Name); break; } var count = source.Count(); var items = source.Skip((page - 1) * pageSize).Take(pageSize).ToList(); PageViewModel pageViewModel = new PageViewModel(count, page, pageSize); Customs_werehousesViewModel customsWerehouse = new Customs_werehousesViewModel { Customs_Werehouses = items, Customs_werehouseViewModel = _werehouse, PageViewModel = pageViewModel, SortViewModel = new Customs_werehousesSortViewModel(sortOrder), FilterViewModel = new Customs_werehousesFilterViewModel(db.Types_of_goods.ToList(), name) }; return(View(customsWerehouse)); }