public JsonResult GetAudiences(int id)
 {
     var audienceManager = new DataAccess.AudienceManager();
     var audiences = audienceManager.GetAudiencesByEventID(id).Select(model => new
     {
         ID = model.AudienceID,
         Name = model.Name,
         Contact = model.Contact,
         VisitDate = model.VisitDate.ToString("MMM dd,yyyy"),
         ConventionName = (model.Convention == null ? (model.Event == null ? "-" : model.Event.convention.Name) : model.Convention.Name),
         Status = model.BookingStatus == 1 ? "In Progress" : (model.BookingStatus == 2 ? "Booked" : "Reach"),
         FSMName = string.IsNullOrWhiteSpace(model.FSMName) ? " - " : model.FSMName,
         Attended = model.IsAttended,
         GSBAmount = model.GSBAmount,
         DonationAmount = model.Amount
     }).ToList();
     return Json(new { data = audiences });
 }