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