Patrik

Naučíme tě pracovat na home-office.

Zjistit více...

ComboBoxi napln

C# .NET

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using Npgsql;
using System.Data;


namespace Kniznica
{
    /// <summary>
    /// Interaction logic for ZobrazKnihy.xaml
    /// </summary>
    public partial class ZobrazKnihy : Window
    {
        private DataTable dtResult = new DataTable();
        private int pocet;



        public ZobrazKnihy()
        {
            InitializeComponent();
            naplnDgMaster();
            naplnCbBox();

        }

        private void naplnDgMaster()
        {
            dtResult.Clear();

            NpgsqlConnection pConn = new NpgsqlConnection("Server = localhost; Port = 5432; User Id = mes; Password = mes; Database = Kniznica");
            NpgsqlCommand pCmd = new NpgsqlCommand("fn_zoznam_knih_sel", pConn);
            pCmd.CommandType = CommandType.StoredProcedure;
            try
            {
                pConn.Open();
                NpgsqlDataReader oReader = pCmd.ExecuteReader();
                dtResult.Load(oReader);  
            }

            finally
            {
                pConn.Close();
            }

            dataGrid.DataContext = dtResult;
            pocet = Convert.ToInt32((dtResult.Rows).Count);
            pocetZaznamov.Text = Convert.ToString(pocet);
        }

        private void btnInsert_Click(object sender, RoutedEventArgs e)
        {
            dlgZobrazKnihy dlgKnihy = new dlgZobrazKnihy(null);
            if (dlgKnihy.ShowDialog() == true)
            {
                naplnDgMaster();
            }
        }

        private void btnEdit_Click(object sender, RoutedEventArgs e)
        {
            Int32 iKnihaId = Convert.ToInt32(((Button)sender).CommandParameter);
            DataView dv = new DataView(dtResult);
            dv.RowFilter = "kniha_id =" + iKnihaId.ToString();
            dlgZobrazKnihy dlgKnihy = new dlgZobrazKnihy(dv);
            if (dlgKnihy.ShowDialog() == true)
            {
                naplnDgMaster();
            }
        }

        private void btnDelete_Click(object sender, RoutedEventArgs e)
        {
            MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Naozaj chcete zmazat zaznam?", "Potvrdenie zmazania", System.Windows.MessageBoxButton.YesNo);
            if (messageBoxResult == MessageBoxResult.Yes)
            {
                Int32 iKnihaId = Convert.ToInt32(((Button)sender).CommandParameter);
                NpgsqlConnection pConn = new NpgsqlConnection("Server=localhost; Port=5432;User Id=mes; Password=mes; Database = Kniznica");
                NpgsqlCommand pCmd = new NpgsqlCommand("fn_kniha_del", pConn);
                pCmd.CommandType = CommandType.StoredProcedure;
                pCmd.Parameters.Add("kniha_id", NpgsqlTypes.NpgsqlDbType.Integer).Value = iKnihaId;
                try
                {
                    pConn.Open();
                    pCmd.ExecuteNonQuery();
                    naplnDgMaster();
                }
                finally
                {
                    pConn.Close();
                }
            }
        }

        public void naplnCbBox()
        {

            if (comboBox.SelectedValue == nazovKnihy)
            {
                comboBox2.Visibility = Visibility.Collapsed;
                tbNazovKnihy.Visibility = Visibility.Visible;
            }
            else
            {
                tbNazovKnihy.Visibility = Visibility.Collapsed;
                comboBox2.Visibility = Visibility.Visible;
            }

            if (comboBox.SelectedValue == vydavatelstvo)
            {
                DataTable dt = new DataTable();
                NpgsqlConnection pConn = new NpgsqlConnection("Server = localhost; Port = 5432; User Id = mes; Password = mes; Database = Kniznica");
                NpgsqlCommand pCmd = new NpgsqlCommand("fn_vydavatelstvo_ddl", pConn);
                pCmd.CommandType = CommandType.StoredProcedure;
                try
                {
                    pConn.Open();
                    NpgsqlDataReader oReader = pCmd.ExecuteReader();
                    dt.Load(oReader);
                }
                finally
                {
                    pConn.Close();
                }
                comboBox2.DataContext = dt;
                comboBox2.SelectedValuePath = "vydavatelstvo_id";
                comboBox2.DisplayMemberPath = "vydavatelstvo_nazov";
            }
            if (comboBox.SelectedValue == zaner)
            {
                comboBox2.DataContext = null;
                DataTable dt = new DataTable();
                NpgsqlConnection pConn = new NpgsqlConnection("Server = localhost; Port = 5432; User Id = mes; Password = mes; Database = Kniznica");
                NpgsqlCommand pCmd = new NpgsqlCommand("fn_zaner_ddl", pConn);
                pCmd.CommandType = CommandType.StoredProcedure;
                try
                {
                    pConn.Open();
                    NpgsqlDataReader oReader = pCmd.ExecuteReader();
                    dt.Load(oReader);
                }
                finally
                {
                    pConn.Close();
                }

                comboBox2.DataContext = dt;
                comboBox2.SelectedValuePath = "zaner_id";
                comboBox2.DisplayMemberPath = "zaner_nazov";
            }

            if (comboBox.SelectedValue == rokVydania)
            {
                Dictionary<string, object> Items = new Dictionary<string, object>();

                comboBox2.ItemsSource = null;
                Items.Add("1", "2019 - 2015");
                Items.Add("2", "2014 - 2010");
                Items.Add("3", "2010 a menej");

                comboBox2.ItemsSource = Items;
                comboBox2.SelectedValuePath = "Key";
                comboBox2.DisplayMemberPath = "Value";
                


            }

        }

        private void cbVyber_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            naplnCbBox();
        }

        private void btnOk_Click(object sender, RoutedEventArgs e)
        {

        }

Neformátovaný

Přidáno: 14.1.2019
Expirace: Neuvedeno

Autor: Patrik Živčák