private static bool IsExist() { using (PlayersDBEntities db = new PlayersDBEntities()) { var query = from p in db.BattlePlayer where p.Name == Form1.playerName select p; int Win = 0; int Defeat = 0; int rating = 0; if (query.Count() != 0) { foreach (var q in query) { Win = (int)q.WinAmount + countWin; Defeat = (int)q.DefeatAmount + countDefeat; if (Defeat == 0) { rating = Win; } else { rating = Win / Defeat; } q.WinAmount = Win; q.DefeatAmount = Defeat; q.Rating = rating; } db.SaveChanges(); return(true); } return(false); } }
private static void SaveResult() { using (PlayersDBEntities db = new PlayersDBEntities()) { if (!IsExist()) { BattlePlayer player = new BattlePlayer() { Name = Form1.playerName, WinAmount = countWin, DefeatAmount = countDefeat, }; if (countDefeat == 0) { player.Rating = (double)countWin; } else { player.Rating = (double)(countWin / countDefeat); } db.BattlePlayer.Add(player); db.SaveChanges(); } } }