public DataSet GetUser(SignInRequest request)
        {
            var email    = _infraDal.GetParameter("P_EMAIL", request.LoginDto.Email);
            var outParam = _infraDal.GetOutParameter("retval");

            return(_infraDal.ExecuteSpQuery(_connection, "GET_USER", email, outParam));
        }