public SimpleMembershipInitializer()
            {
                Database.SetInitializer<UsersContext>(null);

                try
                {
                    using (var context = new UsersContext())
                    {
                        if (!context.Database.Exists())
                        {
                            // Create the SimpleMembership database without Entity Framework migration schema
                            ((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
                        }
                    }
                    WebSecurity.InitializeDatabaseConnection("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
                }
                catch (Exception ex)
                {
                    throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
                }
            }
        //đi đến trang thanh toán
        public ActionResult ThanhToan()
        {
            int MaKhachSan = int.Parse(Request["MaKhachSan"].ToString());
            var _KhachSan = _context.KhachSan.Find(MaKhachSan);

            ViewBag.NgayNhanPhong = Request["ngayDau"].ToString();
            ViewBag.NgayTraPhong = Request["ngayCuoi"].ToString();
            ViewBag.KhachSanCanDat = _KhachSan;

            ViewBag.SoPhongLITE = Request["LITE"].ToString();
            ViewBag.GiaPhongLITE = (int.Parse(Request["LITE"]) * int.Parse(Request["LITE_GiaPhong"]));

            ViewBag.SoPhongNORMAL = Request["NORMAL"].ToString();
            ViewBag.GiaPhongNORMAL = (int.Parse(Request["NORMAL"]) * int.Parse(Request["NORMAL_GiaPhong"]));

            ViewBag.SoPhongVIP = Request["VIP"].ToString();
            ViewBag.GiaPhongVIP = (int.Parse(Request["VIP"]) * int.Parse(Request["VIP_GiaPhong"]));

            ViewBag.TongTien =  int.Parse(Request["LITE"]) * int.Parse(Request["LITE_GiaPhong"])
                              + int.Parse(Request["NORMAL"]) * int.Parse(Request["NORMAL_GiaPhong"])
                              + int.Parse(Request["VIP"]) * int.Parse(Request["VIP_GiaPhong"]);

            //lấy thông tin ng dùng đang đăng nhập
            if (WebSecurity.IsAuthenticated)
            {
                if (!WebSecurity.Initialized)
                {
                    WebSecurity.InitializeDatabaseConnection(
                        "DefaultConnection", "UserProfile", "UserId", "UserName",
                        autoCreateTables: false);
                }

                UsersContext uc = new UsersContext();
                UserProfile userProfile = uc.UserProfiles.Where(x => x.UserId == WebSecurity.CurrentUserId).FirstOrDefault();

                //
                ViewBag.HoVaTen = userProfile.FullName;
                ViewBag.Email = userProfile.Email;
                ViewBag.SoDienThoai = userProfile.PhoneNumber;
                ViewBag.DiaChi = userProfile.Address;
            }
            return View();
        }
        public ActionResult QuanLyTaiKhoan(ManageMessageId? message)
        {
            if (WebSecurity.IsAuthenticated)
            {
                if (!WebSecurity.Initialized)
                {
                    WebSecurity.InitializeDatabaseConnection(
                        "DefaultConnection", "UserProfile", "UserId", "UserName",
                        autoCreateTables: false);
                }

                UsersContext uc = new UsersContext();
                UserProfile userProfile = uc.UserProfiles.Where(x => x.UserId == WebSecurity.CurrentUserId).FirstOrDefault();

                //
                ViewBag.HoVaTen = userProfile.FullName;
                ViewBag.Email = userProfile.Email;
                ViewBag.SoDienThoai = userProfile.PhoneNumber;
                ViewBag.DiaChi = userProfile.Address;

                //lấy lịch sử đặt phòng
                ViewBag.LichSuDatPhong = (from p in _context.DatPhong where p.MaKhachHang == User.Identity.Name select p).ToList();
            }

            return View();
        }
        public ActionResult SuaDoiThongTin(string HoVaTen,string Email,string SoDienThoai,string DiaChi)
        {
            if (WebSecurity.IsAuthenticated)
            {
                if (!WebSecurity.Initialized)
                {
                    WebSecurity.InitializeDatabaseConnection(
                        "DefaultConnection", "UserProfile", "UserId", "UserName",
                        autoCreateTables: false);
                }

                UsersContext uc = new UsersContext();
                UserProfile userProfile = uc.UserProfiles.Where(x => x.UserId == WebSecurity.CurrentUserId).FirstOrDefault();

                userProfile.FullName = HoVaTen;
                userProfile.Email = Email;
                userProfile.PhoneNumber = SoDienThoai;
                userProfile.Address = DiaChi;

                uc.SaveChanges(); //lưu thay đổi
            }
            return RedirectToAction("QuanLyTaiKhoan", "Account");
        }
        public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
        {
            string provider = null;
            string providerUserId = null;

            if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId))
            {
                return RedirectToAction("Manage");
            }

            if (ModelState.IsValid)
            {
                // Insert a new user into the database
                using (UsersContext db = new UsersContext())
                {
                    UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
                    // Check if user already exists
                    if (user == null)
                    {
                        // Insert name into the profile table
                        db.UserProfiles.Add(new UserProfile { UserName = model.UserName });
                        db.SaveChanges();

                        OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
                        OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);

                        return RedirectToLocal(returnUrl);
                    }
                    else
                    {
                        ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name.");
                    }
                }
            }

            ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
            ViewBag.ReturnUrl = returnUrl;
            return View(model);
        }