public async Task <int> Count(University_MajorsFilter university_MajorsFilter) { IQueryable <University_MajorsDAO> university_MajorsDAOs = eMSContext.University_Majors; university_MajorsDAOs = DynamicFilter(university_MajorsDAOs, university_MajorsFilter); return(await university_MajorsDAOs.CountAsync()); }
public async Task <List <University_Majors> > List(University_MajorsFilter university_MajorsFilter) { if (university_MajorsFilter == null) { return(new List <University_Majors>()); } IQueryable <University_MajorsDAO> university_MajorsDAOs = eMSContext.University_Majors; university_MajorsDAOs = DynamicFilter(university_MajorsDAOs, university_MajorsFilter); university_MajorsDAOs = DynamicOrder(university_MajorsDAOs, university_MajorsFilter); var university_Majorss = await DynamicSelect(university_MajorsDAOs); return(university_Majorss); }
public async Task <List <University_MajorsDTO> > List([FromBody] University_MajorsFilterDTO university_MajorsFilterDTO) { University_MajorsFilter university_MajorsFilter = new University_MajorsFilter { UniversityId = university_MajorsFilterDTO.UniversityId, UniversityCode = new StringFilter { StartsWith = university_MajorsFilterDTO.UniversityCode }, UniversityName = new StringFilter { Contains = university_MajorsFilterDTO.UniversityName }, MajorsId = university_MajorsFilterDTO.MajorsId, MajorsCode = new StringFilter { StartsWith = university_MajorsFilterDTO.MajorsCode }, MajorsName = new StringFilter { Contains = university_MajorsFilterDTO.MajorsName }, Year = new StringFilter { Equal = university_MajorsFilterDTO.Year }, Skip = university_MajorsFilterDTO.Skip, Take = int.MaxValue, OrderType = OrderType.DESC, OrderBy = University_MajorsOrder.MajorsName }; List <University_Majors> universities = await university_MajorsService.List(university_MajorsFilter); List <University_MajorsDTO> university_MajorsDTOs = universities.Select(u => new University_MajorsDTO { Id = u.Id, MajorsId = u.MajorsId, MajorsCode = u.MajorsCode, MajorsName = u.MajorsName, UniversityId = u.UniversityId, UniversityCode = u.UniversityCode, UniversityName = u.UniversityName, UniversityAddress = u.UniversityAddress, Year = u.Year, }).ToList(); return(university_MajorsDTOs); }
private async Task <bool> CodeValidate(University_Majors university_Majors) { //Kiểm tra Code nhập vào đã tồn tại trong Db chưa University_MajorsFilter filter = new University_MajorsFilter { MajorsId = university_Majors.MajorsId, UniversityId = university_Majors.UniversityId, Year = new StringFilter { Equal = university_Majors.Year } }; var count = await UOW.University_MajorsRepository.Count(filter); if (count > 0) { university_Majors.AddError(nameof(University_MajorsValidator), nameof(university_Majors.MajorsName), ErrorCode.Duplicate); } return(university_Majors.IsValidated); }
public async Task <List <University_MajorsDTO> > List([FromBody] University_MajorsFilterDTO university_MajorsFilterDTO) { University_MajorsFilter university_MajorsFilter = new University_MajorsFilter { UniversityId = university_MajorsFilterDTO.UniversityId, UniversityCode = university_MajorsFilterDTO.UniversityCode, UniversityName = university_MajorsFilterDTO.UniversityName, MajorsId = university_MajorsFilterDTO.MajorsId, MajorsCode = university_MajorsFilterDTO.MajorsCode, MajorsName = university_MajorsFilterDTO.MajorsName, Year = university_MajorsFilterDTO.Year, Skip = university_MajorsFilterDTO.Skip, Take = university_MajorsFilterDTO.Take, OrderType = university_MajorsFilterDTO.OrderType, OrderBy = university_MajorsFilterDTO.OrderBy }; List <University_Majors> universities = await university_MajorsService.List(university_MajorsFilter); List <University_MajorsDTO> university_MajorsDTOs = universities.Select(u => new University_MajorsDTO(u)).ToList(); return(university_MajorsDTOs); }
private IQueryable <University_MajorsDAO> DynamicOrder(IQueryable <University_MajorsDAO> query, University_MajorsFilter university_MajorsFilter) { switch (university_MajorsFilter.OrderType) { case OrderType.ASC: switch (university_MajorsFilter.OrderBy) { case University_MajorsOrder.MajorsCode: query = query.OrderBy(q => q.Majors.Code); break; case University_MajorsOrder.MajorsName: query = query.OrderBy(q => q.Majors.Name); break; case University_MajorsOrder.UniversityCode: query = query.OrderBy(q => q.University.Code); break; case University_MajorsOrder.UniversityName: query = query.OrderBy(q => q.University.Name); break; case University_MajorsOrder.Year: query = query.OrderBy(q => q.Year); break; default: query = query.OrderBy(q => q.Id); break; } break; case OrderType.DESC: switch (university_MajorsFilter.OrderBy) { case University_MajorsOrder.MajorsCode: query = query.OrderByDescending(q => q.Majors.Code); break; case University_MajorsOrder.MajorsName: query = query.OrderByDescending(q => q.Majors.Name); break; case University_MajorsOrder.UniversityCode: query = query.OrderByDescending(q => q.University.Code); break; case University_MajorsOrder.UniversityName: query = query.OrderByDescending(q => q.University.Name); break; case University_MajorsOrder.Year: query = query.OrderByDescending(q => q.Year); break; default: query = query.OrderByDescending(q => q.Id); break; } break; default: query = query.OrderBy(q => q.Id); break; } query = query.Skip(university_MajorsFilter.Skip).Take(university_MajorsFilter.Take); return(query); }
private IQueryable <University_MajorsDAO> DynamicFilter(IQueryable <University_MajorsDAO> query, University_MajorsFilter university_MajorsFilter) { if (university_MajorsFilter == null) { return(query.Where(q => 1 == 0)); } if (university_MajorsFilter.Year != null) { query = query.Where(q => q.Year.Equals(university_MajorsFilter.Year)); } if (university_MajorsFilter.UniversityId != null) { query = query.Where(q => q.UniversityId, university_MajorsFilter.UniversityId); } if (university_MajorsFilter.MajorsId != null) { query = query.Where(q => q.MajorsId, university_MajorsFilter.MajorsId); } if (university_MajorsFilter.MajorsCode != null) { query = query.Where(q => q.Majors.Code, university_MajorsFilter.MajorsCode); } if (university_MajorsFilter.MajorsName != null) { query = query.Where(q => q.Majors.Name, university_MajorsFilter.MajorsName); } if (university_MajorsFilter.UniversityCode != null) { query = query.Where(q => q.University.Code, university_MajorsFilter.UniversityCode); } if (university_MajorsFilter.UniversityName != null) { query = query.Where(q => q.University.Name, university_MajorsFilter.UniversityName); } return(query); }
public async Task <List <University_Majors> > List(University_MajorsFilter university_MajorsFilter) { return(await UOW.University_MajorsRepository.List(university_MajorsFilter)); }