using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Description;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Collections;
using System.Configuration;
using System.Data;

namespace Host
{
	class Program
	{
  
		static void Main(string[] args)
		{
			// We did not separate contract from implementation.
			// Therefor service and contract are the same in this example.
			Type serviceType = typeof(Service);
			 
			ServiceHost host = new ServiceHost(serviceType, new Uri[] { new Uri("http://192.168.1.3/Service")} );
          			
			// Add behavior for our MEX endpoint   
			ServiceMetadataBehavior behavior = new ServiceMetadataBehavior();   
			behavior.HttpGetEnabled = true;   
			host.Description.Behaviors.Add(behavior);   
			
			// Create basicHttpBinding endpoint at http://localhost: 8080 /Service/   
			host.AddServiceEndpoint(serviceType, new BasicHttpBinding(), "Service");   
			// Add MEX endpoint at http://localhost: 8080 /MEX/
			host.AddServiceEndpoint(typeof(IMetadataExchange), new BasicHttpBinding(), "MEX");   
			
			host.Open();

			Console.WriteLine("Service is ready, press any key to terminate.");  
			Console.ReadKey();
            host.Close();
		}
	}
    
    [DataContract]
    public class User
    {
        private int userid;
        [DataMember] 
         public int userId {
                             get { return userid;}
                                   set { userid =value;}
                                  }

    }

	[ServiceContract]
	class Service
	{
        public string err;
                
        private int activation;
        private string ConnectionString = "Data Source=....";
              
	    [OperationContract]
        bool IsLogin(string login,string pass)
        {
            bool r = false;
           
            SqlConnection connect = new SqlConnection(ConnectionString);
            SqlDataReader reader = null;
            SqlCommand command = new SqlCommand("dbo.mdUsers_GetByLoginPass", connect);
            command.CommandType = CommandType.StoredProcedure;
            try
            {
                command.Parameters.Add("@Nickname", SqlDbType.VarChar,  50 ).Value = login;
                command.Parameters.Add("@password", SqlDbType.NChar,  32 ).Value = pass;

                command.Connection.Open();
                reader = command.ExecuteReader();
                if (reader.Read())
                {
                    User.userid = (int)reader["userID"]; ;
                    activation = (int)reader["Activation"];
                    if (activation== 1 ) r = true;
                }
                //err = nickName + "," + password+","+Convert.ToString(userId);
            }
            catch (SqlException ex)
            {
                err = ex.ToString();
                r = false;
            }
            finally
            {
                reader.Close();
                command.Connection.Close();
            }


            return r;
        } 

using System;
using System.Collections.Generic;
using System.Data;
using System.Runtime.Serialization;

namespace Client.localhost
{

    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Runtime.Serialiation", "4.0.0.0")]
    [System.Runtime.Serialization.DataContractAttribute(Name = "User")]
    public partial class User //: Object, System.Runtime.Serialization.IExtensibleDataObject
    {

        private int userIdField;

        [System.Runtime.Serialization.DataMemberAttribute()]
        public int userId
        {
            get 
            {
                return this.userIdField;
            }
            set 
            {
                this.userIdField = value;
            }
        }
    }

    //---------------------------------------------------------------------------------------------------
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.ServiceModel", "3.0.0.0")]
    [System.ServiceModel.ServiceContractAttribute(ConfigurationName="Client.localhost.Service")]
    public interface Service
    {
        
  
        [System.ServiceModel.OperationContractAttribute(Action = "http://tempuri.org/Service/IsLogin", ReplyAction = "http://tempuri.org/Service/IsLoginResponse")]
        bool IsLogin(string login,string pass);

    

 [DataContract]
    public class User
    {
        private int userid;
        [DataMember] 
         public int userId {
                             get { return userid;}
                                   set { userid =value;}
                                  }

    }


    [OperationContract]
        bool IsLogin(string login,string pass)
        {
            User u=new User();
           .....
                if (reader.Read())
                {
                    User.userid = (int)reader["userID"]; 

 [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Runtime.Serialiation", "4.0.0.0")]
    [System.Runtime.Serialization.DataContractAttribute(Name = "User")]
    public partial class User //: Object, System.Runtime.Serialization.IExtensibleDataObject
    {
        private int userid;
        [System.Runtime.Serialization.DataMemberAttribute()]
        public int userId
        {
            get 
            {
                return this.userid;
            }
            set 
            {
                this.userid = value;
            }
        }
    }