public bool SendMail()
        {
            if (mailWindow.Subject.Length == 0)
            {
                mailWindow.Status = "Subject is empty";
                return(false);
            }
            if (mailWindow.MailContent.Length == 0)
            {
                mailWindow.Status = "Content is empty";
                return(false);
            }
            List <CheckInDto> checkInDtos = (List <CheckInDto>)mailWindow.EmailData;

            foreach (CheckInDto checkInDto in checkInDtos)
            {
                try
                {
                    DataEncryption dataEncryption = new DataEncryption(checkInDto.EventAttendeesID.ToString(), null);
                    QRModuleLib.QRModule.CreateQRCode(dataEncryption.OutputCode, checkInDto.EventAttendeesID + ".png", mailWindow.EventId);
                    EmailLibrary.Email.SendEMail(Properties.Resources.email, Properties.Resources.password, checkInDto.Email, mailWindow.Subject, mailWindow.MailContent, mailWindow.EventId + "/" + checkInDto.EventAttendeesID + ".png");
                }
                catch
                {
                    mailWindow.Status = "Something email address is not exits";
                    return(false);
                }
            }
            EventDao eventDao = new EventDao();

            eventDao.MakeConnection(Properties.Resources.strConnection);
            eventDao.UpdateStatus(int.Parse(mailWindow.EventId), "sended mail");
            return(true);
        }
        public void RemoveEvent()
        {
            EventDao eventDao = new EventDao();

            eventDao.MakeConnection(Properties.Resources.strConnection);
            List <EventDto> events = (List <EventDto>)mainWindow.EventData;

            eventDao.DeleteById(events[mainWindow.SelectIndexEvent].Id);
        }
        public void LoadEvent()
        {
            EventDao eventDao = new EventDao();

            eventDao.MakeConnection(Properties.Resources.strConnection);
            mainWindow.EventData = eventDao.ReadData(((App)Application.Current).UserName, mainWindow.SearchEvent);
            List <dynamic> eventShowList = new List <dynamic>();
            int            count         = 1;

            foreach (EventDto eventDto in eventDao.ReadData(((App)Application.Current).UserName, mainWindow.SearchEvent))
            {
                eventShowList.Add(new { NO = count, Name = eventDto.Name, Description = eventDto.Description, Status = eventDto.Status });
                count++;
            }
            mainWindow.DataEvent = eventShowList;
        }
        public bool UpdateEvent()
        {
            if (detailWindow.DetailName.Length == 0)
            {
                detailWindow.Status = "Event name is empty";
                return(false);
            }
            EventDao eventDao = new EventDao();

            eventDao.MakeConnection(Properties.Resources.strConnection);
            EventDto eventDto = new EventDto();

            eventDto.Name        = detailWindow.DetailName;
            eventDto.Description = detailWindow.Desciption;
            eventDto.Id          = detailWindow.Id;
            return(eventDao.Update(eventDto));
        }
        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);
        }