How to pass parameters to wcf service from android application and connect with sql server database?

Question

0.00/5 (No votes)

See more:

My android side code

Java

String from=et1.getText().toString();
        String to=et2.getText().toString();
        String id=et3.getText().toString();
        String inputxele="ReportData FromDate='"+from+"' ToDate='"+to+"' UserId='"+id+"'";
        String                  url="http://10.0.2.2/JsonWcfService/GetEmployees.svc/?";
        String resp = null;
        InputStream instream =null;
        try
        {
            List<namevaluepair> postParams = new ArrayList<namevaluepair>();
            postParams.add(new BasicNameValuePair("spName", "USP_ListingReport"));
            postParams.add(new BasicNameValuePair("inputxele", inputxele));
            postParams.add(new BasicNameValuePair("transType", "GetMobileData"));
            HttpParams httpParameters = new BasicHttpParams();
            HttpConnectionParams.setConnectionTimeout(httpParameters, 20000);
            HttpConnectionParams.setSoTimeout(httpParameters, 20000);
            HttpClient httpclient = new DefaultHttpClient(httpParameters);
            HttpPost httppost = new HttpPost(url);
            httppost.setHeader("Content-Type", "application/json");
            httppost.setEntity(new UrlEncodedFormEntity(postParams,HTTP.UTF_8));
            HttpResponse response;
            response = httpclient.execute(httppost);
            StatusLine statusLine = response.getStatusLine();
            if(statusLine.getStatusCode() == HttpStatus.SC_OK)
            {
                HttpEntity entity = response.getEntity();
                instream = entity.getContent();
                resp = convertStreamToString(instream);
                instream.close();
            }
        }
        catch (IOException e)
        {
            e.printStackTrace();
            resp = null;
        }
        return resp;
    }

MY WCF SERVICE CODE

C#

[OperationContract]
[WebInvoke(UriTemplate = "?spName={spName}&inputxele={inputxele}&transType={transType}",
    BodyStyle = WebMessageBodyStyle.Wrapped,
    Method = "POST",
    RequestFormat = System.ServiceModel.Web.WebMessageFormat.Json)]
string ValidateCredentials(string spName, string inputxele,string transType);

Using this code i am getting an error "methodnotallowed" exception.

Any help will be appreciated.
Thanks in advance

Posted 4-Dec-14 1:28am

Raghu Golla

Updated 4-Dec-14 2:27am

DamithSL

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Answer 1 · 2014-12-04T03:12:00

If I understood it correctly then remove that ? from the UriTemplate. Make it this way,

C#

[OperationContract]
[WebInvoke(UriTemplate = "spName={spName}&inputxele={inputxele}&transType={transType}",
    BodyStyle = WebMessageBodyStyle.Wrapped,
    Method = "POST",
    RequestFormat = System.ServiceModel.Web.WebMessageFormat.Json)]
string ValidateCredentials(string spName, string inputxele,string transType);

You don't need to explicitly define that, see this example (POST method):

VB

[OperationContract]
        [WebInvoke(UriTemplate = "AddPost",
            BodyStyle = WebMessageBodyStyle.WrappedRequest,
            RequestFormat = WebMessageFormat.Json,
            ResponseFormat = WebMessageFormat.Json)]
        string AddPost(string title, string description, string startTime, string endTime, string noticeTypeId, string groupId, string userId, string approvalStatus);

-KR