using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using YoungEnterpriseServer.Models;
using YoungEnterpriseServer.Models.Database;

namespace YoungEnterpriseServer.Data
{
    public static class DbInitializer
    {
        public static void Initialize(YoungEnterpriseContext context)
        {
            if (context.Contest.Any())
            {
                return;
            }

            var tracks = new Track[]
            {
                new Track{TrackNameId = "All"},
                new Track{TrackNameId = "Trade & Skills"},
                new Track{TrackNameId = "Society & Globalization"},
                new Track{TrackNameId = "Business & Service"},
                new Track{TrackNameId = "Science & Technology"}
            };
            foreach (var track in tracks)
            {
                context.Track.Add(track);
            }
            context.SaveChanges();

            var Contests = new Contest[]
            {
                new Contest
                {
                    ContestTitle = "Entrepreneurship 2016",
                    SignUpStartDate = DateTime.Parse("2016-09-01"),
                    ContestStartDate = DateTime.Parse("2016-10-01"),
                    ContestEndDate = DateTime.Parse("2016-10-03"),
                    Description = "2016 fall contest"
                },
                new Contest
                {
                ContestTitle = "Entrepreneurship 2017",
                SignUpStartDate = DateTime.Parse("2017-09-01"),
                ContestStartDate = DateTime.Parse("2017-10-01"),
                ContestEndDate = DateTime.Parse("2017-10-03"),
                Description = "2017 fall contest"
                }
            };
            foreach (var contest in Contests)
            {
                context.Contest.Add(contest);
            }
            context.SaveChanges();

            var Logins = new Login[]
            {
                new Login
                {
                    UserName = "jakob01",
                    Pass = "Test",
                    UserRole = Role.Admin
                },
                new Login
                {
                UserName = "Sebastian02",
                Pass = "Test",
                UserRole = Role.Admin
                },
                new Login
                {
                    UserName = "Suman03",
                    Pass = "Test",
                    UserRole = Role.Admin
                },
                new Login
                {
                    UserName = "JudgeTeamA2017",
                    Pass = "Test",
                    UserRole = Role.Judge
                },
                new Login
                {
                    UserName = "JudgeTeamB2017",
                    Pass = "Test",
                    UserRole = Role.Judge
                },
                new Login
                {
                    UserName = "JudgeTeamA2016",
                    Pass = "Test",
                    UserRole = Role.Judge
                },
                new Login
                {
                    UserName = "JudgeTeamB2016",
                    Pass = "Test",
                    UserRole = Role.Judge
                },
                new Login
                {
                    UserName = "Team12017",
                    Pass = "Test",
                    UserRole = Role.Contestant
                },
                new Login
                {
                    UserName = "Team22017",
                    Pass = "Test",
                    UserRole = Role.Contestant
                },
                new Login
                {
                    UserName = "Team12016",
                    Pass = "Test",
                    UserRole = Role.Contestant
                },
                new Login
                {
                    UserName = "Team22016",
                    Pass = "Test",
                    UserRole = Role.Contestant
                },



            };
            foreach (var login in Logins)
            {
                context.Login.Add(login);
            }
            context.SaveChanges();

            var Judges = new Judge[]
            {
                new Judge
                {
                    FirstName = "Ole",
                    LastName = "Henning",
                    Email = "OlesMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Helle",
                    LastName = "Iversen",
                    Email = "HellesMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Karsten",
                    LastName = "Krog",
                    Email = "KarstensMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Jytte",
                    LastName = "Herlev",
                    Email = "JyttesMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Grete",
                    LastName = "Kran",
                    Email = "GretesMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Jesper",
                    LastName = "Aase",
                    Email = "JespersMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Kristine",
                    LastName = "Rasputin",
                    Email = "KristinesMail@gmail.com",
                },
                new Judge
                {
                    FirstName = "Patrick",
                    LastName = "Ørlev",
                    Email = "PatricksMail@gmail.com",
                },

            };
            foreach (var judge in Judges)
            {
                context.Judge.Add(judge);
            }
            context.SaveChanges();

            var JudgeTeams = new JudgeTeam[]
            {
                new JudgeTeam
                {
                    Letter = "A",
                    ContestId = 2,
                    LoginId = 4,
                },
                new JudgeTeam
                {
                    Letter = "B",
                    ContestId = 2,
                    LoginId = 5,
                },
                new JudgeTeam
                {
                    Letter = "A",
                    ContestId = 1,
                    LoginId = 6,
                },
                new JudgeTeam
                {
                    Letter = "b",
                    ContestId = 1,
                    LoginId = 7,
                },

            };
            foreach (var judgeteam in JudgeTeams)
            {
                context.JudgeTeam.Add(judgeteam);
            }
            context.SaveChanges();

            var JudgeParticipants = new JudgeParticipants[]
            {
                new JudgeParticipants
                {
                    JudgeId = 1,
                    JudgeTeamId = 1,
                },
                new JudgeParticipants
                {
                    JudgeId = 2,
                    JudgeTeamId = 1,
                },
                new JudgeParticipants
                {
                    JudgeId = 3,
                    JudgeTeamId = 2,
                },
                new JudgeParticipants
                {
                    JudgeId = 4,
                    JudgeTeamId = 2,
                },
                new JudgeParticipants
                {
                    JudgeId = 5,
                    JudgeTeamId = 3,
                },
                new JudgeParticipants
                {
                    JudgeId = 6,
                    JudgeTeamId = 3,
                },
                new JudgeParticipants
                {
                    JudgeId = 7,
                    JudgeTeamId = 4,
                },
                new JudgeParticipants
                {
                    JudgeId = 8,
                    JudgeTeamId = 4,
                },

            };
            foreach (var jp in JudgeParticipants)
            {
                context.JudgeParticipants.Add(jp);
            }
            context.SaveChanges();

            var Administrators = new Administrator[]
            {
                new Administrator
                {
                    FirstName = "Jakob",
                    LastName = "Schroeder",
                    Email = "Test@gmail.com",
                    AdminId = 1
                },
                new Administrator
                {
                    FirstName = "Sebastian",
                    LastName = "Børløs",
                    Email = "Test@gmail.com",
                    AdminId = 2
                },
                new Administrator
                {
                    FirstName = "Suman",
                    LastName = "Panglum",
                    Email = "Test@gmail.com",
                    AdminId = 3
                }
            };
            foreach (var admin in Administrators)
            {
                context.Administrator.Add(admin);
            }
            context.SaveChanges();

            var ContestTeams = new ContestTeam[]
            {
                new ContestTeam
                {
                    TeamName = "Beer 4 You",
                    TrackNameId = "Trade & Skills",
                    ContestId = 2,
                    LoginId = 8
                },
                new ContestTeam
                {
                TeamName = "DURA",
                TrackNameId = "Business & Service",
                ContestId = 2,
                LoginId = 9
                },
                new ContestTeam
                {
                    TeamName = "Just Zipper",
                    TrackNameId = "Science & Technology",
                    ContestId = 1,
                    LoginId = 10
                },
                new ContestTeam
                {
                    TeamName = "DURA",
                    TrackNameId = "Society & Globalizatione",
                    ContestId = 1,
                    LoginId = 11
                }

            };
            foreach (var ct in ContestTeams)
            {
                context.ContestTeam.Add(ct);
            }
            context.SaveChanges();

            var Questionnaires = new Questionnaire[]
            {
                new Questionnaire
                {
                    Title = "Society & Globalization Interview",
                    TrackNameId = "Society & Globalization"
                },
                new Questionnaire
                {
                    Title = "Society & Globalization Report",
                    TrackNameId = "Society & Globalization"
                },
                new Questionnaire
                {
                    Title = "Trade & Skills Interview",
                    TrackNameId = "Trade & Skills"
                },
                new Questionnaire
                {
                    Title = "Trade & Skills Report",
                    TrackNameId = "Trade & Skills"
                },
            };
            foreach (var questionnaire in Questionnaires)
            {
                context.Questionnaire.Add(questionnaire);
            }
            context.SaveChanges();

            var Questions = new Question[]
            {
                new Question
                {
                    QuestionText = "I hvor høj grad kan eleverne argumentere for deres ide med afsæt i en faglig begrundet problemformulering?",
                    QuestionWeight = 1.5,
                    QuestionnaireId = 1
                },
                new Question
                {
                    QuestionText = "I hvor høj grad har eleverne foretaget analyser af, hvorvidt ideen dækker et reelt samfundsmæssigt behov, og kan eleverne dokumentere og fremlægge disse?",
                    QuestionWeight = 1.5,
                    QuestionnaireId = 1
                },
                new Question
                {
                    QuestionText = "I hvor høj grad formår eleverne at placere deres ide i en bredere kontekst – kan de perspektivere denne?",
                    QuestionWeight = 1,
                    QuestionnaireId = 1
                },
                new Question
                {
                    QuestionText = "I hvor høj grad viser eleverne med deres idé forståelse for og indblik i andre samfundsforhold og kulturer end deres egen? Har eleverne med deres idé oparbejdet interkulturelle kompetencer?",
                    QuestionWeight = 1,
                    QuestionnaireId = 1
                },
                new Question
                {
                    QuestionText = "I hvilket omfang anvendes der sociologiske og/eller økonomiske begreber i udviklingen af ideen? - Der lægges størst vægt på de økonomiske begreber og den samfundsmæssige forståelse – bevægelsen fra problem til markedsmulighed",
                    QuestionWeight = 1.5,
                    QuestionnaireId = 2
                },
                new Question
                {
                    QuestionText = "I hvor høj grad har eleverne gjort sig overvejelser om udviklingen af konkrete CSR aktiviteter som supplement til den overordnede idé/produkt?",
                    QuestionWeight = 1,
                    QuestionnaireId = 2
                },
                new Question
                {
                    QuestionText = "I hvor høj grad har eleverne gjort sig overvejelser om deres sociale ansvar ved udviklingen/implementeringen af ideen??",
                    QuestionWeight = 1,
                    QuestionnaireId = 2
                },
                new Question
                {
                    QuestionText = "I hvilken grad skaber ideen social/samfundsmæssig værdi? -For hvilken gruppe i samfundet har idéen skabt værdi? -Her tænkes bl.a. på miljø og sundhed, men andre temaer kan også inddrages",
                    QuestionWeight = 1.5,
                    QuestionnaireId = 2
                },



            };
            foreach (var question in Questions)
            {
                context.Question.Add(question);
            }
            context.SaveChanges();
        }


    }
}