public void HasUserFilledOutQuestionsReturnsTrueIfTheUserFilledOutEvenASingleQuestion()
{
AgileMindEntities agileDb = new AgileMindEntities();
LoginResult.ValidateLogin(LOGINNAME, PASSWORD, "ip");
AgileMind.DAL.Data.Login login = (from data in agileDb.Logins where data.LoginName == LOGINNAME select data).First();
if (login != null)
{
t_LoginSession session = (from data in agileDb.t_LoginSession where data.LoginId == login.LoginId && data.ValidTill > DateTime.Now select data).First();
if (session != null)
{
t_UserProfileAnswer newAnswer = new t_UserProfileAnswer();
newAnswer.LoginId = login.LoginId;
newAnswer.NoAnswer = false;
newAnswer.UserProfileQuestionId = 1;
newAnswer.Answer = "one answer";
newAnswer.Created = DateTime.Now;
agileDb.t_UserProfileAnswer.AddObject(newAnswer);
agileDb.SaveChanges();
bool userFilledOutQuestion = UserProfileQuestionsResults.HasUserFilledOutAnyQuestions(session.LoginSessionId);
Assert.IsTrue(userFilledOutQuestion);
}
else
{
Assert.Fail("Could not find the session to begin testing.");
}
}
else
{
Assert.Fail("Could not find the login to start testing");
}
}
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 void SaveAnswersWillTakeTheViewAndSaveTheInformation()
{
AgileMindEntities agileDb = new AgileMindEntities();
LoginResult.ValidateLogin(LOGINNAME, PASSWORD, "ip");
AgileMind.DAL.Data.Login login = (from data in agileDb.Logins where data.LoginName == LOGINNAME select data).First();
if (login != null)
{
t_LoginSession session = (from data in agileDb.t_LoginSession where data.LoginId == login.LoginId && data.ValidTill > DateTime.Now select data).First();
if (session != null)
{
UserProfileQuestionsResults results = UserProfileQuestionsResults.FetchUserProfileQuestions(session.LoginSessionId);
Assert.IsNotNull(results);
Assert.IsTrue(results.Success);
Assert.Greater(results.QuestionList.Count(), 0);
results.QuestionList[0].Answer = "12345";
List<vwQuestionAnswer> questionList = new List<vwQuestionAnswer>();
questionList.Add(results.QuestionList[0]);
Result saveResult = UserProfileQuestionsResults.SaveUserQuestions(questionList, session.LoginSessionId);
Assert.IsTrue(saveResult.Success);
int userProfileQuestionId = results.QuestionList[0].UserProfileQuestionId;
t_UserProfileAnswer savedAnswer = (from data in agileDb.t_UserProfileAnswer where data.LoginId == login.LoginId && data.UserProfileQuestionId == userProfileQuestionId select data).First();
Assert.IsNotNull(savedAnswer);
Assert.AreEqual(savedAnswer.Answer, "12345");
agileDb.DeleteObject(savedAnswer);
agileDb.SaveChanges();
}
else
{
Assert.Fail("Could not find the session to begin testing.");
}
}
else
{
Assert.Fail("Could not find the login to start testing");
}
}
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 static Result SaveUserQuestions(List<vwQuestionAnswer> QuestionAnswerList, Guid SessionId)
{
Result saveResults = new Result();
AgileMindEntities agileDB = new AgileMindEntities();
t_LoginSession session = (from loginSession in agileDB.t_LoginSession where loginSession.LoginSessionId == SessionId && loginSession.ValidTill > DateTime.Now select loginSession).First();
if (session != null)
{
List<t_UserProfileAnswer> answerList = (from data in agileDB.t_UserProfileAnswer where data.LoginId == session.LoginId select data).ToList();
foreach (vwQuestionAnswer questionAnswer in QuestionAnswerList)
{
if (questionAnswer.UserProfileAnswerId == null || questionAnswer.UserProfileAnswerId == 0)
{
t_UserProfileAnswer newAnswer = new t_UserProfileAnswer();
newAnswer.Answer = questionAnswer.Answer;
newAnswer.Created = DateTime.Now;
newAnswer.LoginId = session.LoginId;
newAnswer.UserProfileQuestionId = questionAnswer.UserProfileQuestionId;
if (questionAnswer.NoAnswer.HasValue)
{
newAnswer.NoAnswer = questionAnswer.NoAnswer.Value;
}
else
{
newAnswer.NoAnswer = false;
}
agileDB.t_UserProfileAnswer.AddObject(newAnswer);
}
else
{
t_UserProfileAnswer foundAnswer = (from data in agileDB.t_UserProfileAnswer where data.UserProfileAnswerId == questionAnswer.UserProfileAnswerId select data).First();
if (foundAnswer != null)
{
foundAnswer.Answer = questionAnswer.Answer;
if (questionAnswer.NoAnswer.HasValue)
{
foundAnswer.NoAnswer = questionAnswer.NoAnswer.Value;
}
else
{
foundAnswer.NoAnswer = false;
}
}
}
}
agileDB.SaveChanges();
saveResults.Success = true;
}
else
{
saveResults.Error = "Could not find session";
}
return saveResults;
}