using jQWidgets.AspNet.Core.Models;
using System.Collections.Generic;
using System;
using jQWidgets.AspNetCore.Mvc.TagHelpers;
using Microsoft.EntityFrameworkCore;

namespace jQWidgets.AspNet.Core.Models
{
    public enum Contract
    {
        Year = 0,
        HalfYear = 1,
        QuarterYear = 2,
        Month = 3
    }
    public class PivotDataRow
    {
        public string Country
        {
            get; set;
        }
        public string Value
        {
            get; set;
        }
    }
    public class jQWidgetsDemosContext : DbContext
    {
        private static bool _created = false;
        private List<Models.SalesEmployee> salesEmployees = new List<Models.SalesEmployee>();
        private List<Models.Employee> employees = new List<Models.Employee>();
        private List<Models.Appointment> appointments = new List<Appointment>();
        private List<string> countries = new List<string>()
        {
           "Germany", "France", "United States", "Italy", "Spain", "Finland", "Canada", "Japan", "Brazil", "United Kingdom", "China", "India", "South Korea", "Romania", "Greece"
        };
        private List<string> dataPoints = new List<string>()
        {
            "2.25", "1.5", "3.0", "3.3", "4.5", "3.6", "3.8", "2.5", "5.0", "1.75", "3.25", "4.0"
        };



        private List<PivotDataRow> dataRows = new List<PivotDataRow>();

        public List<PivotDataRow> PivotDataRows
        {
            get
            {
                return this.dataRows;
            }
        }

