Exemple #1
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            /*
             * var select = "SELECT Pontaj.Id as ID,Angajat.nume_angajat as Angajat, FORMAT (data, 'dd.MM.yyyy ') as Data, Pontaj.ora as Intrare ,Pontaj.ora_iesire as Iesire,Pontaj.data_creare as [Data creare] ,Pontaj.data_creare_iesire as [Data creare iesire],Pontaj.data_modificare as [Data modificare],CONVERT(varchar(5), DATEADD(minute, DATEDIFF(minute, ora, ora_iesire), 0),114) AS 'Ore lucrate', Pontaj.tip as Observatii FROM Pontaj inner join Angajat on Pontaj.nr_angajat = Angajat.Id";
             * var c = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=licenta;Persist Security Info=True;User ID=artur;password=artur");
             * var dataAdapter = new SqlDataAdapter(select, c);
             * var commandBuilder = new SqlCommandBuilder(dataAdapter);
             * var ds = new DataTable();
             * dataAdapter.Fill(ds);
             * datagrid2.ItemsSource = ds.DefaultView;
             */
            var selectt         = "SELECT Pontaj_management.Id as ID,Angajat.nume_angajat as Angajat, Departament.nume_departament as Departament, Proiect.nume_proiect as Proiect, Proiect.numar_proiect as [Numar proiect],Comanda.nume_comanda as Comanda, Comanda.numar_comanda as [Numar comanda], Pontaj_management.ora as Ora, FORMAT (data, 'dd.MM.yyyy ') as Data FROM Pontaj_management  inner join Angajat on Pontaj_management.nr_angajat = Angajat.Id left join Proiect on Pontaj_management.nr_proiect = Proiect.Id left join Comanda on Pontaj_management.nr_comanda = Comanda.Id inner join Departament on Angajat.nr_departament = Departament.Id";
            var con             = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=licenta;Persist Security Info=True;User ID=artur;password=artur");
            var dataAdapterr    = new SqlDataAdapter(selectt, con);
            var commandBuilderr = new SqlCommandBuilder(dataAdapterr);
            var dsa             = new DataTable();

            dataAdapterr.Fill(dsa);
            datagrid3.ItemsSource = dsa.DefaultView;


            licenta.test test = ((licenta.test)(this.FindResource("test")));
            // Load data into the table Angajat. You can modify this code as needed.
            licenta.testTableAdapters.AngajatTableAdapter testAngajatTableAdapter = new licenta.testTableAdapters.AngajatTableAdapter();
            testAngajatTableAdapter.Fill(test.Angajat);
            System.Windows.Data.CollectionViewSource angajatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("angajatViewSource")));
            angajatViewSource.View.MoveCurrentToFirst();
            // Load data into the table Departament. You can modify this code as needed.
            licenta.testTableAdapters.DepartamentTableAdapter testDepartamentTableAdapter = new licenta.testTableAdapters.DepartamentTableAdapter();
            testDepartamentTableAdapter.Fill(test.Departament);
            System.Windows.Data.CollectionViewSource departamentViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("departamentViewSource")));
            departamentViewSource.View.MoveCurrentToFirst();
            datagrid.Columns.RemoveAt(2);
            // Load data into the table Pontaj. You can modify this code as needed.

            /*licenta.testTableAdapters.PontajTableAdapter testPontajTableAdapter = new licenta.testTableAdapters.PontajTableAdapter();
             * testPontajTableAdapter.Fill(test.Pontaj);
             * System.Windows.Data.CollectionViewSource pontajViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pontajViewSource")));
             * pontajViewSource.View.MoveCurrentToFirst();
             */


            licenta.licentaDataSet licentaDataSet = ((licenta.licentaDataSet)(this.FindResource("licentaDataSet")));
            // Load data into the table Pontaj. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.PontajTableAdapter licentaDataSetPontajTableAdapter = new licenta.licentaDataSetTableAdapters.PontajTableAdapter();
            licentaDataSetPontajTableAdapter.Fill(licentaDataSet.Pontaj);
            System.Windows.Data.CollectionViewSource pontajViewSource1 = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pontajViewSource1")));
            pontajViewSource1.View.MoveCurrentToFirst();

            // Load data into the table Comanda. You can modify this code as needed.
            licenta.testTableAdapters.ComandaTableAdapter testComandaTableAdapter = new licenta.testTableAdapters.ComandaTableAdapter();
            testComandaTableAdapter.Fill(test.Comanda);
            System.Windows.Data.CollectionViewSource comandaViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("comandaViewSource")));
            comandaViewSource.View.MoveCurrentToFirst();
            // Load data into the table Proiect. You can modify this code as needed.
            licenta.testTableAdapters.ProiectTableAdapter testProiectTableAdapter = new licenta.testTableAdapters.ProiectTableAdapter();
            testProiectTableAdapter.Fill(test.Proiect);
            System.Windows.Data.CollectionViewSource proiectViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("proiectViewSource")));
            proiectViewSource.View.MoveCurrentToFirst();
            // Load data into the table User. You can modify this code as needed.
            licenta.testTableAdapters.UserTableAdapter testUserTableAdapter = new licenta.testTableAdapters.UserTableAdapter();
            testUserTableAdapter.Fill(test.User);
            System.Windows.Data.CollectionViewSource userViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("userViewSource")));
            userViewSource.View.MoveCurrentToFirst();
            // Load data into the table Cerere. You can modify this code as needed.
            licenta.testTableAdapters.CerereTableAdapter testCerereTableAdapter = new licenta.testTableAdapters.CerereTableAdapter();
            testCerereTableAdapter.Fill(test.Cerere);
            System.Windows.Data.CollectionViewSource cerereViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("cerereViewSource")));
            cerereViewSource.View.MoveCurrentToFirst();
            // Load data into the table Pontaj_management. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.Pontaj_managementTableAdapter licentaDataSetPontaj_managementTableAdapter = new licenta.licentaDataSetTableAdapters.Pontaj_managementTableAdapter();
            licentaDataSetPontaj_managementTableAdapter.Fill(licentaDataSet.Pontaj_management);
            System.Windows.Data.CollectionViewSource pontaj_managementViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pontaj_managementViewSource")));
            pontaj_managementViewSource.View.MoveCurrentToFirst();
            // Load data into the table Pontaj1. You can modify this code as needed.

            /*licenta.licentaDataSetTableAdapters.Pontaj1TableAdapter licentaDataSetPontaj1TableAdapter = new licenta.licentaDataSetTableAdapters.Pontaj1TableAdapter();
             * licentaDataSetPontaj1TableAdapter.Fill(licentaDataSet.Pontaj1);
             * System.Windows.Data.CollectionViewSource pontaj1ViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pontaj1ViewSource")));
             * pontaj1ViewSource.View.MoveCurrentToFirst();
             */
            datagrid1.Columns[4].Visibility = Visibility.Collapsed;
            datagrid1.Columns[5].Visibility = Visibility.Collapsed;
            datagrid1.Columns[6].Visibility = Visibility.Collapsed;
            //datagrid1.Columns[7].Visibility = Visibility.Collapsed;
            datagrid4.Columns[3].Visibility  = Visibility.Collapsed;
            datagrid5.Columns[3].Visibility  = Visibility.Collapsed;
            datagrid2.Columns[5].Visibility  = Visibility.Collapsed;
            this.datagrid1.Columns[1].Header = "Angajat";
            this.datagrid1.Columns[2].Header = "Departament";
            this.datagrid1.Columns[3].Header = "Telefon";
            this.datagrid.Columns[1].Header  = "Departament";
            this.datagrid4.Columns[1].Header = "Nr comanda";
            this.datagrid4.Columns[2].Header = "Comanda";
            this.datagrid5.Columns[1].Header = "Nr proiect";
            this.datagrid5.Columns[2].Header = "Proiect";
            this.datagrid7.Columns[1].Header = "Angajat";
            this.datagrid7.Columns[2].Header = "Cerere";
            this.datagrid7.Columns[3].Header = "Stare";
            this.datagrid7.Columns[4].Header = "Data";
            this.grid.Columns[1].Header      = "Tip";
            this.grid.Columns[2].Header      = "Nume";
            this.grid.Columns[3].Header      = "Text";
            this.datagrid8.Columns[1].Header = "Utilizator";
            this.datagrid8.Columns[2].Header = "Angajat";
            this.datagrid8.Columns[3].Header = "Parola";
            this.datagrid8.Columns[4].Header = "Tip";

            this.datagrid2.Columns[2].Header = "Data";
            this.datagrid2.Columns[3].Header = "Ora intrare";
            this.datagrid2.Columns[4].Header = "Creat intrare";
            this.datagrid2.Columns[6].Header = "Tip";
            this.datagrid2.Columns[7].Header = "Ora iesire";
            this.datagrid2.Columns[8].Header = "Creat iesire";



            // Load data into the table Sugestie. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.SugestieTableAdapter licentaDataSetSugestieTableAdapter = new licenta.licentaDataSetTableAdapters.SugestieTableAdapter();
            licentaDataSetSugestieTableAdapter.Fill(licentaDataSet.Sugestie);
            System.Windows.Data.CollectionViewSource sugestieViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("sugestieViewSource")));
            sugestieViewSource.View.MoveCurrentToFirst();
        }
