public async Task <int> Count(University_Majors_SubjectGroupFilter university_Majors_SubjectGroupFilter) { IQueryable <University_Majors_SubjectGroupDAO> university_Majors_SubjectGroupDAOs = eMSContext.University_Majors_SubjectGroup; university_Majors_SubjectGroupDAOs = DynamicFilter(university_Majors_SubjectGroupDAOs, university_Majors_SubjectGroupFilter); return(await university_Majors_SubjectGroupDAOs.CountAsync()); }
public async Task <List <University_Majors_SubjectGroupDTO> > List([FromBody] University_Majors_SubjectGroupFilterDTO University_Majors_SubjectFilterDTO) { University_Majors_SubjectGroupFilter University_Majors_SubjectFilter = new University_Majors_SubjectGroupFilter { University_MajorsId = University_Majors_SubjectFilterDTO.University_MajorsId, UniversityId = University_Majors_SubjectFilterDTO.UniversityId, UniversityCode = University_Majors_SubjectFilterDTO.UniversityCode, UniversityName = University_Majors_SubjectFilterDTO.UniversityName, MajorsId = University_Majors_SubjectFilterDTO.MajorsId, MajorsCode = University_Majors_SubjectFilterDTO.MajorsCode, MajorsName = University_Majors_SubjectFilterDTO.MajorsName, SubjectGroupId = University_Majors_SubjectFilterDTO.SubjectGroupId, SubjectGroupCode = University_Majors_SubjectFilterDTO.SubjectGroupCode, Benchmark = University_Majors_SubjectFilterDTO.Benchmark, Year = University_Majors_SubjectFilterDTO.Year, Skip = University_Majors_SubjectFilterDTO.Skip, Take = University_Majors_SubjectFilterDTO.Take, OrderType = University_Majors_SubjectFilterDTO.OrderType, OrderBy = University_Majors_SubjectFilterDTO.OrderBy }; List <University_Majors_SubjectGroup> University_Majors_Subjects = await University_Majors_SubjectGroupService.List(University_Majors_SubjectFilter); List <University_Majors_SubjectGroupDTO> University_Majors_SubjectDTOs = University_Majors_Subjects.Select(u => new University_Majors_SubjectGroupDTO(u)).ToList(); return(University_Majors_SubjectDTOs); }
public async Task <List <University_Majors_SubjectGroupDTO> > List([FromBody] University_Majors_SubjectGroupFilterDTO University_Majors_SubjectFilterDTO) { University_Majors_SubjectGroupFilter University_Majors_SubjectFilter = new University_Majors_SubjectGroupFilter { University_MajorsId = University_Majors_SubjectFilterDTO.University_MajorsId, UniversityId = University_Majors_SubjectFilterDTO.UniversityId, UniversityCode = new StringFilter { StartsWith = University_Majors_SubjectFilterDTO.UniversityCode }, UniversityName = new StringFilter { Contains = University_Majors_SubjectFilterDTO.UniversityName }, MajorsId = University_Majors_SubjectFilterDTO.MajorsId, MajorsCode = new StringFilter { StartsWith = University_Majors_SubjectFilterDTO.MajorsCode }, MajorsName = new StringFilter { Contains = University_Majors_SubjectFilterDTO.MajorsName }, SubjectGroupId = University_Majors_SubjectFilterDTO.SubjectGroupId, SubjectGroupCode = new StringFilter { StartsWith = University_Majors_SubjectFilterDTO.SubjectGroupCode }, Benchmark = new DoubleFilter { LessEqual = University_Majors_SubjectFilterDTO.Benchmark }, Year = new StringFilter { Equal = University_Majors_SubjectFilterDTO.Year }, Skip = University_Majors_SubjectFilterDTO.Skip, Take = int.MaxValue, OrderType = OrderType.DESC, OrderBy = University_Majors_SubjectGroupOrder.Benchmark }; List <University_Majors_SubjectGroup> University_Majors_Subjects = await University_Majors_SubjectGroupService.List(University_Majors_SubjectFilter); List <University_Majors_SubjectGroupDTO> University_Majors_SubjectDTOs = University_Majors_Subjects.Select(u => new University_Majors_SubjectGroupDTO { Id = u.Id, MajorsId = u.MajorsId, MajorsCode = u.MajorsCode, MajorsName = u.MajorsName, UniversityId = u.UniversityId, UniversityCode = u.UniversityCode, UniversityName = u.UniversityName, University_MajorsId = u.University_MajorsId, SubjectGroupId = u.SubjectGroupId, SubjectGroupCode = u.SubjectGroupCode, SubjectGroupName = u.SubjectGroupName, Benchmark = u.Benchmark, Quantity = u.Quantity, Note = u.Note, Year = u.Year }).ToList(); return(University_Majors_SubjectDTOs); }
public async Task <List <University_Majors_SubjectGroup> > List(University_Majors_SubjectGroupFilter university_Majors_SubjectGroupFilter) { if (university_Majors_SubjectGroupFilter == null) { return(new List <University_Majors_SubjectGroup>()); } IQueryable <University_Majors_SubjectGroupDAO> university_Majors_SubjectGroupDAOs = eMSContext.University_Majors_SubjectGroup; university_Majors_SubjectGroupDAOs = DynamicFilter(university_Majors_SubjectGroupDAOs, university_Majors_SubjectGroupFilter); university_Majors_SubjectGroupDAOs = DynamicOrder(university_Majors_SubjectGroupDAOs, university_Majors_SubjectGroupFilter); var university_Majors_SubjectGroups = await DynamicSelect(university_Majors_SubjectGroupDAOs); return(university_Majors_SubjectGroups); }
private async Task <bool> DuplicateValidation(University_Majors_SubjectGroup university_Majors_SubjectGroup) { University_Majors_SubjectGroupFilter filter = new University_Majors_SubjectGroupFilter { SubjectGroupId = university_Majors_SubjectGroup.SubjectGroupId, University_MajorsId = university_Majors_SubjectGroup.University_MajorsId }; if (await UOW.University_Majors_SubjectGroupRepository.Count(filter) > 0) { university_Majors_SubjectGroup.AddError(nameof(University_Majors_SubjectGroupValidator), nameof(university_Majors_SubjectGroup), ErrorCode.Duplicate); } return(university_Majors_SubjectGroup.IsValidated); }
public async Task <List <University_Majors_SubjectGroup> > List(University_Majors_SubjectGroupFilter university_Majors_SubjectGroupFilter) { return(await UOW.University_Majors_SubjectGroupRepository.List(university_Majors_SubjectGroupFilter)); }
private IQueryable <University_Majors_SubjectGroupDAO> DynamicOrder(IQueryable <University_Majors_SubjectGroupDAO> query, University_Majors_SubjectGroupFilter university_Majors_SubjectGroupFilter) { switch (university_Majors_SubjectGroupFilter.OrderType) { case OrderType.ASC: switch (university_Majors_SubjectGroupFilter.OrderBy) { case University_Majors_SubjectGroupOrder.SubjectGroupCode: query = query.OrderBy(q => q.SubjectGroup.Code); break; case University_Majors_SubjectGroupOrder.Benchmark: query = query.OrderBy(q => q.Benchmark); break; case University_Majors_SubjectGroupOrder.MajorsCode: query = query.OrderBy(q => q.University_Majors.Majors.Code); break; default: query = query.OrderBy(q => q.Id); break; } break; case OrderType.DESC: switch (university_Majors_SubjectGroupFilter.OrderBy) { case University_Majors_SubjectGroupOrder.SubjectGroupCode: query = query.OrderByDescending(q => q.SubjectGroup.Code); break; case University_Majors_SubjectGroupOrder.Benchmark: query = query.OrderByDescending(q => q.Benchmark); break; case University_Majors_SubjectGroupOrder.MajorsCode: query = query.OrderByDescending(q => q.University_Majors.Majors.Code); break; default: query = query.OrderByDescending(q => q.Id); break; } break; default: query = query.OrderBy(q => q.Id); break; } query = query.Skip(university_Majors_SubjectGroupFilter.Skip).Take(university_Majors_SubjectGroupFilter.Take); return(query); }
private IQueryable <University_Majors_SubjectGroupDAO> DynamicFilter(IQueryable <University_Majors_SubjectGroupDAO> query, University_Majors_SubjectGroupFilter university_Majors_SubjectGroupFilter) { if (university_Majors_SubjectGroupFilter == null) { return(query.Where(q => 1 == 0)); } if (university_Majors_SubjectGroupFilter.University_MajorsId != null) { query = query.Where(q => q.University_MajorsId, university_Majors_SubjectGroupFilter.University_MajorsId); } if (university_Majors_SubjectGroupFilter.UniversityId != null) { query = query.Where(q => q.University_Majors.UniversityId, university_Majors_SubjectGroupFilter.UniversityId); } if (university_Majors_SubjectGroupFilter.MajorsId != null) { query = query.Where(q => q.University_Majors.MajorsId, university_Majors_SubjectGroupFilter.MajorsId); } if (university_Majors_SubjectGroupFilter.SubjectGroupId != null) { query = query.Where(q => q.SubjectGroupId, university_Majors_SubjectGroupFilter.SubjectGroupId); } if (university_Majors_SubjectGroupFilter.UniversityCode != null) { query = query.Where(q => q.University_Majors.University.Code, university_Majors_SubjectGroupFilter.UniversityCode); } if (university_Majors_SubjectGroupFilter.UniversityName != null) { query = query.Where(q => q.University_Majors.University.Name, university_Majors_SubjectGroupFilter.UniversityName); } if (university_Majors_SubjectGroupFilter.MajorsCode != null) { query = query.Where(q => q.University_Majors.Majors.Code, university_Majors_SubjectGroupFilter.MajorsCode); } if (university_Majors_SubjectGroupFilter.MajorsName != null) { query = query.Where(q => q.University_Majors.Majors.Name, university_Majors_SubjectGroupFilter.MajorsName); } if (university_Majors_SubjectGroupFilter.SubjectGroupCode != null) { query = query.Where(q => q.SubjectGroup.Code, university_Majors_SubjectGroupFilter.SubjectGroupCode); } if (university_Majors_SubjectGroupFilter.Benchmark != null) { query = query.Where(q => q.Benchmark, university_Majors_SubjectGroupFilter.Benchmark); } if (university_Majors_SubjectGroupFilter.Year != null) { query = query.Where(q => q.University_Majors.Year.Equals(university_Majors_SubjectGroupFilter.Year)); } return(query); }