public ActionResult Register([Bind(Exclude = "IsEmailVerified, ActivationCode")] UserRegister register)
        {
            bool   Status  = false;
            string Message = "";

            if (ModelState.IsValid)
            {
                #region Email Already Exist
                var isExist = IsEmailExist(register.EmailID);
                if (isExist)
                {
                    ModelState.AddModelError("EmailExist", "Email Already Exist");
                    return(View(register));
                }
                #endregion

                #region Generate Activation Code
                register.ActivationCode = Guid.NewGuid();
                #endregion

                #region Password Hashing
                register.Password        = Crypto.Hash(register.Password);
                register.ConfirmPassword = Crypto.Hash(register.ConfirmPassword);
                #endregion

                #region Save to database
                using (SangitMISEntities db = new SangitMISEntities())
                {
                    db.UserRegisters.Add(register);
                    db.SaveChanges();
                }
                #endregion

                #region Send Verification Email Link
                sendVerificationEmailLink(register.EmailID, register.ActivationCode.ToString());
                Message = " Registration succesfully done" + " Email Activation Link has been sent to your email Id "
                          + register.EmailID;
                Status = true;
                #endregion
            }
            else
            {
                Message = "Invalid Request";
            }
            ViewBag.message = Message;
            ViewBag.status  = Status;
            return(View(register));
        }
        public ActionResult VerifyAccount(string id)
        {
            bool status = false;

            using (SangitMISEntities SangitMIS = new SangitMISEntities())
            {
                SangitMIS.Configuration.ValidateOnSaveEnabled = false;

                var v = SangitMIS.UserRegisters.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();

                if (v != null)
                {
                    v.IsEmailVerified = true;
                    SangitMIS.SaveChanges();
                    status = true;
                }
                else
                {
                    ViewBag.Message = "Invalid Request";
                }
            }
            ViewBag.status = status;
            return(View());
        }