        private List<string> carFeatures = new List<string>()
        {
            "Parking Sensonrs",
            "Heated Front Seats",
            "Active Blind-Spot Detection System",
            "USB Ports",
            "Built-In Navigation System",
            "LED Headlights",
            "Bluetooth Streaming Audio",
            "Side Mirror Turn Signals",
            "Push-button Ignition",
            "Start/Stop System"
        };
        private string data = "6/29/2010,19,25,17.54,23.89,18766300,23.89,6/30/2010,25.79,30.42,23.3,23.83,17187100,23.83,7/1/2010,25,25.92,20.27,21.96,8218800,21.96,7/2/2010,23,23.1,18.71,19.2,5139800,19.2,7/6/2010,20,20,15.83,16.11,6866900,16.11,7/7/2010,16.4,16.63,14.98,15.8,6921700,15.8,7/8/2010,16.14,17.52,15.57,17.46,7711400,17.46,7/9/2010,17.58,17.9,16.55,17.4,4050600,17.4,7/12/2010,17.95,18.07,17,17.05,2202500,17.05,7/13/2010,17.39,18.64,16.9,18.14,2680100,18.14,7/14/2010,17.94,20.15,17.76,19.84,4195200,19.84,7/15/2010,19.94,21.5,19,19.89,3739800,19.89,7/16/2010,20.7,21.3,20.05,20.64,2621300,20.64,7/19/2010,21.37,22.25,20.92,21.91,2486500,21.91,7/20/2010,21.85,21.85,20.05,20.3,1825300,20.3,7/21/2010,20.66,20.9,19.5,20.22,1252500,20.22,7/22/2010,20.5,21.25,20.37,21,957800,21,7/23/2010,21.19,21.56,21.06,21.29,653600,21.29,7/26/2010,21.5,21.5,20.3,20.95,922200,20.95,7/27/2010,20.91,21.18,20.26,20.55,619700,20.55,7/28/2010,20.55,20.9,20.51,20.72,467200,20.72,7/29/2010,20.77,20.88,20,20.35,616000,20.35,7/30/2010,20.2,20.44,19.55,19.94,426900,19.94,8/2/2010,20.5,20.97,20.33,20.92,718100,20.92,8/3/2010,21,21.95,20.82,21.95,1230500,21.95,8/4/2010,21.95,22.18,20.85,21.26,913000,21.26,8/5/2010,21.54,21.55,20.05,20.45,796200,20.45,8/6/2010,20.1,20.16,19.52,19.59,741900,19.59,8/9/2010,19.9,19.98,19.45,19.6,812700,19.6,8/10/2010,19.65,19.65,18.82,19.03,1281300,19.03,8/11/2010,18.69,18.88,17.85,17.9,797600,17.9,8/12/2010,17.8,17.9,17.39,17.6,691000,17.6,8/13/2010,18.18,18.45,17.66,18.32,634000,18.32,8/16/2010,18.45,18.8,18.26,18.78,485800,18.78,8/17/2010,18.96,19.4,18.78,19.15,447900,19.15,8/18/2010,19.59,19.59,18.6,18.77,601300,18.77,8/19/2010,18.54,19.25,18.33,18.79,579100,18.79,8/20/2010,18.65,19.11,18.51,19.1,296000,19.1,8/23/2010,19.09,20.39,19,20.13,1088100,20.13,8/24/2010,19.25,19.71,18.95,19.2,673100,19.2,8/25/2010,19.16,19.98,18.56,19.9,503300,19.9,8/26/2010,19.89,20.27,19.6,19.75,433800,19.75,8/27/2010,19.75,19.87,19.5,19.7,379600,19.7,8/30/2010,19.7,20.19,19.61,19.87,732800,19.87,8/31/2010,19.66,19.79,19.33,19.48,201100,19.48,9/1/2010,19.62,20.69,19.6,20.45,494900,20.45,9/2/2010,20.37,21.24,20.31,21.06,487100,21.06,9/3/2010,20.87,21.3,20.66,21.05,434600,21.05,9/7/2010,20.61,21,20.5,20.54,243400,20.54,9/8/2010,20.66,20.95,20.6,20.9,288400,20.9,9/9/2010,21,21.05,20.69,20.71,376200,20.71,9/10/2010,20.75,20.93,19.76,20.17,386600,20.17,9/13/2010,20.89,20.9,20.5,20.72,360800,20.72,9/14/2010,20.54,21.6,20.53,21.12,654700,21.12,9/15/2010,20.98,22,20.79,21.98,684600,21.98,9/16/2010,22.15,23.16,20.84,20.94,2684500,20.94,9/17/2010,21.02,21.32,19.8,20.23,1198500,20.23,9/20/2010,20.67,21.35,20.16,21.06,947500,21.06,9/21/2010,20.89,21.55,20.67,20.77,796000,20.77,9/22/2010,20.87,20.95,19.8,19.87,962900,19.87,9/23/2010,19.89,20.14,19.5,19.56,668100,19.56,9/24/2010,19.95,20.19,19.65,20.1,578900,20.1,9/27/2010,20.4,20.81,20.05,20.53,418600,20.53,9/28/2010,21.04,21.49,20.76,21.4,1214500,21.4,9/29/2010,21.19,22.03,21.13,21.98,1969300,21.98,9/30/2010,22,22.15,20.19,20.41,2195800,20.41,10/1/2010,20.69,20.75,20.31,20.6,597700,20.6,10/4/2010,20.43,21.17,20.3,20.99,643600,20.99,10/5/2010,21.15,21.28,21.01,21.12,332000,21.12,10/6/2010,21.06,21.26,20.32,20.46,313400,20.46,10/7/2010,20.57,20.64,20.34,20.43,141000,20.43,10/8/2010,20.43,20.79,20.39,20.43,267800,20.43,10/11/2010,20.44,20.7,20.07,20.24,171200,20.24,10/12/2010,20.2,20.28,20.03,20.24,244000,20.24,10/13/2010,20.64,20.85,20.36,20.54,318200,20.54,10/14/2010,21,21.03,20.4,20.75,294800,20.75,10/15/2010,20.89,20.9,20.25,20.54,284700,20.54,10/18/2010,20.52,20.64,20.22,20.23,162800,20.23,10/19/2010,20.2,20.41,20,20.05,245200,20.05,10/20/2010,20.16,20.69,20.04,20.65,312500,20.65,10/21/2010,20.61,20.95,20.45,20.75,417100,20.75,10/22/2010,20.68,20.93,20.55,20.72,161100,20.72,10/25/2010,20.94,20.98,20.73,20.85,118500,20.85,10/26/2010,20.8,21.87,20.51,21.36,660900,21.36,10/27/2010,21.25,21.38,20.65,21,356500,21,10/28/2010,21.39,21.5,20.96,21.19,224200,21.19,10/29/2010,21.14,21.85,21.05,21.84,280600,21.84,11/1/2010,21.94,22.75,21.31,21.41,455800,21.41,11/2/2010,21.68,21.88,21.05,21.25,322500,21.25,11/3/2010,21.28,22.5,21.16,21.77,372600,21.77,11/4/2010,22.6,25.33,22.15,24.9,1874000,24.9,11/5/2010,24.87,24.97,23.72,24.44,1011000,24.44,11/8/2010,24.5,25,24.03,24.98,509500,24.98,11/9/2010,25,25.69,24.05,24.63,956400,24.63,11/10/2010,24.48,29.97,24.05,29.36,3060500,29.36,11/11/2010,28.6,29.1,27.33,28.04,1945300,28.04,11/12/2010,28.25,30.5,28.07,29.84,2729100,29.84,11/15/2010,30.22,32.94,30.22,30.8,2622900,30.8,11/16/2010,31,31.4,28.42,29.67,1347600,29.67,11/17/2010,30.2,30.75,28.61,29.49,750000,29.49,11/18/2010,30.67,30.74,28.92,29.89,956100,29.89,11/19/2010,30.16,31.37,29.7,30.99,1150500,30.99,11/22/2010,31.57,33.45,31.5,33.4,1529700,33.4,11/23/2010,33.29,35.68,32.19,34.57,1577800,34.57,11/24/2010,35.27,35.97,34.33,35.47,1425000,35.47,11/26/2010,35.6,36,34.75,35.32,350600,35.32,11/29/2010,35.41,35.95,33.33,34.33,1145600,34.33,11/30/2010,33.74,35.33,33.41,35.33,2222600,35.33,12/1/2010,35.87,36.42,33.45,34.35,1299200,34.35,12/2/2010,34.01,34.3,31.2,32.35,2007000,32.35,12/3/2010,32.01,32.25,30.87,31.49,1160100,31.49,12/6/2010,31.35,31.45,29.56,30.31,1274400,30.31,12/7/2010,30.49,32.4,30.05,31.56,1311300,31.56,12/8/2010,32.48,32.49,31.52,32.37,660000,32.37,12/9/2010,32.51,32.72,31.65,32.05,406000,32.05,12/10/2010,32.05,32.92,31.13,31.52,429400,31.52,12/13/2010,31.64,31.77,30.4,30.55,410400,30.55,12/14/2010,30.29,30.39,27.76,28.53,1765700,28.53,12/15/2010,28.67,29.97,28.53,29.6,742900,29.6,12/16/2010,30,30.91,29.65,30.81,790100,30.81,12/17/2010,31.34,31.54,30.71,31.36,813000,31.36,12/20/2010,31.64,32.19,31.26,31.7,523400,31.7,12/21/2010,31.8,32.69,31.71,32.26,777700,32.26,12/22/2010,32.25,32.86,31.7,32.63,833300,32.63,12/23/2010,31.26,32.48,29.92,30.09,1552600,30.09,12/27/2010,28.02,28.58,25.06,25.55,9301900,25.55,12/28/2010,25.85,26.75,25,26.41,4056300,26.41,12/29/2010,27.03,28.01,26.5,27.73,3319200,27.73,12/30/2010,27.7,27.9,26.38,26.5,2041100,26.5,12/31/2010,26.57,27.25,26.5,26.63,1417900,26.63,1/3/2011,26.84,27,25.9,26.62,1283000,26.62,1/4/2011,26.66,26.95,26.02,26.67,1187400,26.67,1/5/2011,26.48,26.9,26.19,26.83,1446700,26.83,1/6/2011,26.83,28,26.81,27.88,2061200,27.88,1/7/2011,28,28.58,27.9,28.24,2247900,28.24,1/10/2011,28.17,28.68,28.05,28.45,1342700,28.45,1/11/2011,28.59,28.71,26.92,26.96,1710200,26.96,1/12/2011,27.01,27.4,26.52,26.96,964400,26.96,1/13/2011,26.96,26.97,26.16,26.22,723600,26.22,1/14/2011,26.15,26.58,25.61,25.75,1192000,25.75,1/18/2011,25.48,25.64,24.75,25.64,1621700,25.64,1/19/2011,25.27,25.47,23.75,24.03,2371500,24.03,1/20/2011,24.03,24.45,22.37,22.62,2279900,22.62,1/21/2011,23.12,23.59,22.71,23.04,1217000,23.04,1/24/2011,23.53,24.81,23.23,24.49,1645100,24.49,1/25/2011,24.65,24.89,24.02,24.68,1271500,24.68,1/26/2011,24.71,24.88,24.1,24.75,1079900,24.75,1/27/2011,24.74,25.08,24.53,24.92,895700,24.92,1/28/2011,24.88,24.88,23.75,24.01,1048400,24.01,1/31/2011,24.05,24.12,23.5,24.1,830300,24.1,2/1/2011,24.31,24.73,23.54,23.91,707800,23.91,2/2/2011,24.16,24.18,23.67,23.94,569500,23.94,2/3/2011,23.82,23.9,23.15,23.63,512000,23.63,2/4/2011,23.44,23.67,23.22,23.46,544000,23.46,2/7/2011,23.26,23.26,22.88,23.07,895100,23.07,2/8/2011,23.78,25.25,23,24.49,3504900,24.49,2/9/2011,24.13,24.18,22.79,23.21,2635600,23.21,2/10/2011,23.26,23.64,22.81,23.22,836100,23.22,2/11/2011,23.25,23.75,22.94,23.25,634500,23.25,2/14/2011,23.64,24.14,23.05,23.08,1283100,23.08,2/15/2011,23.01,23.17,22.56,22.84,953700,22.84,2/16/2011,23.1,24.97,23.07,24.73,4115100,24.73,2/17/2011,24.63,25.49,23.55,23.6,2618400,23.6,2/18/2011,23.33,23.49,22.96,23.18,2370700,23.18,2/22/2011,22.88,23,21.78,21.87,2064600,21.87,2/23/2011,22.18,22.5,21.11,21.83,1605600,21.83,2/24/2011,21.78,22.58,21.5,22.53,1055300,22.53,2/25/2011,22.81,23.85,22.69,23.61,1346300,23.61,2/28/2011,23.74,24.1,23.5,23.89,1051200,23.89,3/1/2011,24.05,24.32,23.7,23.94,1106400,23.94,3/2/2011,23.82,24.28,23.73,24.02,663300,24.02,3/3/2011,24.48,24.79,24.06,24.36,640200,24.36,3/4/2011,24.48,24.99,23.78,24.95,1580100,24.95,3/7/2011,24.93,25.4,24.7,24.94,2033600,24.94,3/8/2011,24.6,24.96,24,24.66,1399900,24.66,3/9/2011,24.66,24.99,24.27,24.72,924800,24.72,3/10/2011,24.44,24.49,23.73,24.01,1017000,24.01,3/11/2011,23.85,24.25,23.53,24.07,930800,24.07,3/14/2011,23.82,24,23.2,23.25,1166000,23.25,3/15/2011,22.2,22.96,21.8,22.95,1318800,22.95,3/16/2011,22.86,23.25,22.69,22.82,1169700,22.82,3/17/2011,23.24,23.43,22.64,22.81,922600,22.81,3/18/2011,23.19,23.19,22.51,22.96,687900,22.96,3/21/2011,23.05,23.05,22.54,22.73,411700,22.73,3/22/2011,22.73,22.86,22,22.19,582900,22.19,3/23/2011,22.11,22.27,21.77,22.21,422800,22.21,3/24/2011,22.14,22.38,21.98,22.33,462200,22.33,3/25/2011,22.43,23,22.4,22.75,568000,22.75,3/28/2011,22.7,23.54,22.55,23.25,1058100,23.25,3/29/2011,23.3,24,23.21,23.92,755400,23.92,3/30/2011,24.11,24.49,23.01,23.71,1223300,23.71,3/31/2011,26.55,28.71,26.5,27.75,11517800,27.75,4/1/2011,27.45,28.18,26.57,26.66,2864800,26.66,4/4/2011,26.83,27,25.23,25.83,2609300,25.83,4/5/2011,25.9,27,25.69,26.7,3180900,26.7,4/6/2011,26.99,27.01,25.8,26.49,1288300,26.49,4/7/2011,26.85,27.94,26.45,27.24,2810300,27.24,4/8/2011,27.58,27.6,26.36,26.49,1946400,26.49,4/11/2011,26.47,26.53,25.02,25.27,1369400,25.27,4/12/2011,25.08,25.21,24.3,24.65,1357400,24.65,4/13/2011,25.13,25.69,24.81,24.93,1211500,24.93,4/14/2011,24.87,25.28,24.2,25.14,983400,25.14,4/15/2011,25.65,26.18,25.41,25.58,943500,25.58,4/18/2011,25.13,25.62,24.36,25.03,1033900,25.03,4/19/2011,25.26,25.26,24.65,25.16,548700,25.16,4/20/2011,25.7,26.09,25.3,25.75,837200,25.75,4/21/2011,25.85,26.98,25.59,26.74,1386100,26.74,4/25/2011,26.7,26.73,25.97,26.39,800900,26.39,4/26/2011,26.66,27.25,26.31,26.93,1400000,26.93,4/27/2011,26.93,27.36,26.63,27.08,996900,27.08,4/28/2011,27.07,27.69,26.72,27.66,1600000,27.66,4/29/2011,27.69,27.87,27.42,27.6,726000,27.6,5/2/2011,27.6,27.8,27.06,27.45,784600,27.45,5/3/2011,27.38,27.39,26.5,26.87,913900,26.87,5/4/2011,26.78,27,25.75,26.69,1044500,26.69,5/5/2011,27.2,27.44,26.17,26.44,1218500,26.44,5/6/2011,26.9,27.7,26.62,27.12,981700,27.12,5/9/2011,27,28,26.85,27.91,916400,27.91,5/10/2011,28.24,28.95,27.91,28.33,1535300,28.33,5/11/2011,28.2,28.3,26.92,27.07,962500,27.07,5/12/2011,27.07,27.74,26.65,27.67,628000,27.67,5/13/2011,28,28.19,27.3,27.55,661500,27.55,5/16/2011,27.99,27.99,26.55,26.6,755700,26.6,5/17/2011,27,27,25.72,25.96,1234200,25.96,5/18/2011,26.1,26.47,25.52,26.35,729500,26.35,5/19/2011,27.03,28.44,26.6,28.2,2655100,28.2,5/20/2011,28.26,28.28,27.35,27.97,842500,27.97,5/23/2011,27.62,27.62,26.62,26.82,863600,26.82,5/24/2011,27.02,27.5,26.6,26.72,613700,26.72,5/25/2011,26.9,29.01,26.17,28.98,4693100,28.98,5/26/2011,28.82,29.76,28.1,29.48,3336900,29.48,5/27/2011,29.54,29.67,28.82,29.55,1687100,29.55,5/31/2011,29.69,30.28,29.55,30.14,3290500,30.14,6/1/2011,30,30.1,28.38,28.52,1529900,28.52,6/2/2011,28.52,29.32,28.51,28.76,986300,28.76,6/3/2011,29.95,31.5,29.5,30.13,6209200,30.13,6/6/2011,30.1,30.13,28.26,28.7,2331100,28.7,6/7/2011,28.94,29.39,28.26,28.37,1222100,28.37,6/8/2011,28.44,28.6,27.02,27.12,1695900,27.12,6/9/2011,27.43,28.1,27.1,27.62,1603200,27.62,6/10/2011,27.52,28.3,27.35,27.86,1566600,27.86,6/13/2011,28.07,28.88,27.88,28.43,1713400,28.43,6/14/2011,28.54,29.7,28.52,28.6,1573400,28.6,6/15/2011,28.44,28.45,27.07,27.32,1345000,27.32,6/16/2011,27.67,28,25.74,26.5,1842200,26.5,6/17/2011,26.87,27.7,26.14,26.5,1714000,26.5,6/20/2011,26.29,26.46,25.5,26.01,1537800,26.01,6/21/2011,26.24,27.73,26,27.53,1496000,27.53,6/22/2011,27.37,28.25,27.1,27.21,1475600,27.21,6/23/2011,27.2,27.72,26.21,27.71,1170000,27.71,6/24/2011,27.64,27.97,27.26,27.57,3608500,27.57,6/27/2011,27.73,28.28,27.31,27.46,1809400,27.46,6/28/2011,27.79,28.25,27.67,28.11,889200,28.11,6/29/2011,28.5,29.09,28.07,28.29,1461800,28.29,6/30/2011,28.5,29.33,28.4,29.13,946700,29.13,7/1/2011,29.07,29.6,28.8,29.02,854900,29.02,7/5/2011,29.02,29.52,28.71,29.14,996000,29.14,7/6/2011,29.14,29.14,28.55,28.96,926900,28.96,7/7/2011,29.14,30,29.01,29.73,1327900,29.73,7/8/2011,29.89,29.89,28.59,28.81,1240600,28.81,7/11/2011,28.4,28.53,28,28.35,975800,28.35,7/12/2011,28.37,29.09,28,28.17,1045400,28.17,7/13/2011,28.43,29.03,27.9,28.64,1066000,28.64,7/14/2011,28.53,28.96,27.25,27.61,1159000,27.61,7/15/2011,27.79,27.83,27.4,27.58,709000,27.58,7/18/2011,27.34,27.45,26.63,27.23,851900,27.23,7/19/2011,27.58,28.11,27.54,27.89,1026100,27.89,7/20/2011,28,30.44,27.8,28.69,3048300,28.69,7/21/2011,28.91,29.16,28.1,28.7,1011500,28.7,7/22/2011,28.7,29.54,28.55,29.29,583500,29.29,7/25/2011,29.01,29.25,28.44,28.49,673300,28.49,7/26/2011,28.31,28.77,27.97,28,760600,28,7/27/2011,28.5,28.5,27.51,27.64,958500,27.64,7/28/2011,27.6,28.55,27.54,28.17,938700,28.17,7/29/2011,27.8,28.4,27.5,28.17,948200,28.17,8/1/2011,28.67,28.98,28.21,28.77,1164900,28.77,8/2/2011,28.69,29.2,27.27,27.34,1549400,27.34,8/3/2011,27.5,27.83,26.34,27.2,1794500,27.2,8/4/2011,26.51,26.89,24.67,24.75,3064500,24.75,8/5/2011,24.99,25.38,22.83,24.24,1964400,24.24,8/8/2011,23.1,24.44,23.1,23.64,2608500,23.64,8/9/2011,24.15,25.45,23.7,25.06,1333400,25.06,8/10/2011,25.44,25.44,23.63,23.82,1564200,23.82,8/11/2011,24.04,25.75,24,25.3,836500,25.3,8/12/2011,25.6,27.14,25.36,26.31,1009100,26.31,8/15/2011,26.62,26.75,25.93,26.23,738600,26.23,8/16/2011,26.13,26.54,25.83,26.1,537700,26.1,8/17/2011,26.39,26.65,25.51,25.83,643700,25.83,8/18/2011,25,25.15,23.47,24.26,1056600,24.26,8/19/2011,23.86,24.22,22,22.3,1375300,22.3,8/22/2011,23.11,23.8,21.68,21.95,986100,21.95,8/23/2011,21.93,23.11,21.5,22.96,869000,22.96,8/24/2011,23.1,23.93,22.83,23.87,684300,23.87,8/25/2011,23.87,23.87,22.9,23.11,679800,23.11,8/26/2011,22.71,23.95,22.07,23.73,761800,23.73,8/29/2011,24.22,24.85,24.02,24.71,803400,24.71,8/30/2011,24.5,24.77,24.09,24.63,366200,24.63,8/31/2011,24.8,25.5,24.28,24.74,823800,24.74,9/1/2011,24.66,24.87,23.84,24,848100,24,9/2/2011,23.66,23.99,22.68,23.07,769900,23.07,9/6/2011,22.5,23.2,22.29,22.94,809800,22.94,9/7/2011,23.39,24,23.28,23.84,459200,23.84,9/8/2011,23.58,24.03,23.28,23.61,505700,23.61,9/9/2011,23.37,23.57,22.55,22.97,669300,22.97,9/12/2011,22.5,23.31,22.45,22.88,566600,22.88,9/13/2011,23.01,24.1,22.75,24.08,726500,24.08,9/14/2011,24.25,24.84,23.79,24.34,830800,24.34,9/15/2011,24.58,24.93,24.33,24.82,562600,24.82,9/16/2011,24.78,25.84,24.49,25.8,1417100,25.8,9/19/2011,24.95,25.81,23.82,25.77,1157400,25.77,9/20/2011,25.98,26.6,25.67,26.01,1180400,26.01,9/21/2011,25.95,26.95,25.7,25.85,987600,25.85,9/22/2011,25.64,26.11,24.88,25.63,775800,25.63,9/23/2011,25.49,26.62,25.35,26.38,1156400,26.38,9/26/2011,26.52,26.52,24.9,25.52,934800,25.52,9/27/2011,26,26.99,25.57,26.19,674500,26.19,9/28/2011,26,26.5,24.51,24.59,723300,24.59,9/29/2011,25.72,25.82,23.55,24.12,929600,24.12,9/30/2011,24.8,24.89,23.49,24.39,1336100,24.39,10/3/2011,24.95,25,23.25,23.73,1023200,23.73,10/4/2011,23.29,24.32,22.93,23.66,1200300,23.66,10/5/2011,24.03,25.84,23.35,25.37,1229500,25.37,10/6/2011,25.37,27.6,25.02,26.96,1769100,26.96,10/7/2011,26.98,27.6,26.05,26.99,1311600,26.99,10/10/2011,27.31,28.18,27,27.88,923500,27.88,10/11/2011,27.51,27.77,27.09,27.61,575700,27.61,10/12/2011,27.25,28,27.2,27.8,1123400,27.8,10/13/2011,27.63,28.47,27.44,27.94,1043500,27.94,10/14/2011,28,28.55,27.26,28.05,1400500,28.05,10/17/2011,27.86,28,27.26,27.42,754500,27.42,10/18/2011,27.3,28.43,26.71,28.34,999700,28.34,10/19/2011,28.02,28.06,27.3,27.57,792900,27.57,10/20/2011,27.44,27.47,27,27.34,999700,27.34,10/21/2011,27.4,28.3,27.01,28.03,1142600,28.03,10/24/2011,27.87,28.89,27.75,28.55,940600,28.55,10/25/2011,28.23,28.86,27.8,28.25,654400,28.25,10/26/2011,28.19,28.37,27.4,27.98,510500,27.98,10/27/2011,28.34,28.95,28.11,28.76,869400,28.76,10/28/2011,28.5,30,28.01,29.87,1264000,29.87,10/31/2011,29.5,29.51,28.75,29.37,1134000,29.37,11/1/2011,28.39,28.92,28,28.88,635200,28.88,11/2/2011,29,29.26,28.25,28.71,875300,28.71,11/3/2011,30,32.49,29.53,32.46,2509700,32.46,11/4/2011,31.46,32.4,30.51,32.31,3032900,32.31,11/7/2011,31.64,32,30.75,31.27,1266300,31.27,11/8/2011,31.37,32,30.72,31.84,1167900,31.84,11/9/2011,30.87,31.49,30.3,30.88,953700,30.88,11/10/2011,30.94,31.5,30.65,31.33,747300,31.33,11/11/2011,31.9,34.5,30.57,33.64,3868300,33.64,11/14/2011,33,33.54,32.62,33.22,1325700,33.22,11/15/2011,32.92,34.4,32.73,33.93,891000,33.93,11/16/2011,33.48,35,33.4,34.94,1833200,34.94,11/17/2011,34.5,34.9,33.19,33.68,1349300,33.68,11/18/2011,33.64,34.11,32.54,32.6,902800,32.6,11/21/2011,32.44,32.44,31.05,31.76,1031600,31.76,11/22/2011,31.76,32.79,31.05,32.07,732600,32.07,11/23/2011,31.76,32.05,31.25,31.45,451800,31.45,11/25/2011,31.55,32.41,31.08,31.66,239600,31.66,11/28/2011,32,33.28,31.81,32.56,681200,32.56,11/29/2011,32.49,33.07,31.63,31.75,591100,31.75,11/30/2011,32.5,32.93,32.22,32.74,760300,32.74,12/1/2011,32.57,33.99,31.98,32.6,1030200,32.6,12/2/2011,32.83,33.69,32.4,33.3,802800,33.3,12/5/2011,33.53,35,33.43,34.42,1160100,34.42,12/6/2011,34.2,34.98,34.03,34.87,951800,34.87,12/7/2011,34.63,34.89,33.8,34.19,674300,34.19,12/8/2011,30.84,31.65,29.61,30.89,3305800,30.89,12/9/2011,30.54,31.12,30.28,31.04,1239500,31.04,12/12/2011,30.44,30.62,30.02,30.41,758700,30.41,12/13/2011,30.57,30.93,28.91,29.45,994100,29.45,12/14/2011,29.5,29.68,28,28.53,1163900,28.53,12/15/2011,28.67,29.17,28.12,28.62,700300,28.62,12/16/2011,28.79,28.93,27.98,28,1029700,28,12/19/2011,28.09,28.5,27.37,27.75,987000,27.75,12/20/2011,28.05,28.45,27.72,27.9,843300,27.9,12/21/2011,27.91,28.07,26.03,27.57,1705500,27.57,12/22/2011,27.6,28.05,27.3,27.77,1009400,27.77,12/23/2011,28,28,27.52,27.9,591400,27.9,12/27/2011,27.66,28.77,27.64,28.57,777500,28.57,12/28/2011,28.99,29.24,28.04,28.51,575200,28.51,12/29/2011,28.59,29.34,28.55,28.73,488200,28.73,12/30/2011,28.49,28.98,28.25,28.56,339800,28.56,1/3/2012,28.94,29.5,27.65,28.08,928100,28.08,1/4/2012,28.21,28.67,27.5,27.71,630100,27.71,1/5/2012,27.76,27.93,26.85,27.12,1005500,27.12,1/6/2012,27.2,27.79,26.41,26.91,986300,26.91,1/9/2012,27,27.49,26.12,27.25,897000,27.25,1/10/2012,27.44,27.76,27.25,27.62,671800,27.62,1/11/2012,27.62,28.38,27.3,28.23,672300,28.23,1/12/2012,28.48,28.62,27.81,28.25,729300,28.25,1/13/2012,28.4,28.5,22.64,22.79,5500400,22.79,1/17/2012,26.62,27.34,26.41,26.6,4651600,26.6,1/18/2012,26.69,26.88,26.25,26.81,1260200,26.81,1/19/2012,27.19,27.74,26.61,26.76,1246300,26.76,1/20/2012,26.9,27,26.4,26.6,662300,26.6,1/23/2012,26.81,27.21,26.6,26.77,594600,26.77,1/24/2012,26.63,27.68,26.44,27.42,858000,27.42,1/25/2012,27.27,28.01,27.05,27.97,611200,27.97,1/26/2012,28.07,29.58,28,28.94,1271100,28.94,1/27/2012,28.5,29.72,28.5,29.33,748400,29.33,1/30/2012,29.49,29.61,28.53,29.57,729000,29.57,1/31/2012,29.9,30,28.87,29.07,956400,29.07,2/1/2012,29.07,29.7,29,29.58,523200,29.58,2/2/2012,29.72,30.88,29.61,30.25,805700,30.25,2/3/2012,30.41,31.33,30.25,31.15,764500,31.15,2/6/2012,31.1,31.9,31.05,31.8,652100,31.8,2/7/2012,31.8,31.8,30.82,31.6,1021600,31.6,2/8/2012,31.6,32.01,31.29,31.93,623700,31.93,2/9/2012,32,32.9,31.43,32.58,1277100,32.58,2/10/2012,32.26,32.27,29.84,31.1,1874200,31.1,2/13/2012,31.55,32.06,30.9,31.49,1157900,31.49,2/14/2012,31.74,33.79,31.4,33.17,1810800,33.17,2/15/2012,33.1,34.41,32.27,33.6,2761800,33.6,2/16/2012,33.5,34.51,32.54,34.18,2219700,34.18,2/17/2012,33.99,34.97,33.5,34.97,1376700,34.97,2/21/2012,34.87,34.87,33.81,34.5,1135800,34.5,2/22/2012,34.5,34.72,32.5,34.22,1654600,34.22,2/23/2012,33.99,34.97,33.56,34.53,820400,34.53,2/24/2012,34.23,34.52,33.27,33.75,959900,33.75,2/27/2012,33.41,34,33,33.62,606000,33.62,2/28/2012,33.64,34.44,33.17,33.81,612200,33.81,2/29/2012,33.81,34.12,33.14,33.41,535700,33.41,3/1/2012,33.51,34.5,33.31,34.41,703500,34.41,3/2/2012,34.4,34.5,33.71,34.04,550000,34.04,3/5/2012,34.35,34.4,33.46,33.77,467000,33.77,3/6/2012,33.25,33.28,32.62,33.11,573800,33.11,3/7/2012,33.12,33.31,32.91,33.12,364900,33.12,3/8/2012,33.11,33.49,33.04,33.07,633300,33.07,3/9/2012,33.2,35.31,33.2,34.74,1553400,34.74,3/12/2012,34.69,36.29,34.6,36.01,1963300,36.01,3/13/2012,36.51,36.59,35.5,36.09,1001600,36.09,3/14/2012,36,36,34.8,35.29,851500,35.29,3/15/2012,35.28,35.48,34.78,35,571600,35,3/16/2012,34.9,35.89,34.83,35.32,729300,35.32,3/19/2012,35.26,35.32,34.54,34.98,1015600,34.98,3/20/2012,34.98,35.2,34.57,34.96,567000,34.96,3/21/2012,34.94,35.3,34.6,35.15,607200,35.15,3/22/2012,34.97,35.15,34.3,34.4,522400,34.4,3/23/2012,34.26,34.63,33.15,34.08,1170600,34.08,3/26/2012,35.59,38.09,35.04,37.4,3140500,37.4,3/27/2012,37.16,39.95,37.03,37.94,2539200,37.94,3/28/2012,37.78,38.44,37.11,37.85,955000,37.85,3/29/2012,38.19,38.19,37.03,37.33,796400,37.33,3/30/2012,37.52,37.94,36.68,37.24,886400,37.24,4/2/2012,37.33,37.97,36.53,36.58,1028600,36.58,4/3/2012,36.7,38.47,36.67,38.01,1098100,38.01,4/4/2012,35.27,35.49,34.69,35,4481800,35,4/5/2012,35.1,35.44,34.41,34.48,1509400,34.48,4/9/2012,34.1,34.29,33.1,33.15,1655700,33.15,4/10/2012,33.15,33.85,32.1,32.46,1847700,32.46,4/11/2012,33.24,33.29,32.01,33.09,1105500,33.09,4/12/2012,33.77,34.48,32.92,33.44,1033900,33.44,4/13/2012,33.94,34.04,32.85,33.59,649600,33.59,4/16/2012,33.41,33.7,32.09,32.25,1099600,32.25,4/17/2012,32.43,33.07,32.04,32.24,1115500,32.24,4/18/2012,32.09,32.75,31.53,32.66,823100,32.66,4/19/2012,32.75,33.43,32.5,33.16,774900,33.16,4/20/2012,33.14,33.73,32.94,33.16,821800,33.16,4/23/2012,32.86,32.97,31.71,31.94,890800,31.94,4/24/2012,31.82,32.2,31,31.82,674500,31.82,4/25/2012,32.07,32.99,32.07,32.91,712200,32.91,4/26/2012,32.96,33.52,32.91,33.49,425300,33.49,4/27/2012,33.6,33.63,32.91,33.34,591000,33.34,4/30/2012,33.27,33.36,32.58,33.13,413900,33.13,5/1/2012,33.13,34.21,33.13,33.78,659000,33.78,5/2/2012,33.5,34.39,33.39,33.94,497300,33.94,5/3/2012,33.91,34,32.13,32.46,841300,32.46,5/4/2012,32.32,32.46,31.4,31.83,1247500,31.83,5/7/2012,31.96,32.58,31.61,32.47,1158000,32.47,5/8/2012,32.5,32.73,29.37,30.19,3097200,30.19,5/9/2012,30.3,30.77,29.76,30.06,1947900,30.06,5/10/2012,32.97,34.68,32.4,32.96,5556300,32.96,5/11/2012,32.49,33.44,32.16,32.25,1221300,32.25,5/14/2012,31.92,32.13,30.05,30.06,1380900,30.06,5/15/2012,30.26,30.96,29.22,29.43,1585700,29.43,5/16/2012,29.58,30.18,28.88,29.18,1257100,29.18,5/17/2012,29.3,29.79,28.24,28.57,1149000,28.57,5/18/2012,28.37,28.46,26.83,27.56,1616500,27.56,5/21/2012,27.58,29.26,27.12,28.77,1475200,28.77,5/22/2012,30.1,31.34,30,30.8,2366200,30.8,5/23/2012,30.56,31.05,29.5,31.02,1220400,31.02,5/24/2012,31.25,31.25,29.69,30.28,1075600,30.28,5/25/2012,30.16,30.41,29.2,29.81,757000,29.81,5/29/2012,30.01,31.93,30.01,31.69,1650000,31.69,5/30/2012,31.08,31.42,30.24,30.41,1307200,30.41,5/31/2012,30.07,30.29,28.75,29.5,1118700,29.5,6/1/2012,28.53,29.16,27.76,28.15,885800,28.15,6/4/2012,28.03,28.41,27.11,27.88,1030900,27.88,6/5/2012,27.84,28.39,27.56,27.91,630900,27.91,6/6/2012,28.2,29.45,28.14,29.22,909900,29.22,6/7/2012,29.81,29.87,28.85,28.93,492100,28.93,6/8/2012,28.86,30.19,28.15,30.08,881100,30.08,6/11/2012,30.31,31,28.96,29.12,636000,29.12,6/12/2012,29.23,29.84,28.81,29.66,569000,29.66,6/13/2012,29.55,30.64,29.47,29.77,844100,29.77,6/14/2012,30.18,30.65,28.62,29.39,872200,29.39,6/15/2012,29.39,29.95,28.81,29.91,646800,29.91,6/18/2012,29.94,32.33,29.5,31.84,1256800,31.84,6/19/2012,32.02,32.66,31.5,32.09,911100,32.09,6/20/2012,33.5,34.5,33.21,33.78,3422400,33.78,6/21/2012,34.26,34.28,31.84,32.19,1891900,32.19,6/22/2012,32.6,33.98,32.46,33.79,3046600,33.79,6/25/2012,33.94,34.12,32.75,33.11,1498500,33.11,6/26/2012,32.05,32.35,31.39,31.61,2613900,31.61,6/27/2012,31.9,32.45,31.57,31.96,1047200,31.96,6/28/2012,31.9,32.11,30.62,31.41,914100,31.41,6/29/2012,32.8,32.8,31,31.29,1125800,31.29,7/2/2012,31.35,31.8,30.19,30.4,1315600,30.4,7/3/2012,30.6,31,30.4,30.66,947000,30.66,7/5/2012,30.81,31.67,30.8,31.23,1253800,31.23,7/6/2012,30.99,31.73,30.8,30.99,784500,30.99,7/9/2012,30.94,31.83,30.67,31.49,910500,31.49,7/10/2012,31.54,32.48,30.89,31.27,758400,31.27,7/11/2012,31.57,31.68,31.01,31.51,638600,31.51,7/12/2012,31.29,33.01,30.8,32.7,1125700,32.7,7/13/2012,32.97,34.4,32.83,34.25,1304800,34.25,7/16/2012,34.32,36,33.9,35.96,1744000,35.96,7/17/2012,35,35.21,32.38,33.35,2569300,33.35,7/18/2012,31.42,33.67,31.06,32.15,2881900,32.15,7/19/2012,32.72,33.15,32.04,32.27,1435900,32.27,7/20/2012,32.07,32.25,31.25,31.79,1568500,31.79,7/23/2012,31.05,31.3,30.62,30.66,1386800,30.66,7/24/2012,30.66,31.04,29.62,29.84,1500300,29.84,7/25/2012,29.92,29.98,28.75,28.95,2842200,28.95,7/26/2012,29.9,30,27.64,28.13,2262300,28.13,7/27/2012,28.71,29.66,28.1,29.51,1673000,29.51,7/30/2012,29.51,30.25,27.21,27.35,2065200,27.35,7/31/2012,27.54,27.97,27.35,27.42,1575100,27.42,8/1/2012,27.99,27.99,26.03,26.25,1592300,26.25,8/2/2012,26.84,26.85,25.52,26.1,1305100,26.1,8/3/2012,26.9,27.55,26.74,27.27,1209500,27.27,8/6/2012,27.55,28.7,27.55,28.27,1528200,28.27,8/7/2012,28.77,30.9,28.5,30.25,2387200,30.25,8/8/2012,29.9,30,28.59,29.09,1308900,29.09,8/9/2012,29.52,30,29.13,29.41,672600,29.41,8/10/2012,29.31,29.94,29.31,29.94,707400,29.94,8/13/2012,29.69,31.3,29.1,31.17,870100,31.17,8/14/2012,30.75,31.17,29.26,29.42,793400,29.42,8/15/2012,29.39,29.7,28.81,29.4,525400,29.4,8/16/2012,29.53,30.39,29.5,30.3,669000,30.3,8/17/2012,30.29,30.71,29.98,30.01,508200,30.01,8/20/2012,30.15,30.39,29.1,29.51,1179100,29.51,8/21/2012,29.58,30,29,29.11,761600,29.11,8/22/2012,29.01,30.04,29.01,29.95,775500,29.95,8/23/2012,30,30.85,29.65,30.73,1471000,30.73,8/24/2012,30.06,30.24,29.41,29.5,1429400,29.5,8/27/2012,29.57,29.7,28.17,28.32,1350400,28.32,8/28/2012,28.4,29.38,28,28.69,1402700,28.69,8/29/2012,28.49,28.64,28.02,28.41,838900,28.41,8/30/2012,28.6,28.74,28.1,28.41,656400,28.41,8/31/2012,28.61,28.84,28.2,28.52,539800,28.52,9/4/2012,28.52,28.99,27.9,28.14,752500,28.14,9/5/2012,28.01,28.5,27.81,27.94,639300,27.94,9/6/2012,28,28.9,27.9,28.55,841700,28.55,9/7/2012,28.55,29.57,28.5,29.35,953200,29.35,9/10/2012,29.2,29.35,27.3,27.37,1483300,27.37,9/11/2012,27.76,28.16,27.4,27.8,1014900,27.8,9/12/2012,27.9,28.58,27.8,28.28,1145200,28.28,9/13/2012,28.57,29.5,28.48,29.48,1484700,29.48,9/14/2012,30,30.65,29.65,30.39,1536600,30.39,9/17/2012,32.35,32.78,31.51,32.54,3212800,32.54,9/18/2012,31.88,31.9,30.68,31.34,1788500,31.34,9/19/2012,31,31.74,30.94,31.05,1048500,31.05,9/20/2012,30.93,31.5,30.68,30.9,912400,30.9,9/21/2012,31.1,31.49,29.54,30.02,1870000,30.02,9/24/2012,29.51,31.03,29.4,30.66,1301900,30.66,9/25/2012,28.62,29.48,27.53,27.66,5680400,27.66,9/26/2012,27.66,28.4,27.48,27.54,1527200,27.54,9/27/2012,27.82,28.54,27.6,28.49,1758600,28.49,9/28/2012,28.73,29.89,28.61,29.28,4343400,29.28,10/1/2012,29.5,29.89,29,29.16,884400,29.16,10/2/2012,29.28,29.89,29,29.8,729000,29.8,10/3/2012,29.75,29.95,29.24,29.3,1052800,29.3,10/4/2012,30,30.1,28.65,29.4,1541300,29.4,10/5/2012,29.7,29.81,28.68,28.89,938600,28.89,10/8/2012,28.86,29.4,28.61,29.25,889700,29.25,10/9/2012,29.12,29.12,28.25,28.37,1193000,28.37,10/10/2012,28.39,28.72,28.01,28.4,503600,28.4,10/11/2012,28.94,28.98,28.25,28.32,450600,28.32,10/12/2012,28.32,28.73,27.5,27.64,987600,27.64,10/15/2012,28.02,28.05,26.86,27.33,1468700,27.33,10/16/2012,27.67,28.09,27.34,28.06,479300,28.06,10/17/2012,28.25,28.84,27.8,28.82,668000,28.82,10/18/2012,28.99,28.99,27.78,28.04,741000,28.04,10/19/2012,27.83,28.2,27.3,27.74,1027400,27.74,10/22/2012,27.99,28,27.36,27.85,470200,27.85,10/23/2012,27.38,28.56,27.37,28.39,749000,28.39,10/24/2012,28.52,28.52,27.25,27.42,1016400,27.42,10/25/2012,27.8,27.8,27.45,27.52,577700,27.52,10/26/2012,27.53,27.8,27.02,27.38,477400,27.38,10/31/2012,27.7,28.35,27.37,28.13,775200,28.13,11/1/2012,28.25,29.49,28.2,29.25,1024100,29.25,11/2/2012,29.27,29.55,28.55,28.92,1030300,28.92,11/5/2012,29.8,31.58,29.33,31.5,2048900,31.5,11/6/2012,30.61,31.2,29.95,31.15,2324000,31.15,11/7/2012,31,32.05,30.81,31.54,1714500,31.54,11/8/2012,31.01,31.88,30.94,31.31,1274000,31.31,11/9/2012,30.6,30.93,29.85,30.32,863000,30.32,11/12/2012,30.29,31.42,30.16,31.07,555900,31.07,11/13/2012,31.29,32,30.72,31.61,998300,31.61,11/14/2012,31.96,32.12,31.2,31.38,871300,31.38,11/15/2012,31.3,31.44,30.5,30.82,984000,30.82,11/16/2012,31.15,32,30.59,31.84,908700,31.84,11/19/2012,32.07,33.25,31.84,32.92,1392400,32.92,11/20/2012,32.8,33.1,31.91,33,922500,33,11/21/2012,32.61,33.47,32.29,32.47,963200,32.47,11/23/2012,32.6,32.83,31.7,32.13,430300,32.13,11/26/2012,32.1,32.3,31.62,32.27,495800,32.27,11/27/2012,32.13,32.66,31.52,32.15,910800,32.15,11/28/2012,32,34.29,31.91,33.23,1525200,33.23,11/29/2012,33.44,34,32.87,33.69,1103400,33.69,11/30/2012,33.63,34.28,33.01,33.82,1420300,33.82,12/3/2012,33.89,35,33.5,34.62,2085700,34.62,12/4/2012,34.08,34.8,33.55,33.9,1263300,33.9,12/5/2012,33.82,34.19,33.58,33.71,661500,33.71,12/6/2012,33.82,34.8,33.5,33.9,660400,33.9,12/7/2012,34.3,34.49,33.85,34.17,664400,34.17,12/10/2012,34.43,34.8,34.18,34.57,929800,34.57,12/11/2012,34.6,35.5,34.46,35.28,1572600,35.28,12/12/2012,35.21,35.8,34.95,35.26,2063800,35.26,12/13/2012,35.26,35.3,32.75,33.61,2151300,33.61,12/14/2012,33.78,34.4,33.59,33.81,1023000,33.81,12/17/2012,33.77,34.5,33.75,34.4,824900,34.4,12/18/2012,34.26,35.07,34.26,34.59,1553900,34.59,12/19/2012,34.75,35.26,34.52,34.61,1298800,34.61,12/20/2012,34.51,34.79,34.05,34.43,921200,34.43,12/21/2012,33.94,34.17,33.58,34,1492400,34,12/24/2012,33.64,34.35,33.55,34.28,375800,34.28,12/26/2012,33.96,34.5,33.5,33.59,601400,33.59,12/27/2012,33.5,33.91,33,33.69,561100,33.69,12/28/2012,33.38,33.65,33.02,33.22,414100,33.22,12/31/2012,33,33.97,33,33.87,594900,33.87,1/2/2013,35,35.45,34.71,35.36,1194800,35.36,1/3/2013,35.18,35.45,34.75,34.77,742000,34.77,1/4/2013,34.8,34.8,33.92,34.4,674000,34.4,1/7/2013,34.8,34.8,33.9,34.34,442000,34.34,1/8/2013,34.5,34.5,33.11,33.68,1284000,33.68,1/9/2013,34.01,34.19,33.4,33.64,698000,33.64,1/10/2013,33.87,33.99,33.38,33.53,922500,33.53,1/11/2013,34.04,34.04,32.11,32.91,1563200,32.91,1/14/2013,33.08,33.38,32.85,33.26,925100,33.26,1/15/2013,33.11,34.25,33.08,33.9,1624200,33.9,1/16/2013,33.85,34.23,33.73,34.1,1378200,34.1,1/17/2013,34.16,34.85,33.92,34.38,1436700,34.38,1/18/2013,34.74,34.78,33.82,34.52,3555100,34.52,1/22/2013,34.56,35.55,34.26,35.19,1920200,35.19,1/23/2013,35.02,36.24,34.96,36,1564300,36,1/24/2013,36,37.72,35.84,36.99,1970400,36.99,1/25/2013,37,37.54,36.8,36.98,1287800,36.98,1/28/2013,36.86,38.71,36.86,38.03,1986000,38.03,1/29/2013,38.1,38.44,37.13,37.95,1426600,37.95,1/30/2013,37.85,38,37.43,37.52,968100,37.52,1/31/2013,37.87,37.87,36.93,37.51,901400,37.51,2/1/2013,38.17,38.5,37.62,38.3,1100600,38.3,2/4/2013,38.4,38.42,37.59,37.74,1128000,37.74,2/5/2013,38,38.65,37.68,38.13,1310200,38.13,2/6/2013,38.18,39.39,37.9,39.17,1893200,39.17,2/7/2013,39.19,39.68,38.95,39.48,1196600,39.48,2/8/2013,39.45,40,39.14,39.24,1139800,39.24,2/11/2013,37.98,39.15,37.5,38.42,3266200,38.42,2/12/2013,38.45,38.87,37.29,37.89,2261300,37.89,2/13/2013,38.3,39,38.05,38.45,966800,38.45,2/14/2013,38.64,38.75,38.21,38.27,990700,38.27,2/15/2013,38.5,38.51,36.95,37.04,2017600,37.04,2/19/2013,37.36,39.29,37.31,39.28,2701400,39.28,2/20/2013,39.3,39.65,38.46,38.54,3122000,38.54,2/21/2013,36.49,37.39,34.54,35.16,9037800,35.16,2/22/2013,35.72,36.39,35.6,36.11,2547300,36.11,2/25/2013,36.15,36.75,34.34,34.38,2889400,34.38,2/26/2013,34.46,34.96,33.8,34.43,2762900,34.43,2/27/2013,34.41,35.41,34.4,35.1,1959200,35.1,2/28/2013,35.89,36.1,34.37,34.83,1964900,34.83,3/1/2013,35,35.08,34.25,34.65,1546600,34.65,3/4/2013,34.77,35.83,34.7,35.58,1757700,35.58,3/5/2013,36,36.92,35.79,36.65,2087000,36.65,3/6/2013,37.01,37.88,36.97,37.69,1150000,37.69,3/7/2013,37.73,38.65,36.88,38.23,1158300,38.23,3/8/2013,38.06,39.44,37.36,38.47,912100,38.47,3/11/2013,38.87,39.44,38.65,39.1,1579500,39.1,3/12/2013,38.9,39.38,38.85,39.12,1275100,39.12,3/13/2013,39,39.49,38.81,38.98,822000,38.98,3/14/2013,38.9,38.91,36.77,36.85,2021000,36.85,3/15/2013,36.64,36.65,35.21,35.29,3279600,35.29,3/18/2013,35.3,36.06,34.92,35.15,1316100,35.15,3/19/2013,35.25,35.6,34.94,35.08,1098500,35.08,3/20/2013,35.26,36.07,35.16,35.95,1423000,35.95,3/21/2013,35.95,37.06,35.74,36.01,1146300,36.01,3/22/2013,36.2,36.8,36.2,36.62,440200,36.62,3/25/2013,37.1,38.52,36.77,37.53,2378800,37.53,3/26/2013,37.98,38.22,37.66,37.86,1808200,37.86,3/27/2013,37.94,38.38,37.31,38.16,1296300,38.16,3/28/2013,38.23,38.24,37.75,37.89,1158700,37.89,4/1/2013,42.36,46.68,41.7,43.93,14098500,43.93,4/2/2013,43.6,45.5,43.51,44.34,6652400,44.34,4/3/2013,43.1,43.47,40.21,41.1,5643600,41.1,4/4/2013,41.11,42.25,40.81,42.01,2264800,42.01,4/5/2013,42,42,40.5,41.37,1552400,41.37,4/8/2013,41.97,42.55,41.51,41.83,1679000,41.83,4/9/2013,41.8,41.83,40.33,40.5,1696100,40.5,4/10/2013,40.7,42.01,40.61,41.86,2121100,41.86,4/11/2013,42.06,44.55,41.75,43.59,3447400,43.59,4/12/2013,43.25,45.14,43.05,43.75,3149400,43.75,4/15/2013,43.5,43.8,42.51,43.3,1681400,43.3,4/16/2013,44.19,46.14,43.91,45.59,3180400,45.59,4/17/2013,45.5,45.95,44.54,45.45,2118500,45.45,4/18/2013,45.98,47.6,45.39,46.97,3367900,46.97,4/19/2013,47.46,49.88,47.07,47.83,3011700,47.83,4/22/2013,48.6,50.2,47.75,50.19,3939400,50.19,4/23/2013,51,52.92,50.66,51.01,3733800,51.01,4/24/2013,50.9,51.05,48.98,50.43,2630000,50.43,4/25/2013,50.5,52.4,50.5,52,2795900,52,4/26/2013,53.13,53.74,50.62,51.2,3622100,51.2,4/29/2013,51.76,54.99,51.2,54.94,3639700,54.94,4/30/2013,56,58.18,53.76,53.99,5522600,53.99,5/1/2013,55.99,55.99,53,53.28,2742800,53.28,5/2/2013,53.85,55.27,53.7,54.11,3050400,54.11,5/3/2013,56.47,56.47,54.5,54.55,3378700,54.55,5/6/2013,56.39,59.66,55.5,59.5,4366700,59.5,5/7/2013,62,62.37,55.12,55.51,9991000,55.51,5/8/2013,57.5,58.2,55.71,55.79,6769900,55.79,5/9/2013,70.12,75.77,63.69,69.4,28605000,69.4,5/10/2013,69.65,81,69.25,76.76,25082600,76.76,5/13/2013,80.99,88,79.15,87.8,22416900,87.8,5/14/2013,94.22,97.12,81.15,83.24,37163900,83.24,5/15/2013,81.8,86.88,78.11,84.84,16878700,84.84,5/16/2013,94.7,95,88.66,92.25,21614000,92.25,5/17/2013,92.5,94.44,87.5,91.5,19002200,91.5,5/20/2013,91.12,92.5,88.63,89.94,8348400,89.94,5/21/2013,88.5,89.99,85.28,87.59,8998200,87.59,5/22/2013,86.37,90.96,85.5,87.24,8568000,87.24,5/23/2013,84.81,93.01,83.05,92.73,12022200,92.73,5/24/2013,92.6,97.95,92,97.08,16124200,97.08,5/28/2013,101.55,110.75,100.3,110.33,19691900,110.33,5/29/2013,113.55,114.9,99,104.63,25099500,104.63,5/30/2013,102.46,109.54,101.2,104.95,16133700,104.95,5/31/2013,106.26,106.44,97.73,97.76,15172000,97.76,6/3/2013,97.62,97.62,88.25,92.59,19139600,92.59,6/4/2013,92.75,96.42,92.4,94.84,8856100,94.84,6/5/2013,93.66,97.97,89.11,95.37,12224800,95.37,6/6/2013,95.25,99.27,95.11,97.35,9510900,97.35,6/7/2013,98,102.9,96.7,102.04,10711600,102.04,6/10/2013,98.93,102.52,98.57,100.05,9228600,100.05,6/11/2013,98.18,98.68,94.05,94.47,7394000,94.47,6/12/2013,96.8,100.48,95.75,97.73,9192700,97.73,6/13/2013,99,99.28,95.12,98.18,5961600,98.18,6/14/2013,100,102.52,99.33,100.3,6564700,100.3,6/17/2013,103.6,104.75,101.2,102.2,7066200,102.2,6/18/2013,101.75,103.98,99.2,103.39,8795300,103.39,6/19/2013,102.06,106.67,102.01,104.68,8578900,104.68,6/20/2013,104.65,107.13,99.45,100.65,10106500,100.65,6/21/2013,103.7,103.7,97.5,99.55,11718600,99.55,6/24/2013,96.5,102.87,95.3,101.49,7119800,101.49,6/25/2013,103.1,104.2,100.55,102.4,5848700,102.4,6/26/2013,103.8,105.87,102.66,105.72,6602600,105.72,6/27/2013,106.75,110.25,106.13,109.25,8744900,109.25,6/28/2013,108.57,109.44,106.71,107.36,5748600,107.36,7/1/2013,109.36,117.77,109.15,117.18,10903600,117.18,7/2/2013,118.25,121.89,115.5,117.82,12064100,117.82,7/3/2013,118,119.25,114.27,115.24,4806700,115.24,7/5/2013,118.32,120.28,115.7,120.09,6818700,120.09,7/8/2013,121.37,122.18,118.82,121.61,7814200,121.61,7/9/2013,124.64,125.32,121.91,123.45,8603300,123.45,7/10/2013,123.19,123.25,120.79,122.27,5600100,122.27,7/11/2013,124.88,126.09,122.35,125.61,7483600,125.61,7/12/2013,125.5,129.94,124.51,129.9,11344000,129.9,7/15/2013,133.03,133.26,126.82,127.26,9922400,127.26,7/16/2013,126.28,126.32,107.3,109.05,32371900,109.05,7/17/2013,106.52,121.62,104.5,120.25,26029000,120.25,7/18/2013,120.97,122.73,116.18,119.03,11398100,119.03,7/19/2013,118.5,120.55,116.51,119.68,5890300,119.68,7/22/2013,119.89,126.68,119.88,122.43,9797800,122.43,7/23/2013,124,125.56,121.82,122.74,7736400,122.74,7/24/2013,124.47,124.5,119.56,121.7,6869000,121.7,7/25/2013,120.4,124.75,120.19,124.07,5284300,124.07,7/26/2013,128.14,130.68,126.61,129.39,9633100,129.39,7/29/2013,129.32,135.37,128.25,134.62,9678900,134.62,7/30/2013,134.8,137.49,128.18,131.74,13127000,131.74,7/31/2013,132.57,134.97,131.45,134.28,6351700,134.28,8/1/2013,135,136.52,132.63,135.55,5323600,135.55,8/2/2013,134.59,138.25,133.61,138,6269900,138,8/5/2013,140.01,144.89,139.65,144.68,10200700,144.68,8/6/2013,144.75,145.73,141.1,142.15,9254500,142.15,8/7/2013,141.89,141.95,132.36,134.23,18212200,134.23,8/8/2013,154.35,158.88,150.46,153.48,27246800,153.48,8/9/2013,152.4,155.95,151.25,153,8927700,153,8/12/2013,149.43,150.5,142.05,147.38,14912200,147.38,8/13/2013,149.5,149.84,144.45,145.43,8748900,145.43,8/14/2013,142.72,144.84,138.05,139.36,11693800,139.36,8/15/2013,136.43,143.6,135,139.67,10179200,139.67,8/16/2013,141.63,143.91,140.97,142,7108100,142,8/19/2013,143.43,147.38,142.83,144.9,8037700,144.9,8/20/2013,148.65,149.78,147,149.58,6418200,149.58,8/21/2013,150,150.31,146.25,147.86,6266300,147.86,8/22/2013,149.22,157.48,148.14,157.1,10592400,157.1,8/23/2013,157,162.3,155,161.84,12931900,161.84,8/26/2013,165.15,173,160.25,164.22,24171100,164.22,8/27/2013,162.3,168.8,160.95,167.01,17566900,167.01,8/28/2013,169.06,171.5,163.25,166.45,14740100,166.45,8/29/2013,164.22,167.75,162.51,166.06,9436000,166.06,8/30/2013,166.37,169.21,163.96,169,11028400,169,9/3/2013,173.4,173.7,166.4,168.94,12061100,168.94,9/4/2013,169.77,171.62,165.56,170.62,11475700,170.62,9/5/2013,170.1,171.5,168.25,169.93,6685300,169.93,9/6/2013,168.57,169.7,165.15,166.97,8619700,166.97,9/9/2013,163.12,164.5,158.51,160.7,14344500,160.7,9/10/2013,161.45,167.5,160.63,166.37,8967800,166.37,9/11/2013,166.41,167.9,162.13,163.52,5832500,163.52,9/12/2013,164,166.76,160.51,164.93,6160000,164.93,9/13/2013,162.77,166.37,162.16,165.54,5401200,165.54,9/16/2013,168,170.85,165.85,166.58,7574900,166.58,9/17/2013,165.08,168.42,163.36,166.23,5496900,166.23,9/18/2013,167.07,167.45,164.2,166.22,5439700,166.22,9/19/2013,170.8,180.47,169.08,177.92,15594600,177.92,9/20/2013,178.9,185.83,178.56,183.39,13401700,183.39,9/23/2013,184.48,185.48,177.11,181.11,8173400,181.11,9/24/2013,179.14,184.96,177.65,182.33,6273400,182.33,9/25/2013,183.56,186.3,180.5,185.24,8252700,185.24,9/26/2013,186.7,189.68,185.61,188.64,6614400,188.64,9/27/2013,187.52,191.28,186.43,190.9,5916400,190.9,9/30/2013,189,194.5,188,193.37,8924700,193.37,10/1/2013,193.96,194.23,188.37,193,7755900,193,10/2/2013,188.59,191.83,175.4,180.95,20775400,180.95,10/3/2013,175.05,179.69,168,173.31,23816500,173.31,10/4/2013,176.4,181.18,172.65,180.98,14414000,180.98,10/7/2013,182.46,186.73,180.26,183.07,11485600,183.07,10/8/2013,184.4,185.93,173.21,174.73,13757200,174.73,10/9/2013,174.73,174.99,161.5,168.78,15316500,168.78,10/10/2013,173.09,175.75,169.69,172.93,8883900,172.93,10/11/2013,172.75,179.29,171.2,178.7,8311100,178.7,10/14/2013,175,182.5,174.15,179.72,7769600,179.72,10/15/2013,185.28,188.79,183.18,183.94,10978500,183.94,10/16/2013,184.9,187.3,182.09,183.56,8205400,183.56,10/17/2013,183.54,184.8,180.99,182.8,6705000,182.8,10/18/2013,184.15,185.96,182.52,183.4,5930800,183.4,10/21/2013,183.28,183.39,171,172.6,11532100,172.6,10/22/2013,170.5,177.78,166.11,171.54,11386700,171.54,10/23/2013,168.91,171.81,160.15,164.5,13320400,164.5,10/24/2013,165,174.5,162.83,173.15,10825700,173.15,10/25/2013,174.21,174.5,166.8,169.66,7595500,169.66,10/28/2013,170.18,170.5,162.2,162.86,7841700,162.86,10/29/2013,162.76,165.45,153,164.47,14111700,164.47,10/30/2013,164.63,167.68,158.17,159.22,8401800,159.22,10/31/2013,155.67,162.44,153.3,159.94,9333800,159.94,11/1/2013,163,165.9,160.41,162.17,7180600,162.17,11/4/2013,165,175.39,164.22,175.2,13120400,175.2,11/5/2013,180,181.43,171.36,176.81,22467100,176.81,11/6/2013,154.81,160.73,146.35,151.16,31071700,151.16,11/7/2013,144.19,145.65,137.62,139.77,22284700,139.77,11/8/2013,136.48,140.6,132.32,137.95,22477900,137.95,11/11/2013,141,145.42,137.1,144.7,13997600,144.7,11/12/2013,144.69,144.7,136.18,137.8,14985200,137.8,11/13/2013,140.84,142.37,136.34,138.7,12658300,138.7,11/14/2013,138.92,140.4,134.11,137.6,12203700,137.6,11/15/2013,136.85,137.95,134.35,135.45,9900200,135.45,11/18/2013,135.27,135.45,119.61,121.58,23138200,121.58,11/19/2013,119.43,129,119.22,126.09,19816200,126.09,11/20/2013,126.08,127.45,119.06,121.11,13849600,121.11,11/21/2013,122.89,124.79,120.25,122.1,11903800,122.1,11/22/2013,121.58,122.75,117.93,121.38,11096700,121.38,11/25/2013,124.5,125.84,120.3,120.84,10267300,120.84,11/26/2013,119.38,122.72,116.1,120.5,13885500,120.5,11/27/2013,121.31,126.95,119.52,126.94,12367600,126.94,11/29/2013,129.77,130.59,126.98,127.28,9716200,127.28,12/2/2013,126.35,128.55,123.93,124.17,7689000,124.17,12/3/2013,132.68,144.94,131.59,144.7,25625400,144.7,12/4/2013,144.32,144.43,137.13,138.95,13129000,138.95,12/5/2013,140.15,143.35,139.5,140.48,9278300,140.48,12/6/2013,141.51,142.49,136.3,137.36,7882500,137.36,12/9/2013,137,141.7,134.21,141.6,9027200,141.6,12/10/2013,140.05,145.87,139.86,142.19,10725900,142.19,12/11/2013,141.88,143.05,139.49,139.65,7112200,139.65,12/12/2013,139.7,148.24,138.53,147.47,10742500,147.47,12/13/2013,148.05,151.8,147.32,147.65,10591900,147.65,12/16/2013,148.48,150.43,146.1,147.94,6663700,147.94,12/17/2013,147.58,154.63,146.32,152.46,10472700,152.46,12/18/2013,152.24,154.9,145.95,147.98,11569000,147.98,12/19/2013,146.9,147,139.1,140.72,12740000,140.72,12/20/2013,141.58,144.35,141.58,143.24,7412600,143.24,12/23/2013,144.85,146.24,142.6,143.55,5338400,143.55,12/24/2013,150,154.97,149.82,151.41,9941500,151.41,12/26/2013,155.04,158,154.29,155.5,7112400,155.5,12/27/2013,155.3,155.5,150.8,151.12,5460200,151.12,12/30/2013,151.12,154.81,150.75,152.44,4467500,152.44,12/31/2013,152.32,153.2,148.66,150.43,4262400,150.43,1/2/2014,149.8,152.48,146.55,150.1,6188400,150.1,1/3/2014,150,152.19,148.6,149.56,4695000,149.56,1/6/2014,150,150.4,145.24,147,5361100,147,1/7/2014,147.62,150.4,145.25,149.36,5034100,149.36,1/8/2014,148.85,153.7,148.76,151.28,6163200,151.28,1/9/2014,152.5,153.43,146.85,147.53,5382000,147.53,1/10/2014,148.46,148.9,142.25,145.72,7446100,145.72,1/13/2014,145.78,147,137.82,139.34,6316100,139.34,1/14/2014,140.5,162,136.67,161.27,27607000,161.27,1/15/2014,168.45,172.23,162.1,164.13,20465600,164.13,1/16/2014,162.5,172.7,162.4,170.97,11959400,170.97,1/17/2014,170.19,173.2,167.95,170.01,9206200,170.01,1/21/2014,171.24,177.29,170.81,176.68,9734700,176.68,1/22/2014,177.81,180.32,174.76,178.56,7022600,178.56,1/23/2014,177.23,182.38,173.42,181.5,7867400,181.5,1/24/2014,177.85,180.48,173.53,174.6,7664300,174.6,1/27/2014,175.16,177.92,164.71,169.62,8716400,169.62,1/28/2014,171.5,178.98,171,178.38,6093400,178.38,1/29/2014,175.3,179.09,173.13,175.23,5935500,175.23,1/30/2014,178,184.78,177.01,182.84,8565000,182.84,1/31/2014,178.85,186,178.51,181.41,6508800,181.41,2/3/2014,182.89,184.88,175.16,177.11,6764900,177.11,2/4/2014,180.7,181.6,176.2,178.73,4686300,178.73,2/5/2014,178.3,180.59,169.36,174.42,7268000,174.42,2/6/2014,176.3,180.11,176,178.38,5841600,178.38,2/7/2014,181.01,186.63,179.6,186.53,8928500,186.53,2/10/2014,189.34,199.3,189.32,196.56,12970700,196.56,2/11/2014,198.97,202.2,192.7,196.62,10709900,196.62,2/12/2014,195.78,198.27,194.32,195.32,5173700,195.32,2/13/2014,193.34,202.72,193.25,199.63,8029300,199.63,2/14/2014,198.1,201.88,197,198.23,6158000,198.23,2/18/2014,205.24,206,201.36,203.7,9332800,203.7,2/19/2014,203.7,203.7,193.41,193.64,16169000,193.64,2/20/2014,215.01,215.21,206.27,209.97,18002300,209.97,2/21/2014,211.64,213.98,209.19,209.6,7818800,209.6,2/24/2014,208.76,218.36,208.32,217.65,8278400,217.65,2/25/2014,230,259.2,228.45,248,32681700,248,2/26/2014,258.58,265,247.5,253,24604600,253,2/27/2014,261.25,261.9,248.33,252.54,17945800,252.54,2/28/2014,249.65,252.68,242.55,244.81,14589800,244.81,3/3/2014,237.26,251.65,234.99,250.56,13089300,250.56,3/4/2014,258.48,260,252.83,254.84,8745600,254.84,3/5/2014,256.72,256.99,251.8,252.66,5935700,252.66,3/6/2014,254.14,257.5,249.45,252.94,7361100,252.94,3/7/2014,252.94,254.85,244.41,246.21,7812300,246.21";
            
