public IActionResult AddAnswer(Answer answer)
{
var repo = new QuestionsRepository(_connectionString);
repo.AddAnswer(answer);
return(Redirect($"/home/viewQuestion?questionId={answer.QuestionId}"));
}
public void GetbyIdShouldRequestListIds()
{
QuestionsRepository target = new QuestionsRepository(StackClientFactoryMock.Object);
StackClient.Setup(c =>
c.GetQuestions(It.Is<IEnumerable<int>>(arr => arr.IsEqual(new[] { 0, 1, 2, 3, 4, 5 })), It.IsAny<int?>(), It.IsAny<int?>(), false, false, null, null, null, null, null))
.Returns(new PagedList<Question>(new List<Question>() {
new Question {Id = 1},
new Question {Id = 2},
new Question {Id = 3},
new Question {Id = 4},
new Question {Id = 5},
new Question {Id = 6}}
) { PageSize = 6, TotalItems = 6 });
int[] ids = new[] { 0, 1, 2, 3, 4, 5 };
List<QuestionInfo> actual;
actual = target.Get("siteaddr", ids);
StackClient.VerifyAll();
var expected = new List<QuestionInfo>() {
new QuestionInfo {Id = 1},
new QuestionInfo {Id = 2},
new QuestionInfo {Id = 3},
new QuestionInfo {Id = 4},
new QuestionInfo {Id = 5},
new QuestionInfo {Id = 6}
};
CollectionAssert.AreEqual(expected, actual);
}
public UnitofWork(ApplicationDbContext dbContext)
{
applicationDbContext = dbContext;
Questions = new QuestionsRepository(applicationDbContext);
Tags = new TagsRepository(applicationDbContext);
Answers = new AnswersRepository(applicationDbContext);
}
public IActionResult GetLikes(int id)
{
var repo = new QuestionsRepository(_connectionString);
int likes = repo.GetLikes(id);
return(Json(likes));
}
public IActionResult AddQuestion(Question question, string tagString)
{
var repo = new QuestionsRepository(_connectionString);
repo.AddQuestion(question, tagString);
return(Redirect("/"));
}
public IActionResult AddAnswer(Answer answer)
{
var repository = new QuestionsRepository(_conn);
repository.AddAnswer(answer);
return(Redirect($"/home/questionpage?id={answer.Id}"));
}
public IActionResult SubmitQuestion(Question q, IEnumerable <string> tags)
{
var repository = new QuestionsRepository(_conn);
repository.AddQuestion(q, tags);
return(Redirect("/home/index"));
}
public IActionResult SignUp(User user)
{
var repository = new QuestionsRepository(_conn);
repository.AddUser(user);
return(Redirect("/account/login"));
}
public void GetById_WhenQuestionNotExists_ReturnsNull()
{
var questionsRepository = new QuestionsRepository();
var gotQuestion = questionsRepository.GetById(9999);
Assert.IsNull(gotQuestion);
}
public LmPlatformRepositoriesContainer()
{
UsersRepository = new UsersRepository(_dataContext);
BugsRepository = new BugsRepository(_dataContext);
BugLogsRepository = new BugLogsRepository(_dataContext);
GroupsRepository = new GroupsRepository(_dataContext);
ProjectsRepository = new ProjectsRepository(_dataContext);
ProjectUsersRepository = new ProjectUsersRepository(_dataContext);
ProjectCommentsRepository = new ProjectCommentsRepository(_dataContext);
StudentsRepository = new StudentsRepository(_dataContext);
SubjectRepository = new SubjectRepository(_dataContext);
TestsRepository = new TestsRepository(_dataContext);
TestUnlocksRepository = new TestUnlockRepository(_dataContext);
QuestionsRepository = new QuestionsRepository(_dataContext);
UsersRepository = new UsersRepository(_dataContext);
ModulesRepository = new ModulesRepository(_dataContext);
LecturerRepository = new LecturerRepository(_dataContext);
MessageRepository = new MessageRepository(_dataContext);
MaterialsRepository = new MaterialsRepository(_dataContext);
FoldersRepository = new FoldersRepository(_dataContext);
SubGroupRepository = new SubGroupRepository(_dataContext);
AttachmentRepository = new AttachmentRepository(_dataContext);
LecturesRepository = new LecturesRepository(_dataContext);
LabsRepository = new LabsRepository(_dataContext);
ProjectUsersRepository = new ProjectUsersRepository(_dataContext);
PracticalRepository = new PracticalRepository(_dataContext);
ConceptRepository = new ConceptRepository(_dataContext);
WatchingTimeRepository = new WatchingTimeRepository(_dataContext);
TestQuestionPassResultsRepository = new TestQuestionPassResultsRepository(_dataContext);
//todo UNUSED ProjectMatrixRequirementsRepository = new ProjectMatrixRequirementsRepository(_dataContext);
}
public IActionResult Login(User user)
{
var repository = new QuestionsRepository(_conn);
User u = repository.GetUser(user);
if (u == null)
{
return(Redirect("/account/login"));
}
else if (!repository.Match(user.Password, u.Password))
{
return(Redirect("/account/login"));
}
var claims = new List <Claim>
{
new Claim("user", user.Email)
};
HttpContext.SignInAsync(new ClaimsPrincipal(
new ClaimsIdentity(claims, "Cookies", "user", "role"))).Wait();
return(Redirect("/home/index"));
}
public IActionResult SignUp(User user, string password)
{
var repo = new QuestionsRepository(_connectionString);
repo.AddUser(user, password);
return(Redirect("/account/login"));
}
protected Question SaveQuestion(User user)
{
var question = QuestionsFactory.CreateQuestion(user);
QuestionsRepository.Save(question);
return(question);
}
/// <summary>
/// Génère un quizz
/// </summary>
/// <param name="createQuizzDto">Objetc quizz à créer</param>
/// <param name="nbreQuestion">Nombre de questions composant le quizz</param>
/// <returns></returns>
public FindQuizzDto GenerateQuizz(CreateQuizzDto createQuizzDto, int nbreQuestion)
{
// Récupère le nombre de questions par niveau de difficultés
string key = TransformeIdLevelToString(createQuizzDto.IdLevel);
double nbreQuestionJunior = Math.Round(nbreQuestion * Double.Parse(ConfigurationManager.AppSettings.Get(key + "_junior")));
double nbreQuestionConfirme = Math.Round(nbreQuestion * Double.Parse(ConfigurationManager.AppSettings.Get(key + "_confirme")));
double nbreQuestionExpert = nbreQuestion - nbreQuestionJunior - nbreQuestionConfirme;
// Récupère les questions du quizz
QuestionsRepository repoQuestion = new QuestionsRepository(new QueryBuilder());
List <Question> questions = new List <Question>();
questions.AddRange(repoQuestion.GenererQuestionQuizz(ID_JUNIOR, createQuizzDto.IdCategory, (int)nbreQuestionJunior));
questions.AddRange(repoQuestion.GenererQuestionQuizz(ID_CONFIRME, createQuizzDto.IdCategory, (int)nbreQuestionConfirme));
questions.AddRange(repoQuestion.GenererQuestionQuizz(ID_EXPERT, createQuizzDto.IdCategory, (int)nbreQuestionExpert));
// Creation et enregistrement du quizz
Quizz quizz = new Quizz(null, GenerateCode(12), null, createQuizzDto.IdCategory, createQuizzDto.IdLevel, createQuizzDto.IdUser, createQuizzDto.IdCandidate);
quizz = quizzRepository.Create(quizz);
// Enregistrement des questions du quizz
PersisteQuizzQuestion(questions, quizz);
return(TransformModelToDto(quizz));
}
public void GetById_WhenQuestionNotExists_ReturnsNull()
{
var questionsRepository = new QuestionsRepository();
var gotQuestion = questionsRepository.GetById(9999);
Assert.IsNull(gotQuestion);
}
private List <QuestionEntity> SelectAllByFactors()
{
try
{
using (var repository = new QuestionsRepository())
{
repository.Order = OrderType.Descending;
repository.Sort = SortType.Creation;
//repository.FromDate =
//repository.ToDate =
//repository.Min =
//repository.Max =
repository.Page = 1;
repository.PageSize = 50;
return(repository.SelectItemsFiltered());
}
}
catch (Exception ex)
{
//Log exception error
_loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true);
lblOperationResult.Text = "Sorry, loading All Questions operation failed." + Environment.NewLine + ex.Message;
}
return(null);
}
public void AddQuestionLike(int questionId)
{
var userRepo = new UserRepository(_connectionString);
var user = userRepo.GetByEmail(User.Identity.Name);
var questionRepo = new QuestionsRepository(_connectionString);
questionRepo.AddQuestionLike(questionId, user.Id);
}
public void Like(int id)
{
var repo = new QuestionsRepository(_connectionString);
var email = User.Identity.Name;
var userId = repo.GetByEmail(email).Id;
repo.AddLike(id, userId);
}
public IActionResult AddLike(int questionId)
{
var repository = new QuestionsRepository(_conn);
var u = repository.GetUserByEmail(User.Identity.Name);
repository.AddLike(questionId, u);
return(Redirect($"/home/questionpage?id={questionId}"));
}
public IActionResult Add(Question question, IEnumerable <string> tags)
{
question.DatePosted = DateTime.Now;
var repo = new QuestionsRepository(_connectionString);
repo.AddQuestion(question, tags);
return(Redirect("/questions"));
}
public void GetById_WhenQuestionExists_ReturnsTheQuestion()
{
var stubQuestion = new Question();
var questionsRepository = new QuestionsRepository {stubQuestion};
var gotQuestion = questionsRepository.GetById(stubQuestion.Id);
Assert.AreEqual(stubQuestion,gotQuestion);
}
public IActionResult Add(Question question, List <string> tags)
{
question.UserId = GetCurrentUserId().Value;
question.DatePosted = DateTime.Now;
var repo = new QuestionsRepository(_connectionString);
repo.AddQuestion(question, tags);
return(Redirect("/home/index"));
}
public void GetShouldFilterBySite()
{
QuestionsRepository target = new QuestionsRepository(m_EntitiesMock.Object);
m_EntitiesMock.Setup(e => e.Questions).Returns(new [] {
new Question {
Site = "site1", QuestionId = 1, Date = new DateTime(2010, 06, 23)
},
}.AsQueryable());
}
public QuizzesService(
QuizerContext context,
Auth0ManagementFactory auth0ManagementFactory
) : base(context)
{
_quizzesRepository = new QuizzesRepository(context);
_questionsRepository = new QuestionsRepository(context);
_quizAccessesRepository = new QuizAccessesRepository(context);
_auth0UsersService = new Auth0UsersService(auth0ManagementFactory);
}
public IActionResult Index()
{
var repo = new QuestionsRepository(_connectionString);
var vm = new IndexViewModel()
{
Questions = repo.GetQuestions()
};
return(View(vm));
}
public IActionResult Add(Question q, List <string> tags)
{
var questionRepo = new QuestionsRepository(_connectionString);
var usersRepo = new UsersRepository(_connectionString);
q.User = usersRepo.GetUserByEmail(User.Identity.Name);
q.DatePosted = DateTime.Now;
questionRepo.AddQuestion(q, tags);
return(Redirect("Home/Index"));
}
public IActionResult AddAnswer(Answer answer)
{
var repo = new QuestionsRepository(_connectionString);
answer.DateAnswered = DateTime.Now;
answer.UserId = GetCurrentUserId().Value;
repo.AddAnswer(answer);
return(this.RedirectToAction
("ViewQuestion", new { id = $"{answer.QuestionId}" }));
}
public IActionResult ViewQuestion(int id)
{
var repo = new QuestionsRepository(_connectionString);
var vm = new ViewQuestionViewModel();
vm.Question = repo.GetQuestionById(id);
vm.AskedBy = repo.GetUserNameById(vm.Question.UserId);
vm.CanLike = repo.CanLike(id, GetCurrentUserId().Value);
return(View(vm));
}
public void GetById_WhenQuestionExists_ReturnsTheQuestion()
{
var stubQuestion = new Question();
var questionsRepository = new QuestionsRepository {
stubQuestion
};
var gotQuestion = questionsRepository.GetById(stubQuestion.Id);
Assert.AreEqual(stubQuestion, gotQuestion);
}
public UnitOfWork(IDbContextFactory <KhaoSatDbContext> dbContextFactory, Microsoft.AspNetCore.Http.IHttpContextAccessor httpContextAccessor)
{
_dbContext = dbContextFactory.GetContext();
UserAnswersRepository = new UserAnswersRepository(_dbContext);
UserRepository = new UserRepository(_dbContext);
UserSurveysRepository = new UserSurveysRepository(_dbContext);
SurveysRepository = new SurveyRepository(_dbContext);
AnswerRepository = new AnswerRepository(_dbContext);
QuestionsRepository = new QuestionsRepository(_dbContext);
}
public SolvingQuizzesService(
QuizerContext context,
StatisticsService statisticsService,
Auth0ManagementFactory auth0ManagementFactory
) : base(context)
{
_quizzesRepository = new QuizzesRepository(context);
_questionsRepository = new QuestionsRepository(context);
_statisticsService = statisticsService;
_auth0UsersService = new Auth0UsersService(auth0ManagementFactory);
}
public IActionResult Add(Question question, IEnumerable <string> tags)
{
var repo = new QuestionsRepository(_connectionString);
question.DatePosted = DateTime.Now;
var email = User.Identity.Name;
question.UserId = repo.GetByEmail(email).Id;
repo.AddQuestion(question, tags);
return(RedirectToAction("Index"));
}
public IActionResult AddAnswer(Answer answer)
{
var repo = new QuestionsRepository(_connectionString);
answer.DateAnswered = DateTime.Now;
var email = User.Identity.Name;
answer.UserId = repo.GetByEmail(email).Id;
repo.AddAnswer(answer);
return(Redirect($"/home/ViewQuestion?id={answer.QuestionId}"));
}
public void GetShouldReturnListOfQuestionsOnePage()
{
QuestionsRepository target = new QuestionsRepository(StackClientFactoryMock.Object);
StackClient.Setup(c =>
c.GetQuestionsByUser(c_TestId, QuestionsByUserSort.Activity, SortDirection.Descending, 1, ApiSettings.PageSize, false, false, null, null, null, null, null))
.Returns(new PagedList<Question>(new List<Question>() {
new Question {Id = 1},
new Question {Id = 2}}
) { PageSize = 2, TotalItems = 2 });
List<QuestionInfo> actual;
actual = target.Get("siteaddr", c_TestId);
StackClient.VerifyAll();
var expected = new List<QuestionInfo>() {
new QuestionInfo {Id = 1},
new QuestionInfo {Id = 2}
};
CollectionAssert.AreEqual(expected, actual);
}
