public override string GetUserNameByEmail(string email)
 {
     using (AuthenticationDB dbContext = new DataAccess.AuthenticationDB())
     {
         string username = dbContext.Users
                           .Where(us => string.Compare(email, us.Email) == 0)
                           .Select(u => u.Username).FirstOrDefault();
         return(!string.IsNullOrEmpty(username) ? username : string.Empty);
     }
 }
        public override string GetUserNameByEmail(string email)
        {
            using (AuthenticationDB dbContext = new DataAccess.AuthenticationDB())
            {
                string username = (from u in dbContext.Users
                                   where string.Compare(email, u.USR_DES_EMAIL) == 0
                                   select u.USR_DES_NAME).FirstOrDefault();

                return(!string.IsNullOrEmpty(username) ? username : string.Empty);
            }
        }
        public ActionResult ActivationAccount(string id)
        {
            bool statusAccount = false;

            using (AuthenticationDB dbContext = new DataAccess.AuthenticationDB())
            {
                var userAccount = dbContext.Users.Where(u => u.ActivationCode.ToString().Equals(id)).FirstOrDefault();

                if (userAccount != null)
                {
                    userAccount.IsActive = true;
                    dbContext.SaveChanges();
                    statusAccount = true;
                }
                else
                {
                    ViewBag.Message = "Something Wrong !!";
                }
            }
            ViewBag.Status = statusAccount;
            return(View());
        }