/// <summary> /// Return a TechnologyQuestion object by a given text or null if none was found. /// </summary> /// <param name="id"> Give id. </param> /// <returns> TechnologyQuestion or null </returns> public TechnologyQuestion GetTechnologyQuestionByName(string inputText) { using (QuizEntities context = new QuizEntities()) { return(context.TechnologyQuestions.FirstOrDefault(r => r.TechnologyQuestionText == inputText)); } }
/// <summary> /// Returns the list with all the tests(Test objects) if there are no tests it returns an empty list. /// </summary> /// <returns> A list of Test type objects </returns> public List <Test> GetAllTests() { using (QuizEntities context = new QuizEntities()) { return(context.Tests.Count() == 0 ? new List <Test>() : context.Tests.ToList()); } }
/// <summary> /// Returns the TestId by a given UserId or 0 if none was found. /// </summary> /// <param name="UserId"> Given UserId. </param> /// <returns> Test Id or 0 </returns> public int GetTestIdByUserId(int UserId) { using (QuizEntities context = new QuizEntities()) { return(context.UserTests.Where(p => p.UserID == UserId).FirstOrDefault(r => r.IsFinished == false).TestId); } }
/// <summary> /// Return a TechnologyQuestion object by a given id or null if none was found. /// </summary> /// <param name="id"> Give id. </param> /// <returns> TechnologyQuestion or null </returns> public TechnologyQuestion GetTechnologyQuestionById(int id) { using (QuizEntities context = new QuizEntities()) { return(context.TechnologyQuestions.FirstOrDefault(r => r.Id == id)); } }
public List <int> GetQuestionsIdsByTestId(int testId) { using (QuizEntities context = new QuizEntities()) { return(context.TestQuestions.Where(q => q.TestId == testId).Select(q => q.QuestionID).ToList()); } }
/// <summary> /// Get test type by given type or null if none was found /// </summary> /// <param name="type"> Given type </param> /// <returns> TestType or null </returns> public TestType GetTestTypeByType(string type) { using (QuizEntities context = new QuizEntities()) { return(context.TestTypes.FirstOrDefault(r => r.Type == type)); } }
/// <summary> /// Get test type by given id or null if none was found /// </summary> /// <param name="id"> given Id </param> /// <returns> Test Type or null</returns> public TestType GetTestTypeById(int id) { using (QuizEntities context = new QuizEntities()) { return(context.TestTypes.FirstOrDefault(r => r.Id == id)); } }
//get data /// <summary> /// Gets a list of all the users or an empty list if none were found. /// </summary> /// <returns> List of users or empty list </returns> public List <User> GetAllUsers() { using (QuizEntities context = new QuizEntities()) { return(context.Users.Count() == 0 ? new List <User>() : context.Users.ToList()); } }
/// <summary> /// Returns the list of questions(question objects), if there are no questions it returns an empty list. /// </summary> /// <returns> A list of Question type objects </returns> public List <Question> GetAllQuestions() { using (QuizEntities context = new QuizEntities()) { return(context.Questions.Count() == 0 ? new List <Question>() : context.Questions.ToList()); } }
/// <summary> /// Gets a list of TestQuestionAnswers(objects) found by a testID or empty list if none were found /// </summary> /// <param name="testId"></param> /// <returns> List of TestQuestionAnswers(objects) or empty list</returns> public List <TestQuestionsAnswer> GetAllTestQuestionAnswersByTestId(int testId) { using (QuizEntities context = new QuizEntities()) { return(context.TestQuestionsAnswers.Where(r => r.TestId == testId).Count() == 0 ? new List <TestQuestionsAnswer>() : context.TestQuestionsAnswers.Where(r => r.TestId == testId).ToList()); } }
/// <summary> /// Gets a list of questions by a given Question Technology Id /// </summary> /// <param name="levelQuestion"> Given Question Technology Id </param> /// <returns> List of Questions </returns> public List <Question> GetAllQuestionsByQuestionTechnologyID(int questionTechnologyId) { using (QuizEntities context = new QuizEntities()) { return(context.Questions.Where(r => r.QuestionTechnologyID == questionTechnologyId).ToList()); } }
/// <summary> /// Gets a list of questions by a given Question Technology Id and a Question Level /// </summary> /// <param name="levelQuestion"> Given Question Level </param> /// <param name="questionTechnologyId"> Given Question Technology Id </param> /// <returns> List of questions </returns> public List <Question> GetAllQuestionsByLevelAndTechnology(string levelQuestion, int questionTechnologyId) { using (QuizEntities context = new QuizEntities()) { return(context.Questions.Where(r => r.LevelQuestion == levelQuestion && r.QuestionTechnologyID == questionTechnologyId).ToList()); } }
/// <summary> /// Return the answer(of type Answer) by a given question ID, if no answer was found null is returned. /// </summary> /// <param name="Id"> the id of the question</param> /// <returns> Answer object or null </returns> public Answer GetCorrectAnswerByQuestionID(int QuestionID) { using (QuizEntities context = new QuizEntities()) { return(context.Answers.FirstOrDefault(r => r.QuestionID == QuestionID && r.Value == true)); } }
/// <summary> /// Gets a list of questions by a given levelQuestion /// </summary> /// <param name="levelQuestion"> Given Question Level </param> /// <returns> List of Questions </returns> public List <Question> GetAllQuestionsByLevel(string levelQuestion) { using (QuizEntities context = new QuizEntities()) { return(context.Questions.Where(r => r.LevelQuestion == levelQuestion).ToList()); } }
/// <summary> /// Returns a User object if user was found with given Username or Password, null otherwise. /// </summary> /// <param name="Username"> Given Username </param> /// <param name="Password"> Given Password </param> /// <returns> User object or null </returns> public User LoginUser(string Username, string Password) { using (QuizEntities context = new QuizEntities()) { return(context.Users.FirstOrDefault(r => r.Username == Username && r.Password == Password)); } }
/// <summary> /// Returns a User object if user was found with given Username or null otherwise. /// </summary> /// <param name="Username"> Given Username </param> /// <returns> User object or null </returns> public User GetUserByUsername(string Username) { using (QuizEntities context = new QuizEntities()) { return(context.Users.FirstOrDefault(r => r.Username == Username)); } }
/// <summary> /// Returns a user found by a given Id or null if none were found. /// </summary> /// <param name="UserId"> Given user Id. </param> /// <returns> A User object or null </returns> public User GetUserById(int UserId) { using (QuizEntities context = new QuizEntities()) { return(context.Users.FirstOrDefault(r => r.Id == UserId)); } }
/// <summary> /// Gets a list of questions by a given levelQuestion /// </summary> /// <param name="numberOfQuestions"> Given number of questions </param> /// <param name="levelQuestion"> Given Question Level </param> /// <returns> List of Questions </returns> public List <Question> GetRandomQuestionsByLevel(int numberOfQuestions, string levelQuestion) { using (QuizEntities context = new QuizEntities()) { return(context.Questions.Where(r => r.LevelQuestion == levelQuestion).OrderBy(r => Guid.NewGuid()).Take(numberOfQuestions).ToList()); } }
/// <summary> /// Gets a list of questions by a given Question Technology Id and a Question Level /// </summary> /// <param name="numberOfQuestions"> Given number of questions </param> /// <param name="levelQuestion"> Given Question Level </param> /// <param name="questionTechnologyId"> Given Question Technology Id </param> /// <returns> List of questions </returns> public List <Question> GetRandomQuestionsByLevelAndTechnology(int numberOfQuestions, string levelQuestion, int questionTechnologyId) { using (QuizEntities context = new QuizEntities()) { return(context.Questions.Where(r => r.LevelQuestion == levelQuestion && r.QuestionTechnologyID == questionTechnologyId).OrderBy(r => Guid.NewGuid()).Take(numberOfQuestions).ToList()); } }
/// <summary> /// Returns the list of answers(Answer objects) for a specific question , if there are no answers it returns an empty list. /// </summary> /// <returns> A list of Answer type objects </returns> public List <Answer> GetAnswersByQuestionID(int QuestionID) { using (QuizEntities context = new QuizEntities()) { return(context.Answers.Where(r => r.QuestionID == QuestionID).Count() == 0 ? new List <Answer>() : context.Answers.Where(r => r.QuestionID == QuestionID).ToList()); } }
/// <summary> /// Gets a list of TestQuestionAnswers(objects) by a userId,testId and IsReviewQuestion status or an empty list of none were found. /// </summary> /// <param name="userId"> Given Id </param> /// <param name="testId"> Given TestId </param> /// <param name="isReviewQuestion"> IsReviewQuestion status </param> /// <returns> List of TestQuestionAnswers or empty list </returns> public List <TestQuestionsAnswer> GetTestQuestionAnswersForReviewByUser(int userId, int testId, bool isReviewQuestion) { using (QuizEntities context = new QuizEntities()) { return(context.TestQuestionsAnswers.Where(r => r.UserID == userId && r.TestId == testId && r.IsReviewQuestion == isReviewQuestion).Count() == 0 ? new List <TestQuestionsAnswer>() : context.TestQuestionsAnswers.Where(r => r.UserID == userId && r.TestId == testId && r.IsReviewQuestion == isReviewQuestion).ToList()); } }
/// <summary> /// Returns a TestQuestionAnswer by a given id or null if nothing was found /// </summary> /// <param name="id"> the object id</param> /// <returns> Returns TestQuestionAnswers object or null </returns> public TestQuestionsAnswer GetTestQuestionsAnswersById(int id) { using (QuizEntities context = new QuizEntities()) { return(context.TestQuestionsAnswers.FirstOrDefault(r => r.Id == id)); } }
public List <TestQuestionsAnswer> GetTestQuestionAnswersbyUser(int userId, int testId, int QuestionID) { using (QuizEntities context = new QuizEntities()) { return(context.TestQuestionsAnswers.Where(r => r.UserID == userId && r.TestId == testId && r.QuestionID == QuestionID).ToList()); } }
/// <summary> /// Gets a list of all the TestQuestionAnswers(objects) or empty list if none were found /// </summary> /// <returns> List of TestQuestionAnswers objects or empty list </returns> public List <TestQuestionsAnswer> GetAllTestQuestionsAnswers() { using (QuizEntities context = new QuizEntities()) { return(context.TestQuestionsAnswers.Count() == 0 ? new List <TestQuestionsAnswer>() : context.TestQuestionsAnswers.ToList()); } }
/// <summary> /// Returns the list of questions(string objects), if there are no questions it returns an empty list. /// </summary> /// <returns> A list of questions of string type </returns> public List <string> GetQuestionsString() { var questionList = new List <string>(); using (QuizEntities context = new QuizEntities()) { if (context.Questions.Count() == 0) { return(new List <string>()); } else { try { foreach (var question in context.Questions.ToList()) { questionList.Add(question.Text_Question); } } catch (Exception) { } } } return(questionList); }
/// <summary> /// Return the question(of type Question) by a given Id, if no question was found null is returned. /// </summary> /// <param name="Id"> the id of the question</param> /// <returns> Question object or null </returns> public Question GetQuestionById(int Id) { using (QuizEntities context = new QuizEntities()) { return(context.Questions.FirstOrDefault(r => r.Id == Id)); } }
//delete data /// <summary> /// Deletes a user by a given Id. /// </summary> /// <param name="id"> Given user id </param> public void DeleteUserById(int id) { using (QuizEntities context = new QuizEntities()) { var user = context.Users.FirstOrDefault(r => r.Id == id); context.Users.Remove(user); context.SaveChanges(); } }
/// <summary> /// Deletes test questions by a given user id and test id. /// </summary> /// <param name="userId"> Given userId </param> /// <param name="testId"> Given testId </param> public void DeleteTestQuestionsAnswersByUserAndTestId(int userId, int testId) { using (QuizEntities context = new QuizEntities()) { var testQuestionsAnswers = context.TestQuestionsAnswers.Where(r => r.UserID == userId && r.TestId == testId).ToList(); context.TestQuestionsAnswers.RemoveRange(testQuestionsAnswers); context.SaveChanges(); } }
//delete data /// <summary> /// Deletes a test question by a given id. /// </summary> /// <param name="id"> Given id. </param> public void DeleteTestQuestionsAnswersById(int id) { using (QuizEntities context = new QuizEntities()) { var testQuestionAnswer = context.TestQuestionsAnswers.FirstOrDefault(r => r.Id == id); context.TestQuestionsAnswers.Remove(testQuestionAnswer); context.SaveChanges(); } }
/// <summary> /// Deletes a user by a given username. /// </summary> /// <param name="username"> Given Username </param> public void DeleteUserByUsername(string username) { using (QuizEntities context = new QuizEntities()) { var user = context.Users.FirstOrDefault(r => r.Username == username); context.Users.Remove(user); context.SaveChanges(); } }