public void PopulateMeetingsDropDownList(SacramentProgramContext _context)
{
var meetingQuery = from m in _context.Meeting
orderby m.MeetingDate
select m;
MeetingDatesDropDown = new SelectList(meetingQuery,
"ID", "MeetingDate");
}
public void PopulateMusicNumDropDownList(SacramentProgramContext _context)
{
var musicQuery = from d in _context.MusicalNum
orderby d.Performer // Sort by name.
select d;
MusicNumDropDown = new SelectList(musicQuery,
"ID", "MusicalPerformance");
}
public void PopulateSongDropDownList(SacramentProgramContext _context)
{
var songsQuery = from d in _context.Song
orderby d.PageNum // Sort by name.
select d;
SongDropDown = new SelectList(songsQuery,
"ID", "Name");
}
public void PopulatePersonDropDownList(SacramentProgramContext _context)
{
var personsQuery = from d in _context.Person
orderby d.LastName // Sort by name.
select d;
PersonDropDown = new SelectList(personsQuery,
"ID", "FullName");
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new SacramentProgramContext(
serviceProvider.GetRequiredService <
DbContextOptions <SacramentProgramContext> >()))
{
if (context.Song.Any())
{
return;
}
context.Song.AddRange(
new Song
{
Name = "The Morning Breaks",
PageNum = 1
},
new Song
{
Name = "The Spirit of God",
PageNum = 2
},
new Song
{
Name = "Now Let Us Rejoice",
PageNum = 3
},
new Song
{
Name = "Truth Eternal",
PageNum = 4
},
new Song
{
Name = "Redeemer of Isreal",
PageNum = 5
},
new Song
{
Name = "Rereemer of Isreal",
PageNum = 6
},
new Song
{
Name = "Isreal, Isreal, God is calling",
PageNum = 7
},
new Song
{
Name = "Awake and Arise",
PageNum = 8
},
new Song
{
Name = "Come, Rejoice",
PageNum = 9
},
new Song
{
Name = "Come, Sing to the Lord",
PageNum = 10
},
new Song
{
Name = "What was Witnessed in the Heavens?",
PageNum = 11
},
new Song
{
Name = "Twas Witnessed in the Morning Sky",
PageNum = 12
},
new Song
{
Name = "An Angel from on High",
PageNum = 13
},
new Song
{
Name = "Sweet Is the Peace the Gospel Brings",
PageNum = 14
}
);
context.SaveChanges();
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new SacramentProgramContext(
serviceProvider.GetRequiredService <
DbContextOptions <SacramentProgramContext> >()))
{
if (context.Person.Any())
{
return;
}
context.Person.AddRange(
new Person
{
FirstName = "William",
LastName = "Brown",
BroOrSis = "Bishop"
},
new Person
{
FirstName = "Abi",
LastName = "Napier",
BroOrSis = "Sister"
},
new Person
{
FirstName = "Lauren",
LastName = "Thorne",
BroOrSis = "Sister"
},
new Person
{
FirstName = "Aaron",
LastName = "Wright",
BroOrSis = "Elder"
},
new Person
{
FirstName = "Brian",
LastName = "Warner",
BroOrSis = "Elder"
},
new Person
{
FirstName = "Jack",
LastName = "Johnson",
BroOrSis = "Brother"
},
new Person
{
FirstName = "Jim",
LastName = "Carrey",
BroOrSis = "Brother"
},
new Person
{
FirstName = "Mariah",
LastName = "Carrey",
BroOrSis = "Sister"
},
new Person
{
FirstName = "Cory",
LastName = "Taylor",
BroOrSis = "Brother"
}
);
context.SaveChanges();
}
}
