/// <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); } }
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; } }