public void AddProtocol(int studentID, string value, string hoursTotal, int subjectID, DateTime date)
        {
            int      hours    = Int32.Parse(hoursTotal);
            Protocol protocol = new Protocol();

            protocol.StudentID  = studentID;
            protocol.HoursTotal = hours;

            switch (value)
            {
            case "Present":
                protocol.HoursPresent = hours;
                protocol.HoursVirtual = 0;
                break;

            case "Virtual":
                protocol.HoursPresent = 0;
                protocol.HoursVirtual = hours;
                break;

            case "Absent":
                protocol.HoursPresent = 0;
                protocol.HoursVirtual = 0;
                break;
            }

            if (date == DateTime.Now.Date)
            {
                protocol.Date = DateTime.Now.Date;
            }
            else
            {
                protocol.Date = date;
            }


            protocol.SubjectID = subjectID;
            Protocol protocolobj;

            protocolobj = context.Protocols.FirstOrDefault(p => p.Date == date && p.SubjectID == subjectID && p.StudentID == studentID);
            // && p.HoursPresent == protocol.HoursPresent && p.HoursVirtual == protocol.HoursVirtual
            if (protocolobj == null)
            {
                context.Add(protocol);
                context.SaveChanges();
            }
            else if (protocolobj != null)
            {
                DeleteProtocol(protocolobj);
                context.Add(protocol);
                context.SaveChanges();
            }
        }
        public static void EnsurePopulated(IApplicationBuilder app)
        {
            FFDbContext context = app.ApplicationServices.CreateScope().ServiceProvider
                                  .GetRequiredService <FFDbContext>();

            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }

            if (!context.Subjects.Any())
            {
                context.Subjects.AddRange(
                    new Subject {
                    Name = "DMU-19 ProTek3"
                },
                    new Subject {
                    Name = "DMU-19 Sysudvikling3"
                },
                    new Subject {
                    Name = "DMU-19 Databaser"
                },
                    new Subject {
                    Name = "DMU-20 ProTek3"
                },
                    new Subject {
                    Name = "DMU-20 Sysudvikling3"
                },
                    new Subject {
                    Name = "DMU-20 Databaser"
                }
                    );
            }
            context.SaveChanges();
        }
        public static void EnsurePopulated(IApplicationBuilder app)
        {
            FFDbContext context = app.ApplicationServices.CreateScope().ServiceProvider
                                  .GetRequiredService <FFDbContext>();

            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }

            if (!context.StudentsSubjects.Any())
            {
                context.StudentsSubjects.AddRange(
                    new StudentsSubjects {
                    StudentID = 1, SubjectID = 1
                },
                    new StudentsSubjects {
                    StudentID = 2, SubjectID = 1
                },
                    new StudentsSubjects {
                    StudentID = 3, SubjectID = 2
                }
                    );
            }
            context.SaveChanges();
        }
        public static void EnsurePopulated(IApplicationBuilder app)
        {
            FFDbContext context = app.ApplicationServices.CreateScope().ServiceProvider
                                  .GetRequiredService <FFDbContext>();

            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }

            if (!context.Protocols.Any())
            {
                context.Protocols.AddRange(
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 1, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 2, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 3, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 4, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 5, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 6, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 7, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 8, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 9, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 10, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 11, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 12, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 13, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 14, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 15, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 16, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 17, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 18, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 19, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 20, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("10-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 21, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 1, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 2, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 3, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 4, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 5, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 6, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 7, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 8, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 9, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 10, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 11, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 12, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 13, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 14, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 15, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 16, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 17, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 18, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 19, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("11-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 20, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 21, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 1, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 2, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 3, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 4, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 5, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 6, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 7, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 8, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 9, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 10, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 11, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 12, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 13, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 14, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 15, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 16, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 17, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 18, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 19, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 20, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("12-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 21, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 1, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 2, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 3, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 4, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 5, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 6, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 7, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 8, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 9, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 10, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 11, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 12, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 13, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 14, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 15, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 16, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 17, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 18, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 2, HoursVirtual = 0, StudentID = 19, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 2, StudentID = 20, SubjectID = 1
                },
                    new Protocol {
                    Date = DateTime.Parse("13-12-2020"), HoursTotal = 2, HoursPresent = 0, HoursVirtual = 0, StudentID = 21, SubjectID = 1
                }
                    );
            }
            context.SaveChanges();
        }
        public static void EnsurePopulated(IApplicationBuilder app)
        {
            FFDbContext context = app.ApplicationServices.CreateScope().ServiceProvider
                                  .GetRequiredService <FFDbContext>();

            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }

            if (!context.Students.Any())
            {
                context.Students.AddRange(
                    new Student {
                    Name = "Bjarke Villadsen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Casper Nielsen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Christian Nygaard Pedersen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Claus Jørgensen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Daniel Bjerre Madsen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Dean Marco Dalager Birch Nielsen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Emil Overgaard Jensen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Jack Jakobsen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Jakob Rasmussen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Mads Brandt", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Mark Enggaard", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Mark Pearson", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Martin Godthaab Larsen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Mathias Jensen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Pia Degn Eriksen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Sabine Amtkjær", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Simon Markussen", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Søren Kaalund", Email = "sø[email protected]", IsActive = true
                },
                    new Student {
                    Name = "Victor Eriksen Siig", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Viktor Juul", Email = "*****@*****.**", IsActive = true
                },
                    new Student {
                    Name = "Yasin Güler", Email = "*****@*****.**", IsActive = true
                }
                    );
            }
            context.SaveChanges();
        }
 public void DeleteStudentSubject(StudentsSubjects ss)
 {
     context.Remove(ss);
     context.SaveChanges();
 }
 public void AddSubject(Subject subject)
 {
     context.Add(subject);
     context.SaveChanges();
 }