public async Task <ResponseEntity> LayThongTinLichChieuPhim(int MaPhim = 0)
        {
            Phim p = db.Phim.SingleOrDefault(n => n.MaPhim == MaPhim);

            if (p == null)
            {
                return(new ResponseEntity(StatusCodeConstants.BAD_REQUEST, "Mã phim không tồn tại!", MessageConstant.BAD_REQUEST));
            }
            var conn = new SqlConnection(Config.connect);
            //List<ChiTietPhimTheoHeThongRap> lstResult = new List<ChiTietPhimTheoHeThongRap>();
            LichChieuTheoPhim phim = new LichChieuTheoPhim();

            phim.MaPhim        = p.MaPhim;
            phim.TenPhim       = p.TenPhim;
            phim.BiDanh        = p.BiDanh;
            phim.Trailer       = p.Trailer;
            phim.HinhAnh       = DomainImage + p.HinhAnh;
            phim.MoTa          = p.MoTa;
            phim.MaNhom        = p.MaNhom;
            phim.NgayKhoiChieu = p.NgayKhoiChieu;
            phim.DanhGia       = p.DanhGia;
            phim.Hot           = p.Hot;
            phim.DangChieu     = p.DangChieu;
            phim.SapChieu      = p.SapChieu;
            foreach (var item in db.HeThongRap)
            {
                string LichChieu    = "LichChieu" + p.MaNhom;
                string query        = string.Format("select HeThongRap.Logo, CumRap.ThongTin,Phim.TenPhim,CumRap.TenCumRap,Rap.TenRap , {0}.MaLichChieu,{0}.MaRap,{0}.MaPhim,{0}.NgayChieuGioChieu,{0}.GiaVe,{0}.ThoiLuong,{0}.MaNhom,{0}.MaHeThongRap,{0}.MaCumRap,TenHeThongRap,TenCumRap from Phim,HeThongRap,CumRap,{0},Rap where Phim.MaPhim = {0}.MaPhim and HeThongRap.MaHeThongRap = {0}.MaHeThongRap and {0}.MaCumRap = CumRap.MaCumRap and {0}.MaHeThongRap = '{1}' and {0}.MaPhim= {2} and {0}.MaRap=Rap.MaRap", LichChieu, item.MaHeThongRap, p.MaPhim);
                var    lstLichChieu = conn.Query <LichChieuMapView>(query);

                foreach (var htr in lstLichChieu.GroupBy(n => new { n.MaHeThongRap, n.TenHeThongRap, n.Logo }))
                {
                    ThongTinLichChieuHeThongRap heThongRap = new ThongTinLichChieuHeThongRap();
                    heThongRap.Logo          = DomainImage + htr.Key.Logo;
                    heThongRap.MaHeThongRap  = htr.Key.MaHeThongRap;
                    heThongRap.TenHeThongRap = htr.Key.TenHeThongRap;
                    foreach (var cumRap in htr.GroupBy(n => new { n.MaCumRap, n.TenCumRap, n.ThongTin }))
                    {
                        ThongTinLichChieuCumRap cum = new ThongTinLichChieuCumRap();
                        cum.MaCumRap  = cumRap.Key.MaCumRap;
                        cum.TenCumRap = cumRap.Key.TenCumRap;
                        cum.HinhAnh   = "https://s3img.vcdn.vn/123phim/2021/01/bhd-star-bitexco-16105952137769.png";
                        cum.DiaChi    = cumRap.Key.ThongTin;
                        foreach (var lichChieu in cumRap)
                        {
                            LichChieuPhim lcPhim = new LichChieuPhim();
                            lcPhim.MaLichChieu       = lichChieu.MaLichChieu.ToString();
                            lcPhim.MaRap             = lichChieu.MaRap;
                            lcPhim.TenRap            = lichChieu.TenRap;
                            lcPhim.GiaVe             = lichChieu.GiaVe;
                            lcPhim.ThoiLuong         = lichChieu.ThoiLuong;
                            lcPhim.NgayChieuGioChieu = lichChieu.NgayChieuGioChieu;


                            cum.LichChieuPhim.Add(lcPhim);
                        }
                        heThongRap.CumRapChieu.Add(cum);
                    }


                    phim.HeThongRapChieu.Add(heThongRap);
                }
            }

            conn.Close();

            //return Ok(phim);
            return(new ResponseEntity(StatusCodeConstants.OK, phim, MessageConstant.MESSAGE_SUCCESS_200));
        }
