How to add robots.txt into ASP.NET MVC site?

There are two ways to do so:
First one:
http://rayaspnet.blogspot.ca/2011/04/how-to-implment-dynamic-robotstxt-in.html

Second, the simpler one:
Add robots.txt into your website root, and Add one line into Global.asax file

        public static void RegisterRoutes(RouteCollection routes)
        {
            routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
            routes.IgnoreRoute("robots.txt");
        }

Inside the ASP.NET Single Page Apps Template

http://www.johnpapa.net/inside-the-asp-net-single-page-apps-template/

How to ask user if want to leave current page in JavaScript?

Add function into onbeforeunload

var unsavedChanges = false;
window.onbeforeunload = function() {
  if (unsavedChanges) return 'You have unsaved changes!';
}

https://developer.mozilla.org/en-US/docs/DOM/window.onbeforeunload

How to convert SQL Server's timestamp column to datetime?

No. You can't
SQL Server's timestamp just an incrementing number and does not preserve a date or a time.

How to get client IP address?

How to get client IP address?

HttpContext.Request.UserHostAddress