public AnswerRepositoryTests()
{
_dataContext = new FakeDataContext();
_fakeAnswers = _dataContext.EntitySet <Answer>() as FakeAnswers;
_repository = new AnswerRepository(_dataContext);
}
private Button getRightAnswerButton()
{
AnswerRepository aRep = new AnswerRepository();
if (isAnswerCorrect(btnA1, aRep))
{
return(btnA1);
}
else if (isAnswerCorrect(btnA2, aRep))
{
return(btnA2);
}
else if (isAnswerCorrect(btnA3, aRep))
{
return(btnA3);
}
else if (isAnswerCorrect(btnA4, aRep))
{
return(btnA4);
}
else
{
throw new System.ArgumentException("Fehler bei richtiger Antwortausgabe", "original");
}
}
public void A_ChangedAnswer_modifies_Existing_Answer_in_the_database()
{
var bootStrapper = new BootStrapper();
bootStrapper.StartServices();
var serviceEvents = bootStrapper.GetService<IServiceEvents>();
//1.- Create message
var aggr = GenerateRandomAggregate();
//2.- Create the tuple in the database
var repository = new AnswerRepository(_configuration.TestServer);
repository.Insert(aggr);
//3.- Change the aggregate
aggr.PersonId = Guid.NewGuid();
aggr.AnswerValues.ToList().ForEach(v => v.Type = new Random().Next());
//4.- Emit message
var message = GenerateMessage(aggr);
message.MessageType = typeof(ChangedAnswer).Name;
serviceEvents.AddIncommingEvent(new IncommingEvent { @event = message });
//5.- Load the saved country
var country = repository.Get(aggr.Id);
//6.- Check equality
Assert.True(ObjectExtension.AreEqual(aggr, country));
}
public IEnumerable <Answer> GetAllAnswers(int problemId)
{
AnswerRepository answer = new AnswerRepository(Startup.connectionString);
IEnumerable <Answer> answers = answer.GetAllAnswers(problemId);
return(answers);
}
public AnswerService(AnswerRepository answerRepository, QuestionRepository questionRepository, GuessRepository guessRepository, GameStatusService gameStatusService)
{
this.answerRepository = answerRepository;
this.questionRepository = questionRepository;
this.guessRepository = guessRepository;
this.gameStatusService = gameStatusService;
}
protected void btnSave_Click(object sender, EventArgs e)
{
AnswerRepository aRep = new AnswerRepository();
QuestionRepository qRep = new QuestionRepository();
Question q = getQuestionFromView();
List <Answer> listAnswer = getAnwersFromView();
if (getTrueFalseValue() == null && validateQuestion(q) == null &&
validateCategory(q) == null && validateAnswers(listAnswer) == null)
{
qRep.Save(q);
listAnswer.ForEach(x => {
x.QuestionId = q.Id;
x.UserId = getUserId();
});
aRep.Save(listAnswer);
Response.Redirect("~/QuestionList.aspx");
}
else
{
txtBoxError.Visible = true;
txtBoxError.Text = getTrueFalseValue() +
"\n" + validateQuestion(q) +
"\n" + validateCategory(q) +
"\n" + validateAnswers(listAnswer);
}
}
public QuestionController(QuestionRepository questionRepository, QuestionCategoryRepository qcRepo, AnswerRepository aRepo, FeedbackRepository fRepo, IHostingEnvironment hostingEnvironment) : base(questionRepository)
{
_hostingEnvironment = hostingEnvironment;
_questionCategoryRepo = qcRepo;
_answerRepo = aRepo;
_feedBackRepo = fRepo;
}
/// <summary>
/// Update the information of an answer
/// </summary>
/// <param name="id">answer id</param>
/// <param name="txtanswer">answer text</param>
/// <param name="fileanswer">answer file</param>
/// <returns>returns the result to action</returns>
public ActionResult UpdateAnswer(int id, string txtanswer, HttpPostedFileBase fileanswer)
{
AnswerRepository objanswer = new AnswerRepository(SessionCustom);
objanswer.Entity.AnswerId = id;
objanswer.LoadByKey();
string strfile = objanswer.Entity.Image;
if (fileanswer != null)
{
strfile = DateTime.Now.ToString("ddmmyyyyhhmmssFFF") + Path.GetExtension(fileanswer.FileName);
string filePath = @"Files/" + objanswer.Entity.ContentId.ToString() + "/" + strfile;
string fullPath = Path.Combine(Server.MapPath("~"), filePath);
fileanswer.SaveAs(fullPath);
ImageResize objimage = new ImageResize(Server.MapPath("~"));
objimage.Prefix = "_";
objimage.Width = 255;
objimage.Height = 130;
bool resized = objimage.Resize(filePath, ImageResize.TypeResize.CropProportional);
if (resized)
{
System.IO.File.Delete(fullPath);
System.IO.File.Move(Path.Combine(Server.MapPath("~"), @"Files/" + objanswer.Entity.ContentId.ToString() + "/_" + strfile), fullPath);
}
}
objanswer.Entity.Text = txtanswer;
objanswer.Entity.Image = strfile;
objanswer.Update();
this.InsertAudit("Update", this.Module.Name + " -> Answer" + id);
return(this.View("AnswerDetail", objanswer.Entity));
}
public void SetUp()
{
_fixture = new Fixture().Customize(new AutoMoqCustomization());
_dataContext = new Mock<IDataContext>();
_sut = new AnswerRepository(_dataContext.Object);
}
private async void AddAnswer(int QuestionId)
{
var answer = await SweetAlertMessage.InputDialog(type : "textarea", PlaceholderText : "Type your survey answer here....");
if (!string.IsNullOrEmpty(answer))
{
var percentage = await SweetAlertMessage.RiskWeight();
var confirm = await SweetAlertMessage.ConfirmDialogAsync(Text : "Add this answe to the question.");
if (confirm != null)
{
var _answer = await AnswerRepository.AddAnswer(new Answer
{
QuestionId = QuestionId,
IsActive = true,
Percentage = double.Parse(percentage),
UserAnswer = answer,
AnswerType = AnswerType.No
});
if (_answer != null)
{
var _updatedQuestion = Survey.Questions.FirstOrDefault(p => p.QuestionId == QuestionId);
_updatedQuestion.Answers.Add(_answer);
StateHasChanged();
await SweetAlertMessage.SuccessMessage();
}
else
{
await SweetAlertMessage.ErrorMessage();
}
}
}
}
private void set5050Answers()
{
List <Button> buttons = new List <Button>();
buttons.Add(btnA1);
buttons.Add(btnA2);
buttons.Add(btnA3);
buttons.Add(btnA4);
int buttonListCount = 4;
AnswerRepository aRep = new AnswerRepository();
for (int i = 0; 0 < buttonListCount; i++)
{
if (isAnswerCorrect(buttons[i], aRep, false))
{
buttons.Remove(buttons[i]);
buttonListCount = 0;
}
}
buttons.Shuffle();
buttons[1].Enabled = false;
buttons[2].Enabled = false;
}
public void CreateAnswer_AddExistingAnswer_DoNotInsertTwiceInDb()
{
//ARRANGE
var options = new DbContextOptionsBuilder <AskContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using var context = new AskContext(options);
IQuestionRepository questionRepository = new QuestionRepository(context);
IAnswerRepository answerRepository = new AnswerRepository(context);
DateTime date = DateTime.Now;
var question = new QuestionTO {
IsResolved = false, Message = "Je n'arrive pas à faire un test", Title = "Problème avec Tests", Date = date, AuthorId = 1
};
var addedQuestion = questionRepository.Create(question);
context.SaveChanges();
var answer = new AnswerTO {
Message = "En fait, c'est facile il faut toujorus faire des tests", AuthorId = 2, AssociatedQuestion = addedQuestion,
};
var result = answerRepository.Create(answer);
context.SaveChanges();
//ACT
answerRepository.Create(result);
context.SaveChanges();
//ASSERT
Assert.AreEqual(1, context.Answers.Count());
}
public void Desactivateing(int id)
{
AnswerRepository repository = new AnswerRepository();
AnswersEntity entity = repository.GetById(id);
entity.status = false;
repository.update(entity);
}
public void oneTimeSetUp()
{
var connection = DbConnectionFactory.CreateTransient();
this.ctx = new ApplicationDbContext(connection);
this.repo = new AnswerRepository(ctx);
new DatabaseSeeder().CreateDependenciesAndSeed(ctx);//heavy duty
}
public ActionResult Edit(int id)
{
FillDropdownValues();
var model = AnswerRepository.Find(id);
return(View(model));
}
public QuestionService(QuestionRepository questionRepository,
UserManager <ApplicationUser> userManager,
AnswerRepository answerRepository)
{
_questionRepository = questionRepository;
_answerRepository = answerRepository;
_userManager = userManager;
}
public void TestInitialize()
{
_mockAnswers = new Mock <IDbSet <Answer> >();
var mockContext = new Mock <IApplicationDbContext>();
mockContext.SetupGet(c => c.Answers).Returns(_mockAnswers.Object);
_answerRepository = new AnswerRepository(mockContext.Object);
}
public void PostAnswer(int problemId, string value)
{
Answer answer = new Answer {
answer = value, problem = problemId
};
AnswerRepository answerRepository = new AnswerRepository(Startup.connectionString);
answerRepository.Create(answer);
}
public CourseDatabase()
{
Context = new DataContext();
Tasks = new TaskRepository(Context);
Users = new UserRepository(Context);
Tags = new TagsRepository(Context);
Answers = new AnswerRepository(Context);
Search = new SearchRepository();
}
public QuestionService(IDbContext dbContext)
{
_answerFactory = new AnswerFactory();
_questionFactory = new QuestionFactory();
_answerRepository = new AnswerRepository(dbContext);
_questionRepository = new QuestionRepository(dbContext);
}
/// <summary>
/// Return the detail of an answer
/// </summary>
/// <param name="id">answer id</param>
/// <returns>returns the result to action</returns>
public ActionResult AnswerDetail(int id)
{
AnswerRepository objanswer = new AnswerRepository(SessionCustom);
objanswer.Entity.AnswerId = id;
objanswer.LoadByKey();
return(this.View(objanswer.Entity));
}
public UnitOfWork(ApplicationDbContext context)
{
_context = context;
Polls = new PollRepository(_context);
Answers = new AnswerRepository(_context);
Users = new UserRepository(_context);
DailyStatistics = new DailyStatisticsRepository(_context);
UniqueVisitors = new UniqueVisitorsRepository(_context);
}
/// <summary>
/// ConnectionString kommt aus den appsettings.json
/// </summary>
public UnitOfWork(ApplicationDbContext dbContext)
{
_dbContext = dbContext;
UserRepository = new UserRepository(_dbContext);
GameRepository = new GameRepository(_dbContext);
RoundRepository = new RoundRepository(_dbContext);
QuestionRepository = new QuestionRepository(_dbContext);
AnswerRepository = new AnswerRepository(_dbContext);
}
public QuestionsController(QuestionRepository questionRepository, AnswerRepository answerRepository, IEntityMapper <Question, QuestionViewModel> entityToVmMapper, IEntityMapper <QuestionViewModel, Question> vmToEntityMapper, IEntityMapper <Answer, AnswerViewModel> answerToVmMapper, IEntityMapper <AnswerViewModel, Answer> vmToAnswerMapper)
{
this.questionRepository = questionRepository;
this.answerRepository = answerRepository;
this.vmToEntityMapper = vmToEntityMapper;
this.entityToVmMapper = entityToVmMapper;
this.vmToAnswerMapper = vmToAnswerMapper;
this.answerToVmMapper = answerToVmMapper;
}
private PhoneDataMigration(IComponentContext context)
{
EnsureThat.IsNotNull(context, nameof(context));
_softwareMigrationRepository = (SoftwareMigrationRepository)context.Resolve <ISoftwareMigrationRepository>();
_unitOfWorkFactory = context.Resolve <IUnitOfWorkFactory>();
_answerRepository = (AnswerRepository)context.Resolve <IAnswerRepository>();
_templateControlRepository = context.Resolve <ITemplateControlRepository>();
_migrationName = typeof(PhoneDataMigration).GetCustomAttribute <DescriptionAttribute>()
.Description;
}
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 void GetAllAnswers_NoQuestionInDb_ThrowException()
{
var options = new DbContextOptionsBuilder <AskContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using var context = new AskContext(options);
IAnswerRepository answerRepository = new AnswerRepository(context);
Assert.ThrowsException <ArgumentNullException>(() => answerRepository.GetAll());
}
public ActionResult Create(Answer model)
{
if (ModelState.IsValid)
{
AnswerRepository.Insert(model);
AnswerRepository.Save();
}
FillDropdownValues();
return(View(model));
}
public UnitOfWork(DatabaseContext databaseContext)
{
_databaseContext = databaseContext;
Courses = new CourseRepository(_databaseContext);
Exams = new ExamRepository(_databaseContext);
Grades = new GradeRepository(_databaseContext);
Questions = new QuestionRepository(_databaseContext);
Students = new StudentRepository(_databaseContext);
Teachers = new TeacherRepository(_databaseContext);
Answers = new AnswerRepository(_databaseContext);
}
public void DeleteAnswer_ProvidingNull_ThrowException()
{
var options = new DbContextOptionsBuilder <AskContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using var context = new AskContext(options);
IAnswerRepository answerRepository = new AnswerRepository(context);
Assert.ThrowsException <KeyNotFoundException>(() => answerRepository.Delete(null));
}
public DataAccess()
{
PollAppDBContext context = new PollAppDBContext();
UserRepository = new UserRepository(context);
CategoryRepository = new CategoryRepository(context);
TokenRepository = new TokenRepository(context);
QuestionRepository = new QuestionRepository(context);
AnswerRepository = new AnswerRepository(context);
FormRepository = new FormRepository(context);
VotedFormsRepository = new VotedFormsRepository(context);
}
private bool isAnswerCorrect(Button btn, AnswerRepository aRep, bool setPoints = true)
{
bool correct = aRep.checkAnswer(Convert.ToInt32(btn.Attributes["answerId"]));
if (correct && setPoints)
{
SetPoints();
}
CountQuestionStatisticsOneUp(correct);
return(correct);
}
public void GetAnswersByQuestionId_InvalidArguments(int questionId)
{
// Arrange
SOVAContext databaseContext = new SOVAContext(_connectionString);
AnswerRepository answerRepository = new AnswerRepository(databaseContext);
// Act
IEnumerable <Answer> answers = answerRepository.GetAnswersForQuestionById(questionId);
// Assert
Assert.Null(answers);
}
public void GetAnswerById_InvalidArgument(int answerId)
{
// Arrange
SOVAContext databaseContext = new SOVAContext(_connectionString);
AnswerRepository answerRepository = new AnswerRepository(databaseContext);
// Act
Answer answer = answerRepository.GetAnswerById(answerId);
// Assert
Assert.Null(answer);
}
public void A_RegisteredAnswer_creates_a_new_answer_in_the_database()
{
var bootStrapper = new BootStrapper();
bootStrapper.StartServices();
var serviceEvents = bootStrapper.GetService<IServiceEvents>();
//1.- Create message
var aggr = GenerateRandomAggregate();
var message = GenerateMessage(aggr);
//2.- Emit message
serviceEvents.AddIncommingEvent(new IncommingEvent { @event = message });
//3.- Load the saved country
var repository = new AnswerRepository(_configuration.TestServer);
var country = repository.Get(aggr.Id);
//4.- Check equality
Assert.True(ObjectExtension.AreEqual(aggr, country));
}
public void A_UnregisteredAnswer_removers_Existing_answer_in_the_database()
{
var bootStrapper = new BootStrapper();
bootStrapper.StartServices();
var serviceEvents = bootStrapper.GetService<IServiceEvents>();
//1.- Create message
var aggr = GenerateRandomAggregate();
//2.- Create the tuple in the database
var repository = new AnswerRepository(_configuration.TestServer);
repository.Insert(aggr);
//2.- Emit message
var message = GenerateMessage(aggr);
message.MessageType = typeof(UnregisteredAnswer).Name;
serviceEvents.AddIncommingEvent(new IncommingEvent { @event = message });
var country = repository.Get(aggr.Id);
Assert.Null(country);
}
private void initilizeTest()
{
string connectionString = "server=wt-220.ruc.dk;database=raw4;uid=raw4;pwd=raw4";
answerRepository = new AnswerRepository(connectionString);
}
