{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "ConnectionString_1": "Server=ServeurLocal;Database=BaseLocale;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True",
    "ConnectionString_2": "Server=ServeurDistant;Database=BaserDistante;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True"
  }
}

 
public partial class Context1 : DbContext
{
    public Context1 (DbContextOptions<Context1> options)
        : base(options)
    {
    }
 
    public virtual DbSet<model1> models1{ get; set; }
    ....

 
public partial class Context2 : DbContext
{
    public Context2  (DbContextOptions<Context2> options)
        : base(options)
    {
    }
 
    public virtual DbSet<model2> models2{ get; set; }
    ....

 
var ConnectionString1= builder.Configuration.GetConnectionString("ConnectionString_1") ?? throw new InvalidOperationException("La connexion au serveru n'a pas été établie.");
builder.Services.AddDbContext<Context1>(options =>
    options.UseSqlServer(ConnectionString_1));
 
var ConnectionString2= builder.Configuration.GetConnectionString("ConnectionString_2") ?? throw new InvalidOperationException("La connexion au serveru de trading n'a pas été établie.");
builder.Services.AddDbContext<Context2>(options =>
    options.UseSqlServer(ConnectionString_2));

  public async Task<ActionResult> Index()
  {
       var liste= await _context2.model2.FromSqlRaw("EXEC procedure").ToListAsync();
 
      return View();
  }

public async Task<ActionResult> Edit(int? id)
{
    if (id == null)
    {
        return NotFound();
    }
 
    var SearchOperation = await _context.Operations.FromSqlRaw("EXEC dbo.affiche_operations").ToListAsync();
    var listOperations = SearchOperation.FirstOrDefault(x => x.numero_operation == id);
 
    if (listOperations == null)
    {
        return NotFound();
    }
 
    var listeNatureOperation = await _context.NatureOperations.ToListAsync();
    ViewBag.lib_nature= new SelectList(listeNatureOperation, "CodeNature", "LibNature", selectedValue: listOperations.lib_nature);
 
    var listEmetteur = await _context.Emetteurs.ToListAsync();
    ViewBag.Emetteur = new SelectList(listEmetteur, "CodeEmetteur", "raison_sociale", selectedValue: listOperations.CodeEmetteur);
 
      return View(listOperations);
}

<form asp-action="Edit">
    <div asp-validation-summary="ModelOnly" class="text-danger"></div>
    <input type="hidden" asp-for="numero_operation" />
    <div class="form-group">
        <label asp-for="CodeEmetteur" class="control-label"></label>
        <select asp-for="CodeEmetteur" asp-items="@ViewBag.Emetteur" class="form-control">
            <option value="">-- Selectionner émetteur --</option>
        </select>
        <span asp-validation-for="CodeEmetteur" class="text-danger"></span>
    </div>
    <div class="form-group">
        <label asp-for="lib_nature" class="control-label"></label>
        <select asp-for="lib_nature" asp-items="@ViewBag.lib_nature" class="form-control">
            <option value="">-- Selectionner le type --</option>
        </select>
        <span asp-validation-for="lib_nature" class="text-danger"></span>
    </div>
</form>

public partial class Operation
{
    [Display(Name = "Code émetteur")]
    [Required]
    public int CodeEmetteur { get; set; }
 
    [Display(Name = "Numéro opération")]
    public int NumeroOperation { get; set; }
 
    [Display(Name = "Code nature opération")]
    [Required]
    public int CodeNature { get; set; }
 
    [Display(Name = "Observation")]
    public string Observations { get; set; }
 
    [Display(Name = "Date d'enregistrement")]
    public DateTime? DateEnregistrement { get; set; }
 
    [Display(Name = "Date de diffusion")]
    public DateTime? DateDebutDiffusion { get; set; }
 
    [Display(Name = "Date de fin de diffusion")]
    public DateTime? DateFinDiffusion { get; set; }
 
    [Display(Name = "Document joint")]
    public string Document { get; set; }
 
    [NotMapped]
    public IEnumerable<SelectListItem> NatureOperation { get; set; }
 
    [NotMapped]
    public IEnumerable<SelectListItem> Emetteur { get; set; }
}

public class PaginationViewModel<T> : List<T>
{
    public int TotalItems { get; set; }
    public int PageActive { get; set; }
    public int NbreParPage { get; set; }
    public int TotalPage { get; set; }
    public int DebutPage { get; set; }
    public int FinPage { get; set; }
 
    public PaginationViewModel(List<T> items, int count, int pageIndex, int pageSize)
    {
        TotalItems = count;
        PageActive = pageIndex;
        NbreParPage = pageSize;
        TotalPage = (int)Math.Ceiling(count / (double)NbreParPage);
        DebutPage = pageIndex - 5;
        FinPage = pageIndex + 4;
 
        if (DebutPage <= 0)
        {
            FinPage = FinPage - (DebutPage - 1);
            DebutPage = 1;
        }
        if (FinPage > TotalPage)
        {
            FinPage = TotalPage;
            if (FinPage > 10)
            {
                DebutPage = FinPage - 9;
            }
        }
        this.AddRange(items);
    }
 
    public bool PrecDesactive => PageActive > 1;
    public bool SuivDesactive => PageActive < TotalPage;
 
    public static PaginationViewModel<T> Create(List<T> source, int pageIndex, int pageSize) 
    {
        var count = source.Count;
        var items = source.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
        return new PaginationViewModel<T>(items, count, pageIndex, pageSize);
    }
}

public ActionResult Index(int NumPage)
{
    int NbreParPage = 10;
    //On réinitialise le numéro de page à 1 si le numéro est égal ou inférieru à 1
    if (NumPage < 1)
        NumPage = 1;
 
    var operations = _context.Operations
        .Include(o => o.NatureOperation)
        .Include(o => o.Emetteur)
        .ToList();
 
    return View(PaginationViewModel<Operation>.Create(operations, NumPage, NbreParPage));
}

 
@model BOCNEW_2025.Models.PaginationViewModel<BOCNEW_2025.Models.Operation>
@foreach (var item in Model) {
<tr>
    <td class="col-1" style="width:5%; text-align:right;">
            @Html.DisplayFor(modeltem => item.CodeEmetteur)
    </td>
    <td class="col-1" style="width:5%; text-align:right;">
            @Html.DisplayFor(modelItem => item.Emetteur)
    </td>
     <td class="col-3" style="width:3%; text-align:right;">
            @Html.DisplayFor(modelItem => item.CodeNature)
    </td>
        <td class="col-4" style="width:15%">
            @Html.DisplayFor(modelItem => item.DateDebutDiffusion)
    </td>
        <td style="width:15%">
            @Html.DisplayFor(modelItem => item.DateFinDiffusion)
    </td>
        <td style="width:30%">
            @Html.DisplayFor(modelItem => item.Observations)
        </td>
        <td style="width:15%">
        <button type="button" class="btn btn-primary"><a asp-action="Edit" asp-route-id="@item.NatureOperation" class="text-white">Modifier</a></button>
        <button type="button" class="btn btn-danger"><a asp-action="Delete" asp-route-id="@item.NatureOperation" class="text-white">Supprimer</a></button>
    </td>
</tr>
}