static private void UpdateDBTopBool(int id) { using (var context = new PWS_NamesContext()) { var item = context.Names.First(f => f.NameId == id); item.TopBool = true; item.TopCount++; context.SaveChanges(); } }
static void SetTournamentWinner(List <Names> names) { Console.Clear(); Console.WriteLine($"\nFull Name List"); PrintNameList(names); Console.ForegroundColor = ConsoleColor.Cyan; Console.Write("\n\nEnter PlayerID of the record that you want to update.\n\n"); Console.ResetColor(); bool validId = false; int value = 0; do { value = GetInputInt(); if (value >= 1 && value <= 60) { Console.WriteLine(); Console.WriteLine(); Console.BackgroundColor = ConsoleColor.White; Console.ForegroundColor = ConsoleColor.Red; Console.Write("Updating the database..."); Console.ResetColor(); Console.ResetColor(); Console.WriteLine(); validId = true; } else { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\n\nInvalid PlayerID. Please try again.\n\n"); Console.ResetColor(); validId = false; } } while (!validId); using (var context = new PWS_NamesContext()) { var item = context.Names.First(f => f.NameId == value); item.Wins++; item.DateWin = DateTime.Now; context.WinHistory.Add(new WinHistory { NameId = item.NameId, WinDate = item.DateWin }); context.SaveChanges(); Console.WriteLine(); Console.BackgroundColor = ConsoleColor.White; Console.ForegroundColor = ConsoleColor.Red; Console.Write($"{item.Name}'s win count has been updated!"); Console.ResetColor(); Console.ResetColor(); Console.WriteLine(); Console.WriteLine(); Console.BackgroundColor = ConsoleColor.White; Console.ForegroundColor = ConsoleColor.Red; Console.Write($"History table has been updated"); Console.ResetColor(); Console.ResetColor(); Thread.Sleep(1000); Console.WriteLine(); PrintPlayerWins(item); Console.ResetColor(); } }