public IActionResult Index()
{
FitBodyContext context = new FitBodyContext();
var details = from supplement in context.Supplements
join orderline in context.OrderLines on supplement.ID equals orderline.SupplementID
select new OrderDetailsModel()
{
SupplementName = supplement.SupplementName,
Price = orderline.Price,
Quantity = orderline.Quantity,
Id = orderline.ID,
Time = orderline.Time
};
AdminIndexViewModel model = new AdminIndexViewModel()
{
CustomIdentityContexts = _customIdentityContext.Users.ToList(),
Supplements = _supplementService.GetAll(),
OrderDetailsModels = details.OrderByDescending(x => x.Name).ThenBy(x => x.Time).ToList(),
UnitInStock = _supplementService.GetAllUnitInStock(),
SaleCount = _orderLineService.GetAllSaleCount(),
UserCount = _customIdentityContext.Users.Count(),
BlogPostCount = _blogPostService.GetBlogPostCount(),
};
return(View(model));
}