/// <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();
}
}
