Krok 1 zmiana Connection stringa w Kolokwium.API I Kolokwium.WEB
-----------------------------------------------------------------------------------------------------
Krok 2 stworzenie encji W Kolokwium.Model:

namespace Kolokwium.Model.DataModels;


public class Order{
    public int Id{get;set;}
    public DateTime CreationDate{get;set;}
    public string ShippingAdress{get;set;}=null!;
    public string? Description{get;set;}
    public string Status{get;set;}=null!;
    public int TotalAmount{get;set;}
    public DateTime DueDate{get;set;}
    public int ClientId{get;set;}
    public Client Client{get;set;}=null!;
    public ICollection<Product> Products{get;set;}=null!;
}
------------------------------------------------------------------------------------------------------
Krok 3 Deklaracja właściwości dla tabel w kontekście bazodanowym ApplicationDbContext w Kolokwium.DAL

 	// table properties
        // public virtual DbSet<Entity> TableName { get; set; } = null!;
        public virtual DbSet<Client> Clients{get;set;}=null!;
        public virtual DbSet<Order> Orders{get;set;}=null!;
        public virtual DbSet<Product> Products{get;set;}=null!;

-------------------------------------------------------------------------------------------------------
Krok 4 Tworzenie kontrolerów dla encji w Kolokwium.WEB/Controllers

ClientController.cs:

using Kolokwium.Model.DataModels;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Kolokwium.DAL;
public class ClientController:Controller
{
    private readonly ApplicationDbContext _context;

        public ClientController(ApplicationDbContext context)
    {
        _context = context;
    }

    public async Task<IActionResult> Index()
    {
        var dane = await _context.Clients.ToListAsync();
        return View(dane);
    }

    public IActionResult AddClients()
    {
        return View();
    }
    public IActionResult AddClient(Client client)
    {
        _context.Clients.Add(client);
        _context.SaveChanges();
        return Redirect("Index");
    }
    public IActionResult DeleteClients(int id)
    {
        Client? c=_context.Clients.FirstOrDefault(d=>d.Id==id);
        if(c!=null){
            _context.Clients.Remove(c);
            _context.SaveChanges();
        }
       
        return RedirectToAction(nameof(Index));
    }

     public IActionResult EditClients(int id)
    {
        Client? c=_context.Clients.FirstOrDefault(d=>d.Id==id);
        if(c==null){
            throw new Exception();
        }
       
        return View(c);
    }

     public IActionResult EditClient(Client client)
    {   
        Client? oldclient=_context.Clients.FirstOrDefault(d=>d.Id==client.Id);
        if(oldclient==null){
            throw new Exception();
        }
        oldclient.RegistrationDate=client.RegistrationDate;
        oldclient.FirstName=client.FirstName;
        oldclient.LastName=client.LastName;
        oldclient.Phone=client.Phone;
        oldclient.Email=client.Email;

        _context.SaveChanges();

        return RedirectToAction(nameof(Index));



        
    }



    
}

///////////////////////////////////////////////////////////////////////////////////////////////////////
OrderController.cs:

using Kolokwium.Model.DataModels;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using Kolokwium.DAL;
public class OrderController:Controller
{
    private readonly ApplicationDbContext _context;

        public OrderController(ApplicationDbContext context)
    {
        _context = context;
    }

    public async Task<IActionResult> Index()
    {
        var dane = await _context.Orders.ToListAsync();
        return View(dane);
    }

    public IActionResult AddOrders()
    {
        IList<Client> clients=_context.Clients.ToList();
        ViewBag.Clients = clients; 
        return View();
    }
    public IActionResult AddOrder(Order Order)
    {
        _context.Orders.Add(Order);
        _context.SaveChanges();
        return Redirect("Index");
    }
    public IActionResult DeleteOrders(int id)
    {
        Order? c=_context.Orders.FirstOrDefault(d=>d.Id==id);
        if(c!=null){
            _context.Orders.Remove(c);
            _context.SaveChanges();
        }
       
        return RedirectToAction(nameof(Index));
    }

    public IActionResult EditOrders(int id)
    {
        
        Order? c=_context.Orders.FirstOrDefault(d=>d.Id==id);
        if(c==null){
            throw new Exception();
        }
        IList<Client> clients=_context.Clients.ToList();
        ViewBag.Clients = clients; 
       
        return View(c);
    }

     public IActionResult EditOrder(Order order)
    {   
        Order? oldOrder=_context.Orders.FirstOrDefault(d=>d.Id==order.Id);
        if(oldOrder==null){
            throw new Exception();
        }
        oldOrder.CreationDate=order.CreationDate;
        oldOrder.ShippingAdress=order.ShippingAdress;
        oldOrder.Description=order.Description;
        oldOrder.Status=order.Status;
        oldOrder.TotalAmount=order.TotalAmount;
        oldOrder.DueDate=order.DueDate;
        oldOrder.ClientId=order.ClientId;
    

        _context.SaveChanges();

        return RedirectToAction(nameof(Index));



        
    }



    
}


-------------------------------------------------------------------------------------------------------
Krok 5 Uworzenie folderów zgodnych z nazwą klasy dla encji w Kolokwium.WEB/Views  
-------------------------------------------------------------------------------------------------------
Krok 6 Tworzenie widoków Index.cshtml w tych folderach
Client/Index.cshtml:

@using Kolokwium.Model.DataModels;
@model ICollection<Client>

<a asp-controller="Client" asp-action="AddClients">Add new client</a>

