@using Microsoft.AspNetCore.Http @using Microsoft.EntityFrameworkCore @using KernelRecordsMVC.Infrastructure.Data @using KernelRecordsMVC.Domain.Enums @inject KernelRecordsContext DbContext @{ long cartCount = 0; var sessionUserId = Context.Session.GetInt32("UserId"); if (sessionUserId.HasValue) { var userId = (long)sessionUserId.Value; cartCount = await DbContext.OrderProducts .Where(op => op.Order.UserId == userId && op.Order.Status == OrderStatusType.PENDING) .SumAsync(op => (long?)op.Quantity) ?? 0; } }