public Int64 SalvarUpload(SavarUploadRequest pUploadSavarRequest) { using (OracleConnection conexao = new OracleConnection(_configuration.GetConnectionString("DESENV"))) { var sSql = "SELECT SQ_CILHAS_ARQUIVO_UPLOAD.NEXTVAL FROM DUAL"; Int64 SQ = conexao.QueryFirstOrDefault <Int64>(sSql, null); sSql = @"INSERT INTO TB_CILHAS_ARQUIVO_UPLOAD (ID_ARQUIVO_UPLOAD ,NM_ARQUIVO_UPLOAD ,TP_ARQUIVO_UPLOAD ,DS_TAMANHO_ARQUIVO ,NM_CAMINHO_ARQUIVO ,DT_UPLOAD_ARQUIVO ,FL_ARQUIVO_ATIVO --,DS_DURACAO_ARQUIVO ,NU_MATR_UPLOAD ) VALUES(:ID_ARQUIVO_UPLOAD ,:NM_ARQUIVO_UPLOAD ,:TP_ARQUIVO_UPLOAD ,:DS_TAMANHO_ARQUIVO ,:NM_CAMINHO_ARQUIVO ,:DT_UPLOAD_ARQUIVO ,:FL_ARQUIVO_ATIVO --,:DS_DURACAO_ARQUIVO ,:NU_MATR_UPLOAD )"; DynamicParameters dyParam = new DynamicParameters(); dyParam.Add("ID_ARQUIVO_UPLOAD", SQ, DbType.Int64, ParameterDirection.Input); dyParam.Add("NM_ARQUIVO_UPLOAD", pUploadSavarRequest.Upload.NM_ARQUIVO_UPLOAD, DbType.String, ParameterDirection.Input); dyParam.Add("TP_ARQUIVO_UPLOAD", pUploadSavarRequest.Upload.TP_ARQUIVO_UPLOAD, DbType.String, ParameterDirection.Input); dyParam.Add("DS_TAMANHO_ARQUIVO", pUploadSavarRequest.Upload.DS_TAMANHO_ARQUIVO, DbType.Int64, ParameterDirection.Input); dyParam.Add("NM_CAMINHO_ARQUIVO", pUploadSavarRequest.Upload.NM_CAMINHO_ARQUIVO, DbType.String, ParameterDirection.Input); dyParam.Add("DT_UPLOAD_ARQUIVO", pUploadSavarRequest.Upload.DT_UPLOAD_ARQUIVO, DbType.String, ParameterDirection.Input); dyParam.Add("FL_ARQUIVO_ATIVO", pUploadSavarRequest.Upload.FL_ARQUIVO_ATIVO, DbType.Byte, ParameterDirection.Input); //dyParam.Add("DURACAO", pUploadSavarRequest.Upload.Duracao, DbType.Int64, ParameterDirection.Input); dyParam.Add("NU_MATR_UPLOAD", pUploadSavarRequest.Upload.NU_MATR_UPLOAD, DbType.Int32, ParameterDirection.Input); conexao.Execute(sSql, dyParam, commandType: CommandType.Text); return(SQ); } }
public SavarUploadResponse SalvarUpload(SavarUploadRequest pUploadSalvarRequest) { try { var salvarUpload = _uploadDAL.SalvarUpload(pUploadSalvarRequest); return(new SavarUploadResponse { Mensagem = MensagensService.SUCESSO }); } catch (Exception) { throw; } }
public SavarUploadResponse SalvarUpload([FromBody] SavarUploadRequest pUploadSavarRequest) { return(_uploadService.SalvarUpload(pUploadSavarRequest)); }
public SavarUploadResponse SalvarUpload(SavarUploadRequest pUploadSalvarRequest) { return(Http.Post <SavarUploadResponse>("v1/api/Upload/SalvarUpload", pUploadSalvarRequest)); }