public class MessagesModel
    {
        public long Id { get; set; }
        public ApplicationUser UserExp { get; set; }
        public ApplicationUser UserDest { get; set; }
        public Articles Article { get; set; }
 
        public string Message { get; set; }
        public messageStatus Status { get; set; }
        public DateTime Created_at { get; set; }
        public string Topic { get; set; }
        public bool NewMsg { get; set; }
        public bool NewMsg_Exp { get; set; }
        public bool NewMsg_Dest { get; set; }
        public int Offre { get; set; }
        public OfferStatus OffreStatus { get; set; }
 
        public enum messageStatus
        {
            Sent,
            Delivered
        }
        public enum OfferStatus
        {
            None,
            Sent,
            Accepted,
            Denied,
            Cancelled,
            Expired
        }
        public MessagesModel()
        {
            Status = messageStatus.Sent;
            OffreStatus = OfferStatus.None;
        }
    }

 
    constraints: table =>
     {
     	table.PrimaryKey("PK_Messages", x => x.Id);
     	table.ForeignKey(
     		name: "FK_Messages_Articles_ArticleId",
     		column: x => x.ArticleId,
     		principalTable: "Articles",
     		principalColumn: "Id",
     		onDelete: ReferentialAction.Cascade);
     	table.ForeignKey(
     		name: "FK_Messages_AspNetUsers_User_DestId",
     		column: x => x.User_DestId,
     		principalTable: "AspNetUsers",
     		principalColumn: "Id");
     	table.ForeignKey(
     		name: "FK_Messages_AspNetUsers_User_ExpId",
     		column: x => x.User_ExpId,
     		principalTable: "AspNetUsers",
     		principalColumn: "Id");
     });

 
#region --- M E S S A G E S   ---
modelBuilder.Entity<MessagesModel>().HasKey(d => d.Id);
modelBuilder.Entity<MessagesModel>().Property(d => d.Offre).HasDefaultValue(0);
#endregion

 
@model EditUserViewModel
@{
    Layout = null;
}
 
<h2>Modifier un utilisateur</h2>
 
<form asp-action="Edit" id="EditUser" method="post">
    <input type="hidden" asp-for="Id" />
 
    <div class="mb-3">
        <label asp-for="UserName" class="form-label">Nom d'utilisateur</label>
        <input asp-for="UserName" class="form-control" required />
        <span asp-validation-for="UserName" class="text-danger"></span>
    </div>
 
    <div class="mb-3">
        <label asp-for="Email" class="form-label">Email</label>
        <input asp-for="Email" type="email" class="form-control" required />
        <span asp-validation-for="Email" class="text-danger"></span>
    </div>
 
    <div class="mb-3">
        <label class="form-label">Changer le mot de passe (laisser vide pour ne pas modifier)</label>
        <input asp-for="Password" type="password" class="form-control" value=""/>
        <span asp-validation-for="Password" class="text-danger"></span>
    </div>
 
    <div class="mb-3">
        <label asp-for="Pseudo" class="form-label">Pseudo</label>
        <input asp-for="Pseudo" class="form-control" />
        <span asp-validation-for="Pseudo" class="text-danger"></span>
    </div>
 
    <div class="mb-3">
        <label class="form-label">Rôles</label>
        <div>
            @for (int i = 0; i < Model.Roles.Count; i++)
            {
                <div class="form-check">
                    <input type="checkbox" class="form-check-input" asp-for="Roles[i].Selected" />
                    <label class="form-check-label" for="Roles[i].Selected">@Model.Roles[i].RoleName</label>
                    <input type="hidden" asp-for="Roles[i].RoleId" />
                    <input type="hidden" asp-for="Roles[i].RoleName" />
                </div>
            }
        </div>
    </div>
    <button type="submit" class="btn-dark btn-sm" >Enregistrer</button>
    <button type="button" id="btnEditAnnuler_@Model.Id"  onclick="LoadDetailPartialView_USERS()" style="background-color:lightgray">Annuler</button>
</form>
 
