public void DelBuzzFizz(int n) { var BuzzFizzQuerry = (from BuzzFizz in _context.BuzzFizz where BuzzFizz.Id == n && BuzzFizz.historical == false orderby BuzzFizz.date descending select BuzzFizz).FirstOrDefault(); if (BuzzFizzQuerry != null) { _context.BuzzFizz.Remove(BuzzFizzQuerry); _context.SaveChanges(); } }
public void AddBuzzFizz(BuzzFizz buzzFizz) { var BuzzFizzQuerry = (from BuzzFizz in _context.BuzzFizz where BuzzFizz.historical == false orderby BuzzFizz.date descending select BuzzFizz).Take(10); int amount = BuzzFizzQuerry.Count(); if (amount >= 10) { var BuzzFizzLast = BuzzFizzQuerry.LastOrDefault(); if (BuzzFizzLast != null) { BuzzFizzLast.historical = true; } } _context.BuzzFizz.Add(buzzFizz); _context.SaveChanges(); }