public InserirPlayListResponse InserirPlayList(InserirPlayListRequest pInserirPlayListRequest)
{
try
{
var inserirPlayList = _canalIlhasDAL.InserirPlayList(pInserirPlayListRequest);
return(new InserirPlayListResponse {
Mensagem = MensagensService.SUCESSO
});
}
catch (Exception e)
{
throw;
}
}
public Int64 InserirPlayList(InserirPlayListRequest pInserir)
{
using (OracleConnection conexao = new OracleConnection(_configuration.GetConnectionString("DESENV")))
{
var sSql = "SELECT SQ_CILHAS_PLAYLIST.NEXTVAL FROM DUAL";
Int64 SQ = Convert.ToInt32(conexao.QueryFirstOrDefault <Int64>(sSql, null));
//sSql = "SELECT SQ_CILHAS_UPLOAD_PLAYLIST.NEXTVAL FROM DUAL";
//Int64 SQRel = Convert.ToInt32(conexao.QueryFirstOrDefault<Int64>(sSql, null));
conexao.Open();
OracleCommand command = conexao.CreateCommand();
OracleTransaction transaction = conexao.BeginTransaction();
try
{
sSql = "INSERT INTO TB_CILHAS_PLAYLIST(ID_PLAYLIST, NM_PLAYLIST, TP_PLAYLIST, NM_CAS) values(:ID_PLAYLIST, :NM_PLAYLIST, :TP_PLAYLIST, :NM_CAS)";
var pTranparameters = new { ID_PLAYLIST = SQ, NM_PLAYLIST = pInserir.PlayList.NM_PLAYLIST, TP_PLAYLIST = pInserir.PlayList.TP_PLAYLIST, NM_CAS = pInserir.PlayList.NM_CAS };
conexao.Execute(sSql, pTranparameters, transaction);
var arquivosParaUpload = pInserir.PlayList.TP_PLAYLIST.Split(",");
foreach (var aUpload in arquivosParaUpload)
{
sSql = "INSERT INTO TB_CILHAS_UPLOAD_PLAYLIST(ID_UPLOAD_PLAYLIST, CD_ARQUIVO_UPLOAD, CD_PLAYLIST) values(SQ_CILHAS_UPLOAD_PLAYLIST.NEXTVAL, :CD_ARQUIVO_UPLOAD, :CD_PLAYLIST)";
var sTranparameters = new { CD_ARQUIVO_UPLOAD = Convert.ToInt32(aUpload), CD_PLAYLIST = SQ };
conexao.Execute(sSql, sTranparameters, transaction);
transaction.Commit();
}
conexao.Close();
return(SQ);
}
catch (Exception)
{
transaction.Rollback();
conexao.Close();
throw;
}
}
}
public InserirPlayListResponse InserirPlayList([FromBody] InserirPlayListRequest pInserirPlayListRequest)
{
return(_canalIlhasService.InserirPlayList(pInserirPlayListRequest));
}
public InserirPlayListResponse InserirPlayList(InserirPlayListRequest pInserirPlayListRequest)
{
return(Http.Post <InserirPlayListResponse>("v1/api/CanalIlhas/InserirPlayList", pInserirPlayListRequest));
}
