public List <SearchPictureOutputModel> SearchPicture(SearchPictureInputModel model)
        {
            var images = repo.SearchPicture(model);

            Each(images, i => ConvertCategoriesToArr(i));
            return(images);
        }
 public IActionResult Search([FromBody] SearchPictureInputModel model)
 {
     if (!ModelState.IsValid)
     {
         return(BadRequest());
     }
     return(Ok(repo.SearchProduct(model)));
 }
        public IActionResult Post([FromBody] SearchPictureInputModel model)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest());
            }
            var response = service.SearchPicture(model);

            return(Ok(response));
        }
        public IActionResult Post([FromBody] SearchPictureInputModel model,
                                  int itemsPerPage = 1, int currentPage = 1, int sort = 1)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest());
            }
            var response = service.SearchPicture(model, itemsPerPage, currentPage, sort);

            return(Ok(response));
        }
        public List <SearchPictureOutputModel> SearchPicture(SearchPictureInputModel input)
        {
            var res = new List <SearchPictureOutputModel>();

            using (IDbConnection db = new SqlConnection(Global.Connection))
            {
                // new { SearchDescr = input.SearchDescr, Cust_ID = input.Cust_ID, ID = input.ID }
                res = db.Query <SearchPictureOutputModel>("sp_SearchPicture", input,
                                                          commandType: CommandType.StoredProcedure).ToList();
            }
            return(res);
        }
        public GalleryViewModel SearchPicture(SearchPictureInputModel model, int itemsPerPage, int currentPage, int sort)
        {
            var images = repo.SearchPicture(model);

            Each(images, i => ConvertCategoriesToArr(i));

            var totalItems = images.Count();

            images = images
                     .Skip((currentPage - 1) * itemsPerPage)
                     .Take(itemsPerPage)
                     .ToList();

            var response = new GalleryViewModel
            {
                Images     = images,
                TotalItems = totalItems
            };

            return(response);
        }