        private List<KanbanDataItem> kanbanDataItems = new List<KanbanDataItem>()
       {
           new KanbanDataItem() {Id = 1161, State = "New", Label = "Combine Orders", Tags = "orders, combine", Hex = "#5dc3f0", ResourceId=3 },
           new KanbanDataItem() {Id = 9213, State = "Work", Label = "Change Billing Address", Tags = "orders, combine", Hex = "#f19b60", ResourceId=1 },
           new KanbanDataItem() {Id = 9213, State = "New", Label = "One item added to the cart", Tags = "orders, combine", Hex = "#5dc3f0", ResourceId=3 },
           new KanbanDataItem() {Id = 6546, State = "Done", Label = "Edit Item Price", Tags = "orders, combine", Hex = "#5dc3f0", ResourceId=4 },
           new KanbanDataItem() {Id = 9034, State = "New", Label = "Login 404 issue", Tags = "orders, combine", Hex = "#6bbd49", ResourceId=3 }
       };
        public List<KanbanDataItem> KanbanDataItems
        {
            get
            {
                return this.kanbanDataItems;
            }
        }
        public List<KanbanResource> KanbanResourceItems
        {
            get
            {
                return this.kanbanResourceItems;
            }
        }

        private List<KanbanResource> kanbanResourceItems = new List<KanbanResource>()
       {
           new KanbanResource() {Id = 0, Name = "No name", Image="/images/common.png", Common=true  },
           new KanbanResource() {Id = 1, Name = "Andrew Fuller", Image="/images/andrew.png", Common=false  },
           new KanbanResource() {Id = 2, Name = "Janet Leverling", Image="/images/janet.png", Common=false  },
           new KanbanResource() {Id = 3, Name = "Steven Buchanan", Image="/images/steven.png", Common=false  },
           new KanbanResource() {Id = 4, Name = "Nancy Davolio", Image="/images/nancy.png", Common=false  },
           new KanbanResource() {Id = 5, Name = "Michael Buchanan", Image="/images/michael.png", Common=false  },
           new KanbanResource() {Id = 6, Name = "Margaret Buchanan", Image="/images/margaret.png", Common=false  },
           new KanbanResource() {Id = 7, Name = "Robert Buchanan", Image="/images/robert.png", Common=false  },
           new KanbanResource() {Id = 8, Name = "Laura Buchanan", Image="/images/laura.png", Common=false  }
       };
        private List<ChartDataItem> dataItems = new List<ChartDataItem>()
       {
           new ChartDataItem() { Day="Monday", Keith = 30, Erica = 15, George=25 },
           new ChartDataItem() { Day="Tuesday", Keith = 25, Erica = 25, George=30 },
           new ChartDataItem() { Day="Wednesday", Keith = 30, Erica = 20, George=25 },
           new ChartDataItem() { Day="Thursday", Keith = 35, Erica = 25, George=45 },
           new ChartDataItem() { Day="Friday", Keith = 20, Erica = 20, George=25 },
           new ChartDataItem() { Day="Saturday", Keith = 30, Erica = 20, George=30 },
           new ChartDataItem() { Day="Sunday", Keith = 60, Erica = 45, George=90 }
       };

