public ActionResult showEditProfile()
        {
            int    id      = Convert.ToInt32(Session["userID"]);
            string name    = Request["Username"];
            string email   = Request["email"];
            string address = Request["address"];
            string gender  = Request["Gender"];

            //không thay đổi giới tính
            if (gender == null)
            {
                gender = db.Users.Where(x => x.Id == id).Select(x => x.Gender).FirstOrDefault();
            }
            string   phone  = Request["phone"];
            DateTime date   = Convert.ToDateTime(Request["date"]);
            string   avatar = Session["Avatar"].ToString();

            db.sp_EditProfile(id, name, email, address, gender, phone, date, avatar);
            db.SaveChanges();

            //return RedirectToAction("EditProFile");
            if (Session["userID"] != null)
            {
                id           = Convert.ToInt32(Session["userID"]);
                ViewBag.User = db.Users.Where(x => x.Id == id).FirstOrDefault();
                date         = Convert.ToDateTime(ViewBag.User.Birthday);
                string day   = date.Day.ToString();
                string month = date.Month.ToString();
                if (date.Day < 10)
                {
                    day = "0" + date.Day;
                }
                if (date.Month < 10)
                {
                    month = "0" + date.Month;
                }

                ViewBag.birthday = date.Year + "-" + month + "-" + day;
            }
            return(PartialView("EditProfile"));
        }