public IEnumerable <RankDTO> GetAllRank()
{
var list = new RankDao().GetAll().Select(x => new RankDTO()
{
RMusicName = x.RMusicName,
SongOrMusic = x.SongOrMusic,
RMusicEnd = x.RMusicEnd,
RMusicStart = x.RMusicStart,
CateID = x.CateID,
ID = x.ID,
OldWeekRankId = x.OldWeekRankId,
});
var rankDtos = list.ToList();
foreach (var rankDto in rankDtos)
{
var data = new CategoryDao().GetCateById(rankDto.CateID);
rankDto.CategoryDto = new CategoryDTO()
{
ID = data.ID,
CateName = data.CateName,
};
}
return(rankDtos);
}
public List <RankDTO> GetListRankThisWeek()
{
int currentWeek = (DateTime.Now.DayOfYear / 7) + 1;
var data = new RankDao().GetAll().Where(x => x.RMusicEnd >= DateTime.Now).Select(x => new RankDTO()
{
ID = x.ID,
CateID = x.CateID,
RMusicStart = x.RMusicStart,
RMusicEnd = x.RMusicEnd,
RMusicName = x.RMusicName,
SongOrMusic = x.SongOrMusic,
OldWeekRankId = x.OldWeekRankId
}).ToList();
foreach (var rankDto in data)
{
rankDto.CategoryDto = new CategoryBus()
.GetAllListCategories()
.SingleOrDefault(x => x.ID == rankDto.CateID);
var musicdata = new MusicBus()
.GetListMusicAll()
.Where(x => x.CategoryDto.ID_root == rankDto.CateID && x.SongOrMV == rankDto.SongOrMusic)
.OrderByDescending(x => x.MusicView)
.Take(10)
.ToList();
foreach (var musicDto in musicdata)
{
musicDto.GradeRank = musicdata.IndexOf(musicDto) + 1;
}
rankDto.MusicDtos = musicdata;
}
return(data);
}
public RankDTO GetRankById(int id)
{
var data = new RankDao().GetById(id);
return(new RankDTO()
{
ID = data.ID,
CateID = data.CateID,
RMusicStart = data.RMusicStart,
RMusicEnd = data.RMusicEnd,
RMusicName = data.RMusicName,
SongOrMusic = data.SongOrMusic
});
}
