public async Task <IActionResult> PutComment([FromRoute] int id, [FromBody] Comment comment) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != comment.Id) { return(BadRequest()); } _context.Entry(comment).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CommentExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutPersonas3(int id, [FromBody] Personas3 personas3) { if (id != personas3.Id) { return(BadRequest()); } _context.Entry(personas3).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Personas3Exists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutUsuarios2(int id, [FromBody] Usuarios2 usuarios2) { if (id != usuarios2.Id) { return(BadRequest()); } _context.Entry(usuarios2).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Usuarios2Exists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutRideMetric(int id, RideMetric rideMetric) { if (id != rideMetric.Id) { return(BadRequest()); } _context.Entry(rideMetric).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RideMetricExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Publisher> > GetPublisherDetails(int id) { ////Eager Loading //var publisher = _context.Publishers // .Include(pub=>pub.Books) // .ThenInclude(book=> book.Sales) // .Include(pub => pub.Users) // .Where(pub => pub.PubId == id).FirstOrDefault(); //Explicit Loading var publisher = await _context.Publishers.SingleAsync(publisher => publisher.PubId == id); _context.Entry(publisher) .Collection(pub => pub.Users) .Query() .Where(user => user.EmailAddress.Contains("Karin")) .Load(); _context.Entry(publisher) .Collection(pub => pub.Books) .Query() .Include(book => book.Sales) .Load(); var user = await _context.Users.SingleAsync(usr => usr.UserId == 1); _context.Entry(user) .Reference(usr => usr.Role) .Load(); if (publisher == null) { return(NotFound()); } return(publisher); }
public void setNewScore(string winner) { TblScores oldScore = db.TblScores.FirstOrDefault(x => x.PlayerName == winner); if (oldScore != null) { oldScore.GamesWon++; try { db.Entry(oldScore).State = EntityState.Modified; _logger.LogInformation("If a player with the same name existed the corresponding record is updated instead of creating a new one"); db.SaveChanges(); } catch (Exception ex) { _logger.LogError("Exception happened:" + ex.Message, ex); throw; } } else { TblScores newScore = new TblScores(); newScore.PlayerName = winner; newScore.GamesWon = 1; try { db.Add(newScore); db.SaveChanges(); _logger.LogInformation("if the player name didn't existed the score is a new record."); } catch (Exception ex) { _logger.LogError("Exception happened:" + ex.Message, ex); throw; } } try { db.Database.ExecuteSqlCommand("TRUNCATE TABLE [tblrounds]"); _logger.LogInformation("Table rounds truncated to start a new game"); } catch (Exception ex) { _logger.LogError("Exception happened:" + ex.Message, ex); throw; } }
public int saveRound(TblRounds round) { try { db.Entry(round).State = EntityState.Modified; db.SaveChanges(); _logger.LogInformation("Saved changes to round in progress."); return(round.RoundId); } catch (Exception ex) { _logger.LogError("Exception happened:" + ex.Message, ex); throw; } }
public async Task <IActionResult> PutArticle([FromRoute] int id, [FromBody] Article article) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Article tempArticle = await _context.Article.FindAsync(id); tempArticle.Id = id; tempArticle.Title = article.Title; tempArticle.ContentMain = article.ContentMain; tempArticle.ContentSummary = article.ContentSummary; tempArticle.CategoryId = article.Category.Id; tempArticle.Picture = article.Picture; _context.Entry(tempArticle).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ArticleExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }