示例#1
0
        public async Task <PagedResult <SlideViewModel> > GetAllPaging(PagingRequestBase request)
        {
            var query = from t in _context.Slides
                        select t;

            int totalRow = await query.CountAsync();

            var data = query.OrderBy(m => m.display_order)
                       .Skip((request.PageIndex - 1) * request.PageSize)
                       .Take(request.PageSize)
                       .Select(a => new SlideViewModel()
            {
                id            = a.id,
                display_order = a.display_order,
                status        = a.status,
                image         = a.image,
                create_at     = a.create_at,
                link          = a.link,
                update_at     = a.update_at,
            }).ToListAsync();


            var pageResult = new PagedResult <SlideViewModel>()
            {
                TotalRecords = totalRow,
                PageIndex    = request.PageIndex,
                PageSize     = request.PageSize,
                Items        = await data,
            };

            return(pageResult);
        }
        public async Task <PagedResult <NewsViewModel> > GetAllNewsByPaging(PagingRequestBase request)
        {
            var query = from n in _context.News
                        select new { n };
            int totalRow = await query.CountAsync();

            var data = await query.Skip((request.PageIndex - 1) *request.PageSize)
                       .Take(request.PageSize)
                       .Select(x => new NewsViewModel()
            {
                Id            = x.n.Id,
                Title         = x.n.Title,
                Summary       = x.n.Summary,
                ImagePath     = x.n.ImagePath,
                DateSubmitted = x.n.DateSubmitted
            }).ToListAsync();

            var pagedResult = new PagedResult <NewsViewModel>()
            {
                TotalRecords = totalRow,
                Items        = data
            };

            return(pagedResult);
        }
        public async Task <List <ProductViewModel> > GetProductByName(PagingRequestBase request)
        {
            var query = from p in _context.Products
                        join pt in _context.ProductTranslations
                        on p.Id equals pt.ProductId
                        join pc in _context.ProductInCategories
                        on p.Id equals pc.ProductId
                        where pt.Name.Contains(request.keyword)
                        select new { p, pt, pc };

            var data = await query.Skip((request.PageIndex - 1) *request.PageSize).Take(request.PageSize).Select(x => new ProductViewModel()
            {
                Id             = x.p.Id,
                Name           = x.pt.Name,
                DateCreated    = x.p.DateCreated,
                Description    = x.pt.Description,
                Details        = x.pt.Details,
                LanguageId     = x.pt.LanguageId,
                OriginalPrice  = x.p.OriginalPrice,
                Price          = x.p.Price,
                SeoAlias       = x.pt.SeoAlias,
                SeoDescription = x.pt.SeoDescription,
                SeoTitle       = x.pt.SeoTitle,
                Stock          = x.p.Stock,
                ViewCount      = x.p.ViewCount
            }).ToListAsync();

            return(data);
        }
示例#4
0
        public async Task <PagedResult <SlideViewModel> > GetSlidePagings(PagingRequestBase request)
        {
            var client = _httpClientFactory.CreateClient();

            client.BaseAddress = new Uri(_configuration["BaseAddress"]);
            var respone = await client.GetAsync($"/api/slide/paging?pageIndex={request.PageIndex}&pageSize={request.PageSize}");

            var body = await respone.Content.ReadAsStringAsync();

            var slides = JsonConvert.DeserializeObject <PagedResult <SlideViewModel> >(body);

            return(slides);
        }
示例#5
0
        public async Task <IActionResult> Index(int pageIndex = 1, int pageSize = 10)
        {
            var request = new PagingRequestBase()
            {
                PageIndex = pageIndex,
                PageSize  = pageSize,
            };
            var data = await _slideApiClient.GetSlidePagings(request);

            if (TempData["result"] != null)
            {
                ViewBag.SuccessMsg = TempData["result"];
            }
            if (TempData["error"] != null)
            {
                ViewBag.ErrorMsg = TempData["error"];
            }
            return(View(data));
        }
示例#6
0
        public async Task <IActionResult> Get([FromQuery] PagingRequestBase repuest)
        {
            var data = await _managerHoaDonService.GetAll(repuest);

            return(Ok(data));
        }
