예제 #1
0
        protected void Xl_XemSoDoGhe_Click(object sender, EventArgs e)
        {
            int soHang                  = int.Parse(tb_SoHangGhe.Text);
            int soGheTrenHang           = int.Parse(tb_SoGheTrenHang.Text);
            CinemaLINQDataContext dt    = new CinemaLINQDataContext();
            PhongChieuPhim        phong = new PhongChieuPhim();

            phong.MaRapChieuPhim    = int.Parse(cbb_RapPhim.SelectedItem.Value);
            phong.TenPhongChieuPhim = tb_TenPhong.Text;
            phong.TongSoLuongGhe    = soGheTrenHang * soHang;
            phong.TinhTrang         = false;
            phong.SoHang            = soHang;
            phong.SoGheTrenHang     = soGheTrenHang;
            dt.PhongChieuPhims.InsertOnSubmit(phong);

            dt.SubmitChanges();

            for (int i = 0; i < soHang; ++i)
            {
                for (int j = 0; j < soGheTrenHang; ++j)
                {
                    Ghe ghe = new Ghe();
                    ghe.MaPhongChieuPhim = phong.MaPhongChieuPhim;
                    ghe.TenGhe           = "Ghe";
                    ghe.MaDanhMucGhe     = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
                    ghe.Hang             = i;
                    ghe.SoThuTu          = j;
                    ghe.TinhTrang        = -1;
                    dt.Ghes.InsertOnSubmit(ghe);
                    dt.SubmitChanges();
                }
            }

            Session["Phong"] = (PhongChieuPhim)phong;
        }
예제 #2
0
        private void btn_chon_ghe_Click(object sender, EventArgs e)
        {
            BUS_Ghe bus_ghe = new BUS_Ghe();
            Ghe     ghe     = new Ghe();
            DatVe   ve      = new DatVe();

            if (this._idGhe == -1)
            {
                MessageBox.Show("Chưa chọn Ghế");
                return;
            }

            DataTable dt = new DataTable();

            dt = bus_ghe.getGheById(this._idGhe);
            if (dt == null)
            {
                MessageBox.Show("Không có thông tin Ghế được chọn");
                return;
            }
            DataRow r = dt.Rows[0];

            ve.GiaTien  = Convert.ToInt32(cbx_giatien.Text);
            ve.IDChuyen = Convert.ToInt32(cbx_id_chuyen.Text);
            ghe.IDGhe   = this._idGhe;
            ghe.Dong    = Convert.ToInt32(r["Dong"]);
            ghe.Cot     = Convert.ToInt32(r["Cot"]);
            ghe.Tang    = Convert.ToInt32(r["Tang"]);
            ghe.SoGhe   = Convert.ToInt32(r["So_ghe"]);
            ghe.IDXe    = Convert.ToInt32(cbx_id_xe.Text);

            frmParent.getInfoChonGhe(ghe, ve);
            this.Close();
        }
예제 #3
0
        public void getInfoChonGhe(Ghe ghe, DatVe ve)
        {
            // Get ID Ghe & ID Chuyen from frmGhe;
            BUS_Xe    bus_xe = new BUS_Xe();
            DataTable dt     = new DataTable();

            dt = bus_xe.getXeById(ghe.IDXe);
            if (dt == null)
            {
                MessageBox.Show("Không tìm thấy ID xe");
                return;
            }
            DataRow r = dt.Rows[0];

            txt_id_xe.Text    = r["So_dang_ky"].ToString();
            txt_gia_tien.Text = ve.GiaTien.ToString();
            txt_so_ghe.Text   = ghe.SoGhe.ToString();
            txt_tang.Text     = ghe.Tang.ToString();

            _datve               = new DatVe();
            this._datve.IDGhe    = ghe.IDGhe;
            this._datve.IDChuyen = ve.IDChuyen;

            btn_submit_datve.Enabled = true;
        }
        public async Task <ResponseEntity> ThongTinTaiKhoan()
        {
            var       accessToken = Request.Headers[HeaderNames.Authorization];
            userToken tttk        = commonService.getUserByToken(accessToken).Result;

            if (tttk == null)
            {
                return(new ResponseEntity(StatusCodeConstants.AUTHORIZATION, "Token đã hết hạn bạn hãy đăng nhập lại!", MessageConstant.MESSAGE_ERROR_401));
            }

            NguoiDung tt = db.NguoiDung.SingleOrDefault(n => n.TaiKhoan == tttk.taiKhoan);

            if (tt == null)
            {
                // I wish to return an error response how can i do that?
                //var response = await tbl.TBLoi(ThongBaoLoi.Loi400, "Tài khoản không hợp lệ!");
                //return response;
                return(new ResponseEntity(StatusCodeConstants.BAD_REQUEST, "Tài khoản không hợp lệ!", MessageConstant.BAD_REQUEST));
            }
            IEnumerable <DatVe>  lstDatVe         = db.DatVe.Where(n => n.TaiKhoanNguoiDung == tttk.taiKhoan).ToList();
            List <ThongTinDatVe> lstThongTinDatVe = new List <ThongTinDatVe>();

            if (lstDatVe.Count() != 0)
            {
                foreach (var item in lstDatVe.GroupBy(n => n.MaLichChieu))
                {
                    ThongTinDatVe ttdv = new ThongTinDatVe();
                    ttdv.MaVe = item.First().MaVe;
                    foreach (var ghe in item)
                    {
                        Ghe         gheNavigation = ghe.MaGheNavigation;
                        Rap         rap           = ghe.MaGheNavigation.MaRapNavigation;
                        CumRap      cumRap        = rap.MaCumRapNavigation;
                        HeThongRap  heThongRap    = cumRap.MaHeThongRapNavigation;
                        ThongTinGhe ttg           = new ThongTinGhe()
                        {
                            MaCumRap = rap.TenRap, TenCumRap = rap.TenRap, MaGhe = ghe.MaGhe, TenGhe = gheNavigation.TenGhe, MaRap = gheNavigation.MaRap, TenRap = rap.TenRap, MaHeThongRap = heThongRap.MaHeThongRap, TenHeThongRap = cumRap.TenCumRap
                        };
                        ttdv.DanhSachGhe.Add(ttg);
                    }
                    ttdv.NgayDat       = item.First().NgayDat.Value;
                    ttdv.HinhAnh       = DomainImage + item.First().MaLichChieuNavigation.MaPhimNavigation.HinhAnh;
                    ttdv.TenPhim       = item.First().MaLichChieuNavigation.MaPhimNavigation.TenPhim;
                    ttdv.GiaVe         = item.First().GiaVe.Value;
                    ttdv.ThoiLuongPhim = item.First().MaLichChieuNavigation.ThoiLuong.Value;
                    lstThongTinDatVe.Add(ttdv);
                }
            }

            ThongTinTaiKhoanVM ttTK = Mapper.Map <NguoiDung, ThongTinTaiKhoanVM>(tt);

            ttTK.ThongTinDatVe = lstThongTinDatVe;

            return(new ResponseEntity(StatusCodeConstants.OK, ttTK, MessageConstant.MESSAGE_SUCCESS_200));

            //return Ok(ttTK);
        }
예제 #5
0
 //FrmLoaiXe7Cho LoaiXe = new FrmLoaiXe7Cho();
 public void HoaDonTinhTien_Load(object sender, EventArgs e)
 {
     txtTuyenDuong.Text = Tuyen.ToString();
     txtSoGhe.Text      = Ghe.ToString();
     txtGiaCuoc.Text    = Tien.ToString();
     txtSoXe.Text       = SoXe.ToString();
     txtGioKH.Text      = Ngay.ToString();
     txtGio.Text        = Gio.ToString();
     txtHanhKhach.Text  = THK.ToString();
     txtSDTHK.Text      = SDT.ToString();
 }
예제 #6
0
        public static void InsertGiaVeCuaGhe(KeHoachVe keHoach, Ghe ghe, int giaGhe)
        {
            string sql = @"INSERT INTO [dbo].[giaVeCuaGhe]
                               ([gheID]
                               ,[tenPhim]
                               ,[tenRap]
                               ,[khanDaiID]
                               ,[ngayChieu]
                               ,[suatChieu]
                               ,[giaVeCuaGhe]
                               ,[trangThai])
                         VALUES
                               (@gheID
                               ,@tenPhim
                               ,@tenRap
                               ,@khanDaiID
                               ,@ngayChieu
                               ,@suatChieu
                               ,@giaVeCuaGhe
                               ,'chua')";

            SqlParameter pr1 = new SqlParameter("@tenPhim", SqlDbType.NVarChar);

            pr1.Value = keHoach.TenPhim;

            SqlParameter pr2 = new SqlParameter("@tenRap", SqlDbType.NVarChar);

            pr2.Value = keHoach.TenRap;

            SqlParameter pr3 = new SqlParameter("@khanDaiID", SqlDbType.NVarChar);

            pr3.Value = keHoach.KhanDai;

            SqlParameter pr4 = new SqlParameter("@ngayChieu", SqlDbType.DateTime);

            pr4.Value = keHoach.NgayChieu;

            SqlParameter pr5 = new SqlParameter("@suatChieu", SqlDbType.NVarChar);

            pr5.Value = keHoach.SuatChieu;

            SqlParameter pr6 = new SqlParameter("@giaVeCuaGhe", SqlDbType.Int);

            pr6.Value = giaGhe;

            SqlParameter pr7 = new SqlParameter("@gheID", SqlDbType.NVarChar);

            pr7.Value = ghe.GheID;

            DAO.ExecuteSQLWithParameters(sql, pr1, pr2, pr3, pr4, pr5, pr6, pr7);
        }
예제 #7
0
 public IHttpActionResult Put(GheXe _gheXe)
 {
     try
     {
         using (var db = new DB())
         {
             using (var transaction = db.Database.BeginTransaction())
             {
                 Xe xe = db.Xes.FirstOrDefault(x => x.maxe == _gheXe._maxe);
                 if (xe == null)
                 {
                     return(BadRequest("Xe không t?n t?i"));
                 }
                 DateTime ngayCapNhat = DateTime.Now;
                 _gheXe._ghes.ForEach(x =>
                 {
                     Ghe ghe = db.Ghes.FirstOrDefault(y => y.maghe == x.maghe);
                     if (ghe == null)
                     {
                         db.Ghes.Add(new Ghe()
                         {
                             ngaycapnhat = ngayCapNhat,
                             maxe        = _gheXe._maxe,
                             vitriX      = x.vitriX,
                             vitriY      = x.vitriY,
                             tang        = x.tang,
                             active      = x.active,
                         });
                     }
                     else
                     {
                         ghe.vitriX = x.vitriX;
                         ghe.vitriY = x.vitriY;
                         ghe.tang   = x.tang;
                         ghe.active = x.active;
                     }
                     db.SaveChanges();
                 });
                 transaction.Commit();
                 return(Ok(_gheXe));
             }
         }
     }
     catch (Exception ex)
     {
         return(BadRequest(ex.Message));
     }
 }
        public async Task <ActionResult> ThongTinTaiKhoan(LayThongTinCaNhanVM tttk)
        {
            NguoiDung tt = db.NguoiDung.SingleOrDefault(n => n.TaiKhoan == tttk.TaiKhoan);

            if (tt == null)
            {
                // I wish to return an error response how can i do that?
                var response = await tbl.TBLoi(ThongBaoLoi.Loi400, "Tài khoản không hợp lệ!");

                return(response);
            }
            IEnumerable <DatVe>  lstDatVe         = db.DatVe.Where(n => n.TaiKhoanNguoiDung == tttk.TaiKhoan).ToList();
            List <ThongTinDatVe> lstThongTinDatVe = new List <ThongTinDatVe>();

            if (lstDatVe.Count() != 0)
            {
                foreach (var item in lstDatVe.GroupBy(n => n.NgayDat))
                {
                    ThongTinDatVe ttdv = new ThongTinDatVe();
                    ttdv.MaVe = item.First().MaVe;
                    foreach (var ghe in item)
                    {
                        Ghe         gheNavigation = ghe.MaGheNavigation;
                        Rap         rap           = ghe.MaGheNavigation.MaRapNavigation;
                        CumRap      cumRap        = rap.MaCumRapNavigation;
                        HeThongRap  heThongRap    = cumRap.MaHeThongRapNavigation;
                        ThongTinGhe ttg           = new ThongTinGhe()
                        {
                            MaCumRap = rap.TenRap, TenCumRap = rap.TenRap, MaGhe = ghe.MaGhe, TenGhe = gheNavigation.TenGhe, MaRap = gheNavigation.MaRap, TenRap = rap.TenRap, MaHeThongRap = heThongRap.MaHeThongRap, TenHeThongRap = cumRap.TenCumRap
                        };
                        ttdv.DanhSachGhe.Add(ttg);
                    }
                    ttdv.NgayDat       = item.First().NgayDat.Value;
                    ttdv.TenPhim       = item.First().MaLichChieuNavigation.MaPhimNavigation.TenPhim;
                    ttdv.GiaVe         = item.First().GiaVe.Value;
                    ttdv.ThoiLuongPhim = item.First().MaLichChieuNavigation.ThoiLuong.Value;
                    lstThongTinDatVe.Add(ttdv);
                }
            }

            ThongTinTaiKhoanVM ttTK = Mapper.Map <NguoiDung, ThongTinTaiKhoanVM>(tt);

            ttTK.ThongTinDatVe = lstThongTinDatVe;


            return(Ok(ttTK));
        }
예제 #9
0
        protected void btn_Chuyen_Click(object sender, EventArgs e)
        {
            CinemaLINQDataContext dt = new CinemaLINQDataContext();
            var phong = (from _phong in dt.PhongChieuPhims
                         where _phong.MaPhongChieuPhim == int.Parse(cbb_Phong.SelectedItem.Value)
                         select _phong).Single();

            Ghe ghe = dt.Ghes.Where(_ghe => _ghe.MaGhe == int.Parse(((ImageButton)sender).CommandArgument)).Select(_ghe => _ghe).Single();

            if (ghe.MaDanhMucGhe == dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single())
            {
                ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Vip") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
            }
            else
            {
                ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
            }

            dt.SubmitChanges();
        }
예제 #10
0
        protected void btn_Chuyen_Click(object sender, EventArgs e)
        {
            CinemaLINQDataContext dt = new CinemaLINQDataContext();

            if (Session["Phong"] == null)
            {
                Response.Redirect("/admin/default.aspx");
            }

            Ghe ghe = dt.Ghes.Where(_ghe => _ghe.MaGhe == int.Parse(((ImageButton)sender).CommandArgument)).Select(_ghe => _ghe).Single();

            if (ghe.MaDanhMucGhe == dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single())
            {
                ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Vip") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
            }
            else
            {
                ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
            }

            dt.SubmitChanges();
        }
        public async Task <object> LayThongTinTaiKhoan(string taiKhoan)
        {
            using (var connection = new SqlConnection(connectionString))
            {
                ThanhVien thanhVien = connection.QuerySingleOrDefault <ThanhVien>("SELECT * FROM dbo.ThanhVien WHERE TaiKhoan = '" + taiKhoan + "'", commandType: CommandType.Text);
                if (thanhVien == null)
                {
                    // I wish to return an error response how can i do that?
                    var response = await thongBaoLoi.thongBaoLoi(ThongBaoLoi.Loi400, "Tài khoản không hợp lệ!");

                    return(response);
                }

                IEnumerable <Ve>     listDatVe         = connection.Query <Ve>("SELECT * FROM dbo.VE WHERE MaThanhVien = ' " + thanhVien.MaThanhVien + "'", commandType: CommandType.Text);
                List <ThongTinDatVe> listThongTinDatVe = new List <ThongTinDatVe>();

                if (listDatVe.Count() != 0)
                {
                    Ghe ghe = new Ghe();
                    foreach (var item in listDatVe.GroupBy(n => new { n.MaThanhToan }))
                    {
                        //, MaGhe = item.MaGhe, TenGhe = ghe.TenGhe, MaRap = ghe.MaRap, TenRap = rap.TenRap,MaHeThongRap = cumRap.MaHeThongRap,TenHeThongRap = connection.QuerySingleOrDefault("SELECT TenHeThongRap FROM dbo.HETHONGRAP WHERE MaHeThongRap = " + cumRap.MaHeThongRap, commandType: CommandType.Text)
                        ThongTinDatVe thongTinDatVe = new ThongTinDatVe();
                        Rap           rap           = new Rap();
                        CumRap        cumRap        = new CumRap();
                        LichChieu     lichChieu     = new LichChieu();

                        thongTinDatVe.MaThanhToan  = item.Key.MaThanhToan;
                        thongTinDatVe.TrangThaiHuy = connection.QuerySingleOrDefault <bool>("SELECT TrangThaiHuy FROM dbo.THANHTOAN WHERE MaThanhToan = " + item.Key.MaThanhToan, commandType: CommandType.Text);

                        foreach (var CTVe in item)
                        {
                            ThongTinGhe thongTinGhe = new ThongTinGhe();
                            lichChieu = connection.QuerySingleOrDefault <LichChieu>("SELECT * FROM dbo.LICHCHIEU WHERE MaLichChieu = " + CTVe.MaLichChieu, commandType: CommandType.Text);
                            //rap = connection.QuerySingleOrDefault<Rap>("SELECT * FROM dbo.RAP WHERE MaRap = " + lichChieu.MaRap, commandType: CommandType.Text);
                            //cumRap = connection.QuerySingleOrDefault<CumRap>("SELECT * FROM dbo.CUMRAP WHERE MaCumRap = '" + rap.MaCumRap + "'", commandType: CommandType.Text);
                            ghe = await connection.QuerySingleOrDefaultAsync <Ghe>("SELECT * FROM dbo.GHE WHERE MaGhe = " + CTVe.MaGhe, commandType : CommandType.Text);

                            thongTinDatVe.MaLichChieu = CTVe.MaLichChieu;
                            thongTinGhe.MaGhe         = ghe.MaGhe;
                            thongTinGhe.TenGhe        = ghe.TenGhe;
                            thongTinGhe.MaVe          = CTVe.MaVe;
                            thongTinGhe.NgayDat       = CTVe.NgayDat.Value;

                            thongTinDatVe.TenPhim           = connection.QuerySingleOrDefault <string>("SELECT TenPhim FROM dbo.Phim WHERE MaPhim = " + lichChieu.MaPhim, commandType: CommandType.Text);
                            thongTinDatVe.GiaVe             = CTVe.GiaVe.Value;
                            thongTinDatVe.NgayChieuGioChieu = lichChieu.NgayChieuGioChieu;
                            thongTinDatVe.MaRap             = lichChieu.MaRap;
                            thongTinDatVe.TenRap            = connection.QuerySingleOrDefault <string>("SELECT TenRap FROM dbo.Rap WHERE MaRap = " + lichChieu.MaRap, commandType: CommandType.Text);
                            thongTinDatVe.MaHeThongRap      = lichChieu.MaHeThongRap;
                            thongTinDatVe.MaCumRap          = lichChieu.MaCumRap;
                            thongTinDatVe.TenCumRap         = connection.QuerySingleOrDefault <string>("SELECT TenCumRap FROM dbo.CumRap WHERE MaCumRap = '" + lichChieu.MaCumRap + "'", commandType: CommandType.Text);
                            thongTinDatVe.DanhSachGhe.Add(thongTinGhe);
                        }
                        listThongTinDatVe.Add(thongTinDatVe);
                        //thongTinDatVe.ThoiLuongPhim = item.MaLichChieuNavigation.ThoiLuong.Value;
                    }
                }


                //ThongTinTaiKhoanVM ttTK = Mapper.Map<NguoiDung, ThongTinTaiKhoanVM>(tt);
                ThongTinTaiKhoanVM thongTinTaiKhoan = new ThongTinTaiKhoanVM();
                thongTinTaiKhoan.MaThanhVien   = thanhVien.MaThanhVien;
                thongTinTaiKhoan.LoaiNguoiDung = await connection.QuerySingleOrDefaultAsync <string>("SELECT TenLoai FROM dbo.LOAITHANHVIEN WHERE MaLoaiThanhVien = " + thanhVien.MaLoaiThanhVien, commandType : CommandType.Text);

                thongTinTaiKhoan.TaiKhoan       = thanhVien.TaiKhoan;
                thongTinTaiKhoan.MatKhau        = thanhVien.MatKhau;
                thongTinTaiKhoan.HoTen          = thanhVien.HoTen;
                thongTinTaiKhoan.Email          = thanhVien.Email;
                thongTinTaiKhoan.SoDT           = thanhVien.SoDienThoai;
                thongTinTaiKhoan.SoLuongVeDaMua = thanhVien.SoLuongVeMua;
                thongTinTaiKhoan.ThongTinDatVe  = listThongTinDatVe;
                return(thongTinTaiKhoan);
            }
        }
