WCF With Aspx and Silverlight

WCF With Aspx and Silverlight

First Type

In Web.Config to set basicHttpBinding for call by silverlight xaml side otherwise wsHttpBinding

1->WCF Service –File IService.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

// NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService" in both code and config file together.

[ServiceContract]

public interface IService

{

    [OperationContract]

  

    int save(object id1, object name1, object salary1);

   

}

2-> WCF Service Call By Asps Page Service.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

using System.Data;

using System.Data.SqlClient;

// NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service" in code, svc and config file together.

public class Service : IService

{

    SqlConnection con;

    public Service()

    {

         con= new SqlConnection("initial catalog=nkp;data source=nkp-pc;integrated security=yes");

    }

    public int save(object id1, object name1, object salary1)   //prototype

    {

       

        SqlCommand cmd = new SqlCommand("add_chk", con);

        if (con.State == ConnectionState.Closed)

        {

            con.Open();

        }

        cmd.CommandType = CommandType.StoredProcedure;

         

        cmd.Parameters.AddWithValue("@id", (int)id1);

        SqlDataReader rd = cmd.ExecuteReader();

        bool b = rd.Read();

        if (b == true)

          {

            return 0;

          }

        else

          {

              SqlCommand cmd1 = new SqlCommand("add_data2", con);

              if (con.State == ConnectionState.Open)

              {

                  con.Close();

              }

              if (con.State == ConnectionState.Closed)

              {

                  con.Open();

              }

         

          

            cmd1.CommandType = CommandType.StoredProcedure;

            cmd1.Parameters.AddWithValue("@id", (int)id1);

            cmd1.Parameters.AddWithValue("@name", (string)name1);

            cmd1.Parameters.AddWithValue("@salary",(int)salary1);

            int temp = cmd1.ExecuteNonQuery();

            if (con.State == ConnectionState.Open)

            {

                con.Close();

            }

          

          

            return 1;

          }

       }

    }

 

3-> On  Asps Page Take WCF Service Reference file Aspx.cs

..

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        ServiceReference1.ServiceClient s = new ServiceReference1.ServiceClient();

        int t = s.save(106, "ram", 43000);

        Response.Write(t.ToString());  //return 0 (true) or

                                       // 1 (false)

     }

}

                                            Or :

//Aspx.cs file

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        int id = Convert.ToInt32(TextBox1.Text);

        string name = TextBox2.Text;

        int salary = Convert.ToInt32(TextBox3.Text);

        ServiceReference1.ServiceClient s = new ServiceReference1.ServiceClient();

        int t = s.save(id, name,salary);

        if (t == 1)

        {

            Label1.Text = "Record is saved...";

            //Response.Write(t.ToString());

        }

        else

        {

           Label1.Text = "Record is exist...";

            //Response.Write(t.ToString());

        }

     }

}

Second Type

1->Class1.cs Add in WCF Service Side

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

public class Class1

{

    private int id;

    private string name;

    private decimal salary;

    public int stuid

    {

        get { return id; }

        set { id = value; }

    }

    public string stuname

    {

        get { return name; }

        set { name = value; }

    }

    public decimal stusalary

    {

        get { return salary; }

        set { salary = value; }

    }

}

2->WCF Service –File IService.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

// NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService" in both code and config file together.

[ServiceContract]

public interface IService

{

    [OperationContract]

   // int save(object id1, object name1, object salary1);

    int save(Class1 c);

}

3->WCF Service –File Service.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

using System.Data;

using System.Data.SqlClient;

// NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service" in code, svc and config file together.

public class Service : IService

{

    SqlConnection con;

    public Service()

    {

         con= new SqlConnection("initial catalog=nkp;data source=nkp-pc;integrated security=yes");

    }

public  int save(Class1 c)

          {

              SqlCommand cmd = new SqlCommand("add_chk", con);

              if (con.State == ConnectionState.Closed)

              {

                  con.Open();

              }

              cmd.CommandType = CommandType.StoredProcedure;

              cmd.Parameters.AddWithValue("@id", c.stuid);

              SqlDataReader rd = cmd.ExecuteReader();

              bool b = rd.Read();

              if (b == true)

              {

                  return 0;

              }

              else

              {

                  SqlCommand cmd1 = new SqlCommand("add_data2", con);

                  if (con.State == ConnectionState.Open)

                  {

                      con.Close();

                  }

                  if (con.State == ConnectionState.Closed)

                  {

                      con.Open();

                  }

                  cmd1.CommandType = CommandType.StoredProcedure;

                  cmd1.Parameters.AddWithValue("@id",c.stuid);

                  cmd1.Parameters.AddWithValue("@name",c.stuname);

                  cmd1.Parameters.AddWithValue("@salary",c.stusalary);

                  int temp = cmd1.ExecuteNonQuery();

                  if (con.State == ConnectionState.Open)

                  {

                      con.Close();

                  }

                  return 1;

              }

          }

4->Aspx.cs file here take WCF service Reference

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

protected void Button1_Click(object sender, EventArgs e)

    {

        int id = Convert.ToInt32(TextBox1.Text);

        string name = TextBox2.Text;

        int salary = Convert.ToInt32(TextBox3.Text);

        ServiceReference1.ServiceClient s = new ServiceReference1.ServiceClient();

        ServiceReference1.Class1 c2 = new ServiceReference1.Class1();

        c2.stuid = id;

        c2.stuname = name;

        c2.stusalary = salary;

        int t = s.save(c2);

        if (t == 1)

        {

            Label1.Text = "Record is saved...";

            //Response.Write(t.ToString());

        }

        else

        {

            Label1.Text = "Record is exist...";

            //Response.Write(t.ToString());

        }

       

 }

Third Type

1->Before use WCF Service to take Here……..Use for WCF Service  but use this service on Silverlight xaml side then change   basicHttpBinding…..

2->Use the WCF Service in Silverlight  MainPage.xaml.cs take reference on xaml side…..

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Shapes;

namespace SilverlightApplication130712

{

    public partial class MainPage : UserControl

    {

        ServiceReference1.ServiceClient s;

        ServiceReference1.Class1 c2;

       

        public MainPage()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, RoutedEventArgs e)

        {

            int id = Convert.ToInt32(textBox1.Text);

            string name = textBox2.Text;

            int salary = Convert.ToInt32(textBox3.Text);

           s= new ServiceReference1.ServiceClient();

           c2 = new ServiceReference1.Class1();

           c2.stuid = id;

           c2.stuname = name;

           c2.stusalary = salary;

           //c2.stuid = 104;

           //c2.stuname = "Rahul";

           //c2.stusalary = 32000;

           s.saveAsync(c2);

           s.saveCompleted += new EventHandler<ServiceReference1.saveCompletedEventArgs>(s_saveCompleted);

            

        }

        void s_saveCompleted(object sender, ServiceReference1.saveCompletedEventArgs e)

        {

           

            //MessageBox.Show(e.Result.ToString());

           int t= e.Result;

           if (t == 1)

           {

               label4.Content = "Record is Saved...";

           }

           else

           {

               label4.Content = "Record is exist...";

           }

          

        }

    }

}