public ObterPlayListParaEditResponse ObterPlayEdit(ObterPlayListParaEditRequest pObterPlayListParaEditRequest)
{
try
{
var pList = _canalIlhasDAL.ObterPlayEdit(pObterPlayListParaEditRequest);
return(new ObterPlayListParaEditResponse {
PlayList = pList
});
}
catch (Exception)
{
throw;
}
}
public IEnumerable <PlayListDTO> ObterPlayEdit(ObterPlayListParaEditRequest pObterPlayListParaEditRequest)
{
//Int64 a = 1;
using (OracleConnection conexao = new OracleConnection(_configuration.GetConnectionString("DESENV")))
{
return(conexao.Query <PlayListDTO>(
"SELECT CP.ID_PLAYLIST, CP.NM_PLAYLIST, CP.FL_PLAYLIST_ATIVO, " +
"CUP.ID_UPLOAD_PLAYLIST, CUP.CD_ARQUIVO_UPLOAD, CUP.NU_ORDEM_EXIBICAO, " +
"CAU.ID_ARQUIVO_UPLOAD, CAU.NM_ARQUIVO_UPLOAD " +
"FROM TB_CILHAS_PLAYLIST CP " +
"JOIN TB_CILHAS_UPLOAD_PLAYLIST CUP ON CP.ID_PLAYLIST = CUP.CD_PLAYLIST " +
"JOIN TB_CILHAS_ARQUIVO_UPLOAD CAU ON CAU.ID_ARQUIVO_UPLOAD = CUP.CD_ARQUIVO_UPLOAD " +
"WHERE ID_PLAYLIST = :ID_PLAYLIST ",
new { ID_PLAYLIST = pObterPlayListParaEditRequest.IdPlayList }));
}
}
public ObterPlayListParaEditResponse ObterPlayEdit(ObterPlayListParaEditRequest pObterPlayListParaEditRequest)
{
return(_canalIlhasService.ObterPlayEdit(pObterPlayListParaEditRequest));
}
public ObterPlayListParaEditResponse ObterPlayEdit(ObterPlayListParaEditRequest pObterPlayListParaEditRequest)
{
return(Http.Getp <ObterPlayListParaEditResponse>("v1/api/CanalIlhas/ObterPlayEdit", pObterPlayListParaEditRequest));
}
