phattrienweb

signalr/negotiate?clientProtocol

2023-11-26T19:39:00.000-08:00

Windows Server 2016 / IIS Cannot Disable for site:

signalr/negotiate?clientProtocol

<system.webServer>
<ModSecurity enabled="false" />
</system.webServer>

Publishing a WCF service on IIS 8

2017-12-24T18:42:00.001-08:00

Error: HTTP 404 when accessing .svc file in IIS

WCF services don’t run on IIS 8 with the default configuration, because the webserver doesn’t know, how to handle incoming requests targeting .svc files. You can teach it in two steps:

1. Add a new MIME type:

Extension: .svc MIME type: application/octet-stream

2. Add a new Managed HTTP Handler:

Request path: *.svc
Type: System.ServiceModel.Activation.HttpHandler
Name: svc-Integrated

Go it

Google reCapthca v2 using ASP.Net

2017-01-05T00:48:00.000-08:00

Google's reCaptcha system is very effective at preventing spam, but unlike other systems, does not require you to squint at a screen for ages to work out whether that wobbly circle is an o, O or a 0. With Google's captcha system, all you have to do is click on the 'I am not a robot' checkbox. If someone tries too many times to fill your form in, or the system detects a suspicious response, then it will pop up a series of images and ask to you to identify which image contains pasta or an aeroplane for example. It's quite simple and clever in the way it works.

The way it works is quite straightforward: when you embed the reCaptcaha javascript tag, the captcha code inserts a hidden form field with a pre-generated string created by Google's servers, and then when the form is posted, you send back the contents of this field, plus a secret key to google's web service. The reCaptcha server then looks at the secret key and hidden field string and checks whether the string was generated by its own system using your site key, and if so, it returns a 'true' or if not it returns 'false'.

Version 1 of the reCatpcha included sample code for ASP.net however the newer version does not, so I had to work out how to do this myself. Heres how I added reCaptcha v2 using ASP.net. The code below is written in C# and built using web forms, but it can easily be modified of MVC based applications:

STEP 1 - sign up for your secret key

To do this, go to https://www.google.com/recaptcha and click on the 'get recaptcha' button in the top right.

If you already have a google account, you can log in with this, or if you don't (and who doesn't have one?) then you'll have to register a google account.

Once done, you then add your website domain names to get 2 unique keys: a Site Key and a Secret Key. The site key is used in your code's script tag in your web form, and the secret key is used by your site to create a verification request to the reCaptcha web service.

STEP 2 Integrating the code in your form

Integrating the code into the front end web form is really easy. All you have to do is add 2 lines of code:

paste the following into the section of your page:
paste the following into the body of your html, where you want the captcaha button to appear:

STEP 3. Server Side Validation

When the form is generated in a browser, Google's recaptcha script adds a hidden field element called 'g-recaptcha-response'. To validate the form, you need to send an ajax call to google's web service with the contents of this field, and your secret key - this will return success:true if the response and key are valid, or otherwise will return success:false.

Here's the code for doing this. Note, this code uses Json.NET which is just used for a shortcut to parse JSON responses - in this case the reponse is serialised into the CaptchaResponse object but if you want to create a simple convertor yourself, it's not very hard to do that. The only slight complication is that If you want to use json.net, then you'll need to download the dll files from the newtonsoft site and copy then to the bin folder of your web application.

HTML code (contactform.aspx):

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="contactform.cs" Inherits="contactform" %>


 



 Name: 

 Message:

C# code (contactform.cs):

using Newtonsoft.Json;
using System;
using System.IO;
using System.Net;

public partial class contactform:System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

}

protected void btnSend_Click(object sender, EventArgs e) {

 string reCaptchaSecret = "[SECRET KEY HERE]";
 string reCaptchaRequest = "";

 if (Request.Form["g-recaptcha-response"] != null) {reCaptchaRequest = Request.Form["g-recaptcha-response"].ToString();}  

 if (CheckReCaptcha(reCaptchaSecret, reCaptchaRequest)) {
  // catpcha request is validated, do the form proccessing here...
  string mName=txtName.Text;
  string mMessage=txtMessage.Text;
  // Add code here to save messages to database or send via email.
 } else {
  litMessage.Text = "Please confirm that you are not a robot.
";
 }
}

public bool CheckReCaptcha(string captchaSecret, string captchaRequest) {
 bool cValidated = false;

 if (captchaRequest != null) {
 
  string captchaURL = String.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", captchaSecret, captchaRequest);
  HttpWebRequest wrq = (HttpWebRequest)WebRequest.Create(captchaURL);
  wrq.ContentType = "application/json";
  wrq.Method = "POST";
  using (var streamWriter = new StreamWriter(wrq.GetRequestStream())) {

   try {
    var wrs = (HttpWebResponse)wrq.GetResponse();
    using (var streamReader = new StreamReader(wrs.GetResponseStream())) {
     var result = streamReader.ReadToEnd();
     if (result != "") {
      CaptchaResponse capResp = JsonConvert.DeserializeObject(result);
      cValidated = capResp.success;
     }
    }
   } catch (WebException ex) {
    if (ex.Status == WebExceptionStatus.ProtocolError) {
     litDebug.Text = "ERROR : " + ex.Response.ToString() + "\r\n\r\nexception = " + ex.Message + "\r\n"; // debugging code
    }
   }
  }
 }
 return cValidated;
}

