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