// GET: Engagement/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var engagement = await _context.Engagement.SingleOrDefaultAsync(m => m.Id == id);
if (engagement == null)
{
return(NotFound());
}
var alumSpeakerId = _context.EngagementAlum.Where(ea => ea.EngagementId == id).Single().AlumId;
var alumSpeaker = _context.Alum.Where(a => a.Id == alumSpeakerId).Single();
var currentSpeaker = "";
if (alumSpeaker.LastName == "(NONE)")
{
currentSpeaker = alumSpeaker.LastName;
}
else
{
currentSpeaker = alumSpeaker.LastName + ", " + alumSpeaker.FirstName;
}
var currentStaff = _context.Staff.Where(s => s.Id == engagement.StaffId).Single().Name;
EngagementComments currentEngagementComments = new EngagementComments()
{
Date = engagement.Date,
Organizer = _context.Staff.Where(s => s.Id == engagement.StaffId).Single().Name,
Description = engagement.Description,
EngagementType = _context.EngagementType.Where(et => et.Id == engagement.EngagementTypeId),
Comment = _context.Note.Where(n => n.Id == engagement.NoteId).Single().Detail
};
ViewData["CurrentAlum"] = currentSpeaker;
ViewData["CurrentEngagementId"] = id;
ViewData["CurrentEngagementType"] = _context.EngagementType.Where(et => et.Id == engagement.EngagementTypeId).Single().Name;
ViewData["CurrentMeetup"] = _context.Meetup.Where(m => m.Id == engagement.MeetupId).Single().Name;
ViewData["CurrentTech"] = _context.Tech.Where(t => t.Id == engagement.TechId).Single().Name;
return(View(currentEngagementComments));
}
// GET: Engagement/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var engagement = await _context.Engagement.SingleOrDefaultAsync(m => m.Id == id);
if (engagement == null)
{
return(NotFound());
}
var alumSpeakerId = _context.EngagementAlum.Where(ea => ea.EngagementId == id).Single().AlumId;
var alumSpeaker = _context.Alum.Where(a => a.Id == alumSpeakerId).Single();
var currentSpeaker = "";
if (alumSpeaker.LastName == "(NONE)")
{
currentSpeaker = alumSpeaker.LastName;
}
else
{
currentSpeaker = alumSpeaker.LastName + ", " + alumSpeaker.FirstName;
}
var currentStaff = _context.Staff.Where(s => s.Id == engagement.StaffId).Single().Name;
EngagementComments engagementCommentsToUpdate = new EngagementComments()
{
Date = engagement.Date,
Organizer = currentStaff,
Description = engagement.Description,
EngagementType = _context.EngagementType.Where(et => et.Id == engagement.EngagementTypeId),
Alum = _context.Alum,
Meetup = _context.Meetup.Where(m => m.Id == engagement.MeetupId),
Tech = _context.Tech.Where(t => t.Id == engagement.TechId),
Comment = _context.Note.Where(n => n.Id == engagement.NoteId).Single().Detail,
};
ViewData["AlumList"] =
new SelectList((from a in _context.Alum.OrderBy(a => a.LastName).ToList()
select new
{
Id = a.Id,
FullName = a.LastName + ", " + a.FirstName
}),
"Id",
"FullName",
null);
ViewData["CurrentAlum"] = currentSpeaker;
ViewData["CurrentOrganizer"] = currentStaff;
ViewData["CurrentEngagementType"] = _context.EngagementType.Where(et => et.Id == engagement.EngagementTypeId).Single().Name;
ViewData["CurrentMeetup"] = _context.Meetup.Where(m => m.Id == engagement.MeetupId).Single().Name;
ViewData["CurrentTech"] = _context.Tech.Where(t => t.Id == engagement.TechId).Single().Name;
ViewData["EngagementTypeId"] = new SelectList(_context.EngagementType, "Id", "Name", engagement.EngagementTypeId);
ViewData["MeetupId"] = new SelectList(_context.Meetup, "Id", "Name", engagement.MeetupId);
ViewData["NoteId"] = new SelectList(_context.Note, "Id", "Detail", engagement.NoteId);
ViewData["TechId"] = new SelectList(_context.Tech, "Id", "Name", engagement.TechId);
ViewData["OrganizerId"] = new SelectList(_context.Staff, "Id", "Name", engagement.StaffId);
return(View(engagementCommentsToUpdate));
}
