public IHttpActionResult Read(FileCTRequest fileRequest)
{
try
{
#region UnidadNegocio
UnidadNegocioKeys?unidadNegocioKeys = null;
switch (fileRequest.Region)
{
case "PE":
unidadNegocioKeys = UnidadNegocioKeys.CondorTravel;
break;
case "CL":
unidadNegocioKeys = UnidadNegocioKeys.CondorTravel_CL;
break;
default:
break;
}
RepositoryByBusiness(unidadNegocioKeys);
#endregion
var files = (IEnumerable <FileCT>)_fileCTRepository.GetFileCT(fileRequest)[OutParameter.CursorFileCT];
return(Ok(files));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public Operation GetFileCT(FileCTRequest fileCTRequest)
{
var operation = new Operation();
#region Loading
var idOportunidadSf = fileCTRequest.IdOportunidadSf;
var idCotizacionSf = fileCTRequest.IdCotizacionSf;
var region = fileCTRequest.Region;
var fileCT = fileCTRequest.File;
var subfileCT = fileCTRequest.subfile;
#endregion
#region Parameters
/// (1) P_CODIGO_ERROR
//AddParameter(OutParameter.CodigoError, OracleDbType.Varchar2, DBNull.Value, ParameterDirection.Output, OutParameter.DefaultSize);
/// (2) P_MENSAJE_ERROR
//AddParameter(OutParameter.MensajeError, OracleDbType.Varchar2, DBNull.Value, ParameterDirection.Output, OutParameter.DefaultSize);
/// (3) P_ID_OPORTUNIDAD_SF
AddParameter("P_ID_OPORTUNIDAD_SF", OracleDbType.Varchar2, idOportunidadSf);
/// (4) P_ID_FILE_SF
AddParameter("P_ID_FILE_SF", OracleDbType.Varchar2, idCotizacionSf);
/// (5) P_FILE
AddParameter("P_FILE", OracleDbType.Varchar2, fileCT);
/// (6) P_CUR_COTIZACION
AddParameter("P_SUBFILE", OracleDbType.Int32, subfileCT);
AddParameter(OutParameter.CursorCotizacion, OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output);
#endregion
#region Invoke
ExecuteStoredProcedure(StoredProcedureName.CT_Obtiene_FileCT);
operation[OutParameter.CursorCotizacion] = ToCotizacion(GetDtParameter(OutParameter.CursorCotizacion));
#endregion
return(operation);
}
