private void AddGrafieken(Integratie2018Context context)
        {
            Serie serie1 = new Serie()
            {
                Naam = "Installation"
            };
            Data data1 = new Data()
            {
                Value = 43934
            };
            Data data2 = new Data()
            {
                Value = 52503
            };
            Data data3 = new Data()
            {
                Value = 57177
            };
            Data data4 = new Data()
            {
                Value = 69658
            };
            Data data5 = new Data()
            {
                Value = 97031
            };
            Data data6 = new Data()
            {
                Value = 119931
            };
            Data data7 = new Data()
            {
                Value = 137133
            };
            Data data8 = new Data()
            {
                Value = 154175
            };

            serie1.Data.Add(data1);
            serie1.Data.Add(data2);
            serie1.Data.Add(data3);
            serie1.Data.Add(data4);
            serie1.Data.Add(data5);
            serie1.Data.Add(data6);
            serie1.Data.Add(data7);
            serie1.Data.Add(data8);

            Serie serie2 = new Serie()
            {
                Naam = "Manufacturing"
            };

            data1 = new Data()
            {
                Value = 24916
            };
            data2 = new Data()
            {
                Value = 24064
            };
            data3 = new Data()
            {
                Value = 29742
            };
            data4 = new Data()
            {
                Value = 29851
            };
            data5 = new Data()
            {
                Value = 32490
            };
            data6 = new Data()
            {
                Value = 30282
            };
            data7 = new Data()
            {
                Value = 38121
            };
            data8 = new Data()
            {
                Value = 40434
            };
            serie2.Data.Add(data1);
            serie2.Data.Add(data2);
            serie2.Data.Add(data3);
            serie2.Data.Add(data4);
            serie2.Data.Add(data5);
            serie2.Data.Add(data6);
            serie2.Data.Add(data7);
            serie2.Data.Add(data8);

            Serie serie3 = new Serie()
            {
                Naam = "Sales & Distribution"
            };

            data1 = new Data()
            {
                Value = 11744
            };
            data2 = new Data()
            {
                Value = 17722
            };
            data3 = new Data()
            {
                Value = 16005
            };
            data4 = new Data()
            {
                Value = 19771
            };
            data5 = new Data()
            {
                Value = 20185
            };
            data6 = new Data()
            {
                Value = 24377
            };
            data7 = new Data()
            {
                Value = 32147
            };
            data8 = new Data()
            {
                Value = 39387
            };
            serie3.Data.Add(data1);
            serie3.Data.Add(data2);
            serie3.Data.Add(data3);
            serie3.Data.Add(data4);
            serie3.Data.Add(data5);
            serie3.Data.Add(data6);
            serie3.Data.Add(data7);
            serie3.Data.Add(data8);

            Serie serie4 = new Serie()
            {
                Naam = "Project Development"
            };

            data1 = new Data()
            {
                Value = 0
            };
            data2 = new Data()
            {
                Value = 0
            };
            data3 = new Data()
            {
                Value = 7988
            };
            data4 = new Data()
            {
                Value = 12169
            };
            data5 = new Data()
            {
                Value = 15112
            };
            data6 = new Data()
            {
                Value = 22452
            };
            data7 = new Data()
            {
                Value = 34400
            };
            data8 = new Data()
            {
                Value = 34227
            };
            serie4.Data.Add(data1);
            serie4.Data.Add(data2);
            serie4.Data.Add(data3);
            serie4.Data.Add(data4);
            serie4.Data.Add(data5);
            serie4.Data.Add(data6);
            serie4.Data.Add(data7);
            serie4.Data.Add(data8);

            Serie serie5 = new Serie()
            {
                Naam = "Other"
            };

            data1 = new Data()
            {
                Value = 12908
            };
            data2 = new Data()
            {
                Value = 5948
            };
            data3 = new Data()
            {
                Value = 8105
            };
            data4 = new Data()
            {
                Value = 11248
            };
            data5 = new Data()
            {
                Value = 8989
            };
            data6 = new Data()
            {
                Value = 11816
            };
            data7 = new Data()
            {
                Value = 18274
            };
            data8 = new Data()
            {
                Value = 18111
            };
            serie5.Data.Add(data1);
            serie5.Data.Add(data2);
            serie5.Data.Add(data3);
            serie5.Data.Add(data4);
            serie5.Data.Add(data5);
            serie5.Data.Add(data6);
            serie5.Data.Add(data7);
            serie5.Data.Add(data8);

            List <Serie> series = new List <Serie>();

            series.Add(serie1);
            series.Add(serie2);
            series.Add(serie3);
            series.Add(serie4);
            series.Add(serie5);

            Grafiek grafiek1 = new Lijn(0, "Solar Employment Growth by Sector, 2010-2016", new As()
            {
                IsUsed = true, Titel = "Number of Employees"
            }, series);

            grafiek1.GebruikerId = 0;
            As xAs = new As()
            {
                IsUsed = true
            };

            Categorie cat1 = new Categorie("Apples");
            Categorie cat2 = new Categorie("Oranges");
            Categorie cat3 = new Categorie("Pears");
            Categorie cat4 = new Categorie("Grapes");
            Categorie cat5 = new Categorie("Bananas");

            xAs.Categorieen.Add(cat1);
            xAs.Categorieen.Add(cat2);
            xAs.Categorieen.Add(cat3);
            xAs.Categorieen.Add(cat4);
            xAs.Categorieen.Add(cat5);

            serie1 = new Serie()
            {
                Naam = "John"
            };
            data1 = new Data(5);
            data2 = new Data(3);
            data3 = new Data(4);
            data4 = new Data(7);
            data5 = new Data(2);
            serie1.Data.Add(data1);
            serie1.Data.Add(data2);
            serie1.Data.Add(data3);
            serie1.Data.Add(data4);
            serie1.Data.Add(data5);

            serie2 = new Serie()
            {
                Naam = "Jane"
            };
            data1 = new Data(2);
            data2 = new Data(-2);
            data3 = new Data(-3);
            data4 = new Data(2);
            data5 = new Data(1);
            serie2.Data.Add(data1);
            serie2.Data.Add(data2);
            serie2.Data.Add(data3);
            serie2.Data.Add(data4);
            serie2.Data.Add(data5);

            serie3 = new Serie()
            {
                Naam = "Joe"
            };
            data1 = new Data(3);
            data2 = new Data(4);
            data3 = new Data(4);
            data4 = new Data(-2);
            data5 = new Data(5);
            serie3.Data.Add(data1);
            serie3.Data.Add(data2);
            serie3.Data.Add(data3);
            serie3.Data.Add(data4);
            serie3.Data.Add(data5);

            List <Serie> series2 = new List <Serie>();

            series2.Add(serie1);
            series2.Add(serie2);
            series2.Add(serie3);

            Grafiek grafiek2 = new Bar(1, "Column chart with negative values",
                                       xAs, series2);

            grafiek2.GebruikerId = 0;
            serie1 = new Serie()
            {
                Naam = "Brands", ColorByPoint = true
            };
            data1 = new Data()
            {
                Naam = "Chrome", Value = 61.41, Sliced = true, Selected = false
            };
            data2 = new Data()
            {
                Naam = "Internet Explorer", Value = 11.84
            };
            data3 = new Data()
            {
                Naam = "Firefox", Value = 10.85
            };
            data4 = new Data()
            {
                Naam = "Edge", Value = 4.67
            };
            data5 = new Data()
            {
                Naam = "Safari", Value = 4.18
            };
            data6 = new Data()
            {
                Naam = "Other", Value = 7.05
            };
            serie1.Data.Add(data1);
            serie1.Data.Add(data2);
            serie1.Data.Add(data3);
            serie1.Data.Add(data4);
            serie1.Data.Add(data5);
            serie1.Data.Add(data6);

            Grafiek grafiek3 = new Pie(2, "Browser market shares in January, 2018", serie1);

            grafiek3.GebruikerId = 0;
            context.Grafieken.Add(grafiek1);
            context.Grafieken.Add(grafiek2);
            context.Grafieken.Add(grafiek3);

            context.SaveChanges();
        }
        public DataTable GetCategories()
        {
            var oData = new Data();

            return(oData.GetDataTable("SELECT * FROM Category", null));
        }