INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Need to run a whereClause query from SOAP nested in ASPX C# file

Need to run a whereClause query from SOAP nested in ASPX C# file

Need to run a whereClause query from SOAP nested in ASPX C# file

(OP)
I got help from BillyRayPreacherSon, TheBugSlayer, and drlex from Tek-Tips' forum and my friend Jah-Red to get to this point of understanding. This is now narrowed down to a SOAP question.

My inquery begins at this forum thread:
http://www.tek-tips.com/viewthread.cfm?qid=1619151

So, long story short, I want to display my externally generated listing by the first letter only per page, exactly like these guys do: http://www.ticketnetwork.com/performers/concerts/a.aspx

The 3rd party service gave me these tools to work with, but I don't know how it works. It looks like XML it is pumping out, which might explain the JavaScript working the way it does.

These are the sites the 3rd party service gave me:
http://tnwebservices-test.ticketnetwork.com/tnwebservice/v3.0/TNWebService.asmx?op=SearchEvents

http://tnwebservices-test.ticketnetwork.com/tnwebservice/v3.1/tnwebservicestringinputs.asmx?WSDL


My page currently looks like this, calling all the items:

http://drewstickets.com/Concerts.aspx

and needs to look more like this, only calling every item by its 1st letter at a page:

http://www.ticketnetwork.com/performers/concerts/a.aspx


How do I place my SQL query in my pre-existing file in the proper SOAP syntax? I am in foreign territory since I usually work in PHP. I also don't know what the SQL columns are called since it is a 3rd party service. I can't help feeling the answer is staring me in the face.



The page file looks like this (using masterpage file):

<%@ page language="C#" autoeventwireup="true" inherits="Concerts, App_Web_g65xkisr" masterpagefile="~/BasePage.master" %>


<asp:Content ContentPlaceHolderID="contentBody" ID="cntBody" runat="server">

<script language="javascript" type="text/javascript">
document.write('<script language="javascript" src="http://tickettransaction.com/?bid='+4420+'&sitenumber='+2+'&tid=event_names&pcatid=2&showcats=true&title=Concerts Tickets"></' + 'script>');
</script>

</asp:Content>



And the query should look something like this:

SELECT * FROM GetEvents WHERE eventName = "0%" BETWEEN "9%"
SELECT * FROM GetEvents WHERE eventName = "A%"
SELECT * FROM GetEvents WHERE eventName = "B%"
SELECT * FROM GetEvents WHERE eventName = "C%"

SELECT * FROM GetEvents WHERE eventName = "Z%"

I am a little lost and just want to figure out how to run this. The 3rd party service thinks this is easy to understand.


Here is a SOAP 1.2 example of what they suggest:

POST /TNWebservice/v3.1/TNWebserviceStringInputs.asmx HTTP/1.1
Host: tnwebservices-test.ticketnetwork.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetEvents xmlns="http://tnwebservices-test.ticketnetwork.com/tnwebservice/v3.1">
      <websiteConfigID>string</websiteConfigID>
      <numberOfEvents>string</numberOfEvents>
      <eventID>string</eventID>
      <eventName>string</eventName>
      <eventDate>string</eventDate>
      <beginDate>string</beginDate>
      <endDate>string</endDate>
      <venueID>string</venueID>
      <venueName>string</venueName>
      <stateProvDesc>string</stateProvDesc>
      <stateID>string</stateID>
      <cityZip>string</cityZip>
      <nearZip>string</nearZip>
      <parentCategoryID>string</parentCategoryID>
      <childCategoryID>string</childCategoryID>
      <grandchildCategoryID>string</grandchildCategoryID>
      <performerID>string</performerID>
      <performerName>string</performerName>
      <noPerformers>string</noPerformers>
      <lowPrice>string</lowPrice>
      <highPrice>string</highPrice>
      <modificationDate>string</modificationDate>
      <onlyMine>string</onlyMine>
      <whereClause>string</whereClause>
      <orderByClause>string</orderByClause>
    </GetEvents>
  </soap12:Body>
</soap12:Envelope>

