public object Convert(object[] values, Type targetType, object parameter, CultureInfo culture)
        {
            string          SessionGroupName = (string)values[0];
            string          TeamName         = (string)values[1];
            SessionGroupDAL sgd = new SessionGroupDAL();
            SessionGroup    sg  = sgd.FindAll(x => x.Semester.IsActive && x.SessionGroupName == SessionGroupName).FirstOrDefault();

            if (sg == null)
            {
                return(new SolidColorBrush(Colors.Red));
            }
            TeamDAL td = new TeamDAL();
            Team    t  = td.FindAll(x => x.TeamName == TeamName && x.SessionGroupID == sg.ID).FirstOrDefault();

            if (t == null)
            {
                return(new SolidColorBrush(Colors.Red));
            }
            return(new SolidColorBrush(Colors.Black));
        }
Exemple #2
0
        private void DeleteSemester(object param)
        {
            Semester        selectedSemester = (Semester)((DataGrid)param).SelectedItem;
            SessionGroupDAL sessionGroupDal  = new SessionGroupDAL();

            if (selectedSemester.IsActive == true)
            {
                MessageBox.Show("Aktív szemeszter nem törölhető!", "Hiba", MessageBoxButton.OK, MessageBoxImage.Exclamation);
            }
            else if (sessionGroupDal.FindAll(x => x.SemesterID == selectedSemester.ID).FirstOrDefault() != null)
            {
                MessageBox.Show("A félévhez tartozik csoport, ezért nem törölhető!", "Hiba", MessageBoxButton.OK, MessageBoxImage.Exclamation);
            }
            else
            {
                MessageBoxResult messageBoxResult = MessageBox.Show("Valóban törli?", "Törlés megerősítése", MessageBoxButton.YesNo, MessageBoxImage.Question);
                if (messageBoxResult == MessageBoxResult.Yes)
                {
                    SemesterList.Remove(selectedSemester);
                    ((TeacherDAL)_contextDal).DeleteSemester(selectedSemester);
                }
            }
        }
        public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
        {
            UsersDAL ud = new UsersDAL();

            if (value.GetType() == typeof(Users))
            {
                Users val          = (Users)value;
                Users existingUser = new Users();
                switch (parameter)
                {
                case "Email":
                    existingUser = ud.FindAll(x => x.Email == val.Email).FirstOrDefault();
                    break;

                case "Neptun":
                    existingUser = ud.FindAll(x => x.NEPTUN == val.NEPTUN).FirstOrDefault();
                    break;
                }
                if (existingUser == null)
                {
                    return(new SolidColorBrush(Colors.Black));
                }
                return(new SolidColorBrush(Colors.Red));
            }
            else
            {
                string          paramString      = parameter as string;
                string          SessionGroupName = (string)value;
                SessionGroupDAL sgd = new SessionGroupDAL();
                SessionGroup    sg  = sgd.FindAll(x => x.Semester.IsActive && x.SessionGroupName == SessionGroupName).FirstOrDefault();
                if (sg == null)
                {
                    return(new SolidColorBrush(Colors.Red));
                }
                return(new SolidColorBrush(Colors.Black));
            }
        }
Exemple #4
0
        private void ImportStudents()
        {
            bool         duplicateError      = false;
            bool         sessionGroupMissing = false;
            bool         teamMissing         = false;
            List <Users> userList            = new List <Users>();

            foreach (DataRow item in Table.Rows)
            {
                userList.Add((Users)item["User"]);
            }
            var NEPTUNDuplicates = userList.GroupBy(x => x.NEPTUN).Select(c => new { Key = c.Key, total = c.Count() });
            var MailDuplicates   = userList.GroupBy(x => x.Email).Select(c => new { Key = c.Key, total = c.Count() });

            foreach (var item in NEPTUNDuplicates)
            {
                if (item.total > 1)
                {
                    duplicateError = true;
                    break;
                }
            }
            foreach (var item in MailDuplicates)
            {
                if (item.total > 1)
                {
                    duplicateError = true;
                    break;
                }
            }

            UsersDAL        ud  = new UsersDAL();
            SessionGroupDAL sgd = new SessionGroupDAL();
            TeamDAL         td  = new TeamDAL();

            foreach (DataRow item in Table.Rows)
            {
                Users  rowUser          = ((Users)item["User"]);
                string sessiongroupName = (string)item["SessionGroup"];
                string teamName         = (string)item["Team"];
                duplicateError = duplicateError || ud.FindAll().Exists(x => x.Email == rowUser.Email);
                duplicateError = duplicateError || ud.FindAll().Exists(x => x.Email == rowUser.NEPTUN);

                SessionGroup sg = sgd.FindAll(x => x.Semester.IsActive && x.SessionGroupName == sessiongroupName).FirstOrDefault();
                sessionGroupMissing = sessionGroupMissing || (sg == null);
                teamMissing         = teamMissing || sessionGroupMissing;
                if (!teamMissing)
                {
                    Team t = td.FindAll(x => x.SessionGroupID == sg.ID && x.TeamName == teamName).FirstOrDefault();
                    teamMissing = teamMissing || (t == null);
                }
            }
            string errorMessage = "";

            if (duplicateError)
            {
                errorMessage += "\nAz állományban több azonos, vagy a rendszerben már szereplő E-mail cím vagy NEPTUN kód szerepel!";
            }
            if (sessionGroupMissing)
            {
                errorMessage += "\nAz állományban nem létező csoport szerepel!";
            }
            if (teamMissing)
            {
                errorMessage += "\nAz állományban nem létező csapat szerepel!";
            }
            if (!String.IsNullOrEmpty(errorMessage))
            {
                MessageBox.Show("Hiba az importált adatokban!" + errorMessage, "Hiba", MessageBoxButton.OK, MessageBoxImage.Exclamation);
            }
            else
            {
                foreach (DataRow item in Table.Rows)
                {
                    string       sessionGroupName = (string)item["SessionGroup"];
                    string       teamName         = (string)item["Team"];
                    SessionGroup sg = sgd.FindAll(x => x.Semester.IsActive && x.SessionGroupName == sessionGroupName).FirstOrDefault();
                    Team         t  = td.FindAll(x => x.SessionGroupID == sg.ID && x.TeamName == teamName).FirstOrDefault();
                    Student      st = new Student()
                    {
                        TeamID = t.ID
                    };
                    Users u = (Users)item["User"];
                    u.IsPasswordChangeRequired = true;
                    ud.Create(u);
                    st.UserID = u.ID;
                    u.Student.Add(st);
                    ud.Update(u);
                    MailSender.SendMail(u.Email);
                }
                MessageBox.Show("Sikeres importálás!", "", MessageBoxButton.OK);
                this.Close();
            }
        }