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