Exemple #2
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            licenta.test test = ((licenta.test)(this.FindResource("test")));
            // Load data into the table Angajat. You can modify this code as needed.
            licenta.testTableAdapters.AngajatTableAdapter testAngajatTableAdapter = new licenta.testTableAdapters.AngajatTableAdapter();
            testAngajatTableAdapter.Fill(test.Angajat);
            System.Windows.Data.CollectionViewSource angajatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("angajatViewSource")));
            angajatViewSource.View.MoveCurrentToFirst();
            licenta.licentaDataSet licentaDataSet = ((licenta.licentaDataSet)(this.FindResource("licentaDataSet")));
            // Load data into the table Departament. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.DepartamentTableAdapter licentaDataSetDepartamentTableAdapter = new licenta.licentaDataSetTableAdapters.DepartamentTableAdapter();
            licentaDataSetDepartamentTableAdapter.Fill(licentaDataSet.Departament);
            System.Windows.Data.CollectionViewSource departamentViewSource1 = ((System.Windows.Data.CollectionViewSource)(this.FindResource("departamentViewSource1")));
            departamentViewSource1.View.MoveCurrentToFirst();
            // Load data into the table Pontaj. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.PontajTableAdapter licentaDataSetPontajTableAdapter = new licenta.licentaDataSetTableAdapters.PontajTableAdapter();
            licentaDataSetPontajTableAdapter.Fill(licentaDataSet.Pontaj);
            System.Windows.Data.CollectionViewSource pontajViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pontajViewSource")));
            pontajViewSource.View.MoveCurrentToFirst();
            // Load data into the table Pontaj_management. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.Pontaj_managementTableAdapter licentaDataSetPontaj_managementTableAdapter = new licenta.licentaDataSetTableAdapters.Pontaj_managementTableAdapter();
            licentaDataSetPontaj_managementTableAdapter.Fill(licentaDataSet.Pontaj_management);
            System.Windows.Data.CollectionViewSource pontaj_managementViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("pontaj_managementViewSource")));
            pontaj_managementViewSource.View.MoveCurrentToFirst();
            // Load data into the table Comanda. You can modify this code as needed.
            licenta.testTableAdapters.ComandaTableAdapter testComandaTableAdapter = new licenta.testTableAdapters.ComandaTableAdapter();
            testComandaTableAdapter.Fill(test.Comanda);
            System.Windows.Data.CollectionViewSource comandaViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("comandaViewSource")));
            comandaViewSource.View.MoveCurrentToFirst();
            // Load data into the table Proiect. You can modify this code as needed.
            licenta.testTableAdapters.ProiectTableAdapter testProiectTableAdapter = new licenta.testTableAdapters.ProiectTableAdapter();
            testProiectTableAdapter.Fill(test.Proiect);
            System.Windows.Data.CollectionViewSource proiectViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("proiectViewSource")));
            proiectViewSource.View.MoveCurrentToFirst();
            // Load data into the table Cerere. You can modify this code as needed.
            licenta.testTableAdapters.CerereTableAdapter testCerereTableAdapter = new licenta.testTableAdapters.CerereTableAdapter();
            testCerereTableAdapter.Fill(test.Cerere);
            System.Windows.Data.CollectionViewSource cerereViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("cerereViewSource")));
            cerereViewSource.View.MoveCurrentToFirst();
            // Load data into the table User. You can modify this code as needed.
            licenta.testTableAdapters.UserTableAdapter testUserTableAdapter = new licenta.testTableAdapters.UserTableAdapter();
            testUserTableAdapter.Fill(test.User);
            System.Windows.Data.CollectionViewSource userViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("userViewSource")));
            userViewSource.View.MoveCurrentToFirst();
            datagrid1.Columns[4].Visibility = Visibility.Collapsed;
            datagrid1.Columns[5].Visibility = Visibility.Collapsed;
            datagrid1.Columns[6].Visibility = Visibility.Collapsed;
            // datagrid1.Columns[7].Visibility = Visibility.Collapsed;
            datagrid4.Columns[3].Visibility   = Visibility.Collapsed;
            datagrid5.Columns[3].Visibility   = Visibility.Collapsed;
            datagridpon.Columns[8].Visibility = Visibility.Collapsed;
            datagridpon.Columns[7].Visibility = Visibility.Collapsed;
            datagird.Columns[5].Visibility    = Visibility.Collapsed;
            combobox.SelectedIndex            = -1;
            // Load data into the table Sugestie. You can modify this code as needed.
            licenta.licentaDataSetTableAdapters.SugestieTableAdapter licentaDataSetSugestieTableAdapter = new licenta.licentaDataSetTableAdapters.SugestieTableAdapter();
            licentaDataSetSugestieTableAdapter.Fill(licentaDataSet.Sugestie);
            System.Windows.Data.CollectionViewSource sugestieViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("sugestieViewSource")));
            sugestieViewSource.View.MoveCurrentToFirst();


            this.datagrid1.Columns[1].Header = "Angajat";
            this.datagrid1.Columns[2].Header = "Departament";
            this.datagrid1.Columns[3].Header = "Telefon";
            this.data.Columns[1].Header      = "Nume departament";
            this.datagrid7.Columns[1].Header = "Angajat";
            this.datagrid7.Columns[2].Header = "Cerere";
            this.datagrid7.Columns[3].Header = "Stare";
            this.datagrid7.Columns[4].Header = "Data";
            this.datagrid4.Columns[1].Header = "Nr comanda";
            this.datagrid4.Columns[2].Header = "Comanda";
            this.datagrid5.Columns[1].Header = "Nr proiect";
            this.datagrid5.Columns[2].Header = "Proiect";
            this.data1.Columns[1].Header     = "Tip";
            this.data1.Columns[2].Header     = "Nume";
            this.data1.Columns[3].Header     = "Text";
            this.datagird.Columns[2].Header  = "Data";
            this.datagird.Columns[3].Header  = "Ora intrare";
            this.datagird.Columns[4].Header  = "Creat intrare";
            this.datagird.Columns[6].Header  = "Tip";
            this.datagird.Columns[7].Header  = "Ora iesire";
            this.datagird.Columns[8].Header  = "Creat iesire";

            this.datagridpon.Columns[1].Header = "Angajat";
            this.datagridpon.Columns[2].Header = "Data";
            this.datagridpon.Columns[3].Header = "Ora";
            this.datagridpon.Columns[4].Header = "Nr proiect";
            this.datagridpon.Columns[5].Header = "Nr comanda";
            this.datagridpon.Columns[6].Header = "Data creare";
        }