"DefaultConnection": "Server=DESKTOP-C6JNJAT\\SQLEXPRESS;Database=DoctorManagement;Trusted_Connection=True;TrustServerCertificate=True;MultipleActiveResultSets=True;"

 "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=aspnet-ExampleSetup-0fed3dee-74be-4830-a1b7-	e7b8dc7511c0;Trusted_Connection=True;MultipleActiveResultSets=true"

 public class VideoGame
    {
        public int Id { get; set; }
        public string? Title { get; set; }
        public string? Platform { get; set; }
        
        //1 Developer can have many Games
        public int DeveloperId { get; set; }
        public Developer? Developer { get; set; }

        //1 Publisher can have many Games
        public int PublisherId { get; set; }
        public Publisher? Publisher { get; set; }
        
        //1 Game has 1 VideoGameDetails
        // 1:1 => NavigationPropertys (conveniant for queriying)
        public VideoGameDetails? VideoGameDetails { get; set; }

        //N:N

        //DO NOT DO THE OTHER ONE FOR GOD's SAKE
        public ICollection<VideoGameGenre>? VideoGameGenres { get; set; } = new List<VideoGameGenre>();
    }

 public class VideoGameDetails
    { 
       public int Id { get; set; }
       public string? Description { get; set; }
       public DateTime ReleaseDate { get; set; }
       public int VideoGameId { get; set; }
    }

   public class VideoGameGenre
    {
        public int Id { get; set; }

        //first N
        public int VideoGameId { get; set; }
        public VideoGame VideoGame { get; set; }


        //second N
        public int GenreId { get; set; }
        public Genre Genre { get; set; }
    }

namespace VideoGameTest.Data.Models
{
    public class Genre
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public ICollection<VideoGameGenre>? VideoGameGenres { get; set; } = new List<VideoGameGenre>();
    }
}

 public class ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : IdentityDbContext<ApplicationUser>(options)
 {
     public DbSet<VideoGame> VideoGames { get; set; }
     public DbSet<VideoGameDetails> VideoGameDetails { get; set; }
     public DbSet<Developer> Developers { get; set; }
     public DbSet<Publisher> Publishers { get; set; }
     public DbSet<Genre> Genre { get; set; }

     //N:N VideoGame N Genres
     public DbSet<VideoGameGenre> VideoGameGenres { get; set; }
     protected override void OnModelCreating(ModelBuilder modelBuilder)
     {
         //Neccesary (also for EFcore to build the Identity Tables if you have that activated): 
         base.OnModelCreating(modelBuilder);
     }
 }

public class AppService
{
    private readonly ApplicationDbContext _context;
    public AppService(ApplicationDbContext context)
    {
        _context = context;
    }
    public async Task<List<Developer>> ListDevelopersAsync()
    {
        return await _context.Developers.ToListAsync();
    }
    public async Task<List<Publisher>> ListPublishersAsync()
    {
        return await _context.Publishers.ToListAsync();
    }
    public async Task<List<Genre>> ListGenresAsync()
    {
        return await _context.Genre.ToListAsync();
    }
    public async Task<List<VideoGame>> ListVideoGamesAsync()
    {
        return await _context.VideoGames
            .Include(g => g.VideoGameDetails)
            .Include(g => g.VideoGameGenres)
                .ThenInclude(gg => gg.Genre)
            .Include(g => g.Developer)
            .Include(g => g.Publisher)
            .ToListAsync();
    }

    //CREATE
    public async Task AddVideoGameAsync(VideoGame game)
    {
        _context.VideoGames.Add(game);
        await _context.SaveChangesAsync();
    }

    //DELETE
    public async Task DeleteVideoGameAsync(int id)
    {
        var game = await _context.VideoGames.FindAsync(id);

        if (game != null)
        {
            _context.VideoGames.Remove(game);
            await _context.SaveChangesAsync();
        }
    }
    public async Task<VideoGame?> GetVideoGameByIdAsync(int id)
    {
        return await _context.VideoGames.FindAsync(id);
    }

    //UPDATE
    public async Task UpdateGameAsync(VideoGame game)
    {
        _context.Update(game);
        await _context.SaveChangesAsync();
    }
}

@page "/games"
@using VideoGameTest.Data.Models
@inject NavigationManager navman
@inject IJSRuntime JSRuntime
@rendermode InteractiveServer
@inject AppService appservice

<h3>Games List</h3>


<a href="/game">Create a Game</a>

