Example #1
0
        /// <summary>
        /// Método Para Mostrar por Lista de User
        /// </summary>
        /// <param name="page"></param>
        /// <param name="start"></param>
        /// <param name="limit"></param>
        /// <param name="filter"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        // GET: api/User
        public HttpResponseMessage Get(int?page = 1, int?start = 0, int?limit = 20, string filter = "", string sort = "")
        {
            List <GridFilter> filters = new List <GridFilter>();
            List <GridSort>   sorts   = new List <GridSort>();

            AppPagedResponse <List <UserModel> > response = new AppPagedResponse <List <UserModel> >()
            {
                data = null
            };

            var db = userSvc.LoadNonClients();

            response.Total = db.Count();
            db             = db.Skip(start.Value).Take(limit.Value);
            var model = MapToModel(db.ToList());

            response.data   = model;
            response.Limit  = limit.Value;
            response.Filter = filters;
            response.Sort   = sorts;

            //Calculate actual page
            int intPage = limit.Value == 0 ? 0 : (int)Math.Ceiling((decimal)(start.Value / limit.Value));

            response.Page = intPage + 1;

            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }
Example #2
0
        public HttpResponseMessage Get(int id)
        {
            AppPagedResponse <NewsModel> response = new AppPagedResponse <NewsModel>()
            {
                data = null
            };
            var db = newsSvc.Load(id);

            response.data = MapToModel(db);
            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }
Example #3
0
        public HttpResponseMessage Get(int?page = 1, int?start = 0, int?limit = 20, string filter = "", string sort = "", bool?isWeb = false)
        {
            List <GridFilter> filters = new List <GridFilter>();
            List <GridSort>   sorts   = new List <GridSort>();

            AppPagedResponse <List <NewsGridModel> > response = new AppPagedResponse <List <NewsGridModel> >()
            {
                data = null
            };

            IQueryable <News> db;

            if (isWeb.Value)
            {
                db = newsSvc.LoadAll();
            }
            else
            {
                db = newsSvc.LoadActives();
            }

            //if (filter != string.Empty)
            //{
            //    filters = JsonConvert.DeserializeObject<List<GridFilter>>(filter);
            //    db = ApplyFilters(db, filters);
            //}


            //if (sort != string.Empty)
            //{
            //    sorts = JsonConvert.DeserializeObject<List<GridSort>>(sort);
            //    db = ApplySorts(db, sorts);
            //}
            //else
            //    db = db.OrderBy(x => x.Apellido);

            response.Total = db.Count();
            db             = db.Skip(start.Value).Take(limit.Value);
            var model = MapToGridModel(db.ToList());

            response.data   = model;
            response.Limit  = limit.Value;
            response.Filter = filters;
            response.Sort   = sorts;

            //Calculate actual page
            int intPage = limit.Value == 0 ? 0 : (int)Math.Ceiling((decimal)(start.Value / limit.Value));

            response.Page = intPage + 1;

            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }