private void Button_Click_4(object sender, RoutedEventArgs e)
{
licenta.licentaDataSet licentaDataSet = ((licenta.licentaDataSet)(this.FindResource("licentaDataSet")));
licenta.licentaDataSetTableAdapters.DepartamentTableAdapter licentaDataSetDepartamentTableAdapter = new licenta.licentaDataSetTableAdapters.DepartamentTableAdapter();
licentaDataSetDepartamentTableAdapter.Update(licentaDataSet);
MessageBox.Show(" Rand salvat ");
}
private void Button_Click_2(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 Departament values(@nume_departament)";
cmd = new SqlCommand(s, con);
cmd.Parameters.AddWithValue("@nume_departament", textbox.Text);
cmd.CommandType = CommandType.Text;
int i = cmd.ExecuteNonQuery();
con.Close();
licenta.licentaDataSet licentaDataSet = ((licenta.licentaDataSet)(this.FindResource("licentaDataSet")));
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();
}
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";
}