using Microsoft.EntityFrameworkCore;

namespace BookieWeb.Models
{
    public class ApplicationDbContext: DbContext
    {
        public ApplicationDbContext(DbContextOptions options): base(options) { 
        
        }
        // This is where we will be adding the 
    }
}

using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllersWithViews();
// adding database connection
builder.Services.AddDbContext<BookieWeb.Models.ApplicationDbContext>(
    options => options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"))
);
var app = builder.Build();

// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Home/Error");
    // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
    app.UseHsts();
}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.MapControllerRoute(
    name: "default",
    pattern: "{controller=Home}/{action=Index}/{id?}");

app.Run();

using BookieWeb.Models;
using Microsoft.EntityFrameworkCore;


namespace BookieWeb.Models
{
    public class ApplicationDbContext: DbContext
    {
        public ApplicationDbContext(DbContextOptions options): base(options) { 
        
        }
        // This is where we will be adding the 
        public DbSet<Category> Categories { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Category>().HasData(
                new Category { Id = 1, Name = "Action", DisplayOrders = 1 },
                new Category { Id = 2, Name = "History", DisplayOrders = 2 },
                new Category { Id = 3, Name = "History", DisplayOrders = 2 }
                ); 
        }
    }
}

pattern: "{controller=Home}/{action=Index}/{id?}");

public IActionResult Index()
{
    //  Get list items from the database
    List<Category> objCategoryList = _db.Categories.ToList();
    // Default View if no view is provided
    return View(objCategoryList);
}

@model List<Category>

<table class="table table-bordered table-striped">
    <thead>
        <!-- head of the table -->
        <tr>
            <!-- Adding header column for the table -->
            <th>
                Category Name
            </th>
            <th>
                Display Order
            </th>
        </tr>
    </thead>
    <tbody>
        <!-- Adding for loop to iterate over the list elements -->
        @foreach(var obj in Model.OrderBy(u => u.DisplayOrders))
        {
            <!-- body of the table -->
            <tr>
                <td>
                    @obj.Name
                </td>
                <td>
                    @obj.DisplayOrders
                </td>
            </tr>
        }
    </tbody>
</table>

@section Scripts{
    @{
        <partial name="_ValidationScriptsPartial" />
    }
}

TempData["success"] = "Category has been edited successfully";