Webservices using Json

 Simple webservice using json..

Json string format ..

{"email":" raman@gmail.com ", 

"contact":[          

 {"phone":["333","6666"],"name":"a","Email":["Raman@tet","6@gmailcom"],"address":"jaipur"},        {"phone":["333","6666"],"name":"a","Email":["Raman@tet","6@gmailcom"],"address":"jaipur"},

{"phone":["333","6666"],"name":"a","Email":["Raman@tet","6@gmailcom"],"address":"jaipur"},

 {"phone":["333","6666"],"name":"a","Email":["Raman@tet","6@gmailcom"],"address":"jaipur"}

    ] }

 pass this json string to function it will  be De serialized and saved to database..

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Runtime.Serialization.Json;
using System.IO;
using System.Text;
using System.Web.Script.Serialization;
using System.Data.SqlClient;
using System.Data;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Service : System.Web.Services.WebService
{
    string connstr = "Data Source=209.44.191.78;Initial Catalog=db_Target;uid=raman;pwd=Choudhart@$1;Connect Timeout=600;pooling='true'; Max Pool Size=100;";
    SqlCommand cmd;
    public Service()
    {

        //Uncomment the following line if using designed components
        //InitializeComponent();
    }


       public class Mypersonclass
    {
        public string email;
        public List<CustomObject> Contact { get; set; }
    }
  
    public class CustomObject
    {

        public string[] phone { get; set; }
        public string name { get; set; }
        public string[] Email { get; set; }
        public string address { get; set; }
    }
       
 
    [WebMethod]
    public string SaveContacts(string json)
    {
        SqlConnection constr = new SqlConnection(connstr);
        SqlDataReader dr;
        constr.Open();
        int MainID=0;
        Mypersonclass facebookFriends = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<Mypersonclass>(json);
         string Query="select CustomerID from tbl_nav_customer where emailid='" + facebookFriends.email.Trim()+"'";
        cmd = new SqlCommand(Query, constr);
        dr= cmd.ExecuteReader();
        if (dr.Read())
        {
             MainID = Convert.ToInt32(dr["CustomerID"].ToString());
        }
        try
        {
            constr.Close();
            constr.Open();
            foreach (var item in facebookFriends.Contact)
            {
                string phone=ConvertStringArrayToString(item.phone);
                string email=ConvertStringArrayToString(item.Email);
                cmd = new SqlCommand("insert into tbl_nav_contact(phone,name,email,address,ContactID)values('" + phone + "','" + item.name + "','" + email + "','" + item.address + "','" + MainID + "')", constr);
                cmd.ExecuteNonQuery();
            }
          
          
        }
        catch { }
        finally
        {
            constr.Close();
        }
        return "saved";
    }
    static string ConvertStringArrayToString(string[] array)
    {
       
        StringBuilder builder = new StringBuilder();
        foreach (string value in array)
        {
            builder.Append(value);
            builder.Append('.');
        }
        return builder.ToString();
    }
}