        private List<ChartSalesDataItem> dataItems2 = new List<ChartSalesDataItem>()
       {
           new ChartSalesDataItem() { City="New York", SalesQ1 = 330500, SalesQ2 = 210500,YoYGrowth=1.05, YoYGrowthQ1=1.05, YoYGrowthQ2=1.25 },
           new ChartSalesDataItem() { City="London", SalesQ1 = 120000, SalesQ2 = 169000,YoYGrowth=1.15, YoYGrowthQ1=1.15, YoYGrowthQ2=0.95 },
           new ChartSalesDataItem() { City="Paris", SalesQ1 = 205000, SalesQ2 = 275500, YoYGrowth=1.45,YoYGrowthQ1=1.45 , YoYGrowthQ2=1.15},
           new ChartSalesDataItem() { City="Tokyo", SalesQ1 = 187000, SalesQ2 = 130100, YoYGrowth=0.45,YoYGrowthQ1=0.45 , YoYGrowthQ2=0.55},
           new ChartSalesDataItem() { City="Berlin", SalesQ1 = 187000, SalesQ2 = 113000, YoYGrowth=1.65,YoYGrowthQ1=1.65, YoYGrowthQ2=1.05 },
           new ChartSalesDataItem() { City="San Francisco", SalesQ1 = 142000, SalesQ2 = 102000,YoYGrowth=1.25, YoYGrowthQ1=1.25, YoYGrowthQ2=0.15 },
           new ChartSalesDataItem() { City="Chicago", SalesQ1 = 171000, SalesQ2 = 124000, YoYGrowth=0.75,YoYGrowthQ1=0.75, YoYGrowthQ2=0.65 }
        };