예제 #2
0
        public async Task <ActionResult> LayThongTinLichChieuPhim(int MaPhim = 0)
        {
            Phim p = db.Phim.SingleOrDefault(n => n.MaPhim == MaPhim);

            if (p == null)
            {
                return(await tbl.TBLoi(ThongBaoLoi.Loi400, "Mã phim không tồn tại!"));
            }
            var conn = new SqlConnection(connect);
            //List<ChiTietPhimTheoHeThongRap> lstResult = new List<ChiTietPhimTheoHeThongRap>();
            LichChieuTheoPhim phim = new LichChieuTheoPhim();

            phim.MaPhim        = p.MaPhim;
            phim.TenPhim       = p.TenPhim;
            phim.BiDanh        = p.BiDanh;
            phim.Trailer       = p.Trailer;
            phim.HinhAnh       = DomainImage + p.HinhAnh;
            phim.MoTa          = p.MoTa;
            phim.MaNhom        = p.MaNhom;
            phim.NgayKhoiChieu = p.NgayKhoiChieu;
            phim.DanhGia       = p.DanhGia;
            foreach (var item in db.HeThongRap)
            {
                string LichChieu    = "LichChieu" + p.MaNhom;
                string query        = string.Format("select HeThongRap.Logo, CumRap.ThongTin,Phim.TenPhim,CumRap.TenCumRap,Rap.TenRap , {0}.MaLichChieu,{0}.MaRap,{0}.MaPhim,{0}.NgayChieuGioChieu,{0}.GiaVe,{0}.ThoiLuong,{0}.MaNhom,{0}.MaHeThongRap,{0}.MaCumRap,TenHeThongRap,TenCumRap from Phim,HeThongRap,CumRap,{0},Rap where Phim.MaPhim = {0}.MaPhim and HeThongRap.MaHeThongRap = {0}.MaHeThongRap and {0}.MaCumRap = CumRap.MaCumRap and {0}.MaHeThongRap = '{1}' and {0}.MaPhim= {2} and {0}.MaRap=Rap.MaRap", LichChieu, item.MaHeThongRap, p.MaPhim);
                var    lstLichChieu = conn.Query <LichChieuMapView>(query);

                foreach (var htr in lstLichChieu.GroupBy(n => new { n.MaHeThongRap, n.TenHeThongRap, n.Logo }))
                {
                    ThongTinLichChieuHeThongRap heThongRap = new ThongTinLichChieuHeThongRap();
                    heThongRap.Logo          = DomainImage + htr.Key.Logo;
                    heThongRap.MaHeThongRap  = htr.Key.MaHeThongRap;
                    heThongRap.TenHeThongRap = htr.Key.TenHeThongRap;
                    foreach (var cumRap in htr.GroupBy(n => new { n.MaCumRap, n.TenCumRap }))
                    {
                        ThongTinLichChieuCumRap cum = new ThongTinLichChieuCumRap();
                        cum.MaCumRap  = cumRap.Key.MaCumRap;
                        cum.TenCumRap = cumRap.Key.TenCumRap;
                        foreach (var lichChieu in cumRap)
                        {
                            LichChieuPhim lcPhim = new LichChieuPhim();
                            lcPhim.MaLichChieu       = lichChieu.MaLichChieu.ToString();
                            lcPhim.MaRap             = lichChieu.MaRap;
                            lcPhim.TenRap            = lichChieu.TenRap;
                            lcPhim.GiaVe             = lichChieu.GiaVe;
                            lcPhim.ThoiLuong         = lichChieu.ThoiLuong;
                            lcPhim.NgayChieuGioChieu = lichChieu.NgayChieuGioChieu;


                            cum.LichChieuPhim.Add(lcPhim);
                        }
                        heThongRap.CumRapChieu.Add(cum);
                    }


                    phim.HeThongRapChieu.Add(heThongRap);
                }
            }

            conn.Close();
            return(Ok(phim));
        }