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"); } }
/// <summary> /// Create a new t_UserProfileAnswer object. /// </summary> /// <param name="userProfileAnswerId">Initial value of the UserProfileAnswerId property.</param> /// <param name="loginId">Initial value of the LoginId property.</param> /// <param name="userProfileQuestionId">Initial value of the UserProfileQuestionId property.</param> /// <param name="answer">Initial value of the Answer property.</param> /// <param name="created">Initial value of the Created property.</param> /// <param name="noAnswer">Initial value of the NoAnswer property.</param> public static t_UserProfileAnswer Createt_UserProfileAnswer(global::System.Int32 userProfileAnswerId, global::System.Int32 loginId, global::System.Int32 userProfileQuestionId, global::System.String answer, global::System.DateTime created, global::System.Boolean noAnswer) { t_UserProfileAnswer t_UserProfileAnswer = new t_UserProfileAnswer(); t_UserProfileAnswer.UserProfileAnswerId = userProfileAnswerId; t_UserProfileAnswer.LoginId = loginId; t_UserProfileAnswer.UserProfileQuestionId = userProfileQuestionId; t_UserProfileAnswer.Answer = answer; t_UserProfileAnswer.Created = created; t_UserProfileAnswer.NoAnswer = noAnswer; return t_UserProfileAnswer; }
/// <summary> /// Deprecated Method for adding a new object to the t_UserProfileAnswer EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTot_UserProfileAnswer(t_UserProfileAnswer t_UserProfileAnswer) { base.AddObject("t_UserProfileAnswer", t_UserProfileAnswer); }
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; }