public class CaptchaResponse {
 public bool success { get; set; }
 public string challenge_ts { get; set; }
 public string hostname { get; set; }
 public string errorCodes { get; set; }
}

}

Summary

Before adding this code to my website, I used to get about 20-30 spam messages per day. I installed this code about a week ago and to date I have not received a single spam submission.

LINQ group by and GroupBy (Example)

2016-11-10T17:14:00.003-08:00

I want to take this thought a step further, and as implied by the post title, do a group by.

Starting, here is an order by % 2 giving us a list of even and then odd numbers:


int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
 
var orderedNumbers = from n in numbers
                     orderby n % 2 == 0 descending
                     select n;
 
foreach (var g in orderedNumbers)
{
    Console.Write("{0},", g);
}

This is all pretty straight forward, order by numbers that when modded by 2 are 0 and we have the numbers 4,8,6,2,0,5,1,3,9,7.

But what if I want to simply have two lists, one with evens and one with odds? That’s where group by comes in.


int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
 
var numberGroups = from n in numbers
                   group n by n % 2 into g
                   select new { Remainder = g.Key, Numbers = g };
 
foreach (var g in numberGroups)
{
    if(g.Remainder.Equals(0))
        Console.WriteLine("Even Numbers:", g.Remainder);
    else
        Console.WriteLine("Odd Numbers:", g.Remainder);
    foreach (var n in g.Numbers)
    {
        Console.WriteLine(n);
    }
}

with the output:


Odd Numbers:
5
1
3
9
7
Even Numbers:
4
8
6
2
0

What’s happening here is that LINQ is using anonymous types to create new dictionary (actually a System.Linq.Enumerable.WhereSelectEnumerableIterator>).

It is important to note here that the key here that everything is keyed on is the first value after the “by”.

Taking this one simple step forward let’s group a bunch of words. The following doesn’t work quite right:


string[] words = { "blueberry", "Chimpanzee", "abacus", "Banana", "apple", "cheese" };
 
var wordGroups = from w in words
                 group w by w[0] into g
                 select new { FirstLetter = g.Key.ToString().ToLower(), Words = g };
 
foreach (var g in wordGroups)
{
    Console.WriteLine("Words that start with the letter '{0}':", g.FirstLetter);
    foreach (var w in g.Words)
    {
        Console.WriteLine(w);
    }
}

giving us the output:


Words that start with the letter 'b':
blueberry
Words that start with the letter 'c':
Chimpanzee
Words that start with the letter 'a':
abacus
apple
Words that start with the letter 'b':
Banana
Words that start with the letter 'c':
cheese

That’s because there is a bit of a red herring here. Remember that the first value after the by is what is used to group by. In our case w[0] for Chimpanzee is “C”, not c. If we change it to:


string[] words = { "blueberry", "Chimpanzee", "abacus", "Banana", "apple", "cheese" };
 
var wordGroups = from w in words
                 group w by w[0].ToString().ToLower() into g
                 select new { FirstLetter = g.Key.ToString().ToLower(), Words = g };
 
foreach (var g in wordGroups)
{
    Console.WriteLine("Words that start with the letter '{0}':", g.FirstLetter);
    foreach (var w in g.Words)
    {
        Console.WriteLine(w);
    }
}

then we get the results we expect with:


Words that start with the letter 'b':
blueberry
Banana
Words that start with the letter 'c':
Chimpanzee
cheese
Words that start with the letter 'a':
abacus
apple

Taking this even one step further we can throw an orderby above the group and order things alphabetically:


var wordGroups = from w in words
orderby w[0].ToString().ToLower()
group w by w[0].ToString().ToLower() into g
select new { FirstLetter = g.Key.ToString().ToLower(), Words = g };

So let’s now make this a bit over the top complex. Given the classes:


public class Customer
{
    public List<Order> Orders { get; set; }
}
 
public class Order
{
    public DateTime Date { get; set; }
    public int Total { get; set; }
}

lets group a customer list by customer, then by year, then by month:


List<Customer> customers = GetCustomerList();
 
var customerOrderGroups = from c in customers
                          select
                              new {c.CompanyName,
                                   YearGroups = from o in c.Orders
                                                group o by o.OrderDate.Year into yg
                                                select
                                                    new {Year = yg.Key,
                                                         MonthGroups = from o in yg
                                                         group o by o.OrderDate.Month into mg
                                                         select new { Month = mg.Key, Orders = mg }
                                                    }
                                  };

Whew! that took a lot to copy and paste from MSDN’s sample library!
As mentioned previously the important part here is that the keys for these are the first value after the “by”. This just creates a bunch of dictionarys keyed embeded together keyed on the values after the “by”.

The GroupBy method that is a part of Linq can also take an IEqualityComparer. Given the comparer:


public class AnagramEqualityComparer : IEqualityComparer
{
    public bool Equals(string x, string y)
    {
        return getCanonicalString(x) == getCanonicalString(y);
    }
 
    public int GetHashCode(string obj)
    {
        return getCanonicalString(obj).GetHashCode();
    }
 
    private string getCanonicalString(string word)
    {
        char[] wordChars = word.ToCharArray();
        Array.Sort(wordChars);
        return new string(wordChars);
    }
}

we can find all the matching anagrams. This is possible because the IEqualityComparer compares words based on a sorted array of characters. If you take “meat” and “team” they both become “aemt” when sorted by their characters.


