public PagingOutModel GetGalleryType(PagingInModel pagingInModel)
        {
            PagingOutModel pagingModel = new PagingOutModel
            {
                PageNo   = pagingInModel?.PageNo ?? 0,
                PageSize = pagingInModel?.PageSize ?? 10
            };
            var data = _db.MstGalleryType.Where(x => x.IsActive && (pagingInModel == null || pagingInModel.Id == 0 || x.GalleryTypeId == pagingInModel.Id)).Select(x => new GalleryTypeModel()
            {
                GalleryType   = x.GalleryType,
                GalleryTypeId = x.GalleryTypeId,
                BaseUrl       = x.BaseUrl,
                GridSize      = x.GridSize
            }).ToList();

            pagingModel.Data        = pagingInModel == null ? data : data.Skip((pagingInModel.PageNo - 1) * pagingInModel.PageSize).Take(pagingInModel.PageSize).ToList();
            pagingModel.TotalRecord = data.Count;
            return(pagingModel);
        }
        public PagingOutModel GetGallery(PagingInModel pagingInModel)
        {
            PagingOutModel pagingModel = new PagingOutModel
            {
                PageNo   = pagingInModel.PageNo,
                PageSize = pagingInModel.PageSize
            };
            var data = _db.MstGallery.Where(x => x.IsActive == true && (pagingInModel.Id == 0 || x.GalleryId == pagingInModel.Id)).Select(x => new GalleryModel()
            {
                ArtistId             = x.ArtistId,
                ArtistName           = x.Artist.FirstName + "" + x.Artist.LastName,
                AvailableQy          = x.AvailableQy,
                Badge                = x.Badge,
                GridSize             = x.GalleryType.GridSize,
                Description          = x.Description,
                GalleryId            = x.GalleryId,
                GalleryTypeId        = x.GalleryTypeId,
                HasArtistCertificate = Convert.ToBoolean(x.HasArtistCertificate),
                HasArtistSign        = Convert.ToBoolean(x.HasArtistSign),
                Image                = x.Image,
                IsAvailable          = Convert.ToBoolean(x.IsAvailable),
                Medium               = x.Medium,
                Price                = x.Price,
                Size        = x.Size,
                SuitableFor = x.SuitableFor,
                Surface     = x.Surface,
                Tags        = x.Tags,
                Thumbnail   = x.Thumbnail,
                Title       = x.Title,
                BaseUrl     = x.GalleryType.BaseUrl
            }).ToList();

            pagingModel.Data        = data.Skip((pagingInModel.PageNo - 1) * pagingInModel.PageSize).Take(pagingInModel.PageSize).ToList();
            pagingModel.TotalRecord = data.Count;
            return(pagingModel);
        }
Beispiel #3
0
        public PagingOutModel GetUserList(PagingInModel pagingInModel)
        {
            PagingOutModel pagingModel = new PagingOutModel
            {
                PageNo   = pagingInModel.PageNo,
                PageSize = pagingInModel.PageSize
            };
            var data = _db.MstUsers.Where(x => x.IsActive).Select(x => new UserListModel()
            {
                Email     = x.Email,
                FirstName = x.FirstName,
                IsAdmin   = x.IsAdmin,
                LastName  = x.LastName,
                Gender    = x.Gender,
                Mobile    = x.Mobile,
                IsBlocked = x.IsBlocked,
                UserType  = x.UserType.UserType,
                Photo     = x.MstUserDetails.Where(y => y.IsActive).FirstOrDefault().Photo, UserId = x.UserId
            }).ToList();

            pagingModel.Data        = data.Skip((pagingInModel.PageNo - 1) * pagingInModel.PageSize).Take(pagingInModel.PageSize).ToList();
            pagingModel.TotalRecord = data.Count;
            return(pagingModel);
        }