protected override bool AuthorizeCore(string user, int itemId)
{
var userName = httpContext.User.Identity.Name;
var authUsers = SubmissionRepository.GetAuthoriedUsers(itemId);
return(authUsers.Contains(user));
}
public UserService()
{
UnpopularOpinionsDbContext _dbContext = new UnpopularOpinionsDbContext();
_userRepository = new UserRepository(_dbContext);
_commentRepository = new CommentRepository(_dbContext);
_submissionRepository = new SubmissionRepository(_dbContext);
}
public SubmissionService()
{
UnpopularOpinionsDbContext currentContext = new UnpopularOpinionsDbContext();
this._submissionRepository = new SubmissionRepository(currentContext);
this._userRepository = new UserRepository(currentContext);
this._commentRepository = new CommentRepository(currentContext);
}
public void UpdateSubmissiontReturnsNewSubmission()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
#region Submission
var submission1 = new SubmissionTO
{
SessionId = 30,
AttendeeId = 1012,
Date = DateTime.Today,
};
var submission2 = new SubmissionTO
{
SessionId = 31,
AttendeeId = 2607,
Date = DateTime.Today,
};
var submission3 = new SubmissionTO
{
SessionId = 2,
AttendeeId = 1612,
Date = DateTime.Today,
};
var submissionAdded1 = submissionRepository.Add(submission1);
var submissionAdded2 = submissionRepository.Add(submission2);
memoryContext.SaveChanges();
#endregion
//Act
var idSub = submissionAdded1.Id;
var submissionToUpdate = new SubmissionTO {
Id = idSub, Date = DateTime.Today, AttendeeId = 132, SessionId = 456
};
var updatedSubmission = submissionRepository.Update(submissionToUpdate);
memoryContext.SaveChanges();
var result = submissionRepository.GetById(updatedSubmission.Id);
//Assert
Assert.AreEqual(456, result.SessionId);
}
}
public async Task Save_FileExistsInFolder()
{
var repo = new SubmissionRepository(fileSystem, configuration, referenceNumberGenerator);
var submission = new Submission
{
};
var referenceNumber = await repo.SaveAsync(submission);
Assert.NotNull(referenceNumber);
Assert.True(fileSystem.FileExists(fileSystem.Path.Combine(submissionPersistencePath, $"submission_{referenceNumber}.json")));
}
public void RemoveSubmissionAddNewFormThenRemoveItReturnsTrue()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
#region Submission
var submission1 = new SubmissionTO
{
SessionId = 30,
AttendeeId = 1012,
Date = DateTime.Today,
};
var submission2 = new SubmissionTO
{
SessionId = 31,
AttendeeId = 2607,
Date = DateTime.Today,
};
var submission3 = new SubmissionTO
{
SessionId = 2,
AttendeeId = 1612,
Date = DateTime.Today,
};
var submissionAdded1 = submissionRepository.Add(submission1);
var submissionAdded2 = submissionRepository.Add(submission2);
var submissionAdded3 = submissionRepository.Add(submission3);
memoryContext.SaveChanges();
#endregion
//Act
var result1 = submissionRepository.Remove(submissionAdded1);
var result2 = submissionRepository.Remove(submissionAdded2.Id);
memoryContext.SaveChanges();
var total = submissionRepository.GetAll().Count();
//Assert
Assert.IsTrue(result1);
Assert.IsTrue(result2);
Assert.AreEqual(1, total);
}
}
public async Task Get_SavedSubmissionReturned()
{
var repo = new SubmissionRepository(fileSystem, configuration, referenceNumberGenerator);
var submission = new Submission
{
};
var referenceNumber = await repo.SaveAsync(submission);
var loadedSumbission = await repo.GetAsync(referenceNumber);
Assert.NotNull(loadedSumbission);
}
public IHttpActionResult Post([FromBody] Submission surveySubmission)
{
try
{
var submissionRepository = new SubmissionRepository();
submissionRepository.ConsumeUserSurvey(surveySubmission);
submissionRepository.InsertSubmission(surveySubmission);
return(Ok(surveySubmission));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public void ThrowsExceptionWhenANonExistingSubmissionIsProvided()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange - Act
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
//Assert
Assert.ThrowsException <ArgumentNullException>(() => submissionRepository.Add(null));
}
}
public async void TestCreateAsync()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "SubmissionDatabase")
.Options;
var dbContext = new ApplicationDbContext(options);
var repo = new SubmissionRepository(dbContext);
// Act
var result = await repo.CreateAsync(new Submission { SavedDate = DateTime.Now, SubmissionJson = "{}" });
// Assert
Assert.True(result is Submission);
}
public async void TestFindByAsync()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "SubmissionDatabase")
.Options;
var dbContext = new ApplicationDbContext(options);
var repo = new SubmissionRepository(dbContext);
// Act
var result = await repo.FindByAsync(x => x.Id > 0);
// Assert
Assert.True(result is IEnumerable <Submission>);
}
public async Task Save_DuplicateReferenceNumber_Failed()
{
var presetReferenceNumber = "refnumber";
referenceNumberGenerator.PresetReferenceNumber(presetReferenceNumber);
var repo = new SubmissionRepository(fileSystem, configuration, referenceNumberGenerator);
var submission = new Submission
{
};
await repo.SaveAsync(submission);
await Assert.ThrowsAsync <Exception>(async() => await repo.SaveAsync(submission));
}
public ActionResult GetSubmissionDetails(SubmissionPostData data)
{
Course course = _GetCourse();
if (course == null || course.CourseId != data.CourseId)
{
return(new HttpNotFoundResult());
}
var user = ApplicationUser.Current;
if (user == null || user.Id != data.UserId)
{
return(new HttpNotFoundResult());
}
try
{
var submission = _db.StudentSubmissions
.Where(ss => ss.StudentAssignment.Enrollment.CourseId == data.CourseId)
.Where(ss => ss.StudentAssignment.Enrollment.UserId == user.Id)
.Where(ss => ss.StudentAssignment.AssignmentId == data.AssignmentId)
.Where(ss => ss.StudentSubmissionId == data.SubmissionId)
.Include(ss => ss.StudentAssignment.Assignment)
.Include(ss => ss.StudentAssignment.Enrollment)
.FirstOrDefault();
if (submission == null)
{
return(new HttpNotFoundResult());
}
var repo = SubmissionRepository.Get(submission.StudentAssignment);
repo.Checkout(submission.CommitId); // get selected
var dir = TempDir.Get(repo);
var folder = dir.GetFolder();
return(new JsonNetResult(new { Folder = folder, Results = submission.PreSubmissionResults }));
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ActionResult ImportProject(ProjectImportPostData data)
{
var repo = _GetRepo(data);
if (repo == null)
{
return(new HttpNotFoundResult());
}
Repository sourceRepo = null;
int courseId = data.SourceCourseId > 0 ? data.SourceCourseId : data.CourseId;
if (data.SourceType == ImportableProjects.Types.PLAYGROUND)
{
string userName = String.IsNullOrWhiteSpace(data.SourceUserName) ? data.UserName : data.SourceUserName;
sourceRepo = PlaygroundRepository.Get(courseId, userName, data.SourceRepositoryId);
}
else if (data.SourceType == ImportableProjects.Types.WORKSPACE)
{
sourceRepo = WorkRepository.Get(courseId, data.UserName, data.SourceRepositoryId);
}
else if (data.SourceType == ImportableProjects.Types.SUBMISSION)
{
sourceRepo = SubmissionRepository.Get(courseId, data.UserName, data.SourceRepositoryId);
sourceRepo.Checkout();
}
if (sourceRepo == null)
{
return(new HttpNotFoundResult());
}
try
{
repo.Commit("Before Import Project");
repo.CopyFromRepository(sourceRepo);
repo.Commit("After Import Project");
return(Json("success"));
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.Message));
}
}
public async void TestGetByIdAsync()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "SubmissionDatabase")
.Options;
var dbContext = new ApplicationDbContext(options);
var repo = new SubmissionRepository(dbContext);
var json = "{id: 123}";
// Act
var newSubmission =
await repo.CreateAsync(new Submission { SavedDate = DateTime.Now, SubmissionJson = json });
var createdId = newSubmission.Id;
var searchResult = await repo.GetByIdAsync(createdId);
// Assert
Assert.True(createdId > 0 && searchResult.SubmissionJson == json);
}
public async void TestUpdateAsync()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "SubmissionDatabase")
.Options;
var dbContext = new ApplicationDbContext(options);
var repo = new SubmissionRepository(dbContext);
var newJson = "{id: 234}";
// Act
var newSubmission = await repo.CreateAsync(new Submission
{ SavedDate = DateTime.Now, SubmissionJson = "{id: 123}" });
var id = newSubmission.Id;
newSubmission.SubmissionJson = newJson;
var result = await repo.UpdateAsync(id, newSubmission) as Submission;
// Assert
Assert.True(result.SubmissionJson == newJson);
}
public void ShouldInsertInDbWhenValidSubmissionIsSupplied()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
//Act
#region Submission
var submission1 = new SubmissionTO
{
SessionId = 30,
AttendeeId = 1012,
Date = DateTime.Today,
Responses = new List <ResponseTO>()
};
var submission2 = new SubmissionTO
{
SessionId = 31,
AttendeeId = 2607,
Date = DateTime.Today,
Responses = new List <ResponseTO>()
};
var submissionAdded1 = submissionRepository.Add(submission1);
var submissionAdded2 = submissionRepository.Add(submission2);
memoryContext.SaveChanges();
#endregion
var result = submissionRepository.GetAll().FirstOrDefault(s => s.SessionId == 30);
//Assert
Assert.AreEqual(1012, result.AttendeeId);
}
}
public void AdddNewSubmissionThenRetrieveItIsNotNull()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
//Act
#region Submission
var submission1 = new SubmissionTO
{
SessionId = 30,
AttendeeId = 1012,
Date = DateTime.Today,
};
var submission2 = new SubmissionTO
{
SessionId = 31,
AttendeeId = 2607,
Date = DateTime.Today,
};
var submissionAdded1 = submissionRepository.Add(submission1);
var submissionAdded2 = submissionRepository.Add(submission2);
memoryContext.SaveChanges();
#endregion
var result = submissionRepository.GetById(submissionAdded2.Id);
//Assert
Assert.IsNotNull(result);
Assert.AreEqual(2607, result.AttendeeId);
}
}
public RedirectToActionResult AddSubmission(string name, string title, string story, string favTeam, string favQB)
{
if (story != null)
{
Submission submission = new Submission
{
SubmissionDate = DateTime.Now,
Title = title,
Story = story,
};
submission.Authors.Add(new Author
{
Name = name,
FavQB = favQB,
FavTeam = favTeam,
});
SubmissionRepository.AddSubmission(submission);
return(RedirectToAction("ReadStories"));
}
return(RedirectToAction("SubmitStories"));
}
public void AddSubmissionReturnsCorrectNumberOfSubmission()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
#region Submission
var submission1 = new SubmissionTO
{
SessionId = 30,
AttendeeId = 1012,
Date = DateTime.Today,
};
var submission2 = new SubmissionTO
{
SessionId = 31,
AttendeeId = 2607,
Date = DateTime.Today,
};
var submissionAdded1 = submissionRepository.Add(submission1);
var submissionAdded2 = submissionRepository.Add(submission2);
memoryContext.SaveChanges();
#endregion
//Act
var result = submissionRepository.GetAll();
var total = result.Count();
//Assert
Assert.AreEqual(2, total);
}
}
public async void TestDeleteAsync()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "SubmissionDatabase")
.Options;
var dbContext = new ApplicationDbContext(options);
var repo = new SubmissionRepository(dbContext);
// Act
var newSubmission = await repo.CreateAsync(new Submission
{ SavedDate = DateTime.Now, SubmissionJson = "{id: 123}" });
var createdId = newSubmission.Id;
await repo.DeleteAsync(createdId);
var searchResult = await repo.FindByAsync(x => x.Id == createdId);
if (searchResult.Count() == 0)
{
}
// Assert
Assert.True(createdId > 0 && searchResult.Count() == 0);
}
public QueryPendingHandler(SubmissionRepository submissions)
{
this.submissions = submissions;
}
public QueryStatusHandler(SubmissionRepository submissions)
{
this.submissions = submissions;
}
public SubmitForApprovalHandler(SubmissionRepository submissions)
{
this.submissions = submissions;
}
public SubmissionController()
{
_SubmissionRepository = new SubmissionRepository();
}
public RejectSubmissionHandler(SubmissionRepository submissions, IPublisher publisher)
{
this.submissions = submissions;
this.publisher = publisher;
}
public QueryAuditsHandler(SubmissionRepository submissions)
{
this.submissions = submissions;
}
public void Setup()
{
submissionRepository = new SubmissionRepository(base._DbContext);
}
public void UpdateReponseWithCorrectParameter()
{
var options = new DbContextOptionsBuilder <EvaluationContext>()
.UseInMemoryDatabase(databaseName: MethodBase.GetCurrentMethod().Name)
.Options;
using (var memoryContext = new EvaluationContext(options))
{
//Arrange
IFormRepository formRepository = new FormRepository(memoryContext);
IResponseRepository responseRepository = new ResponseRepository(memoryContext);
IQuestionRepository questionRepository = new QuestionRepository(memoryContext);
ISubmissionRepository submissionRepository = new SubmissionRepository(memoryContext);
IQuestionPropositionRepository questionPropositionRepository = new QuestionPropositionRepository(memoryContext);
#region Form
var Form1 = new FormTO
{
Name = new MultiLanguageString
(
"Daily evaluation form",
"Formulaire d'évaluation journalier",
"Dagelijks evaluatieformulier"
),
};
var formAdded1 = formRepository.Add(Form1);
memoryContext.SaveChanges();
#endregion
#region Questions
var Question1 = new QuestionTO
{
FormId = formAdded1.Id,
Position = 1,
Libelle = new MultiLanguageString
(
"What is your general impression after this first day of training ?",
"Quelle est votre impression générale après cette première journée de formation ?",
"Wat is je algemene indruk na deze eerste dag van training ?"
),
Type = QuestionType.SingleChoice,
};
var Question2 = new QuestionTO
{
FormId = formAdded1.Id,
Position = 2,
Libelle = new MultiLanguageString
(
"Is the pace right for you ?",
"Est-ce que le rythme vous convient ?",
"Is het tempo geschikt voor u ?"
),
Type = QuestionType.SingleChoice,
};
var Question3 = new QuestionTO
{
FormId = formAdded1.Id,
Position = 3,
Libelle = new MultiLanguageString
(
"Do you have questions related to the subject studied today ?",
"Avez-vous des questions relatives à la matière étudiée aujourd’hui ?",
"Heb je vragen over het onderwerp dat vandaag is bestudeerd ?"
),
Type = QuestionType.Open
};
var Question4 = new QuestionTO
{
FormId = formAdded1.Id,
Position = 4,
Libelle = new MultiLanguageString
(
"Do you have specific questions / particular topics that you would like deepen during this training ?",
"Avez-vous des questions spécifiques/sujets particuliers que vous aimeriez approfondir durant cette formation ?",
"Heeft u specifieke vragen / specifieke onderwerpen die u graag zou willen verdiepen tijdens deze training ?"
),
Type = QuestionType.Open
};
var Question5 = new QuestionTO
{
FormId = formAdded1.Id,
Position = 5,
Libelle = new MultiLanguageString
(
"What objectives do you pursue by following this training ?",
"Quels objectifs poursuivez-vous en suivant cette formation ?",
"Welke doelstellingen streeft u na door deze training te volgen?"
),
Type = QuestionType.Open
};
var questionAdded1 = questionRepository.Add(Question1);
var questionAdded2 = questionRepository.Add(Question2);
var questionAdded3 = questionRepository.Add(Question3);
var questionAdded4 = questionRepository.Add(Question4);
var questionAdded5 = questionRepository.Add(Question5);
memoryContext.SaveChanges();
#endregion
#region QuestionProposition
var QuestionProposition1 = new QuestionPropositionTO
{
QuestionId = questionAdded1.Id,
Libelle = new MultiLanguageString("good", "bonne", "goed"),
Position = 1
};
var QuestionProposition2 = new QuestionPropositionTO
{
QuestionId = questionAdded1.Id,
Libelle = new MultiLanguageString("medium", "moyenne", "gemiddelde"),
Position = 2
};
var QuestionProposition3 = new QuestionPropositionTO
{
QuestionId = questionAdded1.Id,
Libelle = new MultiLanguageString("bad", "mauvaise", "slecht"),
Position = 3
};
var QuestionProposition4 = new QuestionPropositionTO
{
QuestionId = questionAdded2.Id,
Libelle = new MultiLanguageString("yes", "oui", "ja"),
Position = 1
};
var QuestionProposition5 = new QuestionPropositionTO
{
QuestionId = questionAdded2.Id,
Libelle = new MultiLanguageString("too fast", "trop rapide", "te snel"),
Position = 2
};
var QuestionProposition6 = new QuestionPropositionTO
{
QuestionId = questionAdded2.Id,
Libelle = new MultiLanguageString("too slow", "trop lent", "te langzaam"),
Position = 3
};
var questionPropositionAdded1 = questionPropositionRepository.Add(QuestionProposition1);
var questionPropositionAdded2 = questionPropositionRepository.Add(QuestionProposition2);
var questionPropositionAdded3 = questionPropositionRepository.Add(QuestionProposition3);
var questionPropositionAdded4 = questionPropositionRepository.Add(QuestionProposition4);
var questionPropositionAdded5 = questionPropositionRepository.Add(QuestionProposition5);
var questionPropositionAdded6 = questionPropositionRepository.Add(QuestionProposition6);
memoryContext.SaveChanges();
#endregion
#region Submission
var submission1 = new SubmissionTO
{
SessionId = 30,
AttendeeId = 1012,
Date = DateTime.Today,
};
var submission2 = new SubmissionTO
{
SessionId = 31,
AttendeeId = 2607,
Date = DateTime.Today,
};
var submission3 = new SubmissionTO
{
SessionId = 2,
AttendeeId = 1612,
Date = DateTime.Today,
};
var submissionAdded1 = submissionRepository.Add(submission1);
var submissionAdded2 = submissionRepository.Add(submission2);
var submissionAdded3 = submissionRepository.Add(submission3);
memoryContext.SaveChanges();
#endregion
#region Responses
var response1 = new ResponseTO
{
Question = questionAdded1,
Submission = submissionAdded1,
QuestionProposition = questionPropositionAdded1,
};
var response2 = new ResponseTO
{
Question = questionAdded2,
Submission = submissionAdded2,
QuestionProposition = questionPropositionAdded2,
};
var response3 = new ResponseTO
{
Question = questionAdded3,
Submission = submissionAdded3,
Text = "Ceci est une réponse à une question ouverte",
//QuestionProposition = QuestionProposition3,
};
var response4 = new ResponseTO
{
Question = questionAdded4,
Submission = submissionAdded1,
Text = "Ceci est une réponse à une question ouverte",
};
//Assert
var responseAdded1 = responseRepository.Add(response1);
var responseAdded2 = responseRepository.Add(response2);
var responseAdded3 = responseRepository.Add(response3);
var responseAdded4 = responseRepository.Add(response4);
memoryContext.SaveChanges();
#endregion
//Act
var result1 = responseRepository.Remove(responseAdded1);
memoryContext.SaveChanges();
var submissionInjected = new SubmissionTO {
AttendeeId = 007, Date = DateTime.Now, SessionId = 36
};
var responseToUpadate = new ResponseTO
{
Id = responseAdded2.Id,
Question = questionAdded2,
Submission = submissionInjected,
QuestionProposition = questionPropositionAdded2,
};
var result = responseRepository.Update(responseToUpadate);
// Assert
Assert.IsTrue(result1);
Assert.AreEqual(36, result.Submission.SessionId);
}
}
public ApproveSubmissionsHandler(SubmissionRepository submissions, IPublisher publisher)
{
this.submissions = submissions;
this.publisher = publisher;
}
