private DataTable GetEventResults(long eventId)
        {
            DataTable results = new DataTable();

            using (EventRegistrationManager erManager = new EventRegistrationManager())
            {
                List <EventRegistration> eventRegistrations = erManager.GetAllRegistrationsByEvent(eventId);

                if (eventRegistrations.Count != 0)
                {
                    XmlNodeReader xmlNodeReader = new XmlNodeReader(eventRegistrations[0].Data);
                    results = CreateDataTableColums(results, XElement.Load(xmlNodeReader));
                    xmlNodeReader.Dispose();
                }

                foreach (EventRegistration er in eventRegistrations)
                {
                    XmlNodeReader xmlNodeReader = new XmlNodeReader(er.Data);
                    results.Rows.Add(AddDataRow(XElement.Load(xmlNodeReader), results));
                    xmlNodeReader.Dispose();
                }
            }

            return(results);
        }
        public EventRegistrationModel(Event e)
        {
            Event       = new EventModel(e);
            EditAllowed = e.EditAllowed;

            using (EventRegistrationManager erManger = new EventRegistrationManager())
            {
                NumberOfRegistration = erManger.GetAllRegistrationsByEvent(e.Id).Count();
            }
        }
        private DataTable GetEventRegistration(long eventId, XDocument data)
        {
            DataTable results = new DataTable();

            using (EventRegistrationManager erManager = new EventRegistrationManager())
            {
                XmlNodeReader xmlNodeReader = new XmlNodeReader(XmlMetadataWriter.ToXmlDocument(data));
                results = CreateDataTableColums(results, XElement.Load(xmlNodeReader));
                results.Rows.Add(AddDataRow(XElement.Load(xmlNodeReader), results));
                xmlNodeReader.Dispose();
            }
            return(results);
        }