public int GetGameSessionId()
{
int id = -1;
if (Session[GameSessionIdKey] != null)
{
return((int)Session[GameSessionIdKey]);
}
using (var db = new SalemEntities())
{
var tomorrow = DateTime.Today.AddDays(1);
var curGameSession = db.GameSessions.FirstOrDefault(x => x.StartTime >= DateTime.Today && x.StartTime < tomorrow);
if (curGameSession == null)
{
curGameSession = new GameSession {
StartTime = DateTime.Now
};
db.GameSessions.Add(curGameSession);
db.SaveChanges();
}
Session[GameSessionIdKey] = curGameSession.Id;
}
return(id);
}
public void SaveResults(string killedPlayer, string savedPlayer)
{
using (var db = new SalemEntities())
{
var roundId = GetRoundId();
var round = db.Rounds.First(x => x.Id == roundId);
round.EndTime = DateTime.Now;
round.KillVote = killedPlayer;
round.SaveVote = savedPlayer;
db.SaveChanges();
}
}
public void StartRound()
{
using (var db = new SalemEntities())
{
var gameSessionId = GetGameSessionId();
var r = new Round
{
GameSessionId = gameSessionId,
StartTime = DateTime.Now,
};
db.Rounds.Add(r);
db.SaveChanges();
Session[RoundKey] = r.Id;
}
}
