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