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