Implicit insert

D

DAMINKO•5/9/24, 3:44 PM

message.txt16.13KB

D

DAMINKO•5/9/24, 3:44 PM

this is the exception I get ^

D

deprecatio•5/9/24, 6:10 PM

an error duplicate key makes me think you are writing nested object which should have been removed and that are already in the db

Ddeprecatio an error duplicate key makes me think you are writing nested object which should...

D

DAMINKO•5/9/24, 6:51 PM

what should I do in this case?

K

Keswiik•5/9/24, 6:52 PM

Does it tell you what field contains the duplicate key?

K

Keswiik•5/9/24, 6:52 PM

oh, didn't see the expand button on that error log

K

Keswiik•5/9/24, 6:52 PM

let me read

K

Keswiik•5/9/24, 6:55 PM

@daminko what does your voyage entity look like?

KKeswiik @daminko what does your voyage entity look like?

D

DAMINKO•5/9/24, 6:57 PM

public class Voyage
    {
        [Key]
        public string IdVoyage { get; set; } = string.Empty;
        public DateTime DateSortieBon { get; set; }
        public DateTime DateDepartVoyage { get; set; }

        public string Etat { get; set; } = string.Empty;
        public double Poids { get; set; }
        public int NbrePalette { get; set; }

        //Demandeur
        public Demandeur? Demandeur { get; set; } = null!;
        public string? DemandeurMatriculeSopal { get; set; } = string.Empty;
        [Column(TypeName = "decimal(30, 25)")]
        public decimal Priorite { get; set; }
        public Magasinier? MagasinierDemandeur { get; set; } = null!;
        public string? MagasinierDemandeurMatriculeSopal { get; set; } = string.Empty;
        public Magasinier Magasinier { get; set; } = null!;
        public string MagasinierMatriculeSopal { get; set; } = string.Empty;
        public TypeVoyage TypeVoyage { get; set; } = null!;
        public int TypeVoyageId { get; set; }
        public List<Transporteur> Transporteurs { get; set; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
    }

public class Voyage
    {
        [Key]
        public string IdVoyage { get; set; } = string.Empty;
        public DateTime DateSortieBon { get; set; }
        public DateTime DateDepartVoyage { get; set; }

        public string Etat { get; set; } = string.Empty;
        public double Poids { get; set; }
        public int NbrePalette { get; set; }

        //Demandeur
        public Demandeur? Demandeur { get; set; } = null!;
        public string? DemandeurMatriculeSopal { get; set; } = string.Empty;
        [Column(TypeName = "decimal(30, 25)")]
        public decimal Priorite { get; set; }
        public Magasinier? MagasinierDemandeur { get; set; } = null!;
        public string? MagasinierDemandeurMatriculeSopal { get; set; } = string.Empty;
        public Magasinier Magasinier { get; set; } = null!;
        public string MagasinierMatriculeSopal { get; set; } = string.Empty;
        public TypeVoyage TypeVoyage { get; set; } = null!;
        public int TypeVoyageId { get; set; }
        public List<Transporteur> Transporteurs { get; set; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
    }

public class Voyage
    {
        [Key]
        public string IdVoyage { get; set; } = string.Empty;
        public DateTime DateSortieBon { get; set; }
        public DateTime DateDepartVoyage { get; set; }

        public string Etat { get; set; } = string.Empty;
        public double Poids { get; set; }
        public int NbrePalette { get; set; }

        //Demandeur
        public Demandeur? Demandeur { get; set; } = null!;
        public string? DemandeurMatriculeSopal { get; set; } = string.Empty;
        [Column(TypeName = "decimal(30, 25)")]
        public decimal Priorite { get; set; }
        public Magasinier? MagasinierDemandeur { get; set; } = null!;
        public string? MagasinierDemandeurMatriculeSopal { get; set; } = string.Empty;
        public Magasinier Magasinier { get; set; } = null!;
        public string MagasinierMatriculeSopal { get; set; } = string.Empty;
        public TypeVoyage TypeVoyage { get; set; } = null!;
        public int TypeVoyageId { get; set; }
        public List<Transporteur> Transporteurs { get; set; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
    }

public class Voyage
    {
        [Key]
        public string IdVoyage { get; set; } = string.Empty;
        public DateTime DateSortieBon { get; set; }
        public DateTime DateDepartVoyage { get; set; }

        public string Etat { get; set; } = string.Empty;
        public double Poids { get; set; }
        public int NbrePalette { get; set; }

        //Demandeur
        public Demandeur? Demandeur { get; set; } = null!;
        public string? DemandeurMatriculeSopal { get; set; } = string.Empty;
        [Column(TypeName = "decimal(30, 25)")]
        public decimal Priorite { get; set; }
        public Magasinier? MagasinierDemandeur { get; set; } = null!;
        public string? MagasinierDemandeurMatriculeSopal { get; set; } = string.Empty;
        public Magasinier Magasinier { get; set; } = null!;
        public string MagasinierMatriculeSopal { get; set; } = string.Empty;
        public TypeVoyage TypeVoyage { get; set; } = null!;
        public int TypeVoyageId { get; set; }
        public List<Transporteur> Transporteurs { get; set; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
    }

K

Keswiik•5/9/24, 7:00 PM

show your voyage repo as well

KKeswiik show your voyage repo as well

D

DAMINKO•5/9/24, 7:01 PM

public class VoyageRepo : IVoyageRepo
    {
        private readonly ApplicationDBContext _context;
        public VoyageRepo(ApplicationDBContext context)
        {
            _context = context;
        }

        public async Task<Voyage> Create(Voyage voyage)
        {
            await _context.Voyage.AddAsync(voyage);
            await _context.SaveChangesAsync();
            return voyage;
        }

        public async Task<List<Voyage>> GetAll(string? transporteurId, string? magasinierId, string? demandeurId)
        {
            IQueryable<Voyage> query = _context.Voyage.Include(voyage => voyage.Transporteurs);

            if (transporteurId != null)
            {
                query = query.Where(voyage => voyage.Transporteurs.Any(t => t.UserId == transporteurId));
            }

            if (magasinierId != null)
            {
                query = query.Where(voyage => voyage.MagasinierMatriculeSopal == magasinierId);
            }
            if (demandeurId != null)
            {
                query = query.Where(voyage => voyage.DemandeurMatriculeSopal == demandeurId);
            }


            return await query.ToListAsync();
        }

        public Voyage GetVoyageById(int id)
        {
            throw new NotImplementedException();
        }

        public Voyage Update(Voyage voyage)
        {
            throw new NotImplementedException();
        }
    }

public class VoyageRepo : IVoyageRepo
    {
        private readonly ApplicationDBContext _context;
        public VoyageRepo(ApplicationDBContext context)
        {
            _context = context;
        }

        public async Task<Voyage> Create(Voyage voyage)
        {
            await _context.Voyage.AddAsync(voyage);
            await _context.SaveChangesAsync();
            return voyage;
        }

        public async Task<List<Voyage>> GetAll(string? transporteurId, string? magasinierId, string? demandeurId)
        {
            IQueryable<Voyage> query = _context.Voyage.Include(voyage => voyage.Transporteurs);

            if (transporteurId != null)
            {
                query = query.Where(voyage => voyage.Transporteurs.Any(t => t.UserId == transporteurId));
            }

            if (magasinierId != null)
            {
                query = query.Where(voyage => voyage.MagasinierMatriculeSopal == magasinierId);
            }
            if (demandeurId != null)
            {
                query = query.Where(voyage => voyage.DemandeurMatriculeSopal == demandeurId);
            }


            return await query.ToListAsync();
        }

        public Voyage GetVoyageById(int id)
        {
            throw new NotImplementedException();
        }

        public Voyage Update(Voyage voyage)
        {
            throw new NotImplementedException();
        }
    }

public class VoyageRepo : IVoyageRepo
    {
        private readonly ApplicationDBContext _context;
        public VoyageRepo(ApplicationDBContext context)
        {
            _context = context;
        }

        public async Task<Voyage> Create(Voyage voyage)
        {
            await _context.Voyage.AddAsync(voyage);
            await _context.SaveChangesAsync();
            return voyage;
        }

        public async Task<List<Voyage>> GetAll(string? transporteurId, string? magasinierId, string? demandeurId)
        {
            IQueryable<Voyage> query = _context.Voyage.Include(voyage => voyage.Transporteurs);

            if (transporteurId != null)
            {
                query = query.Where(voyage => voyage.Transporteurs.Any(t => t.UserId == transporteurId));
            }

            if (magasinierId != null)
            {
                query = query.Where(voyage => voyage.MagasinierMatriculeSopal == magasinierId);
            }
            if (demandeurId != null)
            {
                query = query.Where(voyage => voyage.DemandeurMatriculeSopal == demandeurId);
            }


            return await query.ToListAsync();
        }

        public Voyage GetVoyageById(int id)
        {
            throw new NotImplementedException();
        }

        public Voyage Update(Voyage voyage)
        {
            throw new NotImplementedException();
        }
    }

public class VoyageRepo : IVoyageRepo
    {
        private readonly ApplicationDBContext _context;
        public VoyageRepo(ApplicationDBContext context)
        {
            _context = context;
        }

        public async Task<Voyage> Create(Voyage voyage)
        {
            await _context.Voyage.AddAsync(voyage);
            await _context.SaveChangesAsync();
            return voyage;
        }

        public async Task<List<Voyage>> GetAll(string? transporteurId, string? magasinierId, string? demandeurId)
        {
            IQueryable<Voyage> query = _context.Voyage.Include(voyage => voyage.Transporteurs);

            if (transporteurId != null)
            {
                query = query.Where(voyage => voyage.Transporteurs.Any(t => t.UserId == transporteurId));
            }

            if (magasinierId != null)
            {
                query = query.Where(voyage => voyage.MagasinierMatriculeSopal == magasinierId);
            }
            if (demandeurId != null)
            {
                query = query.Where(voyage => voyage.DemandeurMatriculeSopal == demandeurId);
            }


            return await query.ToListAsync();
        }

        public Voyage GetVoyageById(int id)
        {
            throw new NotImplementedException();
        }

        public Voyage Update(Voyage voyage)
        {
            throw new NotImplementedException();
        }
    }

K

Keswiik•5/9/24, 7:02 PM

pls code format that

D

DAMINKO•5/9/24, 7:02 PM

sure sorry

K

Keswiik•5/9/24, 7:02 PM

ty

KKeswiik ty

D

DAMINKO•5/9/24, 7:02 PM

np

K

Keswiik•5/9/24, 7:03 PM

Is

Transporteur

Transporteur

Transporteur

Transporteur the entity that references ASP users?

KKeswiik Is `Transporteur` the entity that references ASP users?

D

DAMINKO•5/9/24, 7:03 PM

public class Transporteur
    {
        [Key]
        public string UserId { get; set; } = string.Empty;
        public Utilisateur Utilisateur { get; set; } = null!;
        public Vehicule? Vehicule { get; set; }
        public string? VehiculeMatricule { get; set; } = string.Empty;
        public bool ExterneDuService { get; set; } = false;
        public List<Voyage> Voyages { get; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
        public Localisation? Localisation { get; set; } = null;
        public int? LocalisationId { get; set; }
        public bool Active { get; set; } = true;
    }

public class Transporteur
    {
        [Key]
        public string UserId { get; set; } = string.Empty;
        public Utilisateur Utilisateur { get; set; } = null!;
        public Vehicule? Vehicule { get; set; }
        public string? VehiculeMatricule { get; set; } = string.Empty;
        public bool ExterneDuService { get; set; } = false;
        public List<Voyage> Voyages { get; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
        public Localisation? Localisation { get; set; } = null;
        public int? LocalisationId { get; set; }
        public bool Active { get; set; } = true;
    }

public class Transporteur
    {
        [Key]
        public string UserId { get; set; } = string.Empty;
        public Utilisateur Utilisateur { get; set; } = null!;
        public Vehicule? Vehicule { get; set; }
        public string? VehiculeMatricule { get; set; } = string.Empty;
        public bool ExterneDuService { get; set; } = false;
        public List<Voyage> Voyages { get; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
        public Localisation? Localisation { get; set; } = null;
        public int? LocalisationId { get; set; }
        public bool Active { get; set; } = true;
    }

public class Transporteur
    {
        [Key]
        public string UserId { get; set; } = string.Empty;
        public Utilisateur Utilisateur { get; set; } = null!;
        public Vehicule? Vehicule { get; set; }
        public string? VehiculeMatricule { get; set; } = string.Empty;
        public bool ExterneDuService { get; set; } = false;
        public List<Voyage> Voyages { get; } = [];
        public ICollection<TransporteurVoyage> TransporteurVoyages { get; } = [];
        public Localisation? Localisation { get; set; } = null;
        public int? LocalisationId { get; set; }
        public bool Active { get; set; } = true;
    }

D

DAMINKO•5/9/24, 7:04 PM

    public class Utilisateur : IdentityUser
    {
        public string MatriculeSopal { get; set; } = string.Empty;
        public string Nom { get; set; } = string.Empty;
        public string Prenom { get; set; } = string.Empty;

    }

    public class Utilisateur : IdentityUser
    {
        public string MatriculeSopal { get; set; } = string.Empty;
        public string Nom { get; set; } = string.Empty;
        public string Prenom { get; set; } = string.Empty;

    }

    public class Utilisateur : IdentityUser
    {
        public string MatriculeSopal { get; set; } = string.Empty;
        public string Nom { get; set; } = string.Empty;
        public string Prenom { get; set; } = string.Empty;

    }

    public class Utilisateur : IdentityUser
    {
        public string MatriculeSopal { get; set; } = string.Empty;
        public string Nom { get; set; } = string.Empty;
        public string Prenom { get; set; } = string.Empty;

    }

K

Keswiik•5/9/24, 7:05 PM

ok, and are you trying to create a new voyage for an existing user?

D

DAMINKO•5/9/24, 7:05 PM

yep

D

DAMINKO•5/9/24, 7:05 PM

existing users

D

DAMINKO•5/9/24, 7:06 PM

the transporteur, and two magasiniers or the transporteur, and a magasinier and also a demandeur

K

Keswiik•5/9/24, 7:08 PM

normally to avoid stuff like this I have an explicit foreign key property for my navigations

DDAMINKO ```csharp public class Voyage { [Key] public string IdVoyage...

D

DAMINKO•5/9/24, 7:08 PM

I've already done this, no?

K

Keswiik•5/9/24, 7:09 PM

but I'd try setting

Utilisateur

Utilisateur

Utilisateur

Utilisateur to something that's like

something.Utilisateur = new Utilisateur {
  WhateverYourPrimaryKeyIs = existingUser.WhateverYourPrimaryKeyIs
}

something.Utilisateur = new Utilisateur {
  WhateverYourPrimaryKeyIs = existingUser.WhateverYourPrimaryKeyIs
}

something.Utilisateur = new Utilisateur {
  WhateverYourPrimaryKeyIs = existingUser.WhateverYourPrimaryKeyIs
}

something.Utilisateur = new Utilisateur {
  WhateverYourPrimaryKeyIs = existingUser.WhateverYourPrimaryKeyIs
}

K

Keswiik•5/9/24, 7:09 PM

I didn't see one for Utilisateur (which I think is what's causing your current error)

D

DAMINKO•5/9/24, 7:09 PM

ow

D

DAMINKO•5/9/24, 7:09 PM

OWWWW

D

DAMINKO•5/9/24, 7:09 PM

I c

K

Keswiik•5/9/24, 7:09 PM

so what's happening is that EF sees it as a NEW user and is trying to add a new row to the DB

K

Keswiik•5/9/24, 7:10 PM

rather than just setting the foreign key column on the new Transporteur row

D

DAMINKO•5/9/24, 7:10 PM

so it's not binded?
cuz when creating a transporteur I create at the sametime a utilisateur

DDAMINKO so it's not binded? cuz when creating a transporteur I create at the sametime a ...

K

Keswiik•5/9/24, 7:11 PM

not sure what you mean by binded in this case

D

DAMINKO•5/9/24, 7:12 PM

I mean when I get the send a create query to the db I send two queries the first creates an utilisateur and the second creates a transporteur

D

DAMINKO•5/9/24, 7:12 PM

KKeswiik not sure what you mean by binded in this case

D

DAMINKO•5/9/24, 7:12 PM

this is how i'm doing

K

Keswiik•5/9/24, 7:13 PM

what does that

CreateUtilisateur

CreateUtilisateur

CreateUtilisateur

CreateUtilisateur method look like?

D

DAMINKO•5/9/24, 7:16 PM

Sec

KKeswiik what does that `CreateUtilisateur` method look like?

D

DAMINKO•5/9/24, 7:17 PM

public async Task<IdentityResult> CreateAsync(Utilisateur utilisateur)
        {
            return await _userManager.CreateAsync(utilisateur);

        }

public async Task<IdentityResult> CreateAsync(Utilisateur utilisateur)
        {
            return await _userManager.CreateAsync(utilisateur);

        }

public async Task<IdentityResult> CreateAsync(Utilisateur utilisateur)
        {
            return await _userManager.CreateAsync(utilisateur);

        }

public async Task<IdentityResult> CreateAsync(Utilisateur utilisateur)
        {
            return await _userManager.CreateAsync(utilisateur);

        }

K

Keswiik•5/9/24, 7:17 PM

show the user manager code too

K

Keswiik•5/9/24, 7:18 PM

my guess is you're creating this with a different dbcontext instance that is disposed of, so the original entity is no longer being tracked

K

Keswiik•5/9/24, 7:18 PM

but again that's just a guess

KKeswiik but again that's just a guess

D

DAMINKO•5/9/24, 7:30 PM

aight thanks

Implicit insert

Similar Threads

Similar Threads

Similar Threads