public CourseArchiveResponseDTO CreateCourseArchive(CreateCourseArchiveRequestDTO request)
{
CourseArchive archive = this._autoMapper.Map <CourseArchive>(request);
archive.subject = new Subject()
{
uuid = request.subjectUUID
};
archive.moderator = new Teacher()
{
uuid = request.moderatorUUID
};
archive = this._queryExecutor.Execute <CourseArchive>(DatabaseConsts.USER_SCHEMA, this._sqlCommands.CREATE_COURSE_ARCHIVE(archive), this._modelMapper.MapToCourseArchive);
return(this._autoMapper.Map <CourseArchiveResponseDTO>(archive));
}
public ActionResult GetCourseTeasers(string pageNumber, string referenceCourseItemIDs)
{
CourseArchive viewModel = new CourseArchive();
try
{
bool showPrevButton = false;
bool showNextButton = false;
viewModel.CourseTeasers = GetCoursesByPage(string.Empty, pageNumber, referenceCourseItemIDs, out showPrevButton, out showNextButton);
if (viewModel.CourseTeasers != null && viewModel.CourseTeasers.Count > 0)
{
viewModel.FirstAndLastCourseItemIDsInPage = viewModel.CourseTeasers.FirstOrDefault().InnerItem.ID.ToString() + "," + viewModel.CourseTeasers.LastOrDefault().InnerItem.ID.ToString();
viewModel.ShowPreviousButton = showPrevButton;
viewModel.ShowNextButton = showNextButton;
}
}
catch (System.Exception ex)
{
LogManager.SaveLog(System.Reflection.MethodBase.GetCurrentMethod().ReflectedType.Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name, ex, LogManager.LogTypes.Error, string.Empty);
}
return(PartialView(GlobalConstants.SUBLAYOUTS_PATH + "PageContent/_CourseTeasersListing.cshtml", viewModel));
}
public string CREATE_COURSE_ARCHIVE(CourseArchive courseArchive)
{
return($"insert into SAUP_COURSE.CourseArchive(courseUUID, name, description, active, maxStudents, minStudents, creationDate, subjectUUID, moderatorUUID, changeDate) " +
$"values('{courseArchive.courseUUID}', '{courseArchive.name}', '{courseArchive.description}', {boolToInt(courseArchive.active)}, {courseArchive.maxStudents}, " +
$"{courseArchive.minStudents}, '{courseArchive.creationDate}', '{courseArchive.subject.uuid}', '{courseArchive.moderator.uuid}', '{courseArchive.changeDate}'); ");
}
