public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Event = await _context.Events
.Include(e => e.Organizer)
.FirstOrDefaultAsync(m => m.EventID == id);
AttendeeEvent attendeeEvent = await _context.AttendeeEvents
.Where(a => a.Attendee.AttendeeID == 1 && a.EventID == id)
.FirstOrDefaultAsync();
if (attendeeEvent != null)
{
AttendeeIsAttending = true;
}
if (Event == null)
{
return(NotFound());
}
return(Page());
}
public static void Register(EventContext context, int attendeeId, int eventId)
{
context.Database.EnsureCreated();
var AttendeeEvent = new AttendeeEvent
{
AttendeeId = attendeeId,
EventId = eventId
};
context.AttendeeEvent.Add(AttendeeEvent);
context.SaveChanges();
}
public async Task <IActionResult> OnGetAsync(int?id)
{
AttendeeEvent joinedEvent = new AttendeeEvent()
{
Attendee = await _context.Attendee.Where(a => a.ID == 8675).FirstOrDefaultAsync(),
Event = await _context.Event.Where(e => e.ID == id).FirstOrDefaultAsync()
};
_context.AttendeeEvents.Add(joinedEvent);
await _context.SaveChangesAsync();
return(RedirectToPage("../Events/Details", new { id }));
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AttendeeEvent = await _context.AttendeeEvents.FindAsync(id);
if (AttendeeEvent != null)
{
_context.AttendeeEvents.Remove(AttendeeEvent);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AttendeeEvent = await _context.AttendeeEvents
.Include(a => a.Attendee)
.Include(a => a.Event).FirstOrDefaultAsync(m => m.AttendeeEventID == id);
if (AttendeeEvent == null)
{
return(NotFound());
}
return(Page());
}
private void dgvAttendeeEvent_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvAttendeeEvent.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.Equals("Delete"))
{
DialogResult dialogResult = MessageBox.Show("Are you sure ?", "Confirm Delete", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
int attendeeId = Convert.ToInt32(dgvAttendeeEvent.Rows[e.RowIndex].Cells["AttendeeId"].Value);
int eventId = Convert.ToInt32(dgvAttendeeEvent.Rows[e.RowIndex].Cells["EventId"].Value);
AttendeeEvent attendeeEvent = dbContext.AttendeeEvents.Where(ae => ae.AttendeeId == attendeeId).Where(ae => ae.EventId == eventId).Single();
dbContext.AttendeeEvents.Remove(attendeeEvent);
dbContext.SaveChanges();
MessageBox.Show("Attendee removed from the event");
loadDGV();
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
//using (dbContext = new ConventionManagerDbContext())
//{
MethodController methodController = new MethodController();
if (methodController.roomCapacityStatus((int)cbxEvent.SelectedValue, true))
{
AttendeeEvent attendeeEvent = new AttendeeEvent()
{
AttendeeId = (int)cbxAttendee.SelectedValue,
EventId = (int)cbxEvent.SelectedValue
};
Event _eve = dbContext.Events.Find(attendeeEvent.EventId);
if (methodController.attendeeStatus(attendeeEvent.AttendeeId, _eve.EventStartDate, _eve.EventEndDate))
{
dbContext.AttendeeEvents.Add(attendeeEvent);
try
{
dbContext.SaveChanges();
MessageBox.Show("Attendee added to the event successfully!!!");
updateGBXEvent((int)cbxEvent.SelectedValue);
loadDGV();
return;
}
catch (Exception ex)
{
MessageBox.Show("Duplicate entry!!!");
return;
}
}
else
{
MessageBox.Show("Attendee busy on other event or seminar or stall");
}
}
else
{
MessageBox.Show("Booking full!!!");
return;
}
//}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AttendeeEvent joinEvent = new AttendeeEvent()
{
Attendee = await _context.Attendees.Where(a => a.Name == "Samme").FirstOrDefaultAsync(),
Event = await _context.Events.Where(e => e.EventID == id).FirstOrDefaultAsync()
};
_context.AttendeeEvents.Add(joinEvent);
await _context.SaveChangesAsync();
return(RedirectToPage("./Details", new { id = id }));
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Event = await _context.Event.FirstOrDefaultAsync(m => m.ID == id);
AttendeeEvent AttendeeEvent = await _context.AttendeeEvents.Where(ae => ae.Attendee.ID == 8675 && ae.Event.ID == id).FirstOrDefaultAsync();
if (AttendeeEvent != default)
{
IsJoined = true;
}
if (Event == null)
{
return(NotFound());
}
return(Page());
}