       private List<TreeItem> treeData = new List<TreeItem>
       {
           new TreeItem() { Label = "Mail", Icon = "/images/mailIcon.png", Expanded = true, Items = new List<TreeItem>()
           {
               new TreeItem() {Label = "Calendar", Icon = "/images/calendarIcon.png" },
               new TreeItem() {Label = "Contacts", Icon = "/images/contactsIcon.png" }
           }},
           new TreeItem() { Label = "Inbox", Icon = "/images/mailIcon.png", Expanded = true, Items = new List<TreeItem>()
           {
               new TreeItem() {Label = "Inbox", Expanded=true, Icon = "/images/folder.png" },
               new TreeItem() {Label = "Admin", Icon = "/images/folder.png" },
               new TreeItem() {Label = "Corporate", Icon = "/images/folder.png" },
               new TreeItem() {Label = "Finance", Icon = "/images/folder.png" },
               new TreeItem() {Label = "Other", Icon = "/images/folder.png" }
           } },
         new TreeItem() {Label = "Deleted Items", Icon = "/images/recycle.png" },
         new TreeItem() {Label = "Notes", Icon = "/images/notesIcon.png" },
         new TreeItem() {Label = "Settings", Icon = "/images/settings.png" },

         new TreeItem() {Label = "Favorites", Icon = "/images/favorites.png" },
        };
        public List<StockPrice> StockData
        {
            get;
            set;
        }
        public List<ChartDataItem> ChartData
        {
            get;
            set;
        }
        public List<ChartSalesDataItem> ChartSalesData
        {
            get;
            set;
        }

        public List<TreeItem> TreeData
        {
            get
            {
                return this.treeData;
            }
        }

        public List<KeyValuePair<string, bool>> CarFeatures
        {
            get;
            set;
        }
        public Contract ContractDuration
        {
            get;
            set;
        }
        public int ClickCount
        {
            get;
            set;
        }

        public bool IsChecked
        {
            get;
            set;
        }

        public List<BrowserShare> BrowserShares = new List<Models.BrowserShare>()
        {
            new Models.BrowserShare() { Browser="Internet Explorer", Share=33.3 },
            new Models.BrowserShare() { Browser="Firefox", Share=26.5 },
            new Models.BrowserShare() { Browser="Chrome", Share=25.4 },
            new Models.BrowserShare() { Browser="Safari", Share=7.0 },
            new Models.BrowserShare() { Browser="Opera", Share=4.6 },
            new Models.BrowserShare() { Browser="Other", Share=3.2 }
        };

        public jQWidgetsDemosContext()
        {
            if (_created)
                return;
            ClickCount = 0;
            IsChecked = true;
            string[] dataItems = data.Split(',');
            this.StockData = new List<Models.StockPrice>();
            int counter = 0;
            StockPrice currentItem = new Models.StockPrice();

            for (int i = 0; i < 2*this.countries.Count; i++)
            {
                PivotDataRow row = new PivotDataRow();

                row.Country = this.countries[i % countries.Count];
                row.Value = this.dataPoints[(new Random(100).Next() % dataPoints.Count)];

                this.dataRows.Add(row);
            }

            for (int i = 0; i < dataItems.Length; i++)
            {
                switch (counter)
                {
                    case 0:
                        currentItem.Date = DateTime.Parse(dataItems[i]);
                        break;
                    case 1:
                        currentItem.Open = double.Parse(dataItems[i]);
                        break;
                    case 2:
                        currentItem.High = double.Parse(dataItems[i]);
                        break;
                    case 3:
                        currentItem.Low = double.Parse(dataItems[i]);
                        break;
                    case 4:
                        currentItem.Close = double.Parse(dataItems[i]);
                        break;
                    case 5:
                        currentItem.Volume = double.Parse(dataItems[i]);
                        break;
                    case 6:
                        currentItem.AdjClose = double.Parse(dataItems[i]);
                        break;
                }

                counter++;
                if (counter > 6)
                {
                    counter = 0;
                    this.StockData.Add(currentItem);
                    currentItem = new StockPrice();
                }

            }

            List <KeyValuePair<string, bool>> features = new List<KeyValuePair<string, bool>>();
            for (int i = 0; i < carFeatures.Count; i++)
            {
                KeyValuePair<string, bool> pair = new KeyValuePair<string, bool>(carFeatures[i], false);
                features.Add(pair);
            }
            this.ChartData = this.dataItems;
            this.ChartSalesData = this.dataItems2;
            this.CarFeatures = features;
            ContractDuration = Contract.Month;
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 1,
                ManagerID = 2,
                FirstName = "Nancy",
                LastName = "Davolio",
                Title = "Sales Representative",
                Address = "USA Seattle 507 - 20th Ave. E.Apt. 2A",
                City = "Seattle",
                Country = "USA",
                BirthDate = new System.DateTime(1990, 2, 8),
                HireDate = new System.DateTime(2010, 5, 6)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 2,
                ManagerID = null,
                FirstName = "Andrew",
                LastName = "Fuller",
                Title = "Vice President",
                Address = "908 W.Capital Way",
                City = "Kirkland",
                Country = "USA",
                BirthDate = new System.DateTime(1992, 5, 7),
                HireDate = new System.DateTime(2011, 4, 30)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 3,
                ManagerID = 2,
                FirstName = "Janet",
                LastName = "Callahan",
                Title = "Sales Representative",
                Address = "UK London  Coventry House Miner Rd.",
                City = "London",
                Country = "UK",
                BirthDate = new System.DateTime(1991, 2, 22),
                HireDate = new System.DateTime(2012, 5, 25)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 4,
                ManagerID = 2,
                FirstName = "Margaret",
                LastName = "King",
                Title = "Sales Manager",
                Address = "Edgeham Hollow Winchester Way",
                City = "London",
                Country = "UK",
                BirthDate = new System.DateTime(1992, 3, 1),
                HireDate = new System.DateTime(2014, 5, 8)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 5,
                ManagerID = 2,
                FirstName = "Steven",
                LastName = "Buchanan",
                Title = "Sales Representative",
                Address = "7 Houndstooth Rd.	11",
                City = "London",
                Country = "UK",
                BirthDate = new System.DateTime(1993, 2, 3),
                HireDate = new System.DateTime(2015, 3, 6)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 6,
                ManagerID = 5,
                FirstName = "Robert",
                LastName = "King",
                Title = "Sales Representative",
                Address = "USA Seattle 507 - 20th Ave. E.Apt. 2A",
                City = "Seattle",
                Country = "USA",
                BirthDate = new System.DateTime(1991, 9, 18),
                HireDate = new System.DateTime(2012, 8, 2)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 7,
                ManagerID = 5,
                FirstName = "Anne",
                LastName = "Dodsworth",
                Title = "Inside Sales Coordinator",
                Address = "4726 - 11th Ave",
                City = "Seattle",
                Country = "USA",
                BirthDate = new System.DateTime(1980, 8, 8),
                HireDate = new System.DateTime(2010, 1, 3)
            });
            Employee.Add(new Models.Employee()
            {
                EmployeeID = 8,
                ManagerID = 2,
                FirstName = "Michael",
                LastName = "Richards",
                Title = "Sales Representative",
                Address = "6126 - 16th Ave",
                City = "Seattle",
                Country = "USA",
                BirthDate = new System.DateTime(1993, 3, 6),
                HireDate = new System.DateTime(2009, 7, 9)
            });

            var firstNames = new List<string>() { "Andrew", "Nancy", "Shelley", "Regina", "Yoshi", "Antoni", "Mayumi", "Ian", "Peter", "Lars", "Petra", "Martin", "Sven", "Elio", "Beate", "Cheryl", "Michael", "Guylene" };

            var lastNames =

            new List<string>() {
                "Fuller", "Davolio", "Burke", "Murphy", "Nagase", "Saavedra", "Ohno", "Devling", "Wilson", "Peterson", "Winkler", "Bein", "Petersen", "Rossi", "Vileid", "Saylor", "Bjorn", "Nodier"
            };

            var productNames =

            new List<string>() {
                "Black Tea", "Green Tea", "Caffe Espresso", "Doubleshot Espresso", "Caffe Latte", "White Chocolate Mocha", "Caramel Latte", "Caffe Americano", "Cappuccino", "Espresso Truffle", "Espresso con Panna", "Peppermint Mocha Twist"
            };

            var priceValues =

            new List<string>() {
                 "2.25", "1.5", "3.0", "3.3", "4.5", "3.6", "3.8", "2.5", "5.0", "1.75", "3.25", "4.0", "8.0", "6.7", "5.5"
            };