and then this (I don't know why they have two versions):


HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetEventsResponse xmlns="http://tnwebservices-test.ticketnetwork.com/tnwebservice/v3.1">
      <GetEventsResult>
        <Event>
          <ChildCategoryID>int</ChildCategoryID>
          <City>string</City>
          <Clicks>int</Clicks>
          <Date>dateTime</Date>
          <DisplayDate>string</DisplayDate>
          <GrandchildCategoryID>int</GrandchildCategoryID>
          <ID>int</ID>
          <IsWomensEvent>boolean</IsWomensEvent>
          <MapURL>string</MapURL>
          <Name>string</Name>
          <ParentCategoryID>int</ParentCategoryID>
          <StateProvince>string</StateProvince>
          <StateProvinceID>int</StateProvinceID>
          <Venue>string</Venue>
          <VenueConfigurationID>int</VenueConfigurationID>
          <VenueID>int</VenueID>
          <CountryID>int</CountryID>
        </Event>
        <Event>
          <ChildCategoryID>int</ChildCategoryID>
          <City>string</City>
          <Clicks>int</Clicks>
          <Date>dateTime</Date>
          <DisplayDate>string</DisplayDate>
          <GrandchildCategoryID>int</GrandchildCategoryID>
          <ID>int</ID>
          <IsWomensEvent>boolean</IsWomensEvent>
          <MapURL>string</MapURL>
          <Name>string</Name>
          <ParentCategoryID>int</ParentCategoryID>
          <StateProvince>string</StateProvince>
          <StateProvinceID>int</StateProvinceID>
          <Venue>string</Venue>
          <VenueConfigurationID>int</VenueConfigurationID>
          <VenueID>int</VenueID>
          <CountryID>int</CountryID>
        </Event>
      </GetEventsResult>
    </GetEventsResponse>
  </soap12:Body>
</soap12:Envelope>


How do I put a SOAP request with where Clause into my ASPX with masterpagefile using C# language that will just work the way I want it?

This JavaScript is pulling data really easy, but it is ALL the events. Isn't there a way to filter what is already being called?   

RE: Need to run a whereClause query from SOAP nested in ASPX C# file

(OP)
I honestly don't know how to work that thing. I get all kinds of errors.

I have my websiteConfigID, but after that, nothing shows up right.

Here is a documentation file:
http://www.nuwudmultimedia.com/Documentation.pdf

RE: Need to run a whereClause query from SOAP nested in ASPX C# file

(OP)
This is also supposed to be helpful:

http://tnwebservices-test.ticketnetwork.com/tnwebservice/v3.1/WSDL/tnwebservice.xml

I just don't understand how all this XML style code is going into my existing ASP page. It is a little confusing.

How do I make sure it only calls for events strictly from ParentCategoryID 2? What variation of the where Clause do I have to use? I tried variations of this (and nothing worked): WHERE eventName = "A%"  

RE: Need to run a whereClause query from SOAP nested in ASPX C# file

Since the service is for subscriber, I can't test on it. In any case, you have to ask for the syntactic detail for the request and response of SearchEvents - it cannot be guess work.

>This JavaScript is pulling data really easy, but it is ALL the events.
Your page is served with the data prepared server-side. Am I mistaken of this observation? Why do you say something relating to "Javascript ... easy" is beyond me. If it is easy, is that your work or somebody else's? The deduction of how easy seems very unsubstantive, so I am suspecting whether you understand that part!

I re-read your first post. The service provider provides you exactly the page I am referring to op=SearchEvents. But why you are listing request and response layouts for GetEvents? Those layouts for SearchEvents is shown in the page I am quoted above!

>and then this (I don't know why they have two versions): [/i]
Two versions because one is the request, the other is the response!

In any case, there seems to having huge gap between description and the technical material you try to show. I don't see any hints on the server-side (service consumer part) at all. I wonder why? So I wonder whether you need actually more time to diguest the technology first?

One definite way to proceed is that you write an xslt to transform the all englobing events document retrieved you said easily and successfully. In the xslt you have one top-level parameter specifying you want event name starting from a/A or b/B,... Transform the document and then serve it to the client... But again, do you feel comfortable on xslt?

RE: Need to run a whereClause query from SOAP nested in ASPX C# file

(OP)
I inherited this system from another developer that had developed this for the person I have to do this for. The 3rd party service was also there before. I would have built everything in php, which is what I feel more comfortable with. I also feel relatively comfortable with JavaScript, did not mean to call it easy.

I looked into what the previous developer did in the theatre page of ours:

<script language="javascript" type="text/javascript">

document.write('<script language="javascript" src="http://tickettransaction.com/?bid='+4420+'&sitenumber='+2+'&tid=event_names&pcatid=3&title=Theater Events&showcats=true&grpby=city"></' + 'script>');
                                        </script>

I looked up "grpby" and found it could be DB2 being used.
http://webdocs.caspur.it/ibm/udb-6.1/db2help/index.htm#ctlve-11

I have no idea why the previous guy used this and why none of the previous files look like the examples provided by the 3rd party. But it works, to some degree! I thought learning to parse this was going to take much less time. I can leave tickets for the 3rd party provider, but what should I be asking them? They keep dancing around my questions. Maybe I am asking the wrong things.

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close