dcs619

<div class="form-group date-range-picker ">
    <label class="control-label" for="date_range_selection">Date Range</label>
    <div class="control-wrapper">
        <div id="date_range_selection">
            <div class="form-control-group">
                <div class="input-group input-width-md date input-group-lower input-width-md js-date-picker date">
                    <input name="date_range_selection_lower" type="text" id="date_range_selection_lower" class="form-control"><span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                </div>
                <div class="input-group form-control-static"> to </div>
                <div class="input-group input-width-md date input-group-upper input-width-md js-date-picker date">

dcs619

{% assign bgcstate = Person | Attribute:'BackgroundCheckResult' %}
{% assign bgcdate = Person | Attribute: 'BackgroundCheckDate' %}
{% assign today = 'Now' | Date: 'M/dd/yyyy' %}
{% if bgcdate != "" %}
    {% assign numdays = bgcdate | DateDiff: today, 'd' %} 
    {% assign expdate = bgcdate | DateAdd: 1095 %}
    {% assign daystil = 1095 | Minus: numdays %}
{% endif %}
{% if daystil <= 30 and numdays < 1095 and bgcstate == 'Pass' -%}
 <div class="badge badge-BGC-Status" data-toggle="tooltip" data-original-title="{{ Person.NickName }}'s background check will expire in {{ daystil }} days!">

dcs619

# Copyright (c) Microsoft Corporation.  All rights reserved.

$InitialDatabase = '0'

$knownExceptions = @(
    'System.Data.Entity.Migrations.Infrastructure.MigrationsException',
    'System.Data.Entity.Migrations.Infrastructure.AutomaticMigrationsDisabledException',
    'System.Data.Entity.Migrations.Infrastructure.AutomaticDataLossException',
    'System.Data.Entity.Migrations.Infrastructure.MigrationsPendingException',
    'System.Data.Entity.Migrations.ProjectTypeNotSupportedException'

dcs619

$('input:checkbox').prop('checked', true);

dcs619

<div class="form-group date-range-picker ">
    <label class="control-label" for="ctl00_main_ctl23_ctl01_ctl06_gfTransactions_drpDates">Date Range</label>
    <div id="ctl00_main_ctl23_ctl01_ctl06_gfTransactions_drpDates">
        <div class="form-control-group">
            <div class="input-group input-width-md date input-group-lower input-width-md js-date-picker date">
                <input name="drpDates_lower" type="text" id="drpDates_lower" class="form-control" value="{{ PageParameter.StartDate }}" />
                <span class="input-group-addon">
                    <i class="fa fa-calendar"></i>
                </span>
            </div>

dcs619

/*
-- See below for moving a non-clustered file index.  Moving a clustered index is the same
-- as moving the data, as each row lives as a leaf somewhere in the index tree.

-- Current syntax for moving a CLUSTERED file index:
PRINT 'Moving PK_dbo.Group index'
CREATE UNIQUE CLUSTERED INDEX 
	[PK_dbo.Group]
ON 
    [Group] ( [Id] )

dcs619

--select '
--PRINT ''Updating ' + [name] + '''
--UPDATE STATISTICS [dbo].[' + [name] + ']
--'
--from sysobjects where type = 'U'
--and name <> '__MigrationHistory'
--order by [name]

PRINT 'Updating _org_sparkdevnetwork_Documentation_Book'
UPDATE STATISTICS [dbo].[_org_sparkdevnetwork_Documentation_Book]

dcs619

-- Get a list of Member Id's and their schedules 
SELECT EntityId, r.value('.', 'varchar(255)') AS Schedule
FROM (
	-- create valid xml path
	SELECT EntityId, CAST('<n>' + REPLACE(Value, ',', '</n><n>') + '</n>' AS XML) AS 'Schedules' 
	FROM AttributeValue
	WHERE Id = 1257002
) AS baseXML 
-- parse the xml into a table
CROSS APPLY Schedules.nodes('n') AS parse(r)

dcs619

 DECLARE @Today datetime = GETDATE()

 DECLARE @CampusId int
 SELECT @CampusId = 2
 DECLARE @CampusGuid uniqueidentifier
 SELECT @CampusGuid = '6246DDEF-8AC9-4C25-B011-430CEE590F0F'

SELECT COUNT(DISTINCT PersonAliasId)
FROM Attendance A
INNER JOIN (

dcs619

lblInfo.Text = string.Format( "Device IP: {0} {1} Name: {2}", ipAddress, Environment.NewLine, hostName );
var localaddr = Request.ServerVariables["LOCAL_ADDR"];
lblInfo.Text += "<br> local" + localaddr;
var remoteHost = Request.ServerVariables["REMOTE_HOST"];
lblInfo.Text += "<br> remote" + remoteHost;
var getclient = GetClientIPAddress();
lblInfo.Text += "<br> getclient" + getclient;
var remoteaddr = Request.ServerVariables["REMOTE_ADDR"];
lblInfo.Text += "<br> remote" + remoteaddr;
//(Request.ServerVariables["HTTP_X_FORWARDED_FOR"]) ? Request.ServerVariables["REMOTE_ADDR"]).Split(',')[0].Trim();