danielgreen

// http://dillieodigital.wordpress.com/2011/10/12/automatic-user-and-time-stamping-in-entity-framework-4/

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Objects;
using System.Web;
using MyApp.BLL;
 
namespace MyApp.DAL

danielgreen

DECLARE @cmd1 VARCHAR(MAX)
DECLARE @cmd2 VARCHAR(MAX)

IF EXISTS (SELECT object_id FROM tempdb.sys.objects WHERE name like '#OrphanUsers%')
  DROP TABLE #OrphanUsers
CREATE TABLE #OrphanUsers
      (
		UserName VARCHAR(50) NULL,
        userSID	 VARBINARY(85) NULL,
	    dbName	 VARCHAR(50) NULL       

danielgreen

using System;
using System.Collections.Generic;
using System.Data.SqlTypes;
using System.Globalization;
using System.Linq;
using System.Text;

namespace Utility
{
    // http://dotnetslackers.com/articles/aspnet/5-Helpful-DateTime-Extension-Methods.aspx

danielgreen

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Config
{
    public abstract class BaseConfigurationElementCollection<TKey, TElement> 

danielgreen

Develop an unobtrusive approach - if a form has the data-warn-unsaved="true" attribute then attach change event handlers to its fields. Do this for all such forms on the page. The handlers can set data-unsaved-changes="true" on the form.

Set window.onbeforeunload to a function that checks for any forms with data-unsaved-changes="true". If any such forms are found, return some text to be displayed as a prompt to the user.

When a form's contents are saved successfully, we want to set data-unsaved-changes="false". Define an event that can be invoked upon a successful save, in order to set the attribute's value?

Also see http://codethug.com/2013/02/01/knockout-binding-for-onbeforeunload/

danielgreen

A Post action should redirect to a Get action rather than returning a View. This avoids the annoyance of the browser displaying the "do you want to resubmit the form" message if the user tries to refresh the page after the Post.

danielgreen

$("form[data-block-page-on-submit]").each(function () {
  $(this).validate().settings.submitHandler = function () {
    window.BlockPage();
    return true;
  };
});