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(); }