Beispiel #1
0
        /// <summary>
        /// Created By    : hussain
        /// Created Date  : 15 May 2014
        /// Modified By   :  
        /// Modified Date :  
        /// </summary>
        /// <returns> check User Login credentials valid UserDetails</returns>
        public static List<UserDetails> CheckUsersLogin(string Userid, string Pwd)
        {
            var users = new List<UserDetails>();

            System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
            System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
            log.Debug("Start: " + methodBase.Name);
            string encryptedPwd = UserLogin.Encrypt(Pwd);
            SqlParameter[] sqlParams = new SqlParameter[2];
            sqlParams[0] = new SqlParameter("@LoginID", Userid);
            sqlParams[1] = new SqlParameter("@Pwd", encryptedPwd);
            var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpCheckUserLogin", sqlParams);
            var safe = new SafeDataReader(reader);
            while (reader.Read())
            {
                var user = new UserDetails();
                user.FetchLoginUser(user, safe);
                users.Add(user);
            }

            log.Debug("End: " + methodBase.Name);

            return users;
        }