public void ImportDataFromExcel()
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Excel file (*.xlsx)|*.xlsx";
if ((bool)openFileDialog.ShowDialog())
{
try
{
ExcelConnection.ExcelConnect excelConnect = new ExcelConnection.ExcelConnect();
List <EventAttendeesDtoExcel> eventAttendeesDtoExcels = excelConnect.ImportExcel <EventAttendeesDtoExcel>(openFileDialog.FileName);
EventAttendeesDao eventAttendeesDao = new EventAttendeesDao();
eventAttendeesDao.MakeConnection(Properties.Resources.strConnection);
foreach (EventAttendeesDtoExcel eventAttendeesDtoExcel in eventAttendeesDtoExcels)
{
EventAttendeesDto eventAttendeesDto = new EventAttendeesDto();
eventAttendeesDto.Name = eventAttendeesDtoExcel.Name;
eventAttendeesDto.Email = eventAttendeesDtoExcel.Email;
eventAttendeesDto.Other = eventAttendeesDtoExcel.Other;
eventAttendeesDto.GroupID = memberWindow.Id;
eventAttendeesDao.Create(eventAttendeesDto);
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
}
public void ExportReportToExcel()
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel file (*.xlsx)|*.xlsx";
if ((bool)saveFileDialog.ShowDialog())
{
try
{
ExcelConnection.ExcelConnect excelConnect = new ExcelConnection.ExcelConnect();
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
List <EventDto> events = (List <EventDto>)mainWindow.OldEventData;
List <CheckInDto> checkInDtos = checkInDao.ReadData(events[mainWindow.SelectIndexOldEvent].Id, "");
List <EventAttendeesDtoToExportReport> eventAttendeesDtoToExportReports = new List <EventAttendeesDtoToExportReport>();
foreach (CheckInDto checkInDto in checkInDtos)
{
EventAttendeesDtoToExportReport eventAttendeesDtoToExportReport = new EventAttendeesDtoToExportReport();
eventAttendeesDtoToExportReport.Name = checkInDto.Name;
eventAttendeesDtoToExportReport.Email = checkInDto.Email;
eventAttendeesDtoToExportReport.Other = checkInDto.Other;
eventAttendeesDtoToExportReport.IsChecked = checkInDto.Check;
eventAttendeesDtoToExportReports.Add(eventAttendeesDtoToExportReport);
}
excelConnect.ExportExcel(eventAttendeesDtoToExportReports, saveFileDialog.FileName);
}
catch (Exception e)
{
}
}
}