Beispiel #1
0
        private bool CoursePeriodPreferences(PreferencesControl child, int teacherId)
        {
            int cRow    = int.Parse(child.Row);
            int cColumn = int.Parse(child.Column);

            if (teacherId > 0)
            {
                DataTable teacherData = DBConnection.Select("teacher_periods_preferences ", " day, period  ", " teacher_id =" + teacherId + " AND day=" + cColumn + " AND period=" + cRow);

                if (teacherData != null && teacherData.Rows.Count > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            return(false);
        }
Beispiel #2
0
        public void initPanels()
        {
            int iRow = -1;

            foreach (RowDefinition row in GridMain.RowDefinitions)
            {
                iRow++;
                int iCol = -1;
                PreferencesControl pPanel;
                foreach (ColumnDefinition col in GridMain.ColumnDefinitions)
                {
                    iCol++;

                    if (iRow == 0)
                    {
                        pPanel = new PreferencesControl(new List <int>(), null, null, int.Parse(comboBoxTeacher.SelectedValue.ToString()));
                        switch (iCol)
                        {
                        case 1:
                            pPanel.Caption = "Monday";
                            break;

                        case 2:
                            pPanel.Caption = "Tuesday";
                            break;

                        case 3:
                            pPanel.Caption = "Wednesday";
                            break;

                        case 4:
                            pPanel.Caption = "Thursday";
                            break;

                        case 5:
                            pPanel.Caption = "Friday";
                            break;

                        case 6:
                            pPanel.Caption = "Saturday";
                            break;

                        case 7:
                            pPanel.Caption = "Sunday";
                            break;

                        default:
                            pPanel.Caption = "";
                            break;
                        }
                    }
                    else
                    {
                        switch (iCol)
                        {
                        case 0:
                            pPanel         = new PreferencesControl(new List <int>(), null, null, int.Parse(comboBoxTeacher.SelectedValue.ToString()));
                            pPanel.Caption = "";

                            switch (iRow)
                            {
                            case 1:
                                pPanel.Caption = "08:00-09:00";
                                break;

                            case 2:
                                pPanel.Caption = "09:00-10:00";
                                break;

                            case 3:
                                pPanel.Caption = "10:00-11:00";
                                break;

                            case 4:
                                pPanel.Caption = "11:00-12:00";
                                break;

                            case 5:
                                pPanel.Caption = "12:00-13:00";
                                break;

                            case 6:
                                pPanel.Caption = "13:00-14:00";
                                break;

                            case 7:
                                pPanel.Caption = "14:00-15:00";
                                break;

                            case 8:
                                pPanel.Caption = "15:00-16:00";
                                break;

                            case 9:
                                pPanel.Caption = "16:00-17:00";
                                break;

                            case 10:
                                pPanel.Caption = "17:00-18:00";
                                break;

                            case 11:
                                pPanel.Caption = "18:00-19:00";
                                break;

                            case 12:
                                pPanel.Caption = "19:00-20:00";
                                break;

                            case 13:
                                pPanel.Caption = "20:00-21:00";
                                break;

                            case 14:
                                pPanel.Caption = "21:00-22:00";
                                break;

                            default:
                                pPanel.Caption = "";
                                break;
                            }
                            break;

                        default:
                            pPanel         = new PreferencesControl(teacherCourses, iRow.ToString(), iCol.ToString(), int.Parse(comboBoxTeacher.SelectedValue.ToString()));
                            pPanel.Caption = "";
                            break;
                        }
                    }

                    Grid.SetColumn(pPanel, iCol);
                    Grid.SetRow(pPanel, iRow);

                    GridMain.Children.Add(pPanel);
                }
            }
        }