예제 #12
0
        public IHttpActionResult PutAll(GheXeAll _gheXe)
        {
            try
            {
                using (var db = new DB())
                {
                    using (var transaction = db.Database.BeginTransaction())
                    {
                        Xe xe = db.Xes.FirstOrDefault(x => x.maxe == _gheXe.maxe);
                        if (xe == null)
                        {
                            return(BadRequest("Xe không t?n t?i"));
                        }
                        DateTime ngayCapNhat = DateTime.Now;
                        _gheXe.GheTang1.ForEach(x =>
                        {
                            x.Ghes.ForEach(y =>
                            {
                                if (!string.IsNullOrEmpty(y.maghe))
                                {
                                    Ghe ghe = db.Ghes.FirstOrDefault(z => z.maghe == (_gheXe.maxe + "_" + y.maghe));
                                    if (ghe == null)
                                    {
                                        db.Ghes.Add(new Ghe()
                                        {
                                            active = y.active,

                                            maghe       = (_gheXe.maxe + "_" + y.maghe),
                                            tenghe      = y.maghe,
                                            maxe        = _gheXe.maxe,
                                            ngaycapnhat = ngayCapNhat,
                                            tang        = 1,
                                            vitriX      = y.vitriX,
                                            vitriY      = y.vitriY
                                        });
                                    }
                                    else
                                    {
                                        ghe.active      = y.active;
                                        ghe.ngaycapnhat = ngayCapNhat;
                                        ghe.tang        = 1;
                                        ghe.vitriX      = y.vitriX;
                                        ghe.vitriY      = y.vitriY;
                                    }
                                }
                            });
                        });
                        _gheXe.GheTang2.ForEach(x =>
                        {
                            x.Ghes.ForEach(y =>
                            {
                                if (!string.IsNullOrEmpty(y.maghe))
                                {
                                    Ghe ghe = db.Ghes.FirstOrDefault(z => z.maghe == (_gheXe.maxe + "_" + y.maghe));
                                    if (ghe == null)
                                    {
                                        db.Ghes.Add(new Ghe()
                                        {
                                            active      = y.active,
                                            maghe       = (_gheXe.maxe + "_" + y.maghe),
                                            tenghe      = y.maghe,
                                            maxe        = _gheXe.maxe,
                                            ngaycapnhat = ngayCapNhat,
                                            tang        = 2,
                                            vitriX      = y.vitriX,
                                            vitriY      = y.vitriY
                                        });
                                    }
                                    else
                                    {
                                        ghe.active      = y.active;
                                        ghe.ngaycapnhat = ngayCapNhat;
                                        ghe.tang        = 2;
                                        ghe.vitriX      = y.vitriX;
                                        ghe.vitriY      = y.vitriY;
                                    }
                                }
                            });
                        });
                        db.SaveChanges();
                        transaction.Commit();
                        return(Ok(_gheXe));
                    }
                }
            }
            catch (Exception ex)
            {
                return(BadRequest(ex.Message));
            }
        }
