Beispiel #1
0
        // Land Combobox füllen
        private void FillCountryCombobox()
        {
            var res = _mainLogic.SelectData(DbType.MySql, "SELECT * FROM fisch_fauna.bio_country");

            for (int i = 0; i < res.Count; i++)
            {
                int id = i;
                string text = res[i].First(p => p.Key == "countryname").Value as string;
                string valueString = res[i].First(p => p.Key == "countryid").Value as string;

                ComboBoxItem newItem = new ComboBoxItem(id, text, false) { ValueString = valueString };
                countryComboBox.Items.Add(newItem);
            }

            countryComboBox.DisplayMember = "text";

            if (countryComboBox.Items.Count > 0)
            {
                countryComboBox.SelectedIndex = 0;
            }
        }
Beispiel #2
0
        // Quellart Combobox füllen
        private void FillSourceTypeCombobox()
        {
            var res = _mainLogic.SelectData(DbType.MySql, "SELECT * FROM fisch_fauna.bio_sourcetype");

            foreach (var item in res)
            {
                int id = int.Parse(item.First(p => p.Key == "sourcetypeid").Value.ToString());
                string value = item.First(p => p.Key == "sourcename").Value as string;

                ComboBoxItem newItem = new ComboBoxItem(id, value, false);
                sourceTypeComboBox.Items.Add(newItem);
            }

            sourceTypeComboBox.DisplayMember = "text";

            if (sourceTypeComboBox.Items.Count > 0)
            {
                sourceTypeComboBox.SelectedIndex = 0;
            }
        }
Beispiel #3
0
        // Import-Benutzer Combobox füllen
        private void FillImportUsersCombobox()
        {
            var res = _mainLogic.SelectData(DbType.MySql, "select * from bio_editor");

            foreach (var item in res)
            {
                int id = int.Parse(item.First(p => p.Key == "editorid").Value.ToString());
                string value = item.First(p => p.Key == "editorname").Value as string;

                ComboBoxItem newItem = new ComboBoxItem(id, value, false);
                editorCombobox.Items.Add(newItem);
            }

            editorCombobox.DisplayMember = "text";

            if (editorCombobox.Items.Count > 0)
            {
                editorCombobox.SelectedIndex = 0;
            }
        }
Beispiel #4
0
        // Eintrags-Qualität Combobox füllen
        private void FillRecordQualityCombobox()
        {
            var res = _mainLogic.SelectData(DbType.MySql, "SELECT * FROM fisch_fauna.bio_record_quality");

            foreach (var item in res)
            {
                int id = int.Parse(item.First(p => p.Key == "recordqualityid").Value.ToString());
                string value = item.First(p => p.Key == "recordquality").Value as string;

                ComboBoxItem newItem = new ComboBoxItem(id, value, false);
                recordQualityComboBox.Items.Add(newItem);
            }

            recordQualityComboBox.DisplayMember = "text";

            if (recordQualityComboBox.Items.Count > 0)
            {
                recordQualityComboBox.SelectedIndex = 0;
            }
        }
Beispiel #5
0
        // Import Combobox füllen
        private void FillImportsCombobox()
        {
            var res = _mainLogic.SelectData(DbType.Postgres, "select * from public.imports", _sourceCon);

            foreach (var item in res)
            {
                int id = int.Parse(item.First(p => p.Key == "id").Value.ToString());
                bool imported = (bool)item.First(p => p.Key == "imported").Value;
                string fileName = (imported ? "[BEREITS IMPORTIERT]" : string.Empty) + item.First(p => p.Key == "filename").Value;

                ComboBoxItem newItem = new ComboBoxItem(id, fileName, !imported);
                importsCbx.Items.Add(newItem);
            }

            importsCbx.DisplayMember = "text";
            importsCbx.SelectedIndexChanged += importsCbx_SelectedIndexChanged;

            if (importsCbx.Items.Count > 0)
            {
                importsCbx.SelectedIndex = 0;
            }
        }