@if (games == null)
{
    <p><em>Loading games...</em></p>
}
else if (!games.Any())
{
    <p><em>No games available.</em></p>
}
else
{
    <div class="table-responsive">
        <table id="gamesTable" class="table table-striped table-hover">
            <thead class="thead-light">
                <tr>
                    <th scope="col">Name</th>
                    <th scope="col">Developer</th>
                    <th scope="col">Publisher</th>
                    <th scope="col">ReleaseDate</th>
                    <th scope="col">Description</th>
                    <th scope="col">Genres</th>
                    <th scope="col">Delete</th>
                </tr>
            </thead>
            <tbody>
                @foreach (var game in games)
                {
                    <tr>
                        <td>@game.Title</td>
                        <td>@(game.Developer?.Name ?? "N/A")</td>
                        <td>@(game.Publisher?.Name ?? "N/A")</td>
                        <td>@(game.VideoGameDetails?.ReleaseDate.ToString() ?? "N/A")</td>
                        <td>@(game.VideoGameDetails?.Description?.ToString() ?? "N/A")</td>
                        <td>
                                 @if (game.VideoGameGenres?.Any() == true)
                                {
                                    <span>@string.Join(", ", game.VideoGameGenres.Where(pt => pt.Genre != null).Select(pt => pt.Genre.Name))</span>
                                }
                                else
                                {
                                    <span class="text-muted">No genres</span>
                                } 
                        </td>
                        <td>
                    <a href="/game/@game.Id" class="btn btn-sm btn-primary">Edit</a>
                                                <button type="button" class="btn btn-sm btn-danger" @onclick="() => HandleDelete(game.Id)">
                                Delete
                            </button>
                        </td>
                    </tr>
                }
            </tbody>
        </table>
    </div>
}

@code {

    private List<VideoGame>? games;

    public async void HandleDelete(int id)
    {
        await appservice.DeleteVideoGameAsync(id);
        navman.NavigateTo("/games", true);
    }

    protected override async Task OnInitializedAsync()
    {
        games = await appservice.ListVideoGamesAsync();
    }

//Uncomment this first
    protected override async Task OnAfterRenderAsync(bool firstRender)
    {
        if (firstRender && games?.Any() == true)
        {
            await JSRuntime.InvokeVoidAsync("initializeDataTable");
        }
    }
}

function initializeDataTable() {
    // Add the search inputs to each header cell
    $('#gamesTable thead tr')
        .clone(true)
        .addClass('filters')
        .appendTo('#gamesTable thead');

    $('#gamesTable').DataTable({
        orderCellsTop: true,
        fixedHeader: true,
        initComplete: function () {
            var api = this.api();

            // For each column
            api.columns().eq(0).each(function (colIdx) {
                // Skip the Actions column
                if (colIdx === 6) return;

                // Add a search input
                var cell = $('.filters th').eq(colIdx);
                var title = $(cell).text();
                $(cell).html('<input type="text" class="form-control form-control-sm" placeholder="Search ' + title + '" />');

                // Add search functionality
                $('input', $('.filters th').eq(colIdx))
                    .on('keyup change', function () {
                        if (api.column(colIdx).search() !== this.value) {
                            api
                                .column(colIdx)
                                .search(this.value)
                                .draw();
                        }
                    });
            });
        },
        language: {
            search: "Search all:",
            lengthMenu: "Show _MENU_ entries",
            info: "Showing _START_ to _END_ of _TOTAL_ entries",
            paginate: {
                first: "First",
                last: "Last",
                next: "Next",
                previous: "Previous"
            }
        },
        pageLength: 10,
        order: [[0, 'asc']], // Sort by first column (Name) ascending
        columnDefs: [
            { orderable: false, targets: 6 }, // Disable sorting on the Actions column (if its the 7 then 6 because of the index)
            { searchable: false, targets: 6 } // Disable searching on the Actions column (if its the 7 then 6 because of the index)
        ]
    });
} 

<--!--->

<HeadContent>
    <link href="https://cdn.datatables.net/1.13.7/css/dataTables.bootstrap5.min.css" rel="stylesheet" />
    <link href="https://cdn.datatables.net/fixedheader/3.4.0/css/fixedHeader.bootstrap5.min.css" rel="stylesheet" />
    <style>
        thead tr.filters {
            background-color: #f8f9fa;
        }
        thead tr.filters th {
            padding: 0.5rem;
        }
        thead tr.filters input {
            width: 100%;
            padding: 0.25rem;
            box-sizing: border-box;
        }
    </style>
    <script src="https://code.jquery.com/jquery-3.7.0.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.7/js/dataTables.bootstrap5.min.js"></script>
    <script src="https://cdn.datatables.net/fixedheader/3.4.0/js/dataTables.fixedHeader.min.js"></script>
    <script src="js/site.js"></script>
</HeadContent>

<--!--->