string[] anagrams = { "from", "salt", "earn", "last", "near", "form" };
 
var orderGroups = anagrams.GroupBy(
                      w => w.Trim(),
                      a => a.ToUpper(),
                      new AnagramEqualityComparer()
                  );
 
foreach (var group in orderGroups)
{
    Console.WriteLine("For the word "{0}" we found matches to:", group.Key);
    foreach (var word in group)
    {
        Console.WriteLine(word);
    }
}

jQuery: Close a Menu by Clicking Anywhere on the Document

2016-11-06T03:06:00.002-08:00

<div class="dropMenu">
    <span class="trigger">Options</span>
    <div class="panel">
        <ul class="list">
            <li><a href="">List Item 1</a></li>
            <li><a href="">List Item 2</a></li>
            <li><a href="">List Item 3</a></li>
            <li class="separator"></li>
            <li><a href="">List Item 4</a></li>
            <li><a href="">List Item 5</a></li>
        </ul>
    </div>
</div>

 $(function() {
    
    initDropDowns($("div.dropMenu"));

});

function initDropDowns(allMenus) {

    allMenus.children(".trigger").on("click", function() {
        
        var thisTrigger = jQuery(this),
            thisMenu = thisTrigger.parent(),
            thisPanel = thisTrigger.next();

        if (thisMenu.hasClass("open")) {

            thisMenu.removeClass("open");

        } else {            
            
            allMenus.removeClass("open");   
              thisMenu.addClass("open");
        }
        
        return false;
    });
}

 body {
    font: normal 14px Segoe, "Segoe UI", "DejaVu Sans", "Trebuchet MS", Verdana, sans-serif;    
}
.dropMenu {
    display: inline-block;
    position: relative;
    z-index: 1;
    zoom: 1;
 *display: inline;
}
.dropMenu .trigger {
    cursor: pointer;
    display: block;
    position: relative;
    top: 1px;
    z-index: 3;
    color: #1279A2;
    min-width: 230px;
    padding: 4px 7px;
    -webkit-border-radius: 3px;
    border-radius: 3px;
}
.dropMenu .panel {
    border: solid 1px #868686;
    position: absolute;
    left: 0;
    min-width: 242px;
    z-index: 2;
    display: none;
    -webkit-box-shadow: 0 2px 2px 0 rgba(0,0,0,0.3);
    box-shadow: 0 2px 2px 0 rgba(0,0,0,0.3);
    -webkit-border-radius: 0 0 3px 3px;
    border-radius: 0 0 3px 3px;
}
.dropMenu .panel .list {
    background: #fff;
    list-style: none;
    margin: 0;
    padding: 0;
}
.dropMenu .panel .list li {
    clear: both;
    margin: 1px;
    padding: 1px; /* compensate for hover border */
    border-radius: 3px;
    -moz-border-radius: 3px;
    width: 120px;
}
.dropMenu .panel .list li:hover {
    border: solid 1px #d2b47a;
    background: #ffecb5;
    padding: 0;
}
.dropMenu .panel .list li.separator,
.dropMenu .panel .list li:hover.separator {
    width: 232px;
    border: 0 none;
    border-bottom: solid 1px #999;
    height: 1px;
    margin: 0 5px 2px;
    padding: 0;
    background: none;
    float: left; /* this is only here for IE7 */
}
.dropMenu .panel .list a {
    display: block;
    text-decoration: none;
    padding: 2px 4px;
    color: #1279A2;
}
/* Open and Hover styles */
    
.dropMenu.open {
    z-index: 999;
}
.dropMenu.open .trigger {
    z-index: 1001;
    -webkit-box-shadow: 0 -1px 2px 0 rgba(0,0,0,0.3);
    box-shadow: 0 -1px 2px 0 rgba(0,0,0,0.3);
    -webkit-border-radius: 3px 3px 0 0;
    border-radius: 3px 3px 0 0;
    background: #78A9FF;
    color: #fff;
}
.dropMenu .trigger:hover,
.dropMenu.open .trigger {
    border: solid 1px #868686;
    padding: 3px 6px;
}
.dropMenu.open .panel {
    display: block;
    z-index: 1000;
}

get the value of selected option in a select box using jQuery

2016-09-28T18:58:00.001-07:00

$(document).ready(function(){
    $("select.country").change(function(){
        var selectedCountry = $(".country option:selected").val();
        alert("You have selected the country - " + selectedCountry);
    });
});

UNITY 5 AND KINECT 2 INTEGRATION

2016-09-09T01:20:00.004-07:00

Until just this month one of the best Kinect 2 integration tools was hidden, like Rappuccini’s daughter, inside a walled garden. Microsoft released a Unity3D plugin for the Kinect 2 in 2014. Unfortunately, Unity 4 only supported plugins (bridges to non-Unity technology) if you owned a Unity Pro license which typically cost over a thousand dollars per year.

On March 3rd, Unity released Unity 5 which includes plugin support in their free Personal edition – making it suddenly very easy to start building otherwise complex experiences like point cloud simulations that would otherwise require a decent knowledge of C++. In this post, I’ll show you how to get started with the plugin and start running a Kinect 2 application in about 15 minutes.

