public ActionResult Filter(FormCollection formCollection)
{
var searchfieldid = formCollection.Get("SearchType");
var searchfield = formCollection.Get("SearchString");
var musics = MusicService.GetAll().Select(music => new MusicModel()
{
Id = music.Id,
Name = music.Name,
Path = music.Path,
SingerName = SingerService.GetById(music.SingerId).Name,
GenreName = GenreService.GetById(music.GenreId).Name
}).ToList();
switch (searchfieldid)
{
case "0":
musics = musics.Where(x => x.Name.ToLower().Contains(searchfield.ToLower())).ToList();
break;
case "1":
musics = musics.Where(x => x.SingerName.ToLower().Contains(searchfield.ToLower())).ToList();
break;
case "2":
musics = musics.Where(x => x.GenreName.ToLower().Contains(searchfield.ToLower())).ToList();
break;
}
return(View("MusicView", musics));
}
public void GetSingerDetailWithNull()
{
var singersRepository = new Mock <ISingersRepository>();
var singerService = new SingerService(singersRepository.Object);
var result = singerService.GetSingerDetailsByAlbumId(4);
Assert.IsNull(result);
}
public void Task_Get_With_Relation_Return_NotEqual()
{
var factory = new ConnectionFactory();
var context = factory.CreateContextForSQLite();
for (int i = 1; i < 4; i++)
{
var singers = new Singers()
{
SingerId = i,
SingerName = "Category " + i,
SingerReview = "good one",
IsActive = true,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
CreatedBy = 1,
ModifiedBy = 1
};
context.Singers.Add(singers);
}
for (int i = 1; i < 4; i++)
{
var album = new Albums()
{
AlbumId = i,
AlbumName = "Category " + i,
AlbumImagPath = "../Test/Image.png",
AlbumPrice = 1,
AlbumReleaseDate = DateTime.Now,
IsActive = true,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
CreatedBy = 1,
ModifiedBy = 1
};
context.Albums.Add(album);
}
for (int i = 1; i < 4; i++)
{
var singerAlbum = new SingerAlbumLinks()
{
SingerAlbumId = i,
SingerId = i,
AlbumId = 2,
};
context.SingerAlbumLinks.Add(singerAlbum);
}
context.SaveChanges();
var singerRepo = new SingersRepository(context);
var singerService = new SingerService(singerRepo);
var result = singerService.GetSingerDetailsByAlbumId(4);
Assert.NotEqual(3, result.Count);
}
public ActionResult MusicViewSearch(string sText, string sType)
{
var musics = MusicService.GetAll().Select(music => new MusicModel()
{
Id = music.Id,
Name = music.Name,
Path = music.Path,
SingerName = SingerService.GetById(music.SingerId).Name,
GenreName = GenreService.GetById(music.GenreId).Name
}).ToList();
return(View("MusicView", musics));
}
public ActionResult Create()
{
MusicChangeModel.GetSingerSelectItems =
SingerService.GetAll().Select(m => new SelectListItem()
{
Text = m.Name, Value = m.Id
});
MusicChangeModel.GetGenreSelectItems =
GenreService.GetAll().Select(m => new SelectListItem()
{
Text = m.Name, Value = m.Id
});
return(View());
}
public ActionResult MusicViewInPlaylist(string playlistId)
{
var t = User.Identity.GetUserId();
var musics = PlaylistService.GetById(playlistId).Musics;
List <MusicDTO> d = musics.Select(m => MusicService.GetById(m.Id)).ToList();
var musicс = d.Select(music => new MusicModel()
{
Id = music.Id,
Name = music.Name,
Path = music.Path,
SingerName = SingerService.GetById(music.SingerId).Name,
GenreName = GenreService.GetById(music.GenreId).Name
}).ToList();
musicс.First().PlaylistName = PlaylistService.GetById(playlistId).Name;
return(View(musicс));
}
public ActionResult Edit(string id)
{
var music = MusicService.GetById(id);
MusicChangeModel.GetSingerSelectItems =
SingerService.GetAll().Select(m => new SelectListItem()
{
Text = m.Name, Value = m.Id
});
MusicChangeModel.GetGenreSelectItems =
GenreService.GetAll().Select(m => new SelectListItem()
{
Text = m.Name, Value = m.Id
});
MusicChangeModel gm = new MusicChangeModel()
{
Id = music.Id,
Name = music.Name,
SingerId = music.SingerId,
GenreId = music.GenreId
};
return(View(gm));
}
/// <summary>
/// 更新指定id的歌手信息
/// </summary>
/// <param name="singerID"></param>
/// <returns></returns>
public static int updateId(Singer sin)
{
return(SingerService.updateId(sin));
}
/// <summary>
/// 添加歌手
/// </summary>
/// <param name="sin"></param>
/// <returns></returns>
public static int addSinger(Singer sin)
{
return(SingerService.insertSinger(sin));
}
public static DataTable selectAllCgroupsi()
{
return(SingerService.allCgroupsinger());
}
/// <summary>
/// 删除指定id的歌手信息
/// </summary>
/// <param name="singerID"></param>
/// <returns></returns>
public static int deleteID(int singerID)
{
return(SingerService.deleteID(singerID));
}
/// <summary>
/// 热门前12
/// </summary>
/// <returns></returns>
public static DataTable selectTop12()
{
return(SingerService.selectTop12Hotsin());
}
/// <summary>
/// 查询点击量排名前5
/// </summary>
/// <returns></returns>
public static DataTable selectTop5()
{
return(SingerService.selectTop5());
}
public static DataTable selectAll()
{
return(SingerService.selectall());
}
/// <summary>
/// 返回查询歌曲表id
/// </summary>
/// <param name="singerID"></param>
/// <returns></returns>
public static DataTable selectID(int singerID)
{
return(SingerService.selectID(singerID));
}
/// <summary>
/// 点击一次歌手图片，人气值+1
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int updateClickNum(int id)
{
return(SingerService.updateClickNum(id));
}
