示例#1
0
        private void commonSearch()
        {
            string faculty = "";
            string form    = "";

            if (studentFac.SelectedValue != null)
            {
                faculty = studentFac.SelectedValue.ToString();
            }
            if (Form.SelectedValue != null)
            {
                form = Form.SelectedValue.ToString();
            }

            livingTable.ItemsSource = SearchFunctions.commonSearch(globalConnection, (bool)CheckBox1.IsChecked, (bool)CheckBox2.IsChecked, faculty, form, (bool)evictedP.IsChecked);
        }
示例#2
0
        private void Page_Loaded(object sender, RoutedEventArgs e)
        {
            if (searchClass == 0)
            {
                serchString.Visibility = Visibility.Hidden;

                CheckBox1.Visibility = Visibility.Hidden;
                CheckBox2.Visibility = Visibility.Hidden;

                LivingLabel1.Visibility = Visibility.Hidden;
                livingLabel2.Visibility = Visibility.Hidden;
                livingLabel3.Visibility = Visibility.Hidden;
                livingLabel4.Visibility = Visibility.Hidden;

                livingParam.Visibility = Visibility.Hidden;
                roomParam.Visibility   = Visibility.Hidden;

                Citizenship.Visibility = Visibility.Hidden;

                studentFac.Visibility = Visibility.Hidden;
                Form.Visibility       = Visibility.Hidden;

                livingTable.Visibility  = Visibility.Hidden;
                clearFilters.Visibility = Visibility.Hidden;

                roomLable1.Visibility = Visibility.Hidden;
                roomLabel2.Visibility = Visibility.Hidden;

                roomTable.Visibility = Visibility.Hidden;
                type.Visibility      = Visibility.Hidden;

                checkBox3.Visibility  = Visibility.Hidden;
                roomLabel3.Visibility = Visibility.Hidden;

                roomLabel4.Visibility = Visibility.Hidden;
                roomPlaces.Visibility = Visibility.Hidden;

                arcTable.Visibility = Visibility.Hidden;
                arcParam.Visibility = Visibility.Hidden;

                stayLimitLabel1.Visibility   = Visibility.Hidden;
                stayLimitLabel2.Visibility   = Visibility.Hidden;
                stayLimitComboBox.Visibility = Visibility.Hidden;
                stayLimitLabel3.Visibility   = Visibility.Hidden;

                evictedP.Visibility = Visibility.Hidden;

                arcDate1.Visibility  = Visibility.Hidden;
                arcDate2.Visibility  = Visibility.Hidden;
                arcLabel1.Visibility = Visibility.Hidden;
                arcLabel2.Visibility = Visibility.Hidden;
            }

            if (searchClass == 1)
            {
                serchString.Visibility = Visibility.Hidden;

                CheckBox1.Visibility = Visibility.Visible;
                CheckBox2.Visibility = Visibility.Visible;

                LivingLabel1.Visibility = Visibility.Visible;
                livingLabel2.Visibility = Visibility.Visible;
                livingLabel3.Visibility = Visibility.Visible;
                livingLabel4.Visibility = Visibility.Visible;

                livingParam.Visibility = Visibility.Visible;
                roomParam.Visibility   = Visibility.Hidden;

                Citizenship.Visibility = Visibility.Hidden;

                studentFac.Visibility = Visibility.Visible;
                Form.Visibility       = Visibility.Visible;

                livingTable.Visibility  = Visibility.Visible;
                clearFilters.Visibility = Visibility.Visible;

                roomLable1.Visibility = Visibility.Hidden;
                roomLabel2.Visibility = Visibility.Hidden;

                roomTable.Visibility = Visibility.Hidden;
                type.Visibility      = Visibility.Hidden;

                checkBox3.Visibility  = Visibility.Hidden;
                roomLabel3.Visibility = Visibility.Hidden;

                roomLabel4.Visibility = Visibility.Hidden;
                roomPlaces.Visibility = Visibility.Hidden;

                arcTable.Visibility = Visibility.Hidden;
                arcParam.Visibility = Visibility.Hidden;

                stayLimitLabel1.Visibility   = Visibility.Hidden;
                stayLimitLabel2.Visibility   = Visibility.Hidden;
                stayLimitComboBox.Visibility = Visibility.Hidden;
                stayLimitLabel3.Visibility   = Visibility.Hidden;

                arcDate1.Visibility  = Visibility.Hidden;
                arcDate2.Visibility  = Visibility.Hidden;
                arcLabel1.Visibility = Visibility.Hidden;
                arcLabel2.Visibility = Visibility.Hidden;

                evictedP.Visibility = Visibility.Visible;
                evictedP.IsEnabled  = false;

                CheckBox1.IsChecked       = true;
                Search.SelectedIndex      = 0;
                livingParam.SelectedIndex = -1;
                livingTable.ItemsSource   = SearchFunctions.commonSearch(globalConnection, true, false, "", "", false);
            }

            if (searchClass == 2)
            {
                serchString.Visibility = Visibility.Hidden;

                CheckBox1.Visibility = Visibility.Visible;
                CheckBox2.Visibility = Visibility.Visible;

                LivingLabel1.Visibility = Visibility.Hidden;
                livingLabel2.Visibility = Visibility.Visible;
                livingLabel3.Visibility = Visibility.Visible;
                livingLabel4.Visibility = Visibility.Visible;

                livingParam.Visibility = Visibility.Visible;
                roomParam.Visibility   = Visibility.Hidden;

                Citizenship.Visibility = Visibility.Hidden;

                studentFac.Visibility = Visibility.Visible;
                Form.Visibility       = Visibility.Visible;

                livingTable.Visibility  = Visibility.Visible;
                clearFilters.Visibility = Visibility.Visible;

                roomLable1.Visibility = Visibility.Hidden;
                roomLabel2.Visibility = Visibility.Hidden;

                roomTable.Visibility = Visibility.Hidden;
                type.Visibility      = Visibility.Hidden;

                checkBox3.Visibility  = Visibility.Hidden;
                roomLabel3.Visibility = Visibility.Hidden;

                roomLabel4.Visibility = Visibility.Hidden;
                roomPlaces.Visibility = Visibility.Hidden;

                arcTable.Visibility = Visibility.Hidden;
                arcParam.Visibility = Visibility.Hidden;

                stayLimitLabel1.Visibility   = Visibility.Visible;
                stayLimitLabel2.Visibility   = Visibility.Visible;
                stayLimitComboBox.Visibility = Visibility.Visible;
                stayLimitLabel3.Visibility   = Visibility.Visible;

                arcDate1.Visibility  = Visibility.Hidden;
                arcDate2.Visibility  = Visibility.Hidden;
                arcLabel1.Visibility = Visibility.Hidden;
                arcLabel2.Visibility = Visibility.Hidden;

                evictedP.Visibility = Visibility.Visible;

                stayLimitComboBox.IsEnabled = false;
                CheckBox1.IsChecked         = true;
                Search.SelectedIndex        = 0;
                livingParam.SelectedIndex   = 6;
                livingTable.ItemsSource     = SearchFunctions.search_byStayLimit(globalConnection, "", true, false, "", "");
            }

            if (searchClass == 3)
            {
                serchString.Visibility = Visibility.Hidden;

                CheckBox1.Visibility = Visibility.Visible;
                CheckBox2.Visibility = Visibility.Visible;

                LivingLabel1.Visibility = Visibility.Visible;
                livingLabel2.Visibility = Visibility.Visible;
                livingLabel3.Visibility = Visibility.Visible;
                livingLabel4.Visibility = Visibility.Visible;

                livingParam.Visibility = Visibility.Visible;
                roomParam.Visibility   = Visibility.Hidden;

                Citizenship.Visibility = Visibility.Hidden;

                studentFac.Visibility = Visibility.Visible;
                Form.Visibility       = Visibility.Visible;

                livingTable.Visibility  = Visibility.Visible;
                clearFilters.Visibility = Visibility.Visible;

                roomLable1.Visibility = Visibility.Hidden;
                roomLabel2.Visibility = Visibility.Hidden;

                roomTable.Visibility = Visibility.Hidden;
                type.Visibility      = Visibility.Hidden;

                checkBox3.Visibility  = Visibility.Hidden;
                roomLabel3.Visibility = Visibility.Hidden;

                roomLabel4.Visibility = Visibility.Hidden;
                roomPlaces.Visibility = Visibility.Hidden;

                arcTable.Visibility = Visibility.Hidden;
                arcParam.Visibility = Visibility.Hidden;

                stayLimitLabel1.Visibility   = Visibility.Hidden;
                stayLimitLabel2.Visibility   = Visibility.Hidden;
                stayLimitComboBox.Visibility = Visibility.Hidden;
                stayLimitLabel3.Visibility   = Visibility.Hidden;

                arcDate1.Visibility  = Visibility.Hidden;
                arcDate2.Visibility  = Visibility.Hidden;
                arcLabel1.Visibility = Visibility.Hidden;
                arcLabel2.Visibility = Visibility.Hidden;

                evictedP.Visibility = Visibility.Visible;
                evictedP.IsEnabled  = true;
                evictedP.IsChecked  = true;

                CheckBox1.IsChecked       = false;
                Search.SelectedIndex      = 0;
                livingParam.SelectedIndex = -1;
                livingTable.ItemsSource   = SearchFunctions.search_exEvicted(globalConnection);
                //livingTable.ItemsSource = SearchFunctions.commonSearch(globalConnection, true, false, "", "", false);
            }
        }