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}'); "); }