public async Task Update(Models.Quete quet)
{
try
{
var context = CreateContext();
int Sv;
Sv = quet.StatuValidId switch
{
StatuValid.redact => Sv = 0,
StatuValid.relecture => Sv = 1,
StatuValid.validation => Sv = 2,
StatuValid.validé => Sv = 3,
_ => Sv = 0,
};
var toUpdate = await context._Quete.FindAsync(quet.Id);
if (toUpdate != null)
{
toUpdate.Id = quet.Id;
toUpdate.TitreQuete = quet.TitreQuete;
toUpdate.ReferentId = quet.ReferentId;
toUpdate.StatuValidId = Sv;
toUpdate.TypoQueteId = quet.TypoQueteId;
toUpdate.ProjetId = quet.ProjetId;
toUpdate.SynopsisQuete = quet.SynopsisQuete;
await context.SaveChangesAsync();
}
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
}
}
public async Task Delete(Models.Quete quet)
{
try
{
var context = CreateContext();
var toDelete = await context._Quete.FindAsync(quet.Id);
if (toDelete != null)
{
context._Quete.Remove(toDelete);
await context.SaveChangesAsync();
}
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
}
}
public async Task <Guid> Create(Models.Quete quet)
{
try
{
var context = CreateContext();
int Sv;
Sv = quet.StatuValidId switch
{
StatuValid.redact => Sv = 0,
StatuValid.relecture => Sv = 1,
StatuValid.validation => Sv = 2,
StatuValid.validé => Sv = 3,
_ => Sv = 0,
};
var created = new Data.Quete
{
Id = quet.Id,
TitreQuete = quet.TitreQuete,
ReferentId = quet.ReferentId,
StatuValidId = Sv,
TypoQueteId = quet.TypoQueteId,
ProjetId = quet.ProjetId,
SynopsisQuete = quet.SynopsisQuete,
};
var enr = await context
._Quete
.AddAsync(created);
await context.SaveChangesAsync();
return(enr.Entity.Id);
}
catch (DbUpdateException e)
{
Console.WriteLine(e.Message);
return(quet.Id);
}
}
