public ActionResult ChangeEmailId(string EmailId, string Password)
        {
            var  dbc    = new DbConnectivityModel();
            var  userId = Session["UserId"].ToString();
            bool result = dbc.ValidateEmail(EmailId);

            if (result == true)
            {
                bool exist = dbc.CheckPassword(Password, userId);
                if (exist == true)
                {
                    bool outcome = dbc.ChangeEmailId(EmailId, Password, userId);
                    if (outcome == true)
                    {
                        return(RedirectToAction("Account"));
                    }
                    else
                    {
                        return(View());
                    }
                }
                else
                {
                    ViewBag.PasswordMessage = "Invalid Password";
                    return(View());
                }
            }
            else
            {
                ViewBag.EmailMessage = "Email ID already Registered";
                return(View());
            }
        }
        public ActionResult ChangeUserPassword(string CurrentPassword, string NewPassword)
        {
            var  dbc    = new DbConnectivityModel();
            var  userId = Session["UserId"].ToString();
            bool exist  = dbc.CheckPassword(CurrentPassword, userId);

            if (exist == true)
            {
                bool change = dbc.UpdatePassword(CurrentPassword, NewPassword, userId);
                if (change == true)
                {
                    return(View("Account"));
                }
                else
                {
                    return(View());
                }
            }
            else
            {
                ViewBag.PasswordMessage = "Invalid Password";
                return(View());
            }
        }