private string GetParticipantData(IParticipant participant)
{
string data = participant.Email + ";" + participant.Code + ";" + participant.AttendStatus + ";";
NameValueCollection formfields = AttendRegistrationEngine.GetFormData(participant);
foreach (var key in formfields.AllKeys)
{
data += formfields.Get(key) + ";";
}
return(data);
}
private static string GetParticipantData(IParticipant participant, List <string> formFields)
{
string data = participant.AttendStatus.ToString() + ";" + participant.Email + ";" + participant.Code + ";";
NameValueCollection allFormFields = AttendRegistrationEngine.GetFormData(participant);
if (formFields == null)
{
foreach (var key in allFormFields.AllKeys)
{
data += allFormFields.Get(key).Replace(System.Environment.NewLine, ", ") + ";";
}
}
else
{
foreach (string formField in formFields)
{
if (!string.IsNullOrEmpty(formField))
{
data += AttendRegistrationEngine.GetParticipantInfo(participant, formField).Replace(System.Environment.NewLine, ", ") + ";";
}
}
}
return(data);
}
public static void ExportXLSX(List <IParticipant> participants, List <string> formFields)
{
string eventName = (participants.Count > 0) ? ((participants[0] != null && participants[0].EventPage != null && participants[0].EventPage != PageReference.EmptyReference) ? EPiServer.DataFactory.Instance.Get <PageData>(participants[0].EventPage).URLSegment : "NA") : "NA";
string fileName = EPiServer.Framework.Localization.LocalizationService.Current.GetString("/attend/edit/participants") + " - " + eventName;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");
HttpContext.Current.Response.Charset = Encoding.UTF8.WebName;
HttpContext.Current.Response.ContentEncoding = Encoding.UTF8;
HttpContext.Current.Response.BinaryWrite(Encoding.UTF8.GetPreamble());
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.BufferOutput = true;
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Participants");
if (formFields != null)
{
for (int i = 0; i < formFields.Count; i++)
{
worksheet.Cells[0, i] = new Cell(formFields[i]);
}
}
else if (participants.Count > 0)
{
string[] headers = AttendRegistrationEngine.GetFormData(participants[0]).AllKeys;
worksheet.Cells[0, 0] = new Cell("Status");
worksheet.Cells[0, 1] = new Cell("E-mail");
worksheet.Cells[0, 2] = new Cell("Code");
for (int i = 0; i < headers.Length; i++)
{
worksheet.Cells[0, i + 3] = new Cell(headers[i]);
}
}
for (int i = 0; i < participants.Count; i++)
{
AddParticipantToWorksheet(worksheet, i + 1, participants[i]);
}
// Some Excel versions requires more than 100 rows - adding empty ones
for (int i = participants.Count + 1; i < 150; i++)
{
worksheet.Cells[i, 0] = new Cell(string.Empty);
}
workbook.Worksheets.Add(worksheet);
MemoryStream ms = new MemoryStream();
workbook.SaveToStream(ms);
ms.WriteTo(HttpContext.Current.Response.OutputStream);
HttpContext.Current.Response.End();
}
