public IEnumerable <IModel> Get([FromUri] RelacionAsesoresDocumentosFilter filter)
{
IEnumerable <IModel> reldoc = null;
// Validar que esté solicitando un estado válido
if (filter.IdAsesor <= 0)
{
var response = new HttpResponseMessage()
{
StatusCode = (HttpStatusCode)422, //Entidad Inprocesable
ReasonPhrase = "Id de Asesor Invalido"
};
throw new HttpResponseException(response);
}
try
{
reldoc = dao.GetByFilter(filter);
}
catch (Exception e)
{
throw new HttpResponseException(HttpStatusCode.InternalServerError);
}
return(reldoc);
}
protected override SqlParameter[] BuildParameters(IFilter IFilter, string strCommand)
{
RelacionAsesoresDocumentosFilter relacion = (RelacionAsesoresDocumentosFilter)IFilter;
SqlParameter[] parameters = null;
switch (strCommand)
{
case "seleccionar_documentos_asesor":
SqlParameter idAsesor = new SqlParameter("@idAsesor", SqlDbType.Int);
idAsesor.Direction = ParameterDirection.Input;
idAsesor.Value = relacion.IdAsesor;
parameters = new SqlParameter[] {
idAsesor
};
break;
}
return(parameters);
}
