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 bool AddMemberInGroup()
{
if (detailMemberWindow.DataName.Length == 0)
{
detailMemberWindow.Status = "Member name is empty";
return(false);
}
if (!IsValidEmail(detailMemberWindow.Email))
{
detailMemberWindow.Status = "Email invalidate";
return(false);
}
EventAttendeesDao eventAttendeesDao = new EventAttendeesDao();
eventAttendeesDao.MakeConnection(Properties.Resources.strConnection);
EventAttendeesDto eventAttendeesDto = new EventAttendeesDto();
eventAttendeesDto.Name = detailMemberWindow.DataName;
eventAttendeesDto.Email = detailMemberWindow.Email;
eventAttendeesDto.Other = detailMemberWindow.Other;
eventAttendeesDto.GroupID = detailMemberWindow.Id;
return(eventAttendeesDao.Create(eventAttendeesDto));
}