public async Task <ViewModels.ActiveCourseSummary> GetActiveCourseSummary(int id) { var course = new ViewModels.ActiveCourse(); var dbcourse = await context.ViewCourseNotificationEnableds.Where(q => q.Id == id).Select(q => new { q.Total, q.Passed, q.Failed, q.Registered, q.Pending, q.Attended, q.Canceled }).FirstAsync(); var dto = new ViewModels.ActiveCourseSummary() { Attended = dbcourse.Attended, Canceled = dbcourse.Canceled, Registered = dbcourse.Registered, Pending = dbcourse.Pending, Failed = dbcourse.Failed, Passed = dbcourse.Passed, Total = dbcourse.Total, }; return(dto); }
public async Task <ViewModels.ActiveCourse> GetActiveCourseDto(int id) { var course = new ViewModels.ActiveCourse(); var dbcourse = await context.ViewCourseNotificationEnableds.FirstOrDefaultAsync(q => q.Id == id); ViewModels.ActiveCourse.FillDto(dbcourse, course); course.ApplicablePeople = await context.ViewApplicableCoursePersons.Where(q => q.CourseId == course.Id).ToListAsync(); return(course); }
public static void FillDto(Models.ViewCourseNotificationEnabled entity, ViewModels.ActiveCourse activeCourse) { activeCourse.Id = entity.Id; activeCourse.No = entity.No; activeCourse.IsNotificationEnabled = entity.IsNotificationEnabled; activeCourse.CourseTypeId = entity.CourseTypeId; activeCourse.DateStart = entity.DateStart; activeCourse.DateStartP = entity.DateStartP; activeCourse.DateEnd = entity.DateEnd; activeCourse.DateEndP = entity.DateEndP; activeCourse.Instructor = entity.Instructor; activeCourse.Location = entity.Location; activeCourse.Department = entity.Department; activeCourse.OrganizationId = entity.OrganizationId; activeCourse.Duration = entity.Duration; activeCourse.DurationUnitId = entity.DurationUnitId; activeCourse.StatusId = entity.StatusId; activeCourse.Remark = entity.Remark; activeCourse.Capacity = entity.Capacity; activeCourse.Tuition = entity.Tuition; activeCourse.CurrencyId = entity.CurrencyId; activeCourse.DateDeadlineRegistration = entity.DateDeadlineRegistration; activeCourse.DateDeadlineRegistrationP = entity.DateDeadlineRegistrationP; activeCourse.TrainingDirector = entity.TrainingDirector; activeCourse.Title = entity.Title; activeCourse.AircraftTypeId = entity.AircraftTypeId; activeCourse.AircraftModelId = entity.AircraftModelId; activeCourse.CaoTypeId = entity.CaoTypeId; activeCourse.Recurrent = entity.Recurrent; activeCourse.Interval = entity.Interval; activeCourse.CalanderTypeId = entity.CalanderTypeId; activeCourse.IsInside = entity.IsInside; activeCourse.Quarantine = entity.Quarantine; activeCourse.DateStartPractical = entity.DateStartPractical; activeCourse.DateEndPractical = entity.DateEndPractical; activeCourse.DateStartPracticalP = entity.DateStartPracticalP; activeCourse.DateEndPracticalP = entity.DateEndPracticalP; activeCourse.DurationPractical = entity.DurationPractical; activeCourse.DurationPracticalUnitId = entity.DurationPracticalUnitId; activeCourse.CT_CalendarTypeId = entity.CT_CalendarTypeId; activeCourse.CT_Title = entity.CT_Title; activeCourse.CT_LicenseResultBasicId = entity.CT_LicenseResultBasicId; activeCourse.CT_Remark = entity.CT_Remark; activeCourse.CT_CourseCategoryId = entity.CT_CourseCategoryId; activeCourse.CT_Interval = entity.CT_Interval; activeCourse.CT_IsGeneral = entity.CT_IsGeneral; activeCourse.CT_Status = entity.CT_Status; activeCourse.CT_Id = entity.CT_Id; activeCourse.CC_Title = entity.CC_Title; activeCourse.CaoTypeTitle = entity.CaoTypeTitle; activeCourse.CaoTypeRemark = entity.CaoTypeRemark; activeCourse.Organization = entity.Organization; activeCourse.DurationUnit = entity.DurationUnit; activeCourse.Duration2 = entity.Duration2; activeCourse.Status = entity.Status; activeCourse.Currency = entity.Currency; activeCourse.AircraftType = entity.AircraftType; activeCourse.Manufacturer = entity.Manufacturer; activeCourse.ManufacturerId = entity.ManufacturerId; activeCourse.AircraftModel = entity.AircraftModel; activeCourse.CalendarType = entity.CalendarType; activeCourse.DurationPracticalUnit = entity.DurationPracticalUnit; activeCourse.Remain = entity.Remain; activeCourse.ExpireDate = entity.ExpireDate; activeCourse.IsGeneral = entity.IsGeneral; activeCourse.CustomerId = entity.CustomerId; activeCourse.RemainRegistration = entity.RemainRegistration; activeCourse.Total = entity.Total; activeCourse.Pending = entity.Pending; activeCourse.Registered = entity.Registered; activeCourse.Attended = entity.Attended; activeCourse.Canceled = entity.Canceled; activeCourse.Failed = entity.Failed; activeCourse.Passed = entity.Passed; }