@foreach(Client client in Model)
{
    <div style="border:1px solid black;">
    <p>Registration Date:@client.RegistrationDate</p><br>
    <p>First Name:@client.FirstName</p><br>
    <p>Last Name:@client.LastName</p><br>
    <p>Email:@client.Email</p><br>
    <p>Phone:@client.Phone</p>
    <a asp-controller="Client" asp-action="DeleteClients" asp-route-id="@client.Id">Delete client</a>
    <a asp-controller="Client" asp-action="EditClients" asp-route-id="@client.Id">Edit client</a>
    </div>
    

}
/////////////////////////////////////////////////////////////////////////////////////////////////////////
AddClients:

@using Kolokwium.Model.DataModels;
@model Client;

<form asp-action="AddClient">
    <label>Registration Date:<input type="date" asp-for="RegistrationDate"></input></label><br>
    <label>First Name:<input type="text" asp-for="FirstName"></input></label><br>
    <label>Last Name:<input type="text" asp-for="LastName"></input></label><br>
    <label>Email:<input type="text" asp-for="Email"></input></label><br>
    <label>Phone:<input type="text" asp-for="Phone"></input></label><br>
    <input type="submit" value="Add new client">
</form>

//////////////////////////////////////////////////////////////////////////////////////////////////////
EditClients:
@using Kolokwium.Model.DataModels;
@model Client;

<form asp-action="EditClient">
    <input type="hidden" asp-for="Id"></input>
    <label>Registration Date:<input type="date" asp-for="RegistrationDate"></input></label><br>
    <label>First Name:<input type="text" asp-for="FirstName"></input></label><br>
    <label>Last Name:<input type="text" asp-for="LastName"></input></label><br>
    <label>Email:<input type="text" asp-for="Email"></input></label><br>
    <label>Phone:<input type="text" asp-for="Phone"></input></label><br>
    <input type="submit" value="Commit changes">
</form>

////////////////////////////////////////////////////////////////////////////////////////////////////
Order/Index.cshtml:

@using Kolokwium.Model.DataModels;
@model ICollection<Order>

<a asp-controller="Order" asp-action="AddOrders">Add new Order</a>

@foreach(Order Order in Model)
{
    <div style="border:1px solid black;">
    <p>Creation Date:@Order.CreationDate</p><br>
    <p>ShippingAdress:@Order.ShippingAdress</p><br>
    <p>Description:@Order.Description</p><br>
    <p>Status:@Order.Status</p><br>
    <p>TotalAmount:@Order.TotalAmount</p>
    <p>DueDate:@Order.DueDate</p>
    <p>Client:@Order.ClientId</p>
    <a asp-controller="Order" asp-action="DeleteOrders" asp-route-id="@Order.Id">Delete Order</a>
    <a asp-controller="Order" asp-action="EditOrders" asp-route-id="@Order.Id">Edit Order</a>
    </div>
    

}
//////////////////////////////////////////////////////////////////////////////////////////////////
AddOrders.cshtml:

@using Kolokwium.Model.DataModels;
@model Order;
@{

    var clients = ViewBag.Clients as List<Client>;
}

<form asp-action="AddOrder">
    <label>Creation Date:<input type="date" asp-for="CreationDate"></input></label><br>
    <label>ShippingAdress:<input type="text" asp-for="ShippingAdress"></input></label><br>
    <label>Description:<input type="text" asp-for="Description"></input></label><br>
    <label>Status:<input type="text" asp-for="Status"></input></label><br>
    <label>TotalAmount:<input type="text" asp-for="TotalAmount"></input></label><br>
    <label>DueDate:<input type="date" asp-for="DueDate"></input></label><br>
    <label>Clients:<select asp-for="ClientId">
        @foreach (var client in clients)
        {
            <option value="@client.Id">@client.FirstName</option>
        }
    </select></label><br>
    <input type="submit" value="Add new Order">
</form>
//////////////////////////////////////////////////////////////////////////////////////////////
EditOrders.cshtml

@using Kolokwium.Model.DataModels;
@model Order;
@{

    var clients = ViewBag.Clients as List<Client>;
}

<form asp-action="EditOrder">
    <input type="hidden" asp-for="Id"></input>
    <label>Creation Date:<input type="date" asp-for="CreationDate"></input></label><br>
    <label>ShippingAdress:<input type="text" asp-for="ShippingAdress"></input></label><br>
    <label>Description:<input type="text" asp-for="Description"></input></label><br>
    <label>Status:<input type="text" asp-for="Status"></input></label><br>
    <label>TotalAmount:<input type="text" asp-for="TotalAmount"></input></label><br>
    <label>DueDate:<input type="date" asp-for="DueDate"></input></label><br>
    <label>Clients:<select asp-for="ClientId">
        @foreach (var client in clients)
        {
            <option value="@client.Id">@client.FirstName</option>
        }
    </select></label><br>
    <input type="submit" value="Commit changes">
</form>
-------------------------------------------------------------------------------------------------------
Krok 7 W pliku Kolokwium.WEB/Views/Shared/_Layout.cshtml dorabiamy list item

<li class="nav-item">
     <a class="nav-link text-dark" asp-area="" asp-controller="Order" asp-action="Index">Orders</a>
</li>

-------------------------------------------------------------------------------------------------------
Komendy:
dotnet build        
dotnet ef migrations add migrancja1 --project Kolokwium.DAL --startup-project Kolokwium.Web
dotnet ef database update --project Kolokwium.DAL --startup-project Kolokwium.WEB
dotnet ef database drop --project Kolokwium.DAL --startup-project Kolokwium.WEB 
dotnet run --project Kolokwium.Web