(As an aside, I always have trouble keeping this straight: Unity has plugins, openFrameworks as add-ins, while Cinder has bricks. Visual Studio has extensions and add-ins as well as NuGet packages after a confusing few years of rebranding efforts. There may be a difference between them but I can’t tell.)

1. First you are going to need a Kinect 2 and the Unity 5 software. If you already have a Kinect 2 attached to your XBox One, then this part is easy. You’ll just need to buy a Kinect Adapter Kitfrom the Microsoft store. This will allow you to plug your XBox One Kinect into your PC. The Kinect for Windows 2 SDK is available from the K4W2 website, though everything you need should automatically install when you first plug your Kinect into your computer. You don’t even need Visual Studio for this. Finally, you can download Unity 5 from the Unity website.

more here...

C# Math: Mean, Variance and Standard Deviation2016-09-02T18:56:00.001-07:00
internalclassProgram

    {

        private static void Main()

        {

            List<double> data = new List<double> {1, 2, 3, 4, 5, 6};

            double mean = data.Mean();

            double variance = data.Variance();

            double sd = data.StandardDeviation();

            Console.WriteLine("Mean: {0}, Variance: {1}, SD: {2}", mean, variance, sd);

            Console.WriteLine("Press any key to continue...");

            Console.ReadKey();

        }

    }

    public static class MyListExtensions

    {

        public static double Mean(this List<double> values)

        {

            return values.Count == 0 ? 0 : values.Mean(0, values.Count);

        }

        public static double Mean(this List<double> values, int start, int end)

        {

            double s = 0;

            for (int i = start; i < end; i++)

            {

                s += values[i];

            }

            return s / (end - start);

        }

        public static double Variance(this List<double> values)

        {

            return values.Variance(values.Mean(), 0, values.Count);

        }

        public static double Variance(this List<double> values, double mean)

        {

            return values.Variance(mean, 0, values.Count);

        }

        public static double Variance(this List<double> values, double mean, int start, int end)

        {

            double variance = 0;

            for (int i = start; i < end; i++)

            {

                variance += Math.Pow((values[i] - mean), 2);

            }

            int n = end - start;

            if (start > 0) n -= 1;

            return variance / (n);

        }

        public static double StandardDeviation(this List<double> values)

        {

            return values.Count == 0 ? 0 : values.StandardDeviation(0, values.Count);

        }

        public static double StandardDeviation(this List<double> values, int start, int end)

        {

            double mean = values.Mean(start, end);

            double variance = values.Variance(mean, start, end);

            return Math.Sqrt(variance);

        }

    }

Create Windows Service and Send Mail Daily At Fixed Time Using C#

2016-08-26T00:01:00.003-07:00

Introduction

In this article I am explaining how to create a Windows Service to schedule daily mail at a specified time. Scheduling email and sending the email is a basic requirement of any project.

Step 1
Open Visual Studio and create a new project. Under Windows Desktop select Windows Service and provide a proper name and click on the OK button.

More link...

Xử lý tìm kiếm trong website C#

2016-08-15T18:57:00.001-07:00

1. Query tìm kiếm trong SQL

- Bản chất của việc tìm kiếm là việc chúng ta sẽ lập trình để thực thi một câu lệnh SQL với keyword được nhập từ người dùng, cấu trúc lệnh SQL cho việc tìm kiếm trong ví dụ này như dưới đây. Trong trường hợp này mình cho phép tìm từ khóa trong cả tiêu đề "Title" và nội dung "Content"

select * from [Articles] 

where ([Title] like '%keyword%' or [Content] like '%keyword%')

- Đối với dữ liệu tìm kiếm là Tiếng Việt, kiểu dữ liệu nvarchar hay ntext trong SQL, chúng ta cần thêm tiền tố N trước keyword

select * from [Articles] 

where ([Title] like N'%Võ Khánh Thụy%' or [Content] like N'%Võ Khánh Thụy%')

- Đối với câu lệnh trên khi thực hiện tìm kiếm, nếu người dùng gõ "Võ Thụy" thì sẽ không ra. Vậy để xử lý vấn đề này chúng ta cần tách chuỗi từ khóa ra và tìm riêng từng từ một, sẽ cho kết quả tốt hơn.

select * from [Articles] 

where ([Title] like N'%Võ%' or [Content] like N'%Võ%') 

and ([Title] like N'%Khánh%' or [Content] like N'%Khánh%') 

and ([Title] like N'%Thụy%' or [Content] like N'%Thụy%')

2. Xử lý từ khóa người dùng nhập vào

- Với yêu cầu tìm kiếm mà người dùng nhập vào từ form tìm kiếm sẽ phải qua một số bước xử lý dữ liệu như loại bỏ các ký tự cấm trong SQL, xử lý tiếng việt không dấu...Tuy nhiên trong phần này mình chỉ muốn nói qua về cách tách chuỗi từ khóa được nhập vào để tăng kết quả tìm kiếm như mình đã đề cập ở trên. Mình sử dụng đoạn code dưới đây để tách chuỗi từ khóa người dùng nhập vào thành 1 mảng các từ khóa độc lập

// Turn user input to a list of keywords.

string[] keywords = txtKeyWord.Text.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);

- Với mảng từ khóa được tách ra chúng ta cần lập trình vòng lặp để tạo được câu Query SQL như ý đồ ở trên. Mình sử dụng hàm dưới đây để tạo truy vấn và lấy kết quả trả về.

/// 

/// Search records from database.

/// 

