public async Task <Guid> Create(Models.CompetencesPJ compPJ) { try { var context = CreateContext(); var created = new Data.CompetencesPJ { PJId = compPJ.PJId, CompetenceId = compPJ.CompetenceId, CompVal = compPJ.CompVal, Id = compPJ.Id, }; var enr = await context ._CompetencesPJ .AddAsync(created); await context.SaveChangesAsync(); return(enr.Entity.Id); } catch (DbUpdateException e) { Console.WriteLine(e.Message); return(compPJ.Id); } }
public async Task Delete(Models.CompetencesPJ compPJ) { try { var context = CreateContext(); var toDelete = await context._CompetencesPJ.FindAsync(compPJ.Id); if (toDelete != null) { context._CompetencesPJ.Remove(toDelete); await context.SaveChangesAsync(); } } catch (DbUpdateException e) { Console.WriteLine(e.Message); } }
public async Task Update(Models.CompetencesPJ compPJ) { try { var context = CreateContext(); var toUpdate = await context._CompetencesPJ.FindAsync(compPJ.Id); if (toUpdate != null) { toUpdate.PJId = compPJ.PJId; toUpdate.CompetenceId = compPJ.CompetenceId; toUpdate.CompVal = compPJ.CompVal; toUpdate.Id = compPJ.Id; await context.SaveChangesAsync(); } } catch (DbUpdateException e) { Console.WriteLine(e.Message); } }