Example #1
0
        public IEnumerable <dynamic> GetWhere(string schemaName, string tableName, long pageNumber,
                                              [FromBody] JArray filters)
        {
            try
            {
                var f          = Filter.FromJArray(filters);
                var repository = new ViewRepository(schemaName, tableName, this.MetaUser.Tenant, this.MetaUser.LoginId,
                                                    this.MetaUser.UserId);
                return(repository.GetWhere(pageNumber, f));
            }
            catch (UnauthorizedException)
            {
                throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.Forbidden));
            }
            catch (DataAccessException ex)
            {
                throw new HttpResponseException(new HttpResponseMessage
                {
                    Content    = new StringContent(ex.Message),
                    StatusCode = HttpStatusCode.InternalServerError
                });
            }
#if !DEBUG
            catch
            {
                throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError));
            }
#endif
        }