public static GameResults InsertGameResult(String UserName, String Password, GameListEnum gameType, int Score, decimal TestDuration, int Total)
{
GameResults results = new GameResults();
try
{
LoginResult loginResult = LoginResult.ValidateLogin(UserName, Password, String.Empty);
if (loginResult.Success)
{
AgileMindEntities db = new AgileMindEntities();
t_GameResults gameResults = new t_GameResults();
gameResults.Created = DateTime.Now;
gameResults.GameId = (int)gameType;
gameResults.LoginId = loginResult.LoginInfo.LoginId;
gameResults.Score = Score;
gameResults.TestDuration = TestDuration;
gameResults.Total = Total;
db.t_GameResults.AddObject(gameResults);
db.SaveChanges();
results.Success = true;
results.Game = gameResults;
}
else
{
results.Error = "Could not login. Invalid Username/Password";
}
}
catch (Exception ex)
{
results.Error = ex.Message;
}
return results;
}
public static GameResults InsertGameResultLoginId(String UserName, GameListEnum gameType, int Score, decimal TestDuration, int Total)
{
GameResults results = new GameResults();
try
{
AgileMindEntities db = new AgileMindEntities();
vwLoginInfo login = (from data in db.vwLoginInfoes where data.LoginName == UserName select data).Single();
if (login != null)
{
t_GameResults gameResults = new t_GameResults();
gameResults.Created = DateTime.Now;
gameResults.GameId = (int)gameType;
gameResults.LoginId = login.LoginId;
gameResults.Score = Score;
gameResults.TestDuration = TestDuration;
gameResults.Total = Total;
db.t_GameResults.AddObject(gameResults);
db.SaveChanges();
results.Success = true;
results.Game = gameResults;
}
else
{
results.Error = "Could not login. Invalid Username/Password";
}
}
catch (Exception ex)
{
results.Error = ex.Message;
}
return results;
}
public void CanCreateSaveRecord()
{
GameResults newGame = new GameResults();
Assert.IsNotNull(newGame);
}