public async Task <ResponseEntity> LayThongTinPhim(int MaPhim = 0) { if (MaPhim == 0 || !db.Phim.Any(n => n.MaPhim == MaPhim)) { return(new ResponseEntity(StatusCodeConstants.BAD_REQUEST, "Mã phim không hợp lệ!", MessageConstant.BAD_REQUEST)); //return await tbl.TBLoi(ThongBaoLoi.Loi500, "Mã phim không hợp lệ!"); } Phim phim = db.Phim.Single(n => n.MaPhim == MaPhim); ChiTietPhimVM chiTietPhim = new ChiTietPhimVM(); chiTietPhim.BiDanh = phim.BiDanh; chiTietPhim.DanhGia = phim.DanhGia; chiTietPhim.HinhAnh = DomainImage + phim.HinhAnh; chiTietPhim.MaNhom = phim.MaNhom; chiTietPhim.MaPhim = phim.MaPhim; chiTietPhim.MoTa = phim.MoTa; chiTietPhim.Trailer = phim.Trailer; chiTietPhim.NgayKhoiChieu = phim.NgayKhoiChieu; chiTietPhim.Hot = phim.Hot; chiTietPhim.DangChieu = phim.DangChieu; chiTietPhim.SapChieu = phim.SapChieu; var lst = db.LichChieu.Where(n => n.MaPhim == MaPhim); if (lst.Count() > 0) { foreach (var lichChieu in lst) { ThongTinLichChieu thongTinLC = new ThongTinLichChieu(); thongTinLC.GiaVe = lichChieu.GiaVe; thongTinLC.MaLichChieu = lichChieu.MaLichChieu; thongTinLC.MaPhim = lichChieu.MaPhim; thongTinLC.MaRap = lichChieu.MaRap; thongTinLC.NgayChieuGioChieu = lichChieu.NgayChieuGioChieu; thongTinLC.TenPhim = lichChieu.MaPhimNavigation.TenPhim; thongTinLC.ThoiLuong = lichChieu.ThoiLuong; thongTinLC.ThongTinRap.MaCumRap = lichChieu.MaRapNavigation.MaCumRap; thongTinLC.ThongTinRap.MaHeThongRap = lichChieu.MaRapNavigation.MaCumRapNavigation.MaHeThongRap; thongTinLC.ThongTinRap.MaRap = lichChieu.MaRap; thongTinLC.ThongTinRap.TenRap = lichChieu.MaRapNavigation.TenRap; thongTinLC.ThongTinRap.TenCumRap = lichChieu.MaRapNavigation.MaCumRapNavigation.TenCumRap; thongTinLC.ThongTinRap.TenHeThongRap = lichChieu.MaRapNavigation.MaCumRapNavigation.MaHeThongRapNavigation.TenHeThongRap; chiTietPhim.LichChieu.Add(thongTinLC); } } return(new ResponseEntity(StatusCodeConstants.OK, chiTietPhim, MessageConstant.MESSAGE_SUCCESS_200)); //return Ok(chiTietPhim); }
public async Task <ActionResult> LayThongTinPhim(int MaPhim = 0) { if (MaPhim == 0 || !db.Phim.Any(n => n.MaPhim == MaPhim)) { return(await tbl.TBLoi(ThongBaoLoi.Loi500, "Mã phim không hợp lệ!")); } Phim phim = db.Phim.Single(n => n.MaPhim == MaPhim); ChiTietPhimVM chiTietPhim = new ChiTietPhimVM(); chiTietPhim.BiDanh = phim.BiDanh; chiTietPhim.DanhGia = phim.DanhGia; chiTietPhim.HinhAnh = DomainImage + phim.HinhAnh; chiTietPhim.MaNhom = phim.MaNhom; chiTietPhim.MaPhim = phim.MaPhim; chiTietPhim.MoTa = phim.MoTa; chiTietPhim.Trailer = phim.Trailer; chiTietPhim.NgayKhoiChieu = phim.NgayKhoiChieu; chiTietPhim.TenPhim = phim.TenPhim; var lst = db.LichChieu.Where(n => n.MaPhim == MaPhim); if (lst.Count() > 0) { foreach (var lichChieu in lst) { ThongTinLichChieu thongTinLC = new ThongTinLichChieu(); thongTinLC.GiaVe = lichChieu.GiaVe; thongTinLC.MaLichChieu = lichChieu.MaLichChieu; thongTinLC.MaPhim = lichChieu.MaPhim; thongTinLC.MaRap = lichChieu.MaRap; thongTinLC.NgayChieuGioChieu = lichChieu.NgayChieuGioChieu; thongTinLC.TenPhim = lichChieu.MaPhimNavigation.TenPhim; thongTinLC.ThoiLuong = lichChieu.ThoiLuong; thongTinLC.ThongTinRap.MaCumRap = lichChieu.MaRapNavigation.MaCumRap; thongTinLC.ThongTinRap.MaHeThongRap = lichChieu.MaRapNavigation.MaCumRapNavigation.MaHeThongRap; thongTinLC.ThongTinRap.MaRap = lichChieu.MaRap; thongTinLC.ThongTinRap.TenRap = lichChieu.MaRapNavigation.TenRap; thongTinLC.ThongTinRap.TenCumRap = lichChieu.MaRapNavigation.MaCumRapNavigation.TenCumRap; thongTinLC.ThongTinRap.TenHeThongRap = lichChieu.MaRapNavigation.MaCumRapNavigation.MaHeThongRapNavigation.TenHeThongRap; chiTietPhim.LichChieu.Add(thongTinLC); } } return(Ok(chiTietPhim)); }
//Lấy thông tin phim (mô tả, lịch chiếu, bình luận) public async Task <object> LayThongTinPhimFull(int maPhim) { using (var connection = new SqlConnection(connectionString)) { IEnumerable <LichChieuVM> lichChieuList = null; ChiTietPhimViewModel chiTietPhim = new ChiTietPhimViewModel();; var phim = connection.QuerySingleOrDefault <Phim>("SELECT * FROM [dbo].[PHIM] WHERE MaPhim = " + maPhim, commandType: CommandType.Text); chiTietPhim.TenPhim = phim.TenPhim; chiTietPhim.BiDanh = phim.BiDanh; chiTietPhim.DanhGia = phim.DanhGia; chiTietPhim.HinhAnh = phim.HinhAnh; chiTietPhim.MaPhim = phim.MaPhim; chiTietPhim.MoTa = phim.MoTa; chiTietPhim.ThoiLuong = phim.ThoiLuong; chiTietPhim.Trailer = phim.Trailer; chiTietPhim.NgayKhoiChieu = phim.NgayKhoiChieu.ToString("dd/MM/yyyy"); chiTietPhim.DaoDien = phim.DaoDien; chiTietPhim.DienVien = phim.DienVien; chiTietPhim.DoTuoi = phim.DoTuoi; chiTietPhim.DaXoa = phim.DaXoa; chiTietPhim.KhoiChieu = phim.KhoiChieu; chiTietPhim.SapChieu = phim.SapChieu; chiTietPhim.ListTheLoai = connection.Query <TheLoaiPhim>("SELECT * FROM [dbo].[View_THE_LOAI] WHERE MaPhim = " + maPhim, commandType: CommandType.Text); lichChieuList = connection.Query <LichChieuVM>("SELECT * FROM [dbo].[View_LICH_CHIEU_COMMON] WHERE MaPhim = " + maPhim + " ORDER BY [dbo].[View_LICH_CHIEU_COMMON].NgayChieuGioChieu", commandType: CommandType.Text); if (lichChieuList != null) { foreach (var ttr in lichChieuList.GroupBy(n => new { n.MaCumRap })) { ThongTinRap thongTinRap = new ThongTinRap(); thongTinRap.MaCumRap = ttr.Key.MaCumRap; foreach (var lc in ttr) { ThongTinLichChieu thongTinLC = new ThongTinLichChieu(); thongTinRap.MaHeThongRap = lc.MaHeThongRap; thongTinRap.TenHeThongRap = connection.QuerySingleOrDefault <string>("SELECT TenHeThongRap FROM [dbo].[HETHONGRAP] WHERE MaHeThongRap = '" + thongTinRap.MaHeThongRap + "'", commandType: CommandType.Text); thongTinRap.MaCumRap = lc.MaCumRap; thongTinRap.TenCumRap = connection.QuerySingleOrDefault <string>("SELECT TenCumRap FROM [dbo].[CUMRAP] WHERE MaCumRap = '" + thongTinRap.MaCumRap + "'", commandType: CommandType.Text); thongTinRap.ThongTin = connection.QuerySingleOrDefault <string>("SELECT ThongTin FROM [dbo].[CUMRAP] WHERE MaCumRap = '" + thongTinRap.MaCumRap + "'", commandType: CommandType.Text); thongTinLC.MaLichChieu = lc.MaLichChieu; thongTinLC.MaRap = lc.MaRap; thongTinLC.TenRap = connection.QuerySingleOrDefault <string>("SELECT TenRap FROM [dbo].[RAP] WHERE MaRap = " + thongTinLC.MaRap, commandType: CommandType.Text); thongTinLC.NgayChieuGioChieu = lc.NgayChieuGioChieu; thongTinLC.ThoiLuong = lc.ThoiLuong; thongTinLC.GiaVe = lc.GiaVe; thongTinRap.ChiTietLichChieu.Add(thongTinLC); } chiTietPhim.LichChieu.Add(thongTinRap); } } var binhLuanList = connection.Query("SELECT * FROM [dbo].[BINHLUANDANHGIA] WHERE MaPhim = " + maPhim, commandType: CommandType.Text); if (binhLuanList != null) { foreach (var binhLuan in binhLuanList) { ThongTinBinhLuan thongTinBL = new ThongTinBinhLuan(); thongTinBL.MaThanhVien = binhLuan.MaThanhVien; thongTinBL.TenThanhVien = connection.QuerySingleOrDefault <string>("SELECT TaiKhoan FROM [dbo].[THANHVIEN] WHERE MaThanhVien = " + thongTinBL.MaThanhVien, commandType: CommandType.Text); thongTinBL.NoiDungBinhLuan = binhLuan.NoiDungBinhLuan; thongTinBL.ChiSoDanhGia = binhLuan.ChiSoDanhGia.ToString("0.00"); //thongTinBL.NgayBinhLuan = binhLuan.NgayBinhLuan; chiTietPhim.ThongTinBinhLuan.Add(thongTinBL); } } return(chiTietPhim); } }