示例#7
0
        public async Task <IActionResult> GetAllPaging([FromQuery] PagingRequestBase requet)
        {
            var slides = await _slideService.GetAllPaging(requet);

            return(Ok(slides));
        }
示例#8
0
        public async Task <IActionResult> GetAllNewsByPaging(PagingRequestBase request)
        {
            var news = await _newsManagersService.GetAllNewsByPaging(request);

            return(Ok(news));
        }
        public async Task <IActionResult> GetByName(PagingRequestBase request)
        {
            var data = await _product.GetProductByName(request);

            return(Ok(data));
        }
        public async Task <PagedHoaDonByKyResult <HoaDonViewModel> > GetAll(PagingRequestBase repuest)
        {
            if (repuest.KyHoadon != null)
            {
                var query = await(from h in _context.HoaDon
                                  join k in _context.KhachHang on h.MaKh equals k.MaKh
                                  join x in _context.XaPhuong on k.XaPhuong equals x.MaXaPhuong
                                  join kt in _context.KyXuatHoaDon on h.KyTinh equals kt.MaKyTinh
                                  where h.TongTien > 0 && h.KyTinh.Value.Year == repuest.KyHoadon.Year && h.KyTinh.Value.Month == repuest.KyHoadon.Month && h.KyTinh.Value.Day == repuest.KyHoadon.Day
                                  select new HoaDonViewModel
                {
                    RowId     = h.RowId,
                    MaHoaDon  = h.MaHoaDon,
                    KyTinh    = h.KyTinh,
                    MaKh      = h.MaKh,
                    TenKh     = h.TenKh,
                    ChiSoCu   = h.ChiSoCu,
                    ChiSoMoi  = h.ChiSoMoi,
                    SoM3      = h.SoM3,
                    DonGiaTdm = h.DonGiaTdm,
                    TienTdm   = h.TienTdm,
                    DonGiaVdm = h.DonGiaVdm,
                    //TienVdm = h.TienVdm,
                    //TienBaoTri = h.TienBaoTri,
                    //TienThueBao = h.TienThueBao,
                    Vat       = h.Vat,
                    ThanhTien = h.ThanhTien,
                    NoKyTruoc = h.NoKyTruoc,
                    TongTien  = h.TongTien,
                    //NgayLap = h.NgayLap,
                    //NgayThu = h.NgayThu,
                    //DaThanhToan = h.DaThanhToan,
                    //NhanVienGhiNuoc =h.NhanVienGhiNuoc,
                    //NhanVienThuTien = h.NhanVienThuTien,
                    GhiChu = k.MaTram,
                    //NguoiTao = h.NguoiTao,
                    //NgayTao = h.NgayTao,
                    //NguoiThayDoi = h.NguoiThayDoi,
                    //NgayThayDoi = h.NgayThayDoi,
                    //NguyenNhan = h.NguyenNhan,
                    PhiNuocThai    = h.PhiNuocThai,
                    Dm10           = h.Dm10,
                    Dm20           = h.Dm20,
                    Dm30           = h.Dm30,
                    Dm40           = h.Dm40,
                    PhanLoaiNuocSd = h.PhanLoaiNuocSd,
                    Don_Gia_DM10   = 0.0,
                    Don_Gia_DM20   = 0.0,
                    Don_Gia_DM30   = 0.0,
                    Don_Gia_DM40   = 0.0,

                    PhanTramPhiSH   = 0.0,
                    MSThue          = k.MstKh,
                    So_Nha          = k.SoNha,
                    To_KH           = k.ToKh,
                    Ap_KH           = k.ApKh,
                    Xa_Phuong       = x.TenXaPhuong,
                    Ky_Tinh_TuNgay  = kt.DenNgay,
                    Ky_Tinh_DenNgay = kt.TuNgay,
                }).Take(2).ToListAsync();
                var totalcount = query.Count();
                var result     = new PagedHoaDonByKyResult <HoaDonViewModel>()
                {
                    Items       = query,
                    TotalRecord = totalcount,
                    KyHoaDon    = repuest.KyHoadon
                };
                return(result);
            }
            else
            {
                return(null);
            }
        }