Changeset fa0fbaf for KernelRecordsMVC.Web/Controllers/ReleaseController.cs

Timestamp:

09/01/26 06:11:34 (4 weeks ago)

Author:

mmilevski <markomilevski3@…>

Branches:

main

Children:

d2eccb3

Parents:

08aefc6

Message:

Added major improvements.

File:

• KernelRecordsMVC.Web/Controllers/ReleaseController.cs (modified) (4 diffs)

KernelRecordsMVC.Web/Controllers/ReleaseController.cs

@@ -1 @@
-using Microsoft.AspNetCore.Mvc;
+using KernelRecordsMVC.Domain.Enums;
+using KernelRecordsMVC.Infrastructure.Data;
+using Microsoft.AspNetCore.Mvc;
 using Microsoft.EntityFrameworkCore;
-using KernelRecordsMVC.Data;
 
-namespace KernelRecordsMVC.Controllers;
+namespace KernelRecordsMVC.Web.Controllers;
 
 public class ReleaseController : Controller
@@ -14 +15 @@
     }
 
-    // UC003 - Browse Releases
-    public IActionResult Index(string? search, string? genre)
+    // =========================================================
+    // BROWSE RELEASES
+    // =========================================================
+
+    public IActionResult Index(
+        string? search,
+        string? genre,
+        string? format,
+        string? type,
+        string? sort)
     {
         var query = _context.Releases
             .Include(r => r.Products)
             .Include(r => r.ReleaseArtists)
-            .ThenInclude(ra => ra.Artist)
+                .ThenInclude(ra => ra.Artist)
+            .Include(r => r.Album)
+            .Include(r => r.SingleRelease)
             .AsQueryable();
 
+        // SEARCH
         if (!string.IsNullOrWhiteSpace(search))
         {
+            search = search.Trim();
+
             query = query.Where(r =>
-                r.Title.ToLower().Contains(search.ToLower()));
+                r.Title.ToLower().Contains(search.ToLower()) ||
+                r.Genre.ToLower().Contains(search.ToLower()) ||
+                r.ReleaseArtists.Any(ra =>
+                    ra.Artist.ArtistName.ToLower()
+                        .Contains(search.ToLower())));
         }
 
+        // GENRE
         if (!string.IsNullOrWhiteSpace(genre))
         {
@@ -35 +54 @@
         }
 
-        var releases = query
-            .OrderBy(r => r.Title)
-            .ToList();
+        // FORMAT
+        if (!string.IsNullOrWhiteSpace(format))
+        {
+            query = query.Where(r =>
+                r.Products.Any(p =>
+                    p.Format.ToString() == format));
+        }
+
+        // TYPE
+        if (!string.IsNullOrWhiteSpace(type))
+        {
+            if (type.Equals("Album", StringComparison.OrdinalIgnoreCase))
+            {
+                query = query.Where(r => r.Album != null);
+            }
+            else if (type.Equals("Single", StringComparison.OrdinalIgnoreCase))
+            {
+                query = query.Where(r => r.SingleRelease != null);
+            }
+        }
+
+        // SORT
+        query = sort switch
+        {
+            "titleDesc" =>
+                query.OrderByDescending(r => r.Title),
+
+            "newest" =>
+                query.OrderByDescending(r => r.ReleaseDate),
+
+            "oldest" =>
+                query.OrderBy(r => r.ReleaseDate),
+
+            "format" =>
+                query.OrderBy(r =>
+                    r.Products
+                        .Select(p => p.Format.ToString())
+                        .FirstOrDefault()),
+
+            "priceAsc" =>
+                query.OrderBy(r =>
+                    r.Products
+                        .Select(p => (decimal?)p.Price)
+                        .Min()),
+
+            "priceDesc" =>
+                query.OrderByDescending(r =>
+                    r.Products
+                        .Select(p => (decimal?)p.Price)
+                        .Max()),
+
+            _ =>
+                query.OrderBy(r => r.Title)
+        };
+
+        var releases = query.ToList();
 
         ViewBag.Search = search;
         ViewBag.Genre = genre;
+        ViewBag.Format = format;
+        ViewBag.Type = type;
+        ViewBag.Sort = sort;
 
         ViewBag.Genres = _context.Releases
@@ -48 +123 @@
             .ToList();
 
+        ViewBag.Formats = Enum
+            .GetValues<ProductFormat>()
+            .Select(x => x.ToString())
+            .ToList();
+
         return View(releases);
     }
 
 
-    // Release details
+    // =========================================================
+    // DETAILS
+    // =========================================================
+
     public IActionResult Details(long id)
     {
         var release = _context.Releases
             .Include(r => r.Products)
+
             .Include(r => r.ReleaseArtists)
-            .ThenInclude(ra => ra.Artist)
+                .ThenInclude(ra => ra.Artist)
+
             .Include(r => r.Album)
-            .ThenInclude(a => a!.AlbumSongs)
-            .ThenInclude(x => x.Song)
+                .ThenInclude(a => a!.AlbumSongs)
+                    .ThenInclude(x => x.Song)
+                        .ThenInclude(s => s.SongArtists)
+                            .ThenInclude(sa => sa.Artist)
+
             .Include(r => r.SingleRelease)
-            .ThenInclude(s => s!.SingleFeatures)
-            .ThenInclude(x => x.Song)
+
             .FirstOrDefault(r => r.ReleaseId == id);