public List <SongDTO> SelectTopWorldSong()
{
SongDA songDA = new SongDA();
DataTable dt = null;
dt = songDA.GetData("SELECT_TOP_WORLD_SONG");
return(EntityHelper <SongDTO> .GetListObject(dt));
}
//public SongDTO GetSongByID(string songID)
//{
// SongDTO songDTO = new SongDTO();
// SongDA songDA = new SongDA();
// List<SqlParameter> list = new List<SqlParameter>();
// list.Add(new SqlParameter("@SongID", songID));
// return songDTO;
//}
public List <SongDTO> GetDefaultList(string user)
{
SongDA songDA = new SongDA();
DataTable dt = null;
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@UserID", user));
dt = songDA.GetData("SELECT_DEFAULT_LIST", list);
return(EntityHelper <SongDTO> .GetListObject(dt));
}
public bool CheckUser(string user)
{
SongDA songDA = new SongDA();
DataTable dt = null;
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@UserID", user));
dt = songDA.GetData("CHECK_USER_EXIST", list);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public string GetSongUrlByID(string songID)
{
string path = String.Empty;
SongDA songDA = new SongDA();
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@SongID", songID));
DataTable dt = songDA.GetData("SELECT_DIRECTORY_PATH_BY_ID", list);
path = dt.Rows[0][0].ToString();
if (String.IsNullOrEmpty(path))
{
System.Diagnostics.Debug.WriteLine("FUCKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK");
}
else
{
System.Diagnostics.Debug.WriteLine(path + "*********************");
}
return(path);
}