Monday, January 23, 2012

send data to .Net webservice using android client

public void getColumnData(Cursor cur)
{


if (cur.moveToFirst()) {

String name;
String price;
String quantity;
String totpri;
String custid;
String ordid;
String remark1;
String remark2;
String remark3;
String remark4;
String remark;
String space1 = ",";
String space2 = ",";
String space3 = ",";
int nameColumn = cur.getColumnIndex(Databasehelper.itemName);
int p = cur.getColumnIndex(Databasehelper.itemPrice);
int q = cur.getColumnIndex(Databasehelper.itemQuan);
int tot = cur.getColumnIndex(Databasehelper.totpri1);
int cid = cur.getColumnIndex(Databasehelper.cid);
int oid = cur.getColumnIndex(Databasehelper.orderID);
int w1 = cur.getColumnIndex(Databasehelper.bytwo);
int w2 = cur.getColumnIndex(Databasehelper.withoil);
int w3 = cur.getColumnIndex(Databasehelper.withoutoil);
int w4 = cur.getColumnIndex(Databasehelper.withpepper);


do {
// Get the field values
name = cur.getString(nameColumn);
price = cur.getString(p);
quantity = cur.getString(q);
totpri = cur.getString(tot);
custid = cur.getString(cid);
ordid = cur.getString(oid);
remark1 = cur.getString(w1);

remark2 = cur.getString(w2);
remark3 = cur.getString(w3);
remark4 = cur.getString(w4);
remark = remark1+space1+remark2+space2+remark3+space3+remark4;


SoapObject request = new SoapObject(NAMESPACE, METHOD_NAME);

request.addProperty("sname", sysname);
request.addProperty("sport", sysport);
request.addProperty("uid", userid);
request.addProperty("upwd", pass);
request.addProperty("db", dbname);
request.addProperty("name", name);
request.addProperty("price", price);
request.addProperty("quantity",quantity);
request.addProperty("totpri", totpri);
request.addProperty("custid", custid);
request.addProperty("orderid", ordid);
request.addProperty("remark", remark);

SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11);

envelope.setOutputSoapObject(request);
envelope.dotNet = true;

HttpTransportSE aht= new HttpTransportSE(URL);
try
{
aht.call(SOAP_ACTION, envelope);
SoapPrimitive resultString = (SoapPrimitive)envelope.getResponse();

//Toast.makeText(Databasehelper.this,resultString, Toast.LENGTH_LONG).show();
// tvText.setText(resultString.toString());
}
catch (Exception E) {
Throwable error = E.getCause();
//tvText.setText(error.toString());
}

} while (cur.moveToNext());

}
}

No comments:

Post a Comment