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