public IHttpActionResult DeleteParticipant(int id) { var participantToDelete = db.Participants.Where(p => p.Id == id).FirstOrDefault <Participant>(); if (participantToDelete != null) { db.Entry(participantToDelete).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } else { return(NotFound()); } var participantInMeetingToDelete = db.MeetingParticipants.Where(m => m.IdParticipant == id).FirstOrDefault <MeetingParticipants>(); if (participantToDelete != null) { db.Entry(participantInMeetingToDelete).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } else { return(NotFound()); } return(Ok()); }
void IMeetingCommands.Update(Meeting meeting) {//pw: not used MeetingContext.Meeting.Attach(meeting); MeetingContext.Entry(meeting).State = EntityState.Modified; var ChangeTracker = MeetingContext.ChangeTracker; var addedEntities = ChangeTracker.Entries().Where(x => x.State == EntityState.Added).ToList(); var modifiedEntities = ChangeTracker.Entries().Where(x => x.State == EntityState.Modified).ToList(); var deletedEntities = ChangeTracker.Entries().Where(x => x.State == EntityState.Deleted).ToList(); MeetingContext.SaveChanges(); }
public void SaveOriginalFile(string caseName, DbContextOptions options) { var meeting = GetOriginalMeetingfromJson(); using (var context = new MeetingContext(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); strategy.SaveMeeting(context, meeting); context.SaveChanges(); } using (var context = new MeetingContext(options)) { var insertedMeeting = context.Meetings.Find(meeting.Id); context.Entry(insertedMeeting) .Collection(b => b.Races) .Load(); Assert.Equal(3, insertedMeeting.Races.Count()); var trackingEntities = context.ChangeTracker.Entries <Race>().Count(); Assert.Equal(3, trackingEntities); Assert.Equal(insertedMeeting.Id, insertedMeeting.Races.First().MeetingId); } }
public ActionResult Edit([Bind(Include = "MeetingTypeId,MeetingTypeDescription")] MeetingType meetingtype) { if (ModelState.IsValid) { db.Entry(meetingtype).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(meetingtype)); }
public ActionResult Edit([Bind(Include = "ID,Number,Title")] Hymn hymn) { if (ModelState.IsValid) { db.Entry(hymn).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hymn)); }
public ActionResult Edit([Bind(Include = "PersonId,FirstName,LastName,Email,Address,Phone")] Person person) { if (ModelState.IsValid) { _db.Entry(person).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(person)); }
public ActionResult Edit([Bind(Include = "ID,SpeakerName,SubjectTitle")] Subject subject) { if (ModelState.IsValid) { db.Entry(subject).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(subject)); }
public ActionResult Edit([Bind(Include = "ID,MeetingDate,LeaderName,OpeningHymnId,SacramentHymnId,ClosingHymnId,IntermediateHymnId,OpeningPrayer,ClosingPrayer")] Meeting meeting) { if (ModelState.IsValid) { db.Entry(meeting).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(meeting)); }
public ActionResult Edit([Bind(Include = "MeetingItemId,PersonId,MeetingItemDescription,StartDate,DueDate,Priority,Status,PercentageCompleted,CompletedDate")] MeetingItem meetingitem) { if (ModelState.IsValid) { _db.Entry(meetingitem).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PersonId = new SelectList(_db.Persons, "PersonId", "FirstName", meetingitem.PersonId); return(View(meetingitem)); }
public ActionResult Edit([Bind(Include = "MeetingId,MeetingDescription,MeetingDate,StartTime,EndTime,Location,MeetingTypeId")] Meeting meeting) { if (ModelState.IsValid) { db.Entry(meeting).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MeetingTypeId = new SelectList(db.MeetingTypes, "MeetingTypeId", "MeetingTypeDescription", meeting.MeetingTypeId); return(View(meeting)); }
public ActionResult Edit([Bind(Include = "AttendeesId,MeetingId,PersonId")] Attendees attendees) { if (ModelState.IsValid) { _db.Entry(attendees).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MeetingId = new SelectList(_db.Meetings, "MeetingId", "MeetingDescription", attendees.MeetingId); ViewBag.PersonId = new SelectList(_db.Persons, "PersonId", "FirstName", attendees.PersonId); return(View(attendees)); }
public ActionResult Edit([Bind(Include = "MeetingItemStatusId,PersonId,MeetingId,MeetingItemId,CurrentStatus,ActionRequired,DateUpdated")] MeetingItemStatus meetingitemstatus) { if (ModelState.IsValid) { _db.Entry(meetingitemstatus).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MeetingId = new SelectList(_db.Meetings, "MeetingId", "MeetingDescription", meetingitemstatus.MeetingId); ViewBag.MeetingItemId = new SelectList(_db.MeetingItems, "MeetingItemId", "MeetingItemDescription", meetingitemstatus.MeetingItemId); ViewBag.PersonId = new SelectList(_db.Persons, "PersonId", "FirstName", meetingitemstatus.PersonId); return(View(meetingitemstatus)); }