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)
{
}
}
}
public void RemoveCheckIn()
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
List <CheckInDto> checkInDtos = (List <CheckInDto>)memberWindow.DefaulData;
checkInDao.DeleteById(checkInDtos[memberWindow.SelectedIndex].EventAttendeesID);
}
public void CheckIn()
{
BitmapSource srs = (BitmapSource)checkInWindow.ImageSource;
Bitmap bitmap = null;
if (srs != null)
{
using (MemoryStream outStream = new MemoryStream())
{
BitmapEncoder enc = new BmpBitmapEncoder();
enc.Frames.Add(BitmapFrame.Create(srs));
enc.Save(outStream);
bitmap = new Bitmap(outStream);
}
}
try
{
String content = QRModuleLib.QRModule.DecodeFromQRCode(bitmap);
DataEncryption dataEncryption = new DataEncryption(null, content);
content = dataEncryption.InputCode;
if (content == null)
{
checkInWindow.Status = "Waiting....";
}
else
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
try
{
int id = int.Parse(content);
CheckInDto checkInDto = checkInDao.CheckInByAttendeesID(id);
if (checkInDto.Check)
{
checkInWindow.Status = "QR code is checked!";
}
else
{
checkInDao.UpdateStatus(id, true);
LoadMemberEvent();
checkInWindow.Status = checkInDto.Name;
}
}
catch
{
checkInWindow.Status = "QR code is not existed!";
}
}
}
catch (NullReferenceException ex)
{
checkInWindow.Status = "Waiting";
}
}
public void LoadMemberEvent()
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
memberWindow.DefaulData = checkInDao.ReadData(memberWindow.Id, memberWindow.Search);
List <dynamic> checkInShowList = new List <dynamic>();
int count = 1;
foreach (CheckInDto checkInDto in checkInDao.ReadData(memberWindow.Id, memberWindow.Search))
{
checkInShowList.Add(new { NO = count, Name = checkInDto.Name, Email = checkInDto.Email, Other = checkInDto.Other });
count++;
}
memberWindow.ShowData = checkInShowList;
}
public void SubmitCheckIn()
{
EventDao eventDao = new EventDao();
eventDao.MakeConnection(Properties.Resources.strConnection);
eventDao.UpdateStatus(checkInWindow.EventID, "checked in");
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
List <CheckInDto> checkInDtos = (List <CheckInDto>)checkInWindow.MemberInEventData;
List <CheckBox> checkBoxes = (List <CheckBox>)checkInWindow.MemberInEventShow;
foreach (CheckInDto checkInDto in checkInDtos)
{
checkInDao.UpdateStatus(checkInDto.EventAttendeesID, (bool)checkBoxes[checkInDtos.IndexOf(checkInDto)].IsChecked);
}
}
public bool AddEvent()
{
if (addEventWindow.EventName.Length == 0)
{
addEventWindow.Status = "Event name is empty";
return(false);
}
if (addEventWindow.EventName.Length > 50)
{
addEventWindow.Status = "Event name have length lower than 50";
return(false);
}
EventDao eventDao = new EventDao();
eventDao.MakeConnection(Properties.Resources.strConnection);
if (eventDao.Create(new EventDto(addEventWindow.EventName, addEventWindow.Desciption, "", ((App)Application.Current).UserName)))
{
List <CheckBox> groupShowList = (List <CheckBox>)addEventWindow.Group;
int index = 0;
foreach (CheckBox checkBox in groupShowList)
{
if ((bool)checkBox.IsChecked)
{
EventAttendeesDao eventAttendeesDao = new EventAttendeesDao();
List <GroupDto> groupDtos = (List <GroupDto>)addEventWindow.GroupData;
eventAttendeesDao.MakeConnection(Properties.Resources.strConnection);
List <EventAttendeesDto> eventAttendeesDtos = eventAttendeesDao.ReadData(groupDtos[index].Id, "");
foreach (EventAttendeesDto eventAttendeesDto in eventAttendeesDtos)
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
CheckInDto checkInDto = new CheckInDto();
checkInDto.EventID = eventDao.GetLastId();
checkInDto.Name = eventAttendeesDto.Name;
checkInDto.Email = eventAttendeesDto.Email;
checkInDto.Other = eventAttendeesDto.Other;
checkInDao.Create(checkInDto);
}
}
index++;
}
}
return(true);
}
public void LoadMemberEvent()
{
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
checkInWindow.MemberInEventData = checkInDao.ReadData(checkInWindow.EventID, "");
List <CheckBox> checkInShowList = new List <CheckBox>();
int count = 1;
foreach (CheckInDto checkInDto in checkInDao.ReadData(checkInWindow.EventID, ""))
{
CheckBox checkBox = new CheckBox();
checkBox.Content = checkInDto.Name + " | " + checkInDto.Email;
checkBox.IsChecked = checkInDto.Check;
checkInShowList.Add(checkBox);
count++;
}
checkInWindow.MemberInEventShow = checkInShowList;
}
public bool AddMemberInEvent()
{
if (detailMemberWindow.DataName.Length == 0)
{
detailMemberWindow.Status = "Member name is empty";
return(false);
}
if (!IsValidEmail(detailMemberWindow.Email))
{
detailMemberWindow.Status = "Email invalidate";
return(false);
}
CheckInDao checkInDao = new CheckInDao();
checkInDao.MakeConnection(Properties.Resources.strConnection);
CheckInDto checkInDto = new CheckInDto();
checkInDto.Name = detailMemberWindow.DataName;
checkInDto.Email = detailMemberWindow.Email;
checkInDto.Other = detailMemberWindow.Other;
checkInDto.EventID = detailMemberWindow.Id;
return(checkInDao.Create(checkInDto));
}
