ASP.NET

Quote:

SignalR can be used to add any sort of "real-time" web functionality to your ASP.NET application.

[DataContract]
    public class SecureAuthHeader
    {
        [DataMember]
        public string UserKey { get; set; }

        [DataMember]
        public string UserSecret { get; set; }
    }

    [AspNetCompatibilityRequirements(RequirementsMode=AspNetCompatibilityRequirementsMode.Allowed)]
    [ServiceBehavior(InstanceContextMode=InstanceContextMode.PerSession)]
    public class CPApi : ICPApi
    {
        public SecureAuthHeader Authentication;

        public void SetAuthentication(string _userkey, string _usersecret)
        {
            Authentication = new SecureAuthHeader();
            Authentication.UserKey = _userkey;
            Authentication.UserSecret = _usersecret;
        }
                
        public List<UserObject> GetAllUsers()
        {
            string companyCode = IsAuthenticated;


            // MORE HERE
        }

        private string IsAuthenticated
        {
            get
            {
                if (Authentication == null)
                    throw new FaultException("You must authenticate first.");

                try
                {
                    DataTable ds = SqlLibrary.ReadSql("SELECT CompanyID FROM ApiAccess WHERE CustomerKey=@CustomerKey AND CustomerSecret=@CustomerSecret",
                        new SqlParameter[] { new SqlParameter("CustomerKey", Authentication.UserKey), new SqlParameter("CustomerSecret", Authentication.UserSecret) });

                    if (ds == null || ds.Rows.Count == 0)
                        throw new FaultException("Invalid authentication.");

                    return ds.Rows[0]["CompanyID"].ToString();
                }
                catch (Exception ex)
                {
                    throw new FaultException(ex.Message);
                }
            }
        }

UPDATE Table_Name SET Numberofclicks = Numberofclicks+1 WHERE ID=@ID