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