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); }