@using System.Globalization
@using Microsoft.EntityFrameworkCore
@using MyDarling.Models
@inject DataContext context

@{
    var bundles = context.UnderwearBundles
        .Include(b => b.Figures)
        .Where(b => b.Price != 0 && b.Figures.Count > 0)
        .OrderByDescending(b => b.Id);
}

<section class="projects-section bg-light" id="projects">
    <div class="container px-3 px-lg-4 mt-4">
        <div class="row gx-4 gx-lg-5 row-cols-2 row-cols-md-3 row-cols-xl-4 justify-content-center">
            @foreach (var bundle in bundles)
            {
                <div class="col mb-5">
                    <div class="card h-100">
                        <a data-src="@bundle.Figures[0].FilePath" data-fancybox="@bundle.Id"
                            data-caption="@bundle.Figures[0].Description"><img class="card-img-top"
                                src="@bundle.Figures[0].FilePath" alt="@bundle.Name" /></a>
                        @for (int i = 1; i < @bundle.Figures.Count(); i++)
                        {
                            <a data-src="@bundle.Figures[i].FilePath" data-fancybox="@bundle.Id"
                                data-caption="@bundle.Figures[i].Description"></a>
                        }
                        <div class="card-body p-4">
                            <div class="text-center">
                                <h5 class="fw-bolder">@bundle.Name</h5>
                                @String.Format(new CultureInfo("ru-RU"), "{0:C0}", @bundle.Price)
                            </div>
                        </div>
                    </div>
                </div>
            }
        </div>
    </div>
</section>