/// the list of keywords

/// all found records

public List Search(List<string> keywords)

{

// Generate a complex Sql command.

StringBuilder sqlBuilder = new StringBuilder();

sqlBuilder.Append("select * from [Articles] where ");

foreach (string item in keywords)

{

sqlBuilder.AppendFormat("([Title] like '%{0}%' or [Content] like '%{0}%') and ", item);

}

// Remove unnecessary string " and " at the end of the command.

string sql = sqlBuilder.ToString(0, sqlBuilder.Length - 5);

return QueryList(sql);

}

///

/// Excute a Sql command.

///

/// Command text

protected List QueryList(string cmdText)

{

List articles = new List();

SqlCommand cmd = GenerateSqlCommand(cmdText);

using (cmd.Connection)

{

SqlDataReader reader = cmd.ExecuteReader();

// Transform records to a list.

if (reader.HasRows)

{

while (reader.Read())

{

articles.Add(ReadArticle(reader));

}

return articles;

}

3. Hightlight Keyword

- Sau khi hoàn thành các bước ở phần 1 & 2, chúng ta đã có thể lấy được kết quả tìm kiếm trả về, và các bạn có thể bind dữ liệu vào repeate, listview hay datalist... thì tùy vào mục đích sử dụng. Phần này mình muốn nói thêm về cách đánh dấu từ khóa tìm kiếm trên danh sách kết quả tìm kiếm trả về trên giao diện người dùng.
- Đầu tiên mình sẽ viết css cho phân hightlight keyword của mình

- Việc còn lại bây giờ sẽ là lập trình 1 vòng lặp để thay thế các từ khóa có trong nội dung trả về (ở đây kết quả tìm kiếm trả về là 1 danh sách List
) theo dạng như sau:

keyword thay thế bằng 'keyHightLight'>keyword.

- Chắc mình viết đến đây các bạn đã hiểu cách mình làm ở đây. Đoạn code phần này như sau:

//hight light keyword

foreach (string keyItems in keyList)

{

  foreach (Article items in _ls)

     {

       items.Title = items.Title.Replace(keyItems, "" + keyItems   + "

");

items.Content = items.Content.Replace(keyItems, "" + keyItems + "

");

}

- Với cách làm trên mình thấy chạy khá ổn khi tìm kiếm với lượng dữ liêu vừa phải, tuy nhiên nếu xử lý với dữ liệu lớn sẽ không được tối ưu.

File upload and download using JQuery and submit button ASP.net

2016-05-04T20:33:00.002-07:00

The Post method

This method will look in the Request object to see if there are any posted files. If so, it will loop over the files and create them on the server side. The server will return a 201 HttpStatus and a list of strings that will contain the full path of the file(s) at server side. When there are no files posted, the service will return a 401 status a.k.a. BadRequest.

public HttpResponseMessage Post()
       {
           HttpResponseMessage result = null;
           var httpRequest = HttpContext.Current.Request;

           // Check if files are available
           if (httpRequest.Files.Count > 0)
           {
               var files = new List<string>();

               // interate the files and save on the server
               foreach (string file in httpRequest.Files)
               {
                   var postedFile = httpRequest.Files[file];
                   var filePath = HttpContext.Current.Server.MapPath("~/" + postedFile.FileName);
                   postedFile.SaveAs( filePath);

                   files.Add(filePath);
               }

               // return result
              result = Request.CreateResponse(HttpStatusCode.Created, files);
           }
           else
           {
               // return BadRequest (no file(s) available)
               result = Request.CreateResponse(HttpStatusCode.BadRequest);
           }

           return result;
       }

The Get Method

As mentioned before, the Get Method will accept a string file that will identify (= filename) the file that needs to be downloaded.

public HttpResponseMessage Get(string id)
       {
           HttpResponseMessage result = null;
           var localFilePath = HttpContext.Current.Server.MapPath("~/" + id);

           // check if parameter is valid
           if (String.IsNullOrEmpty(id))
           {
               result = Request.CreateResponse(HttpStatusCode.BadRequest);
           }
               // check if file exists on the server
           else if (!File.Exists(localFilePath))
           {
               result = Request.CreateResponse(HttpStatusCode.Gone);
           }
           else
           {// serve the file to the client
               result = Request.CreateResponse( HttpStatusCode.OK);
               result.Content = new StreamContent(new FileStream(localFilePath, FileMode.Open, FileAccess.Read));
               result.Content.Headers.ContentDisposition = new System.Net.Http.Headers.ContentDispositionHeaderValue("attachment");
               result.Content.Headers.ContentDisposition.FileName = id;
           }

           return result;
       }

Uploading a File

Using a submit button

 <form name="form1" method="post" action="api/file" enctype="multipart/form-data">
    <div>
        <label>
            Using submit</label>
        <input name="myFile" type="file" />
    </div>
    <div>
        <input type="submit" value="Submit" />
    </div>
    </form>

Using JQuery

<form enctype="multipart/form-data">
    <label>
        Using JQuery</label>
    <input name="file" type="file" />
    <input type="button" id="Upload" value="Upload" />
    </form>

        <script type="text/javascript">
            $(function () {
                $('#Upload').click(function () {
                    var formData = new FormData($('form')[0]);
                    $.ajax({
                        url: 'api/file', 
                        type: 'POST',
                        // Form data
                        data: formData,
                        //Options to tell JQuery not to process data or worry about content-type
                        cache: false,
                        contentType: false,
                        processData: false
                    });
                });
            });
        </script>

C# standard deviation example

2016-04-24T17:11:00.000-07:00

public static double StdDev<T>(this IEnumerable<T> list, Func<T, double> values)
    {
        // ref: http://stackoverflow.com/questions/2253874/linq-equivalent-for-standard-deviation
        // ref: http://warrenseen.com/blog/2006/03/13/how-to-calculate-standard-deviation/ 
        var mean = 0.0;
        var sum = 0.0;
        var stdDev = 0.0;
        var n = 0;
        foreach (var value in list.Select(values))
        {
            n++;
            var delta = value - mean;
            mean += delta / n;
            sum += delta * (value - mean);
        }
        if (1 < n)
            stdDev = Math.Sqrt(sum / (n - 1));

        return stdDev; 

    }

Or

public static double StdDev(this IEnumerable values)
{
    // ref: http://warrenseen.com/blog/2006/03/13/how-to-calculate-standard-deviation/
    double mean = 0.0;
    double sum = 0.0;
    double stdDev = 0.0;
    int n = 0;
    foreach (double val in values)
    {
        n++;
        double delta = val - mean;
        mean += delta / n;
        sum += delta * (val - mean);
    }
    if (1 < n)
        stdDev = Math.Sqrt(sum / (n - 1));

    return stdDev;
}

ref: http://stackoverflow.com/questions/2253874/linq-equivalent-for-standard-deviation

excite submit URL

2016-04-22T20:32:00.001-07:00

go to this, please:
http://www.excitesubmit.com

Convert and Loop through JSON with PHP and JavaScript Arrays/Objects

2016-04-20T00:15:00.000-07:00

$("#gender").on("change", function() {
  $.ajax({
    type: "POST",
    data: {
      "gender": $("#gender").val()
    },
    url: "response.php",
    dataType: "json",
    success: function(JSONObject) {
      var peopleHTML = "";

      // Loop through Object and create peopleHTML
      for (var key in JSONObject) {
        if (JSONObject.hasOwnProperty(key)) {
          peopleHTML += "
"
;
            peopleHTML += "" + JSONObject[key]["name"] + "

"; peopleHTML += "" + JSONObject[key]["gender"] + ""; peopleHTML += ""; } } // Replace table’s tbody html with peopleHTML $("#people tbody").html(peopleHTML); } }); });

see more:

https://jonsuh.com/blog/convert-loop-through-json-php-javascript-arrays-objects/

C#.net write JSON, (p1)

2016-04-19T06:07:00.003-07:00

//準備資料
            string collapse_key = "score_update";
            int time_to_live = 108;
            bool delay_while_idle = true;
            string score = "4x8";
            string time = "15:16.2342";
            List<string> registration_ids = new List<string>() { "4","8","15","16","23","42"};


            //開始拼接字串
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("{");
            sb.AppendLine("\"collapse_key\":\""+collapse_key+"\",");
            sb.AppendLine("\"time_to_live\":"+time_to_live+",");
            sb.AppendLine("\"delay_while_idle\":"+delay_while_idle.ToString().ToLower()+",");
            sb.AppendLine("\"data\":{");
            sb.AppendLine("\"score\":\""+score+"\",");
            sb.AppendLine("\"time\":\""+time+"\"");
            sb.AppendLine("},");
            sb.AppendLine("\"registration_ids\":[");
            foreach (string item in registration_ids)
            {
                sb.Append("\""+item+"\",");
            }
            sb = new StringBuilder(sb.ToString().TrimEnd(','));//移除最後一個「,」字元
            sb.AppendLine("]");
            sb.AppendLine("}");

            //輸出結果
            Response.Write(sb.ToString());

More here:

https://dotblogs.com.tw/shadow/archive/2012/08/16/74099.aspx

Make AJAX JSON call to ASP.Net WCF Service using jQuery and Javascript

2016-04-17T22:01:00.005-07:00

Here Mudassar Ahmed Khan has explained how to modify the ASP.Net WCF (Windows Communication Foundation) service to make it accept AJAX JSON calls and to make AJAX JSON calls to ASP.Net WCF Service using JavaScript and jQuery

see more:

http://www.aspsnippets.com/Articles/Make-AJAX-JSON-call-to-ASP.Net-WCF-Service-using-jQuery-and-Javascript.aspx

$("#search").live("click", function () {

$.ajax({

type: "POST",

contentType: "application/json; charset=utf-8",

url: '<%=ResolveUrl("~/Services/Service.svc/GetCustomers") %>',

data: '{"prefix": "' + $("#prefix").val() + '"}',

processData: false,

dataType: "json",

success: function (response) {

var customers = eval(response.d);

var html = "";

$.each(customers, function () {

html += "Name: " + this.Name + " Id: " + this.Id + "
";

});

$("#results").html(html == "" ? "No results" : html);

error: function (a, b, c) {

alert(a.responseText);

}

});

500: Internal Server when call Webservice in jquery and Asp.net

2016-04-12T02:55:00.001-07:00


      
           
                 maxJsonLength="50000000"/>

Asp.net C# + Dropzone js : Easy way to upload images [Drag & Drop feature]

2016-04-10T20:08:00.002-07:00

Please see link:
http://codepedia.info/2015/03/using-dropzone-js-file-image-upload-in-asp-net-webform-c/

Generic Handler ashx file : Post send JSON data in Asp.net c#, jQuery

2016-04-10T20:00:00.002-07:00

$("#bntSubmit").on('click', function (e) {

    // Initialize the object, before adding data to it.
    // { } is declarative shorthand for new Object()
    var obj = {};
    obj.first_name = $("#txtFirstName").val();
    obj.last_name = $("#txtLastName").val();
    obj.qualification = $("#txtQualication").val();
    obj.age = $("#txtAge").val();

    //In order to proper pass a json string, you have to use function JSON.stringfy
    var jsonData = JSON.stringify(obj);

    $.ajax({
        url: 'myGenericHandler.ashx',
        type: 'POST',
        data: jsonData,
        success: function (data) {
            console.log(data);
            alert("Success :" + data);
        },
        error: function (errorText) {
            alert("Wwoops something went wrong !");
        }
    });

    e.preventDefault();
});

# Add Generic Handler ( ashx file) in your Asp.net Application.

using System.Web.Script.Serialization;
using System.IO;

// we create a userinfo class to hold the JSON value
public class userInfo
{
     public string first_name { get; set; }
     public string last_name { get; set; }
     public string qualification { get; set; }
     public string age { get; set; }
}

public void ProcessRequest(HttpContext context)
{
    context.Response.ContentType = "text/plain";
    try
    {
        string strJson = new StreamReader(context.Request.InputStream).ReadToEnd();

        //deserialize the object
        userInfo objUsr = Deserialize(strJson);
        if (objUsr != null)
        {
            string fullName = objUsr.first_name + " " + objUsr.last_name;
            string age = objUsr.age;
            string qua = objUsr.qualification;
            context.Response.Write(string.Format("Name :{0} , Age={1}, Qualification={2}", fullName, age, qua));
        }
        else
        {
            context.Response.Write("No Data");
        }
    }
    catch (Exception ex)
    {
        context.Response.Write("Error :" + ex.Message);
    }
}

<%@ WebHandler Language="C#" Class="myGenericHandler" %>

using System;
using System.Web;
using System.Web.Script.Serialization;
using System.IO;

public class myGenericHandler : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        try
        {
            string strJson = new StreamReader(context.Request.InputStream).ReadToEnd();

            //deserialize the object
            userInfo objUsr = Deserialize(strJson);
            if (objUsr != null)
            {
                string fullName = objUsr.first_name + " " + objUsr.last_name;
                string age = objUsr.age;
                string qua = objUsr.qualification;
                context.Response.Write(string.Format("Name :{0} , Age={1}, Qualification={2}", fullName, age, qua));
            }
            else
            {
                context.Response.Write("No Data");
            }
        }
        catch (Exception ex)
        {
            context.Response.Write("Error :" + ex.Message);
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

    // we create a userinfo class to hold the JSON value
    public class userInfo
    {
        public string first_name { get; set; }
        public string last_name { get; set; }
        public string qualification { get; set; }
        public string age { get; set; }
    }

    // Converts the specified JSON string to an object of type T
    public T Deserialize(string context)
    {
        string jsonData = context;

        //cast to specified objectType
        var obj = (T)new JavaScriptSerializer().Deserialize(jsonData);
        return obj;
    }

}

Download and install Microsoft SQL Server 2008 R2 Express

2016-04-06T18:56:00.003-07:00

Introduction

This article explains how to download and install a default instance of Microsoft SQL Server 2008 R2 Express.

Instructions

Before proceeding, verify that you don't already have an instance of Microsoft SQL Server installed on the computer. If any edition (excluding the Compact Edition) of Microsoft SQL Server 2000 or later is already installed, you can use this existing installation with RealtyWare. Previous versions of Microsoft SQL Server may have to be updated or can be kept side-by-side with newer versions.

Follow these steps to download and perform a new default instance installation of Microsoft SQL Server 2008 R2 Express:

Download Microsoft SQL Server 2008 R2 Express. There are 32-bit (x86, file name SQLEXPRWT_x86_ENU.exe) and 64-bit (x64, file name SQLEXPRWT_x64_ENU.exe) versions available for download. If you are unsure if your operating system is 64-bit, download the 32-bit version:

• Microsoft SQL Server 2008 R2 Express 32-bit (x86)
- or -
• Microsoft SQL Server 2008 R2 Express 64-bit (x64)

This download also includes basic management tools for the database server.

Important: You may have to install Microsoft .Net Framework 3.5 SP1, Windows Installer 4.5 and Windows PowerShell 1.0 before installing Microsoft SQL Server 2008 R2 (typically required for Windows XP and Windows Server 2003).

Open the downloaded file (SQLEXPRWT_x86_ENU.exe or SQLEXPRWT_x64_ENU.exe) to start the SQL Server Installation Center.

Click on New installation or add features to an existing installation.

Follow the installation wizard.

When prompted for the Instance Configuration, select Default instance.

Follow the installation wizard.

When prompted for the Database Engine Configuration, it is recommended that you select Mixed Mode (SQL Server authentication and Windows authentication) and provide a strong password.

Follow the installation wizard and wait until the installation is complete.

For security reasons, network access to the database server is disabled by default. Follow these steps to enable TCP/IP network access:

Go to Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager.

Open the node SQL Server Network Configuration and select Protocols for MSSQLSERVER.

Double-click on TCP/IP.

Set Enabled to Yes.

Click on OK.

Close the SQL Server Configuration Manager.

Restart the computer or the SQL Server service.

JSON.stringify

2016-03-30T06:09:00.002-07:00

$(function () {

$("[id*=btnSave]").bind("click", function () {

var user = {};

user.Username = $("[id*=txtUsername]").val();

user.Password = $("[id*=txtPassword]").val();

$.ajax({

type: "POST",

url: "Default.aspx/SaveUser",

data: '{user: ' + JSON.stringify(user) + '}',

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function (response) {

alert("User has been added successfully.");

window.location.reload();

}

});

return false;

});

</script>

Tipsy jQuery Tooltip

2016-03-22T20:40:00.001-07:00

See more:
http://1stwebmagazine.com/tipsy-jquery-tooltip
Demo:
http://1stwebmagazine.com/demo/tipsy-jquery-tooltip.html

Create Android API key for Google Maps

2016-01-25T02:22:00.003-08:00

How to get the SHA1 fingerprint certificate in android studio for debug mode?

See link

Cài đặt Google Play Service cho máy ảo Genymotion

2016-01-24T20:07:00.002-08:00

Link here

Click Once publishing: .sdf.deploy did not succeed

2016-01-21T17:39:00.003-08:00

The Problem

So, you’re trying to publish a desktop app via the Visual Studio 2010 Click Once publishing, and you’re having problems with Visual Studio 2010 Click Once publishing? Are you getting errors like the part below

Following errors were detected during this operation.
* [2/22/2012 1:45:21 PM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
– Downloading http://www.Domain.com/PublishFiles/SomeApp/Application Files/ReportingApp_1_0_0_8/App_Data/Reporting.sdf.deploy did not succeed.
– Source: System.Deployment
– Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadDependencies(SubscriptionState subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri sourceUriBase, String targetDirectory, String group, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
— Inner Exception —
System.Net.WebException
– The remote server returned an error: (404) Not Found.
– Source: System
– Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

Even though you are not using a .sdf file

The Cause

Somewhere along the way you did have a .sdf file in the app_data folder, and the Click Once deploy manifest listed it. The manifest looks for it and does not find it, and would not find it anyway due to .sdf not being an accepted mime type on your server.

The Solution

Make sure that there are no .sdf files in the app_data folder, do a grep for any .sdf files, and then delete the web directories containing the files, the republish via click once

phattrienweb

signalr/negotiate?clientProtocol

Windows Server 2016 / IIS Cannot Disable for site:

signalr/negotiate?clientProtocol

Publishing a WCF service on IIS 8

Google reCapthca v2 using ASP.Net

STEP 1 - sign up for your secret key

STEP 2 Integrating the code in your form

STEP 3. Server Side Validation

HTML code (contactform.aspx):

C# code (contactform.cs):

Summary

LINQ group by and GroupBy (Example)

jQuery: Close a Menu by Clicking Anywhere on the Document

get the value of selected option in a select box using jQuery

UNITY 5 AND KINECT 2 INTEGRATION

C# Math: Mean, Variance and Standard Deviation

Create Windows Service and Send Mail Daily At Fixed Time Using C#

Xử lý tìm kiếm trong website C#

1. Query tìm kiếm trong SQL

2. Xử lý từ khóa người dùng nhập vào

3. Hightlight Keyword

File upload and download using JQuery and submit button ASP.net

The Post method

The Get Method

Uploading a File

Using a submit button

Using JQuery

C# standard deviation example

excite submit URL

Convert and Loop through JSON with PHP and JavaScript Arrays/Objects

C#.net write JSON, (p1)

Make AJAX JSON call to ASP.Net WCF Service using jQuery and Javascript

Here Mudassar Ahmed Khan has explained how to modify the ASP.Net WCF (Windows Communication Foundation) service to make it accept AJAX JSON calls and to make AJAX JSON calls to ASP.Net WCF Service using JavaScript and jQuery

see more:

http://www.aspsnippets.com/Articles/Make-AJAX-JSON-call-to-ASP.Net-WCF-Service-using-jQuery-and-Javascript.aspx

$("#search").live("click", function () {

500: Internal Server when call Webservice in jquery and Asp.net

Asp.net C# + Dropzone js : Easy way to upload images [Drag & Drop feature]

Generic Handler ashx file : Post send JSON data in Asp.net c#, jQuery

# Add Generic Handler ( ashx file) in your Asp.net Application.

using System.Web.Script.Serialization;using System.IO;

// we create a userinfo class to hold the JSON value public class userInfo { public string first_name { get; set; } public string last_name { get; set; } public string qualification { get; set; } public string age { get; set; } }

Download and install Microsoft SQL Server 2008 R2 Express

Introduction

Instructions

JSON.stringify

Tipsy jQuery Tooltip

Create Android API key for Google Maps

How to get the SHA1 fingerprint certificate in android studio for debug mode?

See link

Cài đặt Google Play Service cho máy ảo Genymotion

Click Once publishing: .sdf.deploy did not succeed

The Problem

The Cause

The Solution

using System.Web.Script.Serialization;
using System.IO;

// we create a userinfo class to hold the JSON value
public class userInfo
{
public string first_name { get; set; }
public string last_name { get; set; }
public string qualification { get; set; }
public string age { get; set; }
}