public static void CleanDatabase()
        {
            //make database newish
            //reset passwords
            var userProfileTableAdapter = new SSS_Library.IS2G10_DBSSSDataSetTableAdapters.USERPROFILETableAdapter();
            var userProfiles = userProfileTableAdapter.GetData();
            foreach (var userProfile in userProfiles)
            {
                userProfile.resetPassword = true;
                userProfileTableAdapter.Update(userProfile);
            }

            var brandingTableAdapter = new SSS_Library.IS2G10_DBSSSDataSetTableAdapters.BRANDINGTableAdapter();
            var branding = brandingTableAdapter.GetData();
            branding[0].is_system_clean = true;

            //kill all attendance and stuff like that.
        }
        public static void CleanDatabase()
        {
            //make database newish
            //reset passwords
            var userProfileTableAdapter = new SSS_Library.IS2G10_DBSSSDataSetTableAdapters.USERPROFILETableAdapter();
            var userProfiles            = userProfileTableAdapter.GetData();

            foreach (var userProfile in userProfiles)
            {
                userProfile.resetPassword = true;
                userProfileTableAdapter.Update(userProfile);
            }

            var brandingTableAdapter = new SSS_Library.IS2G10_DBSSSDataSetTableAdapters.BRANDINGTableAdapter();
            var branding             = brandingTableAdapter.GetData();

            branding[0].is_system_clean = true;

            //kill all attendance and stuff like that.
        }