BLAZOR - Faire un CRUD en utilisant Entity Framework Core et une BD PostGreSQL

@page "/"
@using DemoBlazorServerApp.Data
@inject IModalService Modal
@inject IMealService MealService
 
<div class="row">
   <div class="col-12">
     <h4><span class="oi oi-list" aria-hidden="true"></span> Liste de plats</h4>
   </div>
 
</div>
<div class="row">
   <div class="col-6">
     <button @onclick="@(() => AddMeal())" class="btn btn-sm btn-primary"><span class="oi oi-plus" aria-hidden="true"></span> Ajouter plat </button>
   </div>
 
</div>
<br />
 
@if (meals == null)
{
   <p><em>Loading...</em></p>
}
else
{
 
   <table class="table">
     <thead>
       <tr>
         <th>Nom</th>
         <th>Description</th>
         <th>Prix</th>
         <th>Actions</th>
       </tr>
     </thead>
     <tbody>
       @foreach (var meal in meals)
       {
         <tr>
           <td>@meal.Name</td>
           <td>@meal.Description</td>
           <td>@meal.Price $</td>
           <th>
             <button @onclick="@(() => DeleteMeal(meal.Id))" class="btn btn-sm btn-primary">Delete</button>
             | <button @onclick="@(() => EditMeal(meal.Id))" class="btn btn-sm btn-secondary">Edit</button>
           </th>
         </tr>
       }
     </tbody>
   </table>
}
 
@code {
   private List<Meal> meals;
 
   protected override async Task OnInitializedAsync()
   {
     meals = await MealService.GetMealsAsync();
   }
 
   async Task AddMeal()
   {
     var mealModal = Modal.Show<AddMeal>("Ajout de plat");
     var result = await mealModal.Result;
 
     if (!result.Cancelled)
     {
       meals = await MealService.GetMealsAsync();
     }
   }
 
   async Task DeleteMeal(int id)
   {
     var parameters = new ModalParameters();
     parameters.Add(nameof(Meal.Id), id);
 
     var mealModal = Modal.Show<DeleteMeal>("Suppression de plat", parameters);
     var result = await mealModal.Result;
 
     if (!result.Cancelled)
     {
       meals = await MealService.GetMealsAsync();
     }
   }
 
   async Task EditMeal(int id)
   {
     var parameters = new ModalParameters();
     parameters.Add(nameof(Meal.Id), id);
 
     var mealModal = Modal.Show<EditMeal>("Mise à jour de plat", parameters);
     var result = await mealModal.Result;
 
     if (!result.Cancelled)
     {
       meals = await MealService.GetMealsAsync();
     }
   }
 
 
}

@page "/addMeal"
@using DemoBlazorServerApp.Data
@inject IModalService ModalService
@inject IMealService MealService
 
   <EditForm Model="@meal" OnValidSubmit=@FormSubmitted>
 
     <DataAnnotationsValidator />
 
     <div class="form-group">
       <label for="nom">Nom</label><br />
       <InputText id="nom" @bind-Value="meal.Name" />
       <ValidationMessage For="@(() => meal.Name)" />
     </div>
     <div class="form-group">
       <label for="description">Description</label><br/>
       <InputTextArea id="description" @bind-Value="meal.Description" />
     </div>
     <div class="form-group">
       <label for="price">Price</label><br />
       <InputNumber id="price" @bind-Value="meal.Price" />
       <ValidationMessage For="@(() => meal.Price)" />
     </div>
 
 
     <button type="submit" class="btn btn-primary">Ajouter</button>
     <button @onclick="BlazoredModal.Cancel" class="btn btn-secondary">Annuler</button>
   </EditForm>
 
@code {
   private string StatusMessage;
   private string StatusClass;
 
   [CascadingParameter] BlazoredModalInstance BlazoredModal { get; set; }
 
   Meal meal = new Meal();
 
 
   private async void FormSubmitted()
   {
     await MealService.InsertMealAsync(meal);
 
     BlazoredModal.Close(ModalResult.Ok<Meal>(meal));
   }
 
}

@page "/editMeal"
@using DemoBlazorServerApp.Data
@inject IModalService ModalService
@inject IMealService MealService
 
   <EditForm Model="@meal" OnValidSubmit=@FormSubmitted>
 
     <DataAnnotationsValidator />
 
     <div class="form-group">
       <label for="nom">Nom</label><br />
       <InputText id="nom" @bind-Value="meal.Name" />
       <ValidationMessage For="@(() => meal.Name)" />
     </div>
     <div class="form-group">
       <label for="description">Description</label><br />
       <InputTextArea id="description" @bind-Value="meal.Description" />
     </div>
     <div class="form-group">
       <label for="price">Price</label><br />
       <InputNumber id="price" @bind-Value="meal.Price" />
       <ValidationMessage For="@(() => meal.Price)" />
     </div>
 
 
     <button type="submit" class="btn btn-primary">Modifier</button>
     <button @onclick="BlazoredModal.Cancel" class="btn btn-secondary">Annuler</button>
   </EditForm>
 
@code {
   [CascadingParameter] BlazoredModalInstance BlazoredModal { get; set; }
 
   Meal meal = new Meal();
   [Parameter] public int id { get; set; }
 
   protected async override void OnInitialized()
   {
     meal = await MealService.GetMealByIdAsync(id);
   }
 
 
   private async void FormSubmitted()
   {
     await MealService.UpdateMealAsync(id, meal);
     BlazoredModal.Close(ModalResult.Ok<Meal>(meal));
   }
}

@inject IMealService MealService
 
   <EditForm Model="@meal" OnSubmit=@FormSubmitted>
 
     Voulez vous vraiment supprimer ?
 
     <button type="submit" class="btn btn-primary">Oui</button>
     <button @onclick="BlazoredModal.Cancel" class="btn btn-secondary">Annuler</button>
   </EditForm>
 
@code {
   [CascadingParameter] BlazoredModalInstance BlazoredModal { get; set; }
 
   Meal meal = new Meal();
   [Parameter] public int id { get; set; }
 
 
   private async void FormSubmitted()
   {
     await MealService.DeleteMealAsync(id);
 
     BlazoredModal.Close(ModalResult.Ok<Meal>(meal));
 
   }
}