this is the web service:
[WebMethod]
public string InsertCarte(string isbn, string titlu, string anAparitie, string limba, string volum, string editie, string observatii, string cuvantcheie1, string cuvantcheie2, string cuvantcheie3, string cuvantcheie4, string cuvantcheie5)
{
string result = "";
int vol;
if (volum == "")
{
vol = 1;
}
else
{
vol = Convert.ToInt16(volum);
}
try
{
string conStr = "server=localhost;database=biblioteca;Integrated Security = true;";
SqlConnection conn = new SqlConnection(conStr);
string cmdString = "insert into Carte_tbl values(@isbn,@titlu,@an,@limba,@volum,@editie,@observatii,@cuvantcheie1,@cuvantcheie2,@cuvantcheie3,@cuvantcheie4,@cuvantcheie5)";
try
{
SqlCommand sqlCommand = new SqlCommand(cmdString, conn);
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.Add("@isbn", SqlDbType.Text).Value = isbn;
sqlCommand.Parameters.Add("@titlu", SqlDbType.Text).Value = titlu;
sqlCommand.Parameters.Add("@an", SqlDbType.Text).Value = anAparitie;
sqlCommand.Parameters.Add("@limba", SqlDbType.Text).Value = limba;
sqlCommand.Parameters.Add("@volum", SqlDbType.Int).Value = vol;
sqlCommand.Parameters.Add("@editie", SqlDbType.Text).Value = editie;
sqlCommand.Parameters.Add("@observatii", SqlDbType.Text).Value = observatii;
sqlCommand.Parameters.Add("@cuvantcheie1", SqlDbType.Text).Value = cuvantcheie1;
sqlCommand.Parameters.Add("@cuvantcheie2", SqlDbType.Text).Value = cuvantcheie2;
sqlCommand.Parameters.Add("@cuvantcheie3", SqlDbType.Text).Value = cuvantcheie3;
sqlCommand.Parameters.Add("@cuvantcheie4", SqlDbType.Text).Value = cuvantcheie4;
sqlCommand.Parameters.Add("@cuvantcheie5", SqlDbType.Text).Value = cuvantcheie5;
conn.Open();
sqlCommand.ExecuteNonQuery();
conn.Close();
result = "Inserarea a fost facuta cu succes!";
}
catch (Exception ex)
{
Debug.WriteLine(ex);
result = "Inserarea nu a fost facuta";
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
return result;
}
The XML file:<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical" android:layout_width="match_parent"
android:layout_height="match_parent">
<TextView
android:id="@+id/textView0"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Insert Carte"
android:textAppearance="?android:attr/textAppearanceLarge"
android:longClickable="false"
android:layout_gravity="center_horizontal" />
<TextView
android:id="@+id/textView1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="ISBN"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtISBN"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Titlu"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtTitlu"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="AnAparitie"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtAnAparitie"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView4"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Limba"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtLimba"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView5"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Volum"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtVolum"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView6"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Editie"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtEditie"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView7"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Observatii"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtObservatii"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView8"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Cuv1"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtCuv1"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView9"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Cuv2"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtCuv2"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView10"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Cuv3"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtCuv3"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView11"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Cuv4"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtCuv4"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<TextView
android:id="@+id/textView12"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Cuv5"
android:textAppearance="?android:attr/textAppearanceLarge" />
<EditText
android:id="@+id/txtCuv5"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<requestFocus />
</EditText>
<LinearLayout
android:id="@+id/linearLayout1"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<Button
android:id="@+id/btnCarte"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_weight="0.5"
android:text="Insert Carte" />
</LinearLayout>
<Button
android:id="@+id/btnClear"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Clear" />
</LinearLayout>
The activity:package com.example.catalin.biblio;
/**
* Created by Catalin on 3/24/2015.
*/
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import org.ksoap2.SoapEnvelope;
import org.ksoap2.serialization.PropertyInfo;
import org.ksoap2.serialization.SoapObject;
import org.ksoap2.serialization.SoapSerializationEnvelope;
import org.ksoap2.transport.HttpTransportSE;
import org.ksoap2.SoapFault;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import android.view.Menu;
public class Activity5 extends Activity {
public final String SOAP_ACTION = "http://tempuri.org/InsertCarte";
public final String OPERATION_NAME = "InsertCarte";
public final String WSDL_TARGET_NAMESPACE = "http://tempuri.org/";
private static String METHOD_NAME1 = "InsertCarte";
public final String SOAP_ADDRESS = "http://localhost:6676/WebService1.asmx";
Button btnCarte, btnClear;
EditText txtISBN, txtTitlu, txtAnAparitie,txtLimba,txtVolum,txtEditie, txtObservatii,txtCuv1,txtCuv2,txtCuv3,txtCuv4,txtCuv5;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity5);
btnCarte = (Button) findViewById(R.id.btnCarte);
btnClear = (Button) findViewById(R.id.btnClear);
txtISBN = (EditText) findViewById(R.id.txtISBN);
txtTitlu = (EditText) findViewById(R.id.txtTitlu);
txtAnAparitie = (EditText) findViewById(R.id.txtAnAparitie);
txtLimba = (EditText) findViewById(R.id.txtLimba);
txtVolum = (EditText) findViewById(R.id.txtVolum);
txtEditie = (EditText) findViewById(R.id.txtEditie);
txtObservatii = (EditText) findViewById(R.id.txtObservatii);
txtCuv1 = (EditText) findViewById(R.id.txtCuv1);
txtCuv2 = (EditText) findViewById(R.id.txtCuv2);
txtCuv3 = (EditText) findViewById(R.id.txtCuv3);
txtCuv4= (EditText) findViewById(R.id.txtCuv4);
txtCuv5 = (EditText) findViewById(R.id.txtCuv5);
btnCarte.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
//Initialize soap request + add parameters
SoapObject request = new SoapObject(WSDL_TARGET_NAMESPACE, METHOD_NAME1);
//Use this to add parameters
PropertyInfo pi=new PropertyInfo();
pi.setName("ISBN");
pi.setValue(txtISBN.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
pi=new PropertyInfo();
pi.setName("Titlu");
pi.setValue(txtTitlu.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
pi=new PropertyInfo();
pi.setName("AnAparitie");
pi.setValue(txtAnAparitie.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
pi=new PropertyInfo();
pi.setName("Limba");
pi.setValue(txtLimba.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
pi=new PropertyInfo();
pi.setName("Volum");
pi.setValue(txtVolum.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
pi=new PropertyInfo();
pi.setName("Editie");
pi.setValue(txtEditie.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
pi.setName("Observatii");
pi.setValue(txtObservatii.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
request.addProperty(pi);
pi.setName("Cuv1");
pi.setValue(txtCuv1.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
request.addProperty(pi);
pi.setName("Cuv2");
pi.setValue(txtCuv2.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
request.addProperty(pi);
pi.setName("Cuv3");
pi.setValue(txtCuv3.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
request.addProperty(pi);
pi.setName("Cuv4");
pi.setValue(txtCuv4.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
request.addProperty(pi);
pi.setName("Cuv5");
pi.setValue(txtCuv5.getText().toString());
pi.setType(String.class);
request.addProperty(pi);
//Declare the version of the SOAP request
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11);
envelope.setOutputSoapObject(request);
envelope.dotNet = true;
try {
HttpTransportSE androidHttpTransport = new HttpTransportSE(SOAP_ADDRESS);
//this is the actual part that will call the webservice
androidHttpTransport.call(SOAP_ACTION + METHOD_NAME1, envelope);
// Get the SoapResult from the envelope body.
SoapObject result = (SoapObject)envelope.bodyIn;
if(result != null)
{
Toast.makeText(getBaseContext(), result.getProperty(0).toString(), Toast.LENGTH_SHORT).show();
txtISBN.setText("");
txtTitlu.setText("");
txtAnAparitie.setText("");
txtLimba.setText("");
txtVolum.setText("");
txtEditie.setText("");
txtObservatii.setText("");
txtCuv1.setText("");
txtCuv2.setText("");
txtCuv3.setText("");
txtCuv4.setText("");
txtCuv5.setText("");
}
else
{
Toast.makeText(getApplicationContext(), "No Response",Toast.LENGTH_LONG).show();
}
} catch (Exception e) {
e.printStackTrace();
}
}
});
btnClear.setOnClickListener(new View.OnClickListener()
{
@Override
public void onClick(View v)
{
txtISBN.setText("");
txtTitlu.setText("");
txtAnAparitie.setText("");
txtLimba.setText("");
txtVolum.setText("");
txtEditie.setText("");
txtObservatii.setText("");
txtCuv1.setText("");
txtCuv2.setText("");
txtCuv3.setText("");
txtCuv4.setText("");
txtCuv5.setText("");
}
});
}
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
}
Main Activity:
package com.example.catalin.biblio;
import android.content.Intent;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class MainActivity extends Activity implements OnClickListener {
Button btnAdresa;
Button btnArticol;
Button btnAutor;
Button btnCarte;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
btnAdresa = (Button) findViewById(R.id.btnAdresa);
btnAdresa.setOnClickListener(this);
btnArticol = (Button) findViewById(R.id.btnArticol);
btnArticol.setOnClickListener(this);
btnAutor = (Button) findViewById(R.id.btnAutor);
btnAutor.setOnClickListener(this);
btnCarte = (Button) findViewById(R.id.btnCarte);
btnCarte.setOnClickListener(this);
}
@Override
public void onClick(View v) {
switch (v.getId()) {
case R.id.btnAdresa:
// TODO Call second activity
Intent intent = new Intent(this, ActivityTwo.class);
startActivity(intent);
break;
case R.id.btnArticol:
// TODO Call second activity
Intent intent1 = new Intent(this, ActivityThree.class);
startActivity(intent1);
break;
case R.id.btnAutor:
// TODO Call second activity
Intent intent2 = new Intent(this, Activity4.class);
startActivity(intent2);
break;
case R.id.btnCarte:
// TODO Call second activity
Intent intent3 = new Intent(this, Activity5.class);
startActivity(intent3);
break;
default:
break;
}
}
}
and The manifest:
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.catalin.biblio" >
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE"/>
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<application
android:allowBackup="true"
android:icon="@mipmap/ic_launcher"
android:label="@string/app_name"
android:theme="@style/AppTheme" >
<activity
android:name=".MainActivity"
android:label="@string/app_name" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:label="@string/app_name"
android:name=".ActivityTwo" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:label="@string/app_name"
android:name=".ActivityThree" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:label="@string/app_name"
android:name=".Activity4" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:label="@string/app_name"
android:name=".Activity5" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
</application>
</manifest>
What is wrong????when i tap the button insert carte nothing happen..
Android : I'm trying to insert into sql database from android using webservice but does not working
on Wednesday, March 25, 2015
0 comments:
Post a Comment