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)); }