@section Scripts {
    <partial name="_ValidationScriptsPartial" />
}

 
        public async Task<IActionResult> Edit(string id)
        {
            var user = await _userManager.FindByIdAsync(id);
            if (user == null) return NotFound();
 
            var userRoles = await _userManager.GetRolesAsync(user);
            var allRoles = _roleManager.Roles.ToList();
 
            var model = new EditUserViewModel
            {
                Id = user.Id,
                UserName = user.UserName,
                Email = user.Email,
                Pseudo = user.Pseudo,
                Roles = allRoles.Select(r => new RoleSelectionViewModel
                {
                    RoleId = r.Id,
                    RoleName = r.Name,
                    Selected = userRoles.Contains(r.Name)
                }).ToList()
            };
 
            return View(model);
        }

 
        function Modif_User(Id) {
            $.ajax({
                url: '@Url.Action("Edit", "Users", new { Area = "Admin" })',
                type: 'GET',
                cache: false,
                data: {id:Id }
            }).done(function (result) {
                    $(PartialUsers).html(result);
            });
        }

 
        $("#Edit").submit(function (e) {
            e.preventDefault();
            var formdata = new FormData(this);
 
            $.ajax({
                url: '@Url.Action("Edit","Users", new { Area = "Admin" })',
                data: formdata,
                method: "post",
                success: function (result) {
                    debugger;
                    if(result.success)
                    {
                        window.location.href = "@Url.Action("Index","Users", new { Area = "Admin" })";
                    }
                },
            });
        });

 
        [HttpPost]
        public async Task<IActionResult> Edit(EditUserViewModel model)
        {
            if (!ModelState.IsValid)
            {
                return Json(new { success = false });
            }
 
            var user = await _userManager.FindByIdAsync(model.Id);
            if (user == null) return Json(new { success = false }); 
 
            user.Email = model.Email;
            user.Pseudo = model.Pseudo;
            if (!string.IsNullOrEmpty(model.Password))
            {
                var token = await _userManager.GeneratePasswordResetTokenAsync(user);
                await _userManager.ResetPasswordAsync(user, token, model.Password);
            }
 
            await _userManager.UpdateAsync(user);
 
            var currentRoles = await _userManager.GetRolesAsync(user);
            var selectedRoles = model.Roles.Where(r => r.Selected).Select(r => r.RoleName).ToList();
 
            await _userManager.RemoveFromRolesAsync(user, currentRoles);
            await _userManager.AddToRolesAsync(user, selectedRoles);
 
            return Json(new { success = true });
        }

 
       const connection = new signalR.HubConnectionBuilder()
           .withUrl("/message")
           .configureLogging(signalR.LogLevel.Information)
           .build();
 
       async function start() {
           try {
                   await connection.start();
               console.log("SignalR Connected.");
           } catch (err) {
               console.log(err);
               setTimeout(start, 10000);
           }
       };
 
       connection.onclose(async () => {
           await start();
       });
 
       start();

 
    public class MSGHub : Hub
    {
         public async Task Send(string User_Exp, string User_Dest, string Topic, string message )
        {
            if(Pageconsultee == "messagerie")
            {
                await Clients.User(User_Dest).SendAsync("ReceiveMessage", User_Exp, User_Dest, Topic, message);
            }
            else
            {
                await Clients.User(User_Dest).SendAsync("NotifMessage");
            }
        }
    }

 
    public class MessagesModel
    {
        public long Id { get; set; }
        public ApplicationUser User_Exp { get; set; }
        public ApplicationUser User_Dest { get; set; }
        public Articles Article { get; set; }
 
        public string Message { get; set; }
        public messageStatus Status { get; set; }
        public DateTime Created_at { get; set; }
        public enum messageStatus
        {
            Sent,
            Delivered
        }
        public MessagesModel()
        {
            Status = messageStatus.Sent;
        }
    }

 
        function getChat() {
            $.ajax({
                url: '@Url.Action("ConversationWithContact", "Messagerie")',
                type: 'GET',
                cache: false,
                data: {articleId:  '@Html.DisplayTextFor(model => model.Id)'},
            })
                .done( function(resp) {
                var chat_data = resp.data || [];
                loadChat( chat_data );
                });
        };

 
        public JsonResult ConversationWithContact(long articleId)
        {
            ApplicationUser currentUser = _repo.GetUser();
            Articles item = _repo.GetArticleByID(articleId);
 
            var conversations = new List<Models.Messages.MessagesModel>();
 
            conversations = _context.Messages.
                                  Where(c => (c.Article.Id == item.Id)
                                  && (c.User_Dest.Id == currentUser.Id ||
                                  c.User_Exp.Id == currentUser.Id))
                                  .OrderBy(c => c.Created_at)
                                  .ToList();
 
            return Json(new { status = "success", data = conversations });
        }

using API.Middleware;
using Core.Interfaces;
using Infrastructure.Data;
 
 
using Microsoft.EntityFrameworkCore;
 
var builder = WebApplication.CreateBuilder(args);
 
// Add services to the container.
 
builder.Services.AddDbContext<StoreContext>(options =>
{
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"));
});
 
 
builder.Services.AddScoped<IProductRepository, ProductRepository>();
builder.Services.AddScoped(typeof(IGenericRepository<>), typeof(GenericRepository<>));
 
// Learn more about configuring OpenAPI at https://aka.ms/aspnet/openapi
// builder.Services.AddOpenApi();
builder.Services.AddControllers(); 
var app = builder.Build();
 
 
app.UseMiddleware<ExceptionMiddleware>();
 
app.UseCors(x => x.AllowAnyHeader().AllowAnyHeader()
.WithOrigins("http://localhost:4200", "https://localhost:4200"));
 
 
 
app.UseCors(); 
 
app.MapControllers();
 
// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.MapOpenApi();
}
 
 
 
try
{
    // using var scope = app.Services.CreateScope();
    // var services = scope.ServiceProvider;
    // var context = services.GetRequiredService<StoreContext>();
 
    // if (!context.Database.CanConnect())
    // { Console.WriteLine("Impossible de se connecter à la base de données"); }
    // await context.Database.MigrateAsync();// Si la Db n'existe pas, elle va la créer
    // await StoreContextSeed.SeedAsync(context);// Peupler la Db avec des données de test
}
 
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
    throw;
}
app.Run();

 "ConnectionStrings": {
   "DefaultConnection": "Server=.\\MSSQLSERVER;Database=Event;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True"
 }