            var streets = new List<string>() {"10th Street","11th Street","12th Street","12th Street East","13th Street","14th Street","1st Avenue","1st Street","2nd Avenue","2nd Street","2nd Street East","2nd Street North","2nd Street West","3rd Avenue","3rd Street","3rd Street East","3rd Street North","3rd Street West","4th Avenue","4th Street","4th Street North","4th Street South","4th Street West","5th Avenue","5th Street","5th Street East","5th Street North","5th Street South","5th Street West","6th Avenue","6th Street","6th Street North","6th Street West","7th Avenue","7th Street","8th Avenue","8th Street","8th Street South","8th Street West","9th Street","9th Street West","Academy Street","Adams Avenue","Adams Street","Amherst Street","Andover Court","Ann Street","Arch Street","Arlington Avenue","Ashley Court","Aspen Court","Aspen Drive","Atlantic Avenue","Augusta Drive","B Street","Bank Street","Bay Street","Bayberry Drive","Beech Street","Beechwood Drive","Belmont Avenue","Berkshire Drive","Brandywine Drive","Briarwood Court","Briarwood Drive","Bridge Street","Bridle Court","Bridle Lane","Broad Street","Broad Street West","Broadway","Brook Lane","Brookside Drive","Brown Street","Buckingham Drive","Buttonwood Drive","Cambridge Court","Cambridge Drive","Cambridge Road","Canal Street","Canterbury Court","Canterbury Drive","Canterbury Road","Cardinal Drive","Carriage Drive","Catherine Street","Cedar Avenue","Cedar Court","Cedar Lane","Cedar Street","Cemetery Road","Center Street","Central Avenue","Chapel Street","Charles Street","Cherry Lane","Cherry Street","Chestnut Avenue","Chestnut Street","Church Road","Church Street","Church Street North","Church Street South","Circle Drive","Clark Street","Clay Street","Cleveland Avenue","Cleveland Street","Clinton Street","Cobblestone Court","College Avenue","College Street","Colonial Avenue","Colonial Drive","Columbia Street","Cooper Street","Cottage Street","Country Club Drive","Country Club Road","Country Lane","Court Street","Creek Road","Creekside Drive","Crescent Street","Cross Street","Cypress Court","Deerfield Drive","Delaware Avenue","Depot Street","Devon Court","Devon Road","Devonshire Drive","Division Street","Dogwood Drive","Dogwood Lane","Durham Court","Durham Road","Eagle Road","Eagle Street","East Avenue","East Street","Edgewood Drive","Edgewood Road","Elizabeth Street","Elm Avenue","Elm Street","Elmwood Avenue","Essex Court","Euclid Avenue","Evergreen Drive","Evergreen Lane","Fairview Avenue","Fairview Road","Fairway Drive","Fawn Court","Fawn Lane","Fieldstone Drive","Forest Avenue","Forest Drive","Forest Street","Franklin Avenue","Franklin Court","Franklin Street","Front Street","Front Street North","Front Street South","Fulton Street","Garden Street","Garfield Avenue","George Street","Glenwood Avenue","Glenwood Drive","Grand Avenue","Grant Avenue","Grant Street","Green Street","Grove Avenue","Grove Street","Hamilton Road","Hamilton Street","Hanover Court","Harrison Avenue","Harrison Street","Hartford Road","Hawthorne Avenue","Hawthorne Lane","Heather Court","Heather Lane","Henry Street","Heritage Drive","Hickory Lane","Hickory Street","High Street","Highland Avenue","Highland Drive","Hill Street","Hillcrest Avenue","Hillcrest Drive","Hillside Avenue","Hillside Drive","Hilltop Road","Holly Court","Holly Drive","Homestead Drive","Howard Street","Hudson Street","Inverness Drive","Ivy Court","Ivy Lane","Jackson Avenue","Jackson Street","James Street","Jefferson Avenue","Jefferson Court","Jefferson Street","John Street","Jones Street","King Street","Lafayette Avenue","Lafayette Street","Lake Avenue","Lake Street","Lakeview Drive","Lantern Lane","Laurel Drive","Laurel Lane","Laurel Street","Lawrence Street","Lexington Court","Lexington Drive","Liberty Street","Lilac Lane","Lincoln Avenue","Lincoln Street","Linda Lane","Linden Avenue","Linden Street","Locust Lane","Locust Street","Madison Avenue","Madison Court","Madison Street","Magnolia Avenue","Magnolia Court","Magnolia Drive","Maiden Lane","Main Street","Main Street East","Main Street North","Main Street South","Main Street West","Manor Drive","Maple Avenue","Maple Lane","Maple Street","Market Street","Marshall Street","Meadow Lane","Meadow Street","Mechanic Street","Mill Road","Mill Street","Monroe Drive","Monroe Street","Morris Street","Mulberry Court","Mulberry Lane","Mulberry Street","Myrtle Avenue","Myrtle Street","New Street","North Avenue","North Street","Oak Avenue","Oak Lane","Oak Street","Old York Road","Olive Street","Orange Street","Orchard Avenue","Orchard Lane","Orchard Street","Overlook Circle","Oxford Court","Oxford Road","Park Avenue","Park Drive","Park Place","Park Street","Parker Street","Pearl Street","Penn Street","Pennsylvania Avenue","Pheasant Run","Pin Oak Drive","Pine Street","Pleasant Street","Poplar Street","Primrose Lane","Prospect Avenue","Prospect Street","Queen Street","Race Street","Railroad Avenue","Railroad Street","Redwood Drive","Ridge Avenue","Ridge Road","Ridge Street","River Road","River Street","Riverside Drive","Roberts Road","Roosevelt Avenue","Rose Street","Rosewood Drive","Route 1","Route 10","Route 100","Route 11","Route 17","Route 2","Route 20","Route 202","Route 27","Route 29","Route 30","Route 32","Route 4","Route 41","Route 44","Route 5","Route 6","Route 64","Route 7","Route 70","Route 9","School Street","Schoolhouse Lane","Shady Lane","Sheffield Drive","Sherman Street","Sherwood Drive","Smith Street","Somerset Drive","South Street","Spring Street","Spruce Avenue","Spruce Street","State Street","State Street East","Strawberry Lane","Street Road","Summer Street","Summit Avenue","Summit Street","Sunset Avenue","Sunset Drive","Surrey Lane","Sycamore Drive","Sycamore Lane","Sycamore Street","Tanglewood Drive","Taylor Street","Union Street","Valley Drive","Valley Road","Valley View Drive","Valley View Road","Victoria Court","Vine Street","Virginia Avenue","Virginia Street","Wall Street","Walnut Avenue","Walnut Street","Warren Avenue","Warren Street","Washington Avenue","Washington Street","Water Street","West Avenue","West Street","Westminster Drive","White Street","William Street","Williams Street","Willow Avenue","Willow Drive","Willow Lane","Willow Street","Winding Way","Windsor Court","Windsor Drive","Wood Street","Woodland Avenue","Woodland Drive","Woodland Road","York Road","York Street"};
            var zipCodes = new List<string>() { "01020 Chicopee, MA", "01040 Holyoke, MA", "01085 Westfield, MA", "01089 West Springfield, MA", "01201 Pittsfield, MA", "01420 Fitchburg, MA", "01453 Leominster, MA", "01545 Shrewsbury, MA", "01604 Worcester, MA", "01701 Framingham, MA", "01752 Marlborough, MA", "01757 Milford, MA", "01760 Natick, MA", "01801 Woburn, MA", "01803 Burlington, MA", "01810 Andover, MA", "01821 Billerica, MA", "01824 Chelmsford, MA", "01826 Dracut, MA", "01841 Lawrence, MA", "01844 Methuen, MA", "01845 North Andover, MA", "01851 Lowell, MA", "01867 Reading, MA", "01876 Tewksbury, MA", "01880 Wakefield, MA", "01886 Westford, MA", "01887 Wilmington, MA", "01902 Lynn, MA", "01906 Saugus, MA", "01915 Beverly, MA", "01923 Danvers, MA", "01930 Gloucester, MA", "01960 Peabody, MA", "01970 Salem, MA", "02026 Dedham, MA", "02038 Franklin, MA", "02048 Mansfield, MA", "02062 Norwood, MA", "02072 Stoughton, MA", "02124 Dorchester Center, MA", "02125 Dorchester, MA", "02127 Boston, MA", "02130 Jamaica Plain, MA", "02131 Roslindale, MA", "02132 West Roxbury, MA", "02135 Brighton, MA", "02136 Hyde Park, MA", "02138 Cambridge, MA", "02148 Malden, MA", "02149 Everett, MA", "02150 Chelsea, MA", "02151 Revere, MA", "02155 Medford, MA", "02169 Quincy, MA", "02176 Melrose, MA", "02184 Braintree, MA", "02186 Milton, MA", "02301 Brockton, MA", "02360 Plymouth, MA", "02368 Randolph, MA", "02446 Brookline, MA", "02453 Waltham, MA", "02472 Watertown, MA", "02474 Arlington, MA", "02478 Belmont, MA", "02703 Attleboro, MA", "02720 Fall River, MA", "02740 New Bedford, MA", "02760 North Attleboro, MA", "02780 Taunton, MA", "02816 Coventry, RI", "02852 North Kingstown, RI", "02860 Pawtucket, RI", "02864 Cumberland, RI", "02886 Warwick, RI", "02893 West Warwick, RI", "02895 Woonsocket, RI", "02904 Providence, RI", "02919 Johnston, RI", "02920 Cranston, RI", "03038 Derry, NH", "03051 Hudson, NH", "03053 Londonderry, NH", "03054 Merrimack, NH", "03060 Nashua, NH", "03102 Manchester, NH", "03301 Concord, NH", "03820 Dover, NH", "04103 Portland, ME", "04106 South Portland, ME", "04240 Lewiston, ME", "04401 Bangor, ME", "06010 Bristol, CT", "06033 Glastonbury, CT", "06051 New Britain, CT", "06066 Vernon Rockville, CT", "06074 South Windsor, CT", "06082 Enfield, CT", "06095 Windsor, CT", "06106 Hartford, CT", "06109 Wethersfield, CT", "06111 Newington, CT", "06118 East Hartford, CT", "06340 Groton, CT", "06360 Norwich, CT", "06405 Branford, CT", "06410 Cheshire, CT", "06450 Meriden, CT", "06457 Middletown, CT", "06473 North Haven, CT", "06484 Shelton, CT", "06489 Southington, CT", "06492 Wallingford, CT", "06511 New Haven, CT", "06512 East Haven, CT", "06514 Hamden, CT", "06516 West Haven, CT", "06606 Bridgeport, CT", "06611 Trumbull, CT", "06614 Stratford, CT", "06705 Waterbury, CT", "06770 Naugatuck, CT", "06776 New Milford, CT", "06790 Torrington, CT", "06810 Danbury, CT", "06824 Fairfield, CT", "06851 Norwalk, CT", "06877 Ridgefield, CT", "06880 Westport, CT", "06902 Stamford, CT", "07002 Bayonne, NJ", "07003 Bloomfield, NJ", "07006 Caldwell, NJ", "07011 Clifton, NJ", "07016 Cranford, NJ", "07017 East Orange, NJ", "07024 Fort Lee, NJ", "07026 Garfield, NJ", "07030 Hoboken, NJ", "07032 Kearny, NJ", "07036 Linden, NJ", "07039 Livingston, NJ", "07040 Maplewood, NJ", "07042 Montclair, NJ", "07047 North Bergen, NJ", "07050 Orange, NJ", "07052 West Orange, NJ", "07054 Parsippany, NJ", "07055 Passaic, NJ", "07060 Plainfield, NJ", "07065 Rahway, NJ", "07076 Scotch Plains, NJ", "07080 South Plainfield, NJ", "07083 Union, NJ", "07087 Union City, NJ", "07093 West New York, NJ", "07103 Newark, NJ", "07109 Belleville, NJ", "07110 Nutley, NJ", "07111 Irvington, NJ", "07202 Elizabeth, NJ", "07302 Jersey City, NJ", "07410 Fair Lawn, NJ", "07424 Little Falls, NJ", "07430 Mahwah, NJ", "07450 Ridgewood, NJ", "07470 Wayne, NJ", "07501 Paterson, NJ", "07601 Hackensack, NJ", "07621 Bergenfield, NJ", "07631 Englewood, NJ", "07652 Paramus, NJ", "07666 Teaneck, NJ", "07675 Westwood, NJ", "07712 Asbury Park, NJ", "07726 Englishtown, NJ", "07728 Freehold, NJ", "07731 Howell, NJ", "07740 Long Branch, NJ", "07747 Matawan, NJ", "07753 Neptune, NJ", "07840 Hackettstown, NJ", "07860 Newton, NJ", "07866 Rockaway, NJ", "07920 Basking Ridge, NJ", "07960 Morristown, NJ", "08003 Cherry Hill, NJ", "08012 Blackwood, NJ", "08021 Clementon, NJ", "08037 Hammonton, NJ", "08043 Voorhees, NJ", "08046 Willingboro, NJ", "08050 Manahawkin, NJ", "08053 Marlton, NJ", "08054 Mount Laurel, NJ", "08060 Mount Holly, NJ", "08075 Riverside, NJ", "08080 Sewell, NJ", "08081 Sicklerville, NJ", "08087 Tuckerton, NJ", "08088 Vincentown, NJ", "08094 Williamstown, NJ", "08096 West Deptford, NJ", "08105 Camden, NJ", "08205 Absecon, NJ", "08234 Egg Harbor Township, NJ", "08302 Bridgeton, NJ", "08330 Mays Landing, NJ", "08332 Millville, NJ", "08360 Vineland, NJ", "08401 Atlantic City, NJ", "08520 Hightstown, NJ", "08527 Jackson, NJ", "08540 Princeton, NJ", "08610 Trenton, NJ", "08648 Lawrence Township, NJ", "08701 Lakewood, NJ", "08723 Brick, NJ", "08742 Point Pleasant Beach, NJ", "08753 Toms River, NJ", "08759 Manchester Township, NJ", "08807 Bridgewater, NJ", "08816 East Brunswick, NJ", "08817 Edison, NJ", "08822 Flemington, NJ", "08831 Monroe Township, NJ", "08844 Hillsborough, NJ", "08854 Piscataway, NJ", "08857 Old Bridge, NJ", "08859 Parlin, NJ", "08861 Perth Amboy, NJ", "08865 Phillipsburg, NJ", "08873 Somerset, NJ", "08901 New Brunswick, NJ", "08902 North Brunswick, NJ", "10002 New York, NY", "10301 Staten Island, NY", "10451 Bronx, NY", "10512 Carmel, NY", "10541 Mahopac, NY", "10550 Mount Vernon, NY", "10562 Ossining, NY", "10573 Port Chester, NY", "10583 Scarsdale, NY", "10598 Yorktown Heights, NY", "10701 Yonkers, NY", "10801 New Rochelle, NY", "10950 Monroe, NY", "10952 Monsey, NY", "10954 Nanuet, NY", "10956 New City, NY", "10977 Spring Valley, NY", "11001 Floral Park, NY", "11003 Elmont, NY", "11010 Franklin Square, NY", "11040 New Hyde Park, NY", "11050 Port Washington, NY", "11102 Astoria, NY", "11104 Sunnyside, NY", "11201 Brooklyn, NY", "11354 Flushing, NY", "11357 Whitestone, NY", "11361 Bayside, NY", "11364 Oakland Gardens, NY", "11365 Fresh Meadows, NY", "11368 Corona, NY", "11369 East Elmhurst, NY", "11372 Jackson Heights, NY", "11373 Elmhurst, NY", "11374 Rego Park, NY", "11375 Forest Hills, NY", "11377 Woodside, NY", "11378 Maspeth, NY", "11379 Middle Village, NY", "11412 Saint Albans, NY", "11413 Springfield Gardens, NY", "11414 Howard Beach, NY", "11417 Ozone Park, NY", "11418 Richmond Hill, NY", "11419 South Richmond Hill, NY", "11420 South Ozone Park, NY", "11421 Woodhaven, NY", "11422 Rosedale, NY", "11423 Hollis, NY", "11432 Jamaica, NY", "11510 Baldwin, NY", "11520 Freeport, NY", "11530 Garden City, NY", "11542 Glen Cove, NY", "11550 Hempstead, NY", "11552 West Hempstead, NY", "11553 Uniondale, NY", "11554 East Meadow, NY", "11561 Long Beach, NY", "11566 Merrick, NY", "11570 Rockville Centre, NY", "11572 Oceanside, NY", "11580 Valley Stream, NY", "11590 Westbury, NY", "11691 Far Rockaway, NY", "11701 Amityville, NY", "11704 West Babylon, NY", "11706 Bay Shore, NY", "11710 Bellmore, NY", "11714 Bethpage, NY", "11717 Brentwood, NY", "11720 Centereach, NY", "11722 Central Islip, NY", "11725 Commack, NY", "11727 Coram, NY", "11729 Deer Park, NY", "11731 East Northport, NY", "11735 Farmingdale, NY", "11741 Holbrook, NY", "11743 Huntington, NY", "11746 Huntington Station, NY", "11756 Levittown, NY", "11757 Lindenhurst, NY", "11758 Massapequa, NY", "11762 Massapequa Park, NY", "11772 Patchogue, NY", "11776 Port Jefferson Station, NY", "11779 Ronkonkoma, NY", "11784 Selden, NY", "11787 Smithtown, NY", "11791 Syosset, NY", "11793 Wantagh, NY", "11795 West Islip, NY", "11801 Hicksville, NY", "11803 Plainview, NY", "11967 Shirley, NY", "12010 Amsterdam, NY", "12020 Ballston Spa, NY", "12065 Clifton Park, NY", "12180 Troy, NY", "12203 Albany, NY", "12302 Schenectady, NY", "12401 Kingston, NY", "12533 Hopewell Junction, NY", "12550 Newburgh, NY", "12553 New Windsor, NY", "12590 Wappingers Falls, NY", "12601 Poughkeepsie, NY", "12804 Queensbury, NY", "12866 Saratoga Springs, NY", "12901 Plattsburgh, NY", "13021 Auburn, NY", "13027 Baldwinsville, NY", "13090 Liverpool, NY", "13126 Oswego, NY", "13440 Rome, NY", "13501 Utica, NY", "13760 Endicott, NY", "14043 Depew, NY", "14075 Hamburg, NY", "14086 Lancaster, NY", "14094 Lockport, NY", "14120 North Tonawanda, NY", "14127 Orchard Park, NY", "14150 Tonawanda, NY", "14215 Buffalo, NY", "14304 Niagara Falls, NY", "14424 Canandaigua, NY", "14450 Fairport, NY", "14534 Pittsford, NY", "14580 Webster, NY", "14606 Rochester, NY", "14701 Jamestown, NY", "14850 Ithaca, NY", "15001 Aliquippa, PA", "15010 Beaver Falls, PA", "15044 Gibsonia, PA", "15068 New Kensington, PA", "15101 Allison Park, PA", "15102 Bethel Park, PA", "15108 Coraopolis, PA", "15146 Monroeville, PA", "15206 Pittsburgh, PA", "15301 Washington, PA", "15317 Canonsburg, PA", "15401 Uniontown, PA", "15601 Greensburg, PA", "15642 Irwin, PA", "15650 Latrobe, PA", "15701 Indiana, PA", "16001 Butler, PA", "16066 Cranberry Twp, PA", "16101 New Castle, PA", "16335 Meadville, PA", "16506 Erie, PA", "16601 Altoona, PA", "16801 State College, PA", "17011 Camp Hill, PA", "17013 Carlisle, PA", "17022 Elizabethtown, PA", "17036 Hummelstown, PA", "17042 Lebanon, PA", "17050 Mechanicsburg, PA", "17109 Harrisburg, PA", "17201 Chambersburg, PA", "17268 Waynesboro, PA", "17325 Gettysburg, PA", "17331 Hanover, PA", "17402 York, PA", "17522 Ephrata, PA", "17543 Lititz, PA", "17701 Williamsport, PA", "18015 Bethlehem, PA", "18042 Easton, PA", "18052 Whitehall, PA", "18062 Macungie, PA", "18064 Nazareth, PA", "18102 Allentown, PA", "18201 Hazleton, PA", "18301 East Stroudsburg, PA", "18360 Stroudsburg, PA", "18702 Wilkes Barre, PA", "18901 Doylestown, PA", "18940 Newtown, PA", "18944 Perkasie, PA", "18951 Quakertown, PA", "18966 Southampton, PA", "18974 Warminster, PA", "19002 Ambler, PA", "19013 Chester, PA", "19020 Bensalem, PA", "19026 Drexel Hill, PA", "19038 Glenside, PA", "19047 Langhorne, PA", "19050 Lansdowne, PA", "19053 Feasterville Trevose, PA", "19061 Marcus Hook, PA", "19063 Media, PA", "19064 Springfield, PA", "19067 Morrisville, PA", "19082 Upper Darby, PA", "19083 Havertown, PA", "19111 Philadelphia, PA", "19320 Coatesville, PA", "19335 Downingtown, PA", "19355 Malvern, PA", "19380 West Chester, PA", "19401 Norristown, PA", "19406 King Of Prussia, PA", "19426 Collegeville, PA", "19438 Harleysville, PA", "19446 Lansdale, PA", "19454 North Wales, PA", "19460 Phoenixville, PA", "19464 Pottstown, PA", "19468 Royersford, PA", "19701 Bear, DE", "20109 Manassas, VA", "20120 Centreville, VA", "20136 Bristow, VA", "20147 Ashburn, VA", "20155 Gainesville, VA", "20164 Sterling, VA", "20170 Herndon, VA", "20175 Leesburg, VA", "20191 Reston, VA", "20601 Waldorf, MD", "20705 Beltsville, MD", "20706 Lanham, MD", "20707 Laurel, MD", "20715 Bowie, MD", "20735 Clinton, MD", "20743 Capitol Heights, MD", "20744 Fort Washington, MD", "20745 Oxon Hill, MD", "20746 Suitland, MD", "20747 District Heights, MD", "20748 Temple Hills, MD", "20772 Upper Marlboro, MD", "20782 Hyattsville, MD", "20814 Bethesda, MD", "20815 Chevy Chase, MD", "20832 Olney, MD", "20850 Rockville, MD", "20854 Potomac, MD", "20874 Germantown, MD", "20877 Gaithersburg, MD", "20886 Montgomery Village, MD", "20901 Silver Spring, MD", "21009 Abingdon, MD", "21014 Bel Air, MD", "21030 Cockeysville, MD", "21042 Ellicott City, MD", "21044 Columbia, MD", "21060 Glen Burnie, MD", "21075 Elkridge, MD", "21093 Lutherville Timonium, MD", "21113 Odenton, MD", "21114 Crofton, MD", "21117 Owings Mills, MD", "21122 Pasadena, MD", "21133 Randallstown, MD", "21136 Reisterstown, MD", "21144 Severn, MD", "21146 Severna Park, MD", "21157 Westminster, MD", "21206 Baltimore, MD", "21207 Gwynn Oak, MD", "21208 Pikesville, MD", "21220 Middle River, MD", "21221 Essex, MD", "21222 Dundalk, MD", "21227 Halethorpe, MD", "21228 Catonsville, MD", "21234 Parkville, MD", "21236 Nottingham, MD", "21244 Windsor Mill, MD", "21401 Annapolis, MD", "21701 Frederick, MD", "21740 Hagerstown, MD", "21771 Mount Airy, MD", "21784 Sykesville, MD", "21801 Salisbury, MD", "21921 Elkton, MD", "22003 Annandale, VA", "22015 Burke, VA", "22030 Fairfax, VA", "22041 Falls Church, VA", "22079 Lorton, VA", "22101 Mc Lean, VA", "22180 Vienna, VA", "22191 Woodbridge, VA", "22304 Alexandria, VA", "22405 Fredericksburg, VA", "22554 Stafford, VA", "22601 Winchester, VA", "22630 Front Royal, VA", "22701 Culpeper, VA", "22801 Harrisonburg, VA", "22901 Charlottesville, VA", "23059 Glen Allen, VA", "23111 Mechanicsville, VA", "23112 Midlothian, VA", "23139 Powhatan, VA", "23185 Williamsburg, VA", "23223 Richmond, VA", "23228 Henrico, VA", "23320 Chesapeake, VA", "23434 Suffolk, VA", "23451 Virginia Beach, VA", "23503 Norfolk, VA", "23601 Newport News, VA", "23666 Hampton, VA", "23693 Yorktown, VA", "23703 Portsmouth, VA", "23803 Petersburg, VA", "23832 Chesterfield, VA", "23834 Colonial Heights, VA", "23860 Hopewell, VA", "24012 Roanoke, VA", "24060 Blacksburg, VA", "24073 Christiansburg, VA", "24112 Martinsville, VA", "24401 Staunton, VA", "24502 Lynchburg, VA", "24540 Danville, VA", "25801 Beckley, WV", "26003 Wheeling, WV", "26101 Parkersburg, WV", "26301 Clarksburg, WV", "26508 Morgantown, WV", "26554 Fairmont, WV", "27012 Clemmons, NC", "27028 Mocksville, NC", "27103 Winston Salem, NC", "27205 Asheboro, NC", "27253 Graham, NC", "27265 High Point, NC", "27284 Kernersville, NC", "27292 Lexington, NC", "27302 Mebane, NC", "27320 Reidsville, NC", "27330 Sanford, NC", "27360 Thomasville, NC", "27405 Greensboro, NC", "27502 Apex, NC", "27511 Cary, NC", "27516 Chapel Hill, NC", "27520 Clayton, NC", "27526 Fuquay Varina, NC", "27529 Garner, NC", "27530 Goldsboro, NC", "27540 Holly Springs, NC", "27587 Wake Forest, NC", "27603 Raleigh, NC", "27703 Durham, NC", "27804 Rocky Mount, NC", "27834 Greenville, NC", "27870 Roanoke Rapids, NC", "27893 Wilson, NC", "27909 Elizabeth City, NC", "28031 Cornelius, NC", "28052 Gastonia, NC", "28078 Huntersville, NC", "28079 Indian Trail, NC", "28086 Kings Mountain, NC", "28092 Lincolnton, NC", "28104 Matthews, NC", "28115 Mooresville, NC", "28173 Waxhaw, NC", "28205 Charlotte, NC", "28303 Fayetteville, NC", "28348 Hope Mills, NC", "28358 Lumberton, NC", "28376 Raeford, NC", "28451 Leland, NC", "28540 Jacksonville, NC", "28560 New Bern, NC", "28601 Hickory, NC", "28625 Statesville, NC", "28645 Lenoir, NC", "28655 Morganton, NC", "28752 Marion, NC", "28792 Hendersonville, NC", "28803 Asheville, NC", "29063 Irmo, SC", "29150 Sumter, SC", "29301 Spartanburg, SC", "29349 Inman, SC", "29406 Charleston, SC", "29440 Georgetown, SC", "29445 Goose Creek, SC", "29456 Ladson, SC", "29461 Moncks Corner, SC", "29464 Mount Pleasant, SC", "29483 Summerville, SC", "29501 Florence, SC", "29526 Conway, SC", "29550 Hartsville, SC", "29576 Murrells Inlet, SC", "29577 Myrtle Beach, SC", "29621 Anderson, SC", "29640 Easley, SC", "29646 Greenwood, SC", "29650 Greer, SC", "29673 Piedmont, SC", "29680 Simpsonville, SC", "29687 Taylors, SC", "29708 Fort Mill, SC", "29710 Clover, SC", "29730 Rock Hill, SC", "29803 Aiken, SC", "29841 North Augusta, SC", "29910 Bluffton, SC", "30004 Alpharetta, GA", "30008 Marietta, GA", "30012 Conyers, GA", "30014 Covington, GA", "30019 Dacula, GA", "30024 Suwanee, GA", "30030 Decatur, GA", "30038 Lithonia, GA", "30039 Snellville, GA", "30040 Cumming, GA", "30043 Lawrenceville, GA", "30047 Lilburn, GA", "30052 Loganville, GA", "30075 Roswell, GA", "30080 Smyrna, GA", "30083 Stone Mountain, GA", "30084 Tucker, GA", "30092 Norcross, GA", "30096 Duluth, GA", "30101 Acworth, GA", "30114 Canton, GA", "30117 Carrollton, GA", "30120 Cartersville, GA", "30126 Mableton, GA", "30127 Powder Springs, GA", "30132 Dallas, GA", "30134 Douglasville, GA", "30144 Kennesaw, GA", "30180 Villa Rica, GA", "30188 Woodstock, GA", "30213 Fairburn, GA", "30223 Griffin, GA", "30236 Jonesboro, GA", "30240 Lagrange, GA", "30252 Mcdonough, GA", "30263 Newnan, GA", "30269 Peachtree City, GA", "30274 Riverdale, GA", "30281 Stockbridge, GA", "30294 Ellenwood, GA", "30303 Atlanta, GA", "30518 Buford, GA", "30534 Dawsonville, GA", "30542 Flowery Branch, GA", "30605 Athens, GA", "30680 Winder, GA", "30701 Calhoun, GA", "30705 Chatsworth, GA", "30721 Dalton, GA", "30736 Ringgold, GA", "30741 Rossville, GA", "30809 Evans, GA", "30813 Grovetown, GA", "30815 Hephzibah, GA", "30906 Augusta, GA", "31021 Dublin, GA", "31061 Milledgeville, GA", "31088 Warner Robins, GA", "31204 Macon, GA", "31313 Hinesville, GA", "31404 Savannah, GA", "31525 Brunswick, GA", "31601 Valdosta, GA", "31904 Columbus, GA", "32003 Fleming Island, FL", "32034 Fernandina Beach, FL", "32043 Green Cove Springs, FL", "32065 Orange Park, FL", "32068 Middleburg, FL", "32082 Ponte Vedra Beach, FL", "32084 Saint Augustine, FL", "32127 Port Orange, FL", "32137 Palm Coast, FL", "32159 Lady Lake, FL", "32162 The Villages, FL", "32174 Ormond Beach, FL", "32250 Jacksonville Beach, FL", "32259 Saint Johns, FL", "32303 Tallahassee, FL", "32404 Panama City, FL", "32503 Pensacola, FL", "32533 Cantonment, FL", "32547 Fort Walton Beach, FL", "32566 Navarre, FL", "32578 Niceville, FL", "32703 Apopka, FL", "32707 Casselberry, FL", "32708 Winter Springs, FL", "32714 Altamonte Springs, FL", "32720 Deland, FL", "32725 Deltona, FL", "32746 Lake Mary, FL", "32765 Oviedo, FL", "32779 Longwood, FL", "32780 Titusville, FL", "32792 Winter Park, FL", "32806 Orlando, FL", "32904 Melbourne, FL", "32907 Palm Bay, FL", "32927 Cocoa, FL", "32937 Satellite Beach, FL", "32955 Rockledge, FL", "32958 Sebastian, FL", "33009 Hallandale, FL", "33010 Hialeah, FL", "33020 Hollywood, FL", "33028 Pembroke Pines, FL", "33030 Homestead, FL", "33040 Key West, FL", "33054 Opa Locka, FL", "33056 Miami Gardens, FL", "33060 Pompano Beach, FL", "33125 Miami, FL", "33139 Miami Beach, FL", "33160 North Miami Beach, FL", "33308 Fort Lauderdale, FL", "33404 West Palm Beach, FL", "33410 Palm Beach Gardens, FL", "33414 Wellington, FL", "33428 Boca Raton, FL", "33435 Boynton Beach, FL", "33442 Deerfield Beach, FL", "33445 Delray Beach, FL", "33458 Jupiter, FL", "33460 Lake Worth, FL", "33470 Loxahatchee, FL", "33510 Brandon, FL", "33569 Riverview, FL", "33594 Valrico, FL", "33604 Tampa, FL", "33702 Saint Petersburg, FL", "33756 Clearwater, FL", "33771 Largo, FL", "33801 Lakeland, FL", "33823 Auburndale, FL", "33844 Haines City, FL", "33880 Winter Haven, FL", "33904 Cape Coral, FL", "33905 Fort Myers, FL", "33917 North Fort Myers, FL", "33952 Port Charlotte, FL", "34116 Naples, FL", "34135 Bonita Springs, FL", "34203 Bradenton, FL", "34221 Palmetto, FL", "34231 Sarasota, FL", "34293 Venice, FL", "34491 Summerfield, FL", "34608 Spring Hill, FL", "34639 Land O Lakes, FL", "34653 New Port Richey, FL", "34668 Port Richey, FL", "34683 Palm Harbor, FL", "34698 Dunedin, FL", "34711 Clermont, FL", "34741 Kissimmee, FL", "34761 Ocoee, FL", "34786 Windermere, FL", "34787 Winter Garden, FL", "34952 Port Saint Lucie, FL", "34990 Palm City, FL", "34997 Stuart, FL", "35007 Alabaster, AL", "35124 Pelham, AL", "35173 Trussville, AL", "35209 Birmingham, AL", "35405 Tuscaloosa, AL", "35640 Hartselle, AL", "35758 Madison, AL", "35803 Huntsville, AL", "36067 Prattville, AL", "36109 Montgomery, AL", "36301 Dothan, AL", "36330 Enterprise, AL", "36526 Daphne, AL", "36532 Fairhope, AL", "36605 Mobile, AL", "37013 Antioch, TN", "37040 Clarksville, TN", "37055 Dickson, TN", "37066 Gallatin, TN", "37072 Goodlettsville, TN", "37076 Hermitage, TN", "37086 La Vergne, TN", "37110 Mcminnville, TN", "37122 Mount Juliet, TN", "37128 Murfreesboro, TN", "37160 Shelbyville, TN", "37205 Nashville, TN", "37312 Cleveland, TN", "37343 Hixson, TN", "37363 Ooltewah, TN", "37379 Soddy Daisy, TN", "37388 Tullahoma, TN", "37421 Chattanooga, TN", "37601 Johnson City, TN", "37643 Elizabethton, TN", "37659 Jonesborough, TN", "37660 Kingsport, TN", "37803 Maryville, TN", "37830 Oak Ridge, TN", "37849 Powell, TN", "37876 Sevierville, TN", "37918 Knoxville, TN", "38016 Cordova, TN", "38017 Collierville, TN", "38024 Dyersburg, TN", "38053 Millington, TN", "38106 Memphis, TN", "38501 Cookeville, TN", "38632 Hernando, MS", "38637 Horn Lake, MS", "38654 Olive Branch, MS", "38655 Oxford, MS", "38671 Southaven, MS", "38801 Tupelo, MS", "39120 Natchez, MS", "39180 Vicksburg, MS", "39208 Pearl, MS", "39401 Hattiesburg, MS", "39503 Gulfport, MS", "39532 Biloxi, MS", "39564 Ocean Springs, MS", "39759 Starkville, MS", "40004 Bardstown, KY", "40165 Shepherdsville, KY", "40207 Louisville, KY", "40356 Nicholasville, KY", "40601 Frankfort, KY", "41017 Ft Mitchell, KY", "41018 Erlanger, KY", "41051 Independence, KY", "42001 Paducah, KY", "42101 Bowling Green, KY", "42141 Glasgow, KY", "42240 Hopkinsville, KY", "42301 Owensboro, KY", "42420 Henderson, KY", "42431 Madisonville, KY", "43015 Delaware, OH", "43026 Hilliard, OH", "43035 Lewis Center, OH", "43040 Marysville, OH", "43062 Pataskala, OH", "43068 Reynoldsburg, OH", "43081 Westerville, OH", "43110 Canal Winchester, OH", "43119 Galloway, OH", "43123 Grove City, OH", "43147 Pickerington, OH", "43420 Fremont, OH", "43512 Defiance, OH", "43537 Maumee, OH", "43551 Perrysburg, OH", "43560 Sylvania, OH", "43612 Toledo, OH", "43701 Zanesville, OH", "44004 Ashtabula, OH", "44012 Avon Lake, OH", "44024 Chardon, OH", "44035 Elyria, OH", "44039 North Ridgeville, OH", "44052 Lorain, OH", "44060 Mentor, OH", "44070 North Olmsted, OH", "44077 Painesville, OH", "44094 Willoughby, OH", "44095 Eastlake, OH", "44122 Beachwood, OH", "44133 North Royalton, OH", "44136 Strongsville, OH", "44139 Solon, OH", "44145 Westlake, OH", "44146 Bedford, OH", "44203 Barberton, OH", "44221 Cuyahoga Falls, OH", "44224 Stow, OH", "44240 Kent, OH", "44256 Medina, OH", "44266 Ravenna, OH", "44281 Wadsworth, OH", "44312 Akron, OH", "44406 Canfield, OH", "44512 Youngstown, OH", "44601 Alliance, OH", "44646 Massillon, OH", "44663 New Philadelphia, OH", "44691 Wooster, OH", "44720 North Canton, OH", "44805 Ashland, OH", "44870 Sandusky, OH", "44883 Tiffin, OH", "45011 Hamilton, OH", "45039 Maineville, OH", "45040 Mason, OH", "45066 Springboro, OH", "45103 Batavia, OH", "45140 Loveland, OH", "45211 Cincinnati, OH", "45324 Fairborn, OH", "45342 Miamisburg, OH", "45356 Piqua, OH", "45365 Sidney, OH", "45385 Xenia, OH", "45420 Dayton, OH", "45601 Chillicothe, OH", "45840 Findlay, OH", "46037 Fishers, IN", "46060 Noblesville, IN", "46077 Zionsville, IN", "46112 Brownsburg, IN", "46123 Avon, IN", "46140 Greenfield, IN", "46201 Indianapolis, IN", "46304 Chesterton, IN", "46307 Crown Point, IN", "46321 Munster, IN", "46322 Highland, IN", "46342 Hobart, IN", "46350 La Porte, IN", "46360 Michigan City, IN", "46368 Portage, IN", "46375 Schererville, IN", "46383 Valparaiso, IN", "46410 Merrillville, IN", "46514 Elkhart, IN", "46526 Goshen, IN", "46530 Granger, IN", "46544 Mishawaka, IN", "46614 South Bend, IN", "46804 Fort Wayne, IN", "46901 Kokomo, IN", "46947 Logansport, IN", "47130 Jeffersonville, IN", "47150 New Albany, IN", "47274 Seymour, IN", "47302 Muncie, IN", "47401 Bloomington, IN", "47711 Evansville, IN", "47802 Terre Haute, IN", "47905 Lafayette, IN", "47906 West Lafayette, IN", "47933 Crawfordsville, IN", "48021 Eastpointe, MI", "48035 Clinton Township, MI", "48042 Macomb, MI", "48045 Harrison Township, MI", "48047 New Baltimore, MI", "48060 Port Huron, MI", "48066 Roseville, MI", "48067 Royal Oak, MI", "48071 Madison Heights, MI", "48076 Southfield, MI", "48089 Warren, MI", "48101 Allen Park, MI", "48103 Ann Arbor, MI", "48124 Dearborn, MI", "48127 Dearborn Heights, MI", "48146 Lincoln Park, MI", "48150 Livonia, MI", "48167 Northville, MI", "48174 Romulus, MI", "48178 South Lyon, MI", "48180 Taylor, MI", "48185 Westland, MI", "48192 Wyandotte, MI", "48195 Southgate, MI", "48197 Ypsilanti, MI", "48205 Detroit, MI", "48212 Hamtramck, MI", "48236 Grosse Pointe, MI", "48237 Oak Park, MI", "48239 Redford, MI", "48310 Sterling Heights, MI", "48322 West Bloomfield, MI", "48329 Waterford, MI", "48331 Farmington, MI", "48348 Clarkston, MI", "48423 Davison, MI", "48430 Fenton, MI", "48439 Grand Blanc, MI", "48446 Lapeer, MI", "48504 Flint, MI", "48601 Saginaw, MI", "48640 Midland, MI", "48706 Bay City, MI", "48823 East Lansing, MI", "48867 Owosso, MI", "48910 Lansing, MI", "49009 Kalamazoo, MI", "49015 Battle Creek, MI", "49022 Benton Harbor, MI", "49085 Saint Joseph, MI", "49120 Niles, MI", "49221 Adrian, MI", "49341 Rockford, MI", "49417 Grand Haven, MI", "49418 Grandville, MI", "49423 Holland, MI", "49426 Hudsonville, MI", "49428 Jenison, MI", "49441 Muskegon, MI", "49464 Zeeland, MI", "49503 Grand Rapids, MI", "49509 Wyoming, MI", "49684 Traverse City, MI", "49855 Marquette, MI", "50010 Ames, IA", "50023 Ankeny, IA", "50158 Marshalltown, IA", "50265 West Des Moines, IA", "50310 Des Moines, IA", "50322 Urbandale, IA", "50401 Mason City, IA", "50501 Fort Dodge, IA", "50613 Cedar Falls, IA", "50701 Waterloo, IA", "51106 Sioux City, IA", "51501 Council Bluffs, IA", "52001 Dubuque, IA", "52240 Iowa City, IA", "52402 Cedar Rapids, IA", "52501 Ottumwa, IA", "52722 Bettendorf, IA", "52761 Muscatine, IA", "52804 Davenport, IA", "53045 Brookfield, WI", "53051 Menomonee Falls, WI", "53066 Oconomowoc, WI", "53072 Pewaukee, WI", "53081 Sheboygan, WI", "53095 West Bend, WI", "53140 Kenosha, WI", "53150 Muskego, WI", "53151 New Berlin, WI", "53154 Oak Creek, WI", "53186 Waukesha, WI", "53204 Milwaukee, WI", "53402 Racine, WI", "53511 Beloit, WI", "53546 Janesville, WI", "53562 Middleton, WI", "53590 Sun Prairie, WI", "54115 De Pere, WI", "54130 Kaukauna, WI", "54220 Manitowoc, WI", "54302 Green Bay, WI", "54401 Wausau, WI", "54449 Marshfield, WI", "54481 Stevens Point, WI", "54494 Wisconsin Rapids, WI", "54601 La Crosse, WI", "54650 Onalaska, WI", "54701 Eau Claire, WI", "54729 Chippewa Falls, WI", "54880 Superior, WI", "54901 Oshkosh, WI", "54911 Appleton, WI", "54935 Fond Du Lac, WI", "54952 Menasha, WI", "54956 Neenah, WI", "55014 Circle Pines, MN", "55016 Cottage Grove, MN", "55021 Faribault, MN", "55033 Hastings, MN", "55044 Lakeville, MN", "55060 Owatonna, MN", "55068 Rosemount, MN", "55082 Stillwater, MN", "55104 Saint Paul, MN", "55303 Anoka, MN", "55311 Osseo, MN", "55316 Champlin, MN", "55318 Chaska, MN", "55330 Elk River, MN", "55337 Burnsville, MN", "55343 Hopkins, MN", "55347 Eden Prairie, MN", "55372 Prior Lake, MN", "55378 Savage, MN", "55379 Shakopee, MN", "55406 Minneapolis, MN", "55912 Austin, MN", "55987 Winona, MN", "56001 Mankato, MN", "56301 Saint Cloud, MN", "56401 Brainerd, MN", "56560 Moorhead, MN", "56601 Bemidji, MN", "57103 Sioux Falls, SD", "57401 Aberdeen, SD", "57701 Rapid City, SD", "58078 West Fargo, ND", "58102 Fargo, ND", "58201 Grand Forks, ND", "58501 Bismarck, ND", "58701 Minot, ND", "59101 Billings, MT", "59404 Great Falls, MT", "59601 Helena, MT", "59701 Butte, MT", "59715 Bozeman, MT", "59801 Missoula, MT", "59901 Kalispell, MT", "60004 Arlington Heights, IL", "60007 Elk Grove Village, IL", "60008 Rolling Meadows, IL", "60010 Barrington, IL", "60014 Crystal Lake, IL", "60015 Deerfield, IL", "60016 Des Plaines, IL", "60025 Glenview, IL", "60030 Grayslake, IL", "60031 Gurnee, IL", "60035 Highland Park, IL", "60046 Lake Villa, IL", "60047 Lake Zurich, IL", "60048 Libertyville, IL", "60050 Mchenry, IL", "60053 Morton Grove, IL", "60056 Mount Prospect, IL", "60060 Mundelein, IL", "60061 Vernon Hills, IL", "60062 Northbrook, IL", "60067 Palatine, IL", "60068 Park Ridge, IL", "60073 Round Lake, IL", "60076 Skokie, IL", "60085 Waukegan, IL", "60089 Buffalo Grove, IL", "60091 Wilmette, IL", "60099 Zion, IL", "60101 Addison, IL", "60102 Algonquin, IL", "60103 Bartlett, IL", "60107 Streamwood, IL", "60110 Carpentersville, IL", "60115 Dekalb, IL", "60120 Elgin, IL", "60133 Hanover Park, IL", "60134 Geneva, IL", "60137 Glen Ellyn, IL", "60139 Glendale Heights, IL", "60142 Huntley, IL", "60148 Lombard, IL", "60156 Lake In The Hills, IL", "60169 Hoffman Estates, IL", "60172 Roselle, IL", "60174 Saint Charles, IL", "60181 Villa Park, IL", "60185 West Chicago, IL", "60187 Wheaton, IL", "60188 Carol Stream, IL", "60193 Schaumburg, IL", "60201 Evanston, IL", "60402 Berwyn, IL", "60409 Calumet City, IL", "60411 Chicago Heights, IL", "60426 Harvey, IL", "60435 Joliet, IL", "60439 Lemont, IL", "60440 Bolingbrook, IL", "60446 Romeoville, IL", "60448 Mokena, IL", "60451 New Lenox, IL", "60452 Oak Forest, IL", "60453 Oak Lawn, IL", "60459 Burbank, IL", "60462 Orland Park, IL", "60466 Park Forest, IL", "60515 Downers Grove, IL", "60559 Westmont, IL", "60621 Chicago, IL", "61350 Ottawa, IL", "61604 Peoria, IL", "61821 Champaign, IL", "63109 Saint Louis, MO", "64151 Kansas City, MO", "65401 Rolla, MO", "66801 Emporia, KS", "67037 Derby, KS", "68107 Omaha, NE", "68506 Lincoln, NE", "68801 Grand Island, NE", "70001 Metairie, LA", "70115 New Orleans, LA", "70301 Thibodaux, LA", "70605 Lake Charles, LA", "70663 Sulphur, LA", "70806 Baton Rouge, LA", "71730 El Dorado, AR", "72209 Little Rock, AR", "73072 Norman, OK", "73112 Oklahoma City, OK", "74403 Muskogee, OK", "74820 Ada, OK", "75043 Garland, TX", "75080 Richardson, TX", "75088 Rowlett, TX", "75115 Desoto, TX", "75126 Forney, TX", "75604 Longview, TX", "76039 Euless, TX", "76110 Fort Worth, TX", "76522 Copperas Cove, TX", "76901 San Angelo, TX", "77016 Houston, TX", "77478 Sugar Land, TX", "77566 Lake Jackson, TX", "77904 Victoria, TX", "78023 Helotes, TX", "78213 San Antonio, TX", "78418 Corpus Christi, TX", "78501 Mcallen, TX", "78552 Harlingen, TX", "79106 Amarillo, TX", "79930 El Paso, TX", "80003 Arvada, CO", "80123 Littleton, CO", "80241 Thornton, CO", "80911 Colorado Springs, CO", "81001 Pueblo, CO", "83301 Twin Falls, ID", "83651 Nampa, ID", "84010 Bountiful, UT", "84067 Roy, UT", "84119 Salt Lake City, UT", "84404 Ogden, UT", "85021 Phoenix, AZ", "85203 Mesa, AZ", "85224 Chandler, AZ", "85302 Glendale, AZ", "85326 Buckeye, AZ", "85351 Sun City, AZ", "85365 Yuma, AZ", "85718 Tucson, AZ", "89523 Reno, NV", "90008 Los Angeles, CA", "90260 Lawndale, CA", "90274 Palos Verdes Peninsula, CA", "90278 Redondo Beach, CA", "90403 Santa Monica, CA", "90505 Torrance, CA", "91010 Duarte, CA", "91316 Encino, CA", "91387 Canyon Country, CA", "91733 South El Monte, CA", "91740 Glendora, CA", "91762 Ontario, CA", "91768 Pomona, CA", "91784 Upland, CA", "92083 Vista, CA", "92111 San Diego, CA", "92220 Banning, CA", "92236 Coachella, CA", "92307 Apple Valley, CA", "92806 Anaheim, CA", "92831 Fullerton, CA", "93035 Oxnard, CA", "93306 Bakersfield, CA", "93555 Ridgecrest, CA", "93635 Los Banos, CA", "93706 Fresno, CA", "94043 Mountain View, CA", "94070 San Carlos, CA", "94566 Pleasanton, CA", "94580 San Lorenzo, CA", "94603 Oakland, CA", "94806 San Pablo, CA", "95008 Campbell, CA", "95050 Santa Clara, CA", "95060 Santa Cruz, CA", "95127 San Jose, CA", "95301 Atwater, CA", "95677 Rocklin, CA", "95820 Sacramento, CA", "95993 Yuba City, CA", "96815 Honolulu, HI", "97062 Tualatin, OR", "97124 Hillsboro, OR", "97402 Eugene, OR", "97603 Klamath Falls, OR", "98037 Lynnwood, WA", "98144 Seattle, WA", "98290 Snohomish, WA", "98444 Tacoma, WA", "98503 Lacey, WA", "98512 Olympia, WA", "98604 Battle Ground, WA", "98607 Camas, WA", "98801 Wenatchee, WA", "98837 Moses Lake, WA", "98908 Yakima, WA", "99337 Kennewick, WA", "99504 Anchorage, AK", "99654 Wasilla, AK" };
            var calendars = new List<string> { "Dev team", "Reporting team", "QA team" };
            Random random = new Random();


