public async Task <Guid> Create(Models.ObjetsQuete objeQt)
{
try
{
var context = CreateContext();
int Sv;
Sv = objeQt.StatuValidId switch
{
StatuValid.redact => Sv = 0,
StatuValid.relecture => Sv = 1,
StatuValid.validation => Sv = 2,
StatuValid.validé => Sv = 3,
_ => Sv = 0,
};
var created = new Data.ObjetsQuete
{
Id = objeQt.Id,
QueteId = objeQt.QueteId,
NomObjet = objeQt.NomObjet,
PrezObjet = objeQt.PrezObjet,
SituationDebJeu = objeQt.SituationDebJeu,
Effet = objeQt.Effet,
Image = objeQt.Image,
PPLieId = objeQt.PPLieId,
StatuValidId = Sv,
StockId = objeQt.StockId,
ExisteDeja = objeQt.ExisteDeja,
EstDisponible = objeQt.EstDisponible,
EstDemande = objeQt.EstDemande,
DemandeResaOK = objeQt.DemandeResaOK,
};
var enr = await context
._ObjetsQuete
.AddAsync(created);
await context.SaveChangesAsync();
return(enr.Entity.Id);
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
return(objeQt.Id);
}
}
public async Task Delete(Models.ObjetsQuete objeQt)
{
try
{
var context = CreateContext();
var toDelete = await context._ObjetsQuete.FindAsync(objeQt.Id);
if (toDelete != null)
{
context._ObjetsQuete.Remove(toDelete);
await context.SaveChangesAsync();
}
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
}
}
public async Task Update(Models.ObjetsQuete objeQt)
{
try
{
var context = CreateContext();
int Sv;
Sv = objeQt.StatuValidId switch
{
StatuValid.redact => Sv = 0,
StatuValid.relecture => Sv = 1,
StatuValid.validation => Sv = 2,
StatuValid.validé => Sv = 3,
_ => Sv = 0,
};
var toUpdate = await context._ObjetsQuete.FindAsync(objeQt.Id);
if (toUpdate != null)
{
toUpdate.Id = objeQt.Id;
toUpdate.QueteId = objeQt.QueteId;
toUpdate.NomObjet = objeQt.NomObjet;
toUpdate.PrezObjet = objeQt.PrezObjet;
toUpdate.SituationDebJeu = objeQt.SituationDebJeu;
toUpdate.Effet = objeQt.Effet;
toUpdate.Image = objeQt.Image;
toUpdate.PPLieId = objeQt.PPLieId;
toUpdate.StatuValidId = Sv;
toUpdate.StockId = objeQt.StockId;
toUpdate.ExisteDeja = objeQt.ExisteDeja;
toUpdate.EstDisponible = objeQt.EstDisponible;
toUpdate.EstDemande = objeQt.EstDemande;
toUpdate.DemandeResaOK = objeQt.DemandeResaOK;
await context.SaveChangesAsync();
}
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
}
}
