private void Window_Loaded(object sender, RoutedEventArgs e) { /* licenta.licentaDataSet licentaDataSet = ((licenta.licentaDataSet)(this.FindResource("licentaDataSet"))); * // Load data into the table Angajat. You can modify this code as needed. * licenta.licentaDataSetTableAdapters.AngajatTableAdapter licentaDataSetAngajatTableAdapter = new licenta.licentaDataSetTableAdapters.AngajatTableAdapter(); * licentaDataSetAngajatTableAdapter.Fill(licentaDataSet.Angajat); * System.Windows.Data.CollectionViewSource angajatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("angajatViewSource"))); * angajatViewSource.View.MoveCurrentToFirst(); */ 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 angajatViewSource1 = ((System.Windows.Data.CollectionViewSource)(this.FindResource("angajatViewSource1"))); angajatViewSource1.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(); }
private void Button_Click_13(object sender, RoutedEventArgs e) { object item = datagrid5.SelectedItem; string CourseName = (datagrid5.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text; SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=licenta;Persist Security Info=True;User ID=artur;password=artur"); cn.Open(); SqlCommand cmd = new SqlCommand("delete from Proiect where Id = @Id", cn); cmd.Parameters.AddWithValue("Id", CourseName); cmd.ExecuteNonQuery(); cn.Close(); licenta.test test = ((licenta.test)(this.FindResource("test"))); 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(); }
private void Button_Click_12(object sender, RoutedEventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=licenta;Persist Security Info=True;User ID=artur;password=artur"); SqlCommand cmd; con.Open(); string s = "insert into Proiect values(@numar_proiect,@nume_proiect)"; cmd = new SqlCommand(s, con); cmd.Parameters.AddWithValue("@numar_proiect", textboxproiect2.Text); cmd.Parameters.AddWithValue("@nume_proiect", textboxproiect1.Text); cmd.CommandType = CommandType.Text; int i = cmd.ExecuteNonQuery(); con.Close(); licenta.test test = ((licenta.test)(this.FindResource("test"))); 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(); }
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(); }
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"; }