Esempio n. 1
0
        /// <summary>
        /// Get RoleID Name by RoleName
        /// </summary>
        /// <param name="Rolename"></param>
        /// <returns></returns>
        public int getRolesofUserbyRolename(string Rolename)
        {
            using (var _context = new AdventureTaskEntities())
            {
                var roleID = (from role in _context.Roles
                              where role.RoleName == Rolename
                              select role.RoleID).SingleOrDefault();

                return(roleID);
            }
        }
Esempio n. 2
0
        public PersonLogin ValidateUser(string userName, string passWord)
        {
            try
            {
                using (var _context = new AdventureTaskEntities())
                {
                    var validate = (from user in _context.PersonLogins
                                    where user.EmailAddress == userName && user.Password == passWord
                                    select user).SingleOrDefault();

                    return(validate);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }