How To call get Android App Parameter From WCF Serivce

Question

0.00/5 (No votes)

See more:

I New In WCF So Anybody Help Me

My Task is To Create WCF Service For Android App

Get Data From Android App Anmd Save It Into SQL server Using WCF service

My code IS Iservice.cs

[OperationContract]
        [WebGet(UriTemplate = "/GetBarCodeData/{barcode}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Bare)]
        [return: MessageParameter(Name = "barcode")]
        string GetBarCodeData(string barcode);

Service1.svc.cs

public string  GetBarCodeData(string barcode)
        {
       
            SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            sqlConnection.Open();
            SqlCommand sqlCommand = new SqlCommand("Insert Into Emp(Ename)values('" + barcode + "')");
            SqlDataAdapter sdap = new SqlDataAdapter();
            sqlCommand.Connection = sqlConnection;
            sqlCommand.ExecuteNonQuery();
            // flag = true;
            //dataset ds = new dataset();
            //sqldataadapter sqldataadapter = new sqldataadapter(sqlcommand);
            //sqldataadapter.fill(ds);
            sqlConnection.Close();
            return barcode;
}

Web Config

XML

<?xml version="1.0"?>
<configuration>

  <system.web>
    <compilation debug="true" targetFramework="4.0" />
  </system.web>

  <connectionStrings>
    <add name ="ConnectionString" providerName ="System.Data.SqlClient" ;persist security info=True;multipleactiveresultsets=True;"/>
  </connectionStrings>
  <system.serviceModel>
    <behaviors>
      <serviceBehaviors>
        <behavior>
          <!-- To avoid disclosing metadata information, set the value below to false and remove the metadata endpoint above before deployment -->
          <serviceMetadata httpGetEnabled="true"/>
          <!-- To receive exception details in faults for debugging purposes, set the value below to true.  Set to false before deployment to avoid disclosing exception information -->
          <serviceDebug includeExceptionDetailInFaults="false"/>
        </behavior>
      </serviceBehaviors>
    </behaviors>
    <serviceHostingEnvironment multipleSiteBindingsEnabled="true" />
  </system.serviceModel>
  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true"/>
  </system.webServer>

</configuration>

Posted 25-Jun-14 0:28am

Member 10189206

Updated 25-Jun-14 0:36am

Vedat Ozan Oner

v2

Add a Solution

Comments

Vedat Ozan Oner 25-Jun-14 6:38am

do you your service up and running? have you tested it?

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)

Pravuprasad · Answer 1 · 2014-06-25T00:45:00

first of all if you want to get data from android app and store in database , then create a wcf service , then define [OperationContract] in interface like below

[OperationContract]
[WebInvoke(UriTemplate = "/GetBarCodeData/{barcode}", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Bare)]
string GetBarCodeData(string barcode);

then write the logic in .svc.cs for inserting data in server (Like traditional way)

now go to web.config file
in <system.servicemodel> define end points and behaviours

XML

<pre> <system.serviceModel>
    <bindings>
      <webHttpBinding>
        <binding bypassProxyOnLocal="true" useDefaultWebProxy="false" hostNameComparisonMode="WeakWildcard" sendTimeout="10:15:00" openTimeout="10:15:00" receiveTimeout="10:15:00" maxBufferSize="2147483647" transferMode="StreamedRequest" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647">
          <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />
          <security mode="None" />
        </binding>
      </webHttpBinding>
    </bindings>

    <services>
      <service name="Pojectname.serviceclassname" behaviorConfiguration="Pojectname.serviceclassnameBehavior">
        <endpoint address="" binding="webHttpBinding" contract="Pojectname.serviceinterfacename" behaviorConfiguration="webBehaviour" />
        <endpoint name="mexHttpBinding" address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />
      </service>
    </services>

    <behaviors>
      <serviceBehaviors>
        <behavior name="Pojectname.serviceclassnameBehavior">
          <!-- To avoid disclosing metadata information, set the values below to false before deployment -->
          <serviceMetadata httpGetEnabled="true" httpsGetEnabled="true" />
          <!-- To receive exception details in faults for debugging purposes, set the value below to true.  Set to false before deployment to avoid disclosing exception information -->
          <serviceDebug includeExceptionDetailInFaults="true" />
        </behavior>
      </serviceBehaviors>
      <endpointBehaviors>
        <behavior name="webBehaviour">
          <webHttp />
        </behavior>
      </endpointBehaviors>
    </behaviors>

    <protocolMapping>
      <add binding="basicHttpsBinding" scheme="https" />
    </protocolMapping>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" multipleSiteBindingsEnabled="true" minFreeMemoryPercentageToActivateService="0" />
  </system.serviceModel

>

hope it will help you.