            var startDates = new List<DateTime>();
            var endDates = new List<DateTime>();
            var resourceIndex = 0;
            for(int i = 0; i < 30; i++)
            {
                DateTime date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, random.Next(1, 27), random.Next(0, 23), 0, 0);
                startDates.Add(date);
                endDates.Add(date.AddHours(random.Next(3, 10)));
                Appointment appointment = new Appointment();
                appointment.Start = startDates[i];
                appointment.End = endDates[i];
                appointment.ID = i.ToString();
                appointment.Name = firstNames[random.Next(0, firstNames.Count)] + " " + lastNames[random.Next(0, lastNames.Count)];
                appointment.Location = random.Next(1, 1000) + " " + streets[random.Next(0, streets.Count)] + " " + zipCodes[random.Next(0, zipCodes.Count)].Substring(6) + " " + zipCodes[random.Next(0, zipCodes.Count)].Substring(0, 5);
                appointment.Description = "";
                appointment.Calendar = calendars[resourceIndex];
                resourceIndex++;
                if (resourceIndex > 2) resourceIndex = 0;
                appointments.Add(appointment);
            }

            for (var i = 0; i < 200; i++)
            {
                SalesEmployee row = new SalesEmployee();
               
                var productindex = random.Next(0, productNames.Count);
                var price = float.Parse(priceValues[random.Next(0, priceValues.Count)]);
                var quantity = 1 + random.Next(0, 20);

                row.ID = 1 + random.Next(0, 20) + 1 + "-" + random.Next(0, 20) + 1 + "-" + random.Next(0, 20) + "";// i.ToString();
                row.ReportsTo = random.Next(0, firstNames.Count);
                if (i > 5 && i % random.Next(1, firstNames.Count) == 0)
                {
                    row.ReportsTo = null;
                }
                else if (i < 5)
                {
                    row.ReportsTo = null;
                }

                row.Available = random.Next(0, 100) % 2 == 0;
                row.FirstName = firstNames[random.Next(0, firstNames.Count)];
                row.LastName = lastNames[random.Next(0, lastNames.Count)];
                row.Name = row.FirstName + " " + row.LastName;
                row.ProductName = productNames[productindex];
                row.Price = price;
                row.Quantity= quantity;
                row.Total = price * quantity;

                var date = new DateTime(2016, random.Next(1, 12), random.Next(1, 29));
           
                row.Date = date;

                this.SalesEmployees.Add(row);
            }
            _created = true;
         }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
        }

        protected override void OnModelCreating(ModelBuilder builder)
        {

        }

        public List<Appointment> Appointments
        {
            get
            {
                return this.appointments;
            }
        }

        public SchedulerResources Resources
        {
            get
            {
                SchedulerResources resources = new SchedulerResources();
                resources.DataField = "Calendar";
                resources.Source = this.Appointments;
                resources.Orientation = null;
                resources.ColorScheme = "scheme02";
                return resources;
            }
        }

        public KanbanResources KanbanResources
        {
            get
            {
                KanbanResources resources = new KanbanResources();
                resources.Source = this.KanbanResourceItems;
                Dictionary<string, string> mappings = new Dictionary<string, string>();
                mappings["Id"] = "id";
                mappings["State"] = "status";
                mappings["Text"] = "label";
                mappings["Label"] = "label";
                mappings["Tags"] = "tags";
                mappings["Hex"] = "color";
                mappings["ResourceId"] = "resourceId";
                mappings["Name"] = "name";
                mappings["Image"] = "image";
                resources.Mappings = mappings;
                return resources;
            }
        }


        public AppointmentDataFields AppointmentDataFields
        {
            get
            {
                AppointmentDataFields fields = new AppointmentDataFields();
                fields.From = "Start";
                fields.To = "End";
                fields.Id = "ID";
                fields.Subject = "Name";
                fields.Location = "Location";
                fields.Description = "Description";
                fields.ResourceId = "Calendar";
                return fields;
            }
        }
        public DateTime Date
        {
            get
            {
                return new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
            }
        }
        public List<SalesEmployee> SalesEmployees
        {
            get
            {
                return this.salesEmployees;
            }
        }
        public List<Employee> Employee
        {
            get
            {
                return this.employees;
            }
        }
    }
}