public async Task <IActionResult> Edit(int id, [Bind("ID,SacramentMeetingID,AssignedOnDate,SpeakingSequence,SpeakerName,AssignedTopic")] SpeakingAssignment speakingAssignment)
{
if (id != speakingAssignment.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(speakingAssignment);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SpeakingAssignmentExists(speakingAssignment.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index), new { id = speakingAssignment.SacramentMeetingID }));
}
ViewData["SacramentMeetingID"] = new SelectList(_context.SacramentMeetings, "ID", "ID", speakingAssignment.SacramentMeetingID);
return(View(speakingAssignment));
}
public async Task <IActionResult> Edit(int id, [Bind("SpeakingAssignmentID,MeetingID,SpeakerID,Topic")] SpeakingAssignment speakingAssignment)
{
if (id != speakingAssignment.SpeakingAssignmentID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(speakingAssignment);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SpeakingAssignmentExists(speakingAssignment.SpeakingAssignmentID))
{
return(NotFound());
}
else
{
throw;
}
}
//return RedirectToAction(nameof(Index));
return(RedirectToAction("Index", "Meetings"));
}
ViewData["MeetingID"] = new SelectList(_context.Meetings, "ID", "ID", speakingAssignment.MeetingID);
ViewData["SpeakerID"] = new SelectList(_context.Speakers, "ID", "ID", speakingAssignment.SpeakerID);
return(View(speakingAssignment));
}
public async Task <IActionResult> Create([Bind("ID,SacramentMeetingID,AssignedOnDate,SpeakingSequence,SpeakerName,AssignedTopic")] SpeakingAssignment speakingAssignment)
{
speakingAssignment.ID = 0;
if (ModelState.IsValid)
{
_context.Add(speakingAssignment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index), new { id = speakingAssignment.SacramentMeetingID }));
}
ViewData["SacramentMeetingID"] = speakingAssignment.SacramentMeetingID;
return(View(speakingAssignment));
}
public async Task <IActionResult> Create([Bind("SpeakingAssignmentID,MeetingID,SpeakerID,Topic")] SpeakingAssignment speakingAssignment)
{
if (ModelState.IsValid)
{
_context.Add(speakingAssignment);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MeetingID"] = new SelectList(_context.Meetings, "ID", "ID", speakingAssignment.MeetingID);
ViewData["SpeakerID"] = new SelectList(_context.Speakers, "ID", "ID", speakingAssignment.SpeakerID);
return(View(speakingAssignment));
}
// GET: SpeakingAssignments/Create
public IActionResult Create(int?id)
{
var speakingAssignment = new SpeakingAssignment();
speakingAssignment.AssignedOnDate = DateTime.Now;
speakingAssignment.SacramentMeetingID = id.Value;
ViewData["SacramentMeetingID"] = id;
var sacramentMeeting = _context.SacramentMeetings.SingleOrDefaultAsync(s => s.ID == id);
if (sacramentMeeting == null)
{
return(NotFound());
}
speakingAssignment.SacramentMeeting = new SacramentMeeting();
speakingAssignment.SacramentMeeting.MeetingDate = sacramentMeeting.Result.MeetingDate;
return(View(speakingAssignment));
}
public async Task <IActionResult> Create([Bind("ID,MeetingDate,Conductor,OpeningHymn,Invocation,SacramentHymn,ClosingHymn,Benediction,Notes")] Meeting meeting, Speaker speaker)
{
if (ModelState.IsValid)
{
_context.Add(meeting);
speaker.Name = Request.Form["Name"];
_context.AddRange(speaker);
SpeakingAssignment topic = new SpeakingAssignment();
topic.Topic = Request.Form["Topic"];
topic.MeetingID = meeting.ID;
topic.SpeakerID = speaker.ID;
_context.AddRange(topic);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(meeting));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,MeetingDate,Conductor,OpeningHymn,Invocation,SacramentHymn,ClosingHymn,Benediction,Notes")] Meeting meeting)
{
if (id != meeting.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(meeting);
Speaker speaker = new Speaker();
speaker.Name = Request.Form["Name"];
_context.Add(speaker);
SpeakingAssignment topic = new SpeakingAssignment();
topic.Topic = Request.Form["Topic"];
topic.MeetingID = meeting.ID;
topic.SpeakerID = speaker.ID;
_context.Add(topic);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingExists(meeting.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(meeting));
}
public static void Initialize(ApplicationDbContext context)
{
//context.Database.EnsureCreated();
// Look for any Sacrament Meetings.
if (context.SacramentMeetings.Any())
{
return; // DB has been seeded
}
var sacramentMeetings = new SacramentMeeting[]
{
new SacramentMeeting {
MeetingDate = DateTime.Parse("2018-02-25"), ConductorName = "Bishop Smith", OpeningSongNumber = 2,
OpeningSongTitle = "The Spirit Of God", OpeningPrayerName = "Sister Porter", SacramentSongNumber = 184, SacramentSongTitle = "Upon the Cross of Calvary",
IntermediateSongNumber = 220, IntermediateSongTitle = "Lord, I Would Follow Thee", ClosingSongNumber = 239, ClosingSongTitle = "Choose The Right",
ClosingPrayerName = "Brother Allred"
},
new SacramentMeeting {
MeetingDate = DateTime.Parse("2018-03-04"), SpecialNote = "Fast and Testimony", ConductorName = "Brother Johnson", OpeningSongNumber = 140,
OpeningSongTitle = "Did You Think to Pray?", OpeningPrayerName = "Sister White", SacramentSongNumber = 187, SacramentSongTitle = "God Loved Us, So He Sent His Son",
ClosingSongNumber = 81, ClosingSongTitle = "Press Forward Saints",
ClosingPrayerName = "Brother Brown"
},
new SacramentMeeting {
MeetingDate = DateTime.Parse("2018-03-11"), ConductorName = "Brother Johnson", OpeningSongNumber = 136,
OpeningSongTitle = "I Know That My Redeemer Lives", OpeningPrayerName = "Sister Knapp", SacramentSongNumber = 182, SacramentSongTitle = "We'll Sing Al Hail To Jesus Name",
IntermediateSongNumber = 227, IntermediateSongTitle = "There is Sunshine in My Soul Today", ClosingSongNumber = 243, ClosingSongTitle = "Let Us All Press On",
ClosingPrayerName = "Brother Knapp"
},
new SacramentMeeting {
MeetingDate = DateTime.Parse("2018-03-18"), SpecialNote = "High Council Speakers", ConductorName = "Brother Johnson",
OpeningSongNumber = 85, OpeningSongTitle = "How Firm a Foundation", OpeningPrayerName = "Brother Porter", SacramentSongNumber = 190,
SacramentSongTitle = "In Memory of the Crucified", IntermediateSongTitle = "Special Music: Piano solo by Sister Rogers",
ClosingSongNumber = 241, ClosingSongTitle = "Count Your Blessings", ClosingPrayerName = "Sister Merrell"
},
new SacramentMeeting {
MeetingDate = DateTime.Parse("2018-03-25"), ConductorName = "Brother Miller", OpeningSongNumber = 2,
OpeningSongTitle = "Come, Listen to a Prophet's Voice", OpeningPrayerName = "Sister Johnsen", SacramentSongNumber = 193, SacramentSongTitle = "I Stand All Amazed",
IntermediateSongNumber = 247, IntermediateSongTitle = "We Love Thy House, O God", ClosingSongNumber = 223, ClosingSongTitle = "Have I Done Any Good?",
ClosingPrayerName = "Brother Laws"
},
new SacramentMeeting {
MeetingDate = DateTime.Parse("2018-04-01"), SpecialNote = "General Conference"
}
};
foreach (SacramentMeeting s in sacramentMeetings)
{
context.SacramentMeetings.Add(s);
}
context.SaveChanges();
var speakingAssignments = new SpeakingAssignment[]
{
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-02-25")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Sister Jones", AssignedTopic = "Repentance"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-02-25")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Brother Jones", AssignedTopic = "Forgiveness"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-11")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Sam Matthews", AssignedTopic = "Faith"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-11")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Hunter Knapp", AssignedTopic = "Hope"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-11")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Rose Howard", AssignedTopic = "Charity"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-18")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Brother Garner (Stake)", AssignedTopic = "Preparedness"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-18")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Brother Williams (Stake HC)", AssignedTopic = "Study the Scriptures"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-25")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Liz Clark", AssignedTopic = "Young Women Values"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-25")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Sister Kay", AssignedTopic = "Cheerful Giving"
},
new SpeakingAssignment {
SacramentMeetingID = sacramentMeetings.Single(s => s.MeetingDate == DateTime.Parse("2018-03-25")).ID, AssignedOnDate = DateTime.Parse("2018-02-10"),
SpeakerName = "Brother Kay", AssignedTopic = "Service"
}
};
foreach (SpeakingAssignment a in speakingAssignments)
{
context.SpeakingAssignments.Add(a);
}
context.SaveChanges();
}
public static void Initialize(MeetingContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Speakers.Any())
{
return; // DB has been seeded
}
var speakers = new Speaker[]
{
new Speaker {
Name = "Alexander Laureta"
},
new Speaker {
Name = "Norman Mota"
},
new Speaker {
Name = "Olivetto Rivera"
},
};
foreach (Speaker s in speakers)
{
context.Speakers.Add(s);
}
context.SaveChanges();
var meetings = new Meeting[]
{
new Meeting {
MeetingDate = DateTime.Parse("2005-09-01"), Conductor = "Philip Kim", OpeningHymn = "The Spirit of God", Invocation = "Leo Cristiano", SacramentHymn = "As Now We Take The Sacrament", ClosingHymn = "Because I Have Been Given Much", Benediction = "Meredith Laurence", Notes = ""
},
new Meeting {
MeetingDate = DateTime.Parse("2005-09-08"), Conductor = "Yong Lopez", OpeningHymn = "Come Come Ye Saints", Invocation = "Billy Jones", SacramentHymn = "God, Our Father, Hear Us Pray", ClosingHymn = "I am a Child of God", Benediction = "Robert Frias", Notes = ""
},
};
foreach (Meeting c in meetings)
{
context.Meetings.Add(c);
}
context.SaveChanges();
var speakingAssignments = new SpeakingAssignment[]
{
new SpeakingAssignment {
MeetingID = 1, SpeakerID = 1, Topic = "Faith"
},
new SpeakingAssignment {
MeetingID = 2, SpeakerID = 2, Topic = "Sacrifice"
},
new SpeakingAssignment {
MeetingID = 1, SpeakerID = 3, Topic = "Faith"
},
};
foreach (SpeakingAssignment e in speakingAssignments)
{
context.SpeakingAssignments.Add(e);
}
context.SaveChanges();
StreamReader sr = new StreamReader("../Data/hymns.json");
string jsonString = sr.ReadToEnd();
List <MyModel> myModels = JsonConvert.DeserializeObject <List <MyModel> >(jsonString);
/* var myModels = new MyModel[]
* {
* new MyModel{name = "The Morning Breaks" },
* new MyModel{ name = "The Spirit of God" },
* };*/
foreach (MyModel e in myModels)
{
new MyModel {
name = e.name
};
context.MyModel.Add(e);
}
context.SaveChanges();
}