예제 #13
0
        private Panel CreateDatGhePanel(Phim t, SuatChieu s)
        {
            Panel pn    = new Panel();
            Label lb_LV = new Label();
            Label lb_MH = new Label();

            pn.BackColor   = System.Drawing.Color.PeachPuff;
            pn.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
            pn.Controls.Add(lb_LV);
            pn.Controls.Add(lb_MH);
            pn.Location = new System.Drawing.Point(3, 55);
            pn.Name     = "PnFLow_DatGhe";
            pn.Size     = new System.Drawing.Size(907, 432);
            //
            // Buttons Ghe
            //
            List <Ghe> li    = MyResources.MyRapPhim.GetListGheFollowSC(t, s);
            int        soGhe = MyResources.MyRapPhim.FindPhong(s.MaPhong).SoGhe;

            for (int i = 0; i < soGhe - 7; i++)
            {
                Ghe    _tmp    = li[i];
                Button btn_ghe = new Button
                {
                    BackColor = System.Drawing.Color.White,
                    FlatStyle = System.Windows.Forms.FlatStyle.Flat,
                    Font      = new System.Drawing.Font("Segoe UI Semibold", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))),
                    ForeColor = System.Drawing.Color.Black,
                    Size      = new System.Drawing.Size(41, 26),
                    Text      = _tmp.MaGhe,
                    UseVisualStyleBackColor = false
                };
                btn_ghe.FlatAppearance.BorderSize = 0;
                btn_ghe.Click += this.Btn_GheClick;
                if (_tmp.TrangThai != "Trống")
                {
                    btn_ghe.Enabled   = false;
                    btn_ghe.BackColor = Color.LightGray;
                }
                string ma  = _tmp.MaGhe.Substring(0, 1);
                int    stt = Convert.ToInt32(_tmp.MaGhe.Substring(1, 2));
                int    day = Convert.ToInt32(ma.ToCharArray()[0]);
                btn_ghe.Location = new System.Drawing.Point(768, 70);
                int[] arrX     = { 768, 721, 623, 576, 529, 482, 435, 388, 341, 294, 197, 150, 103, 56 };
                int[] arrXForI = { 721, 576, 482, 388, 294, 150, 56 };
                if (ma == "I")
                {
                    btn_ghe.Location = new System.Drawing.Point(arrXForI[stt - 1], 70 + (day - 65) * 40);
                    btn_ghe.Size     = new System.Drawing.Size(88, 26);
                }
                else
                {
                    btn_ghe.Location = new System.Drawing.Point(arrX[stt - 1], 70 + (day - 65) * 40);
                }
                pn.Controls.Add(btn_ghe);
            }
            //
            // Labels Alplabet
            //
            for (int i = 0; i < 9; i++)
            {
                Label tmp = new Label
                {
                    AutoSize = true,
                    Font     = new System.Drawing.Font("Segoe UI Semibold", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))),
                    Location = new System.Drawing.Point(14, 75 + i * 40),
                    Size     = new System.Drawing.Size(17, 17),
                    TabIndex = 1,
                    Text     = ((char)(i + 65)).ToString()
                };
                pn.Controls.Add(tmp);
            }
            //
            // Label_ManHinh
            //
            lb_MH.BackColor = System.Drawing.Color.SkyBlue;
            lb_MH.Font      = new System.Drawing.Font("Segoe UI Semibold", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            lb_MH.Location  = new System.Drawing.Point(102, 13);
            lb_MH.Name      = "Label_ManHinh";
            lb_MH.Size      = new System.Drawing.Size(659, 34);
            lb_MH.TabIndex  = 15;
            lb_MH.Text      = "Màn hình";
            lb_MH.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
            //
            // Label_LoiVao
            //
            lb_LV.BackColor = System.Drawing.Color.DarkSlateGray;
            lb_LV.Font      = new System.Drawing.Font("Segoe UI Semibold", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            lb_LV.ForeColor = System.Drawing.Color.White;
            lb_LV.Location  = new System.Drawing.Point(825, 390);
            lb_LV.Name      = "Label_LoiVao";
            lb_LV.Size      = new System.Drawing.Size(70, 26);
            lb_LV.TabIndex  = 16;
            lb_LV.Text      = "Lối vào";
            lb_LV.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
            return(pn);
        }