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); } }