public static void EnsurePopulated(IApplicationBuilder application)
{
ScheduleTestDbContext context = application.ApplicationServices.
CreateScope().ServiceProvider.GetRequiredService <ScheduleTestDbContext>();
//making sure the db is connected and that it runs smoothly
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
if (!context.Appointments.Any())
{
context.Appointments.AddRange(
//one day
new Appointment
{
AppointmentId = 1,
Time = "8:00am",
Day = "Monday"
},
new Appointment
{
AppointmentId = 2,
Time = "9:00am",
Day = "Monday"
},
new Appointment
{
AppointmentId = 3,
Time = "10:00am",
Day = "Monday"
},
new Appointment
{
AppointmentId = 4,
Time = "11:00am",
Day = "Monday"
},
new Appointment
{
AppointmentId = 5,
Time = "12:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 6,
Time = "1:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 7,
Time = "2:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 8,
Time = "3:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 9,
Time = "4:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 10,
Time = "5:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 11,
Time = "6:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 12,
Time = "7:00pm",
Day = "Monday"
},
new Appointment
{
AppointmentId = 13,
Time = "8:00pm",
Day = "Monday"
},
//tuesday
new Appointment
{
AppointmentId = 14,
Time = "8:00am",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 15,
Time = "9:00am",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 16,
Time = "10:00am",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 17,
Time = "11:00am",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 18,
Time = "12:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 19,
Time = "1:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 20,
Time = "2:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 21,
Time = "3:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 22,
Time = "4:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 23,
Time = "5:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 24,
Time = "6:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 25,
Time = "7:00pm",
Day = "Tuesday"
},
new Appointment
{
AppointmentId = 26,
Time = "8:00pm",
Day = "Tuesday"
},
//wednesday
new Appointment
{
AppointmentId = 27,
Time = "8:00am",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 28,
Time = "9:00am",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 29,
Time = "10:00am",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 30,
Time = "11:00am",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 31,
Time = "12:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 32,
Time = "1:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 33,
Time = "2:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 34,
Time = "3:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 35,
Time = "4:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 36,
Time = "5:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 37,
Time = "6:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 38,
Time = "7:00pm",
Day = "Wednesday"
},
new Appointment
{
AppointmentId = 39,
Time = "8:00pm",
Day = "Wednesday"
},
//Thursday
new Appointment
{
AppointmentId = 40,
Time = "8:00am",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 41,
Time = "9:00am",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 42,
Time = "10:00am",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 43,
Time = "11:00am",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 44,
Time = "12:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 45,
Time = "1:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 46,
Time = "2:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 47,
Time = "3:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 48,
Time = "4:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 49,
Time = "5:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 50,
Time = "6:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 51,
Time = "7:00pm",
Day = "Thursday"
},
new Appointment
{
AppointmentId = 52,
Time = "8:00pm",
Day = "Thursday"
},
//Friday
new Appointment
{
AppointmentId = 53,
Time = "8:00am",
Day = "Friday"
},
new Appointment
{
AppointmentId = 54,
Time = "9:00am",
Day = "Friday"
},
new Appointment
{
AppointmentId = 55,
Time = "10:00am",
Day = "Friday"
},
new Appointment
{
AppointmentId = 56,
Time = "11:00am",
Day = "Friday"
},
new Appointment
{
AppointmentId = 57,
Time = "12:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 58,
Time = "1:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 59,
Time = "2:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 60,
Time = "3:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 61,
Time = "4:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 62,
Time = "5:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 63,
Time = "6:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 64,
Time = "7:00pm",
Day = "Friday"
},
new Appointment
{
AppointmentId = 65,
Time = "8:00pm",
Day = "Friday"
},
//Saturday
new Appointment
{
AppointmentId = 66,
Time = "8:00am",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 67,
Time = "9:00am",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 68,
Time = "10:00am",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 69,
Time = "11:00am",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 70,
Time = "12:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 71,
Time = "1:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 72,
Time = "2:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 73,
Time = "3:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 74,
Time = "4:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 75,
Time = "5:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 76,
Time = "6:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 77,
Time = "7:00pm",
Day = "Saturday"
},
new Appointment
{
AppointmentId = 78,
Time = "8:00pm",
Day = "Saturday"
},
//Sunday
new Appointment
{
AppointmentId = 79,
Time = "8:00am",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 80,
Time = "9:00am",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 81,
Time = "10:00am",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 82,
Time = "11:00am",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 83,
Time = "12:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 84,
Time = "1:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 85,
Time = "2:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 86,
Time = "3:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 87,
Time = "4:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 88,
Time = "5:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 89,
Time = "6:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 90,
Time = "7:00pm",
Day = "Sunday"
},
new Appointment
{
AppointmentId = 91,
Time = "8:00pm",
Day = "Sunday"
}
);
context.SaveChanges();
}
}
//constructor
public EFScheduleRepository(ScheduleTestDbContext context)
{
_context = context;
}