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));
}
