private void detailgrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
try
{
PersonalundBerechtigung selectedEintrag = (PersonalundBerechtigung)detailgrid.SelectedItem;
detailedview Detailview = new detailedview(selectedEintrag, conn);
Detailview.ShowDialog();
if (Detailview.DialogResult == true)
{
string SQLCommand1 = string.Format("UPDATE Personal SET Geschlecht='{0}',GeburtsDatum='{1}',PVorname='{2}',PNachname='{3}',PersID='{4}',VerNr='{5}',PAdresse='{6}',PTelNr='{7}',Rolle='{8}' WHERE PersID='{9}'", Detailview.ComboGeschlecht.Text, Detailview.TextBoxGeburtsdatum.Text, Detailview.TextBoxVorname.Text, Detailview.TextBoxNachname.Text, Detailview.TextBoxID.Text, Detailview.TextBoxVerNr.Text, Detailview.TextBoxAdresse.Text, Detailview.TextBoxTel.Text, Detailview.ComboRolle.Text, selectedEintrag.PersID);
MySqlCommand cmd1 = new MySqlCommand(SQLCommand1, conn);
cmd1.ExecuteNonQuery();
string SQLCommand2 = string.Format("UPDATE Berechtigung SET BID='{0}',darfarbeitenin='{1}',Ausbildung='{2}' WHERE BID='{3}'", Detailview.TextBoxBID.Text, Detailview.Combodai.Text, Detailview.TextBoxAusbildung.Text, selectedEintrag.BID);
MySqlCommand cmd2 = new MySqlCommand(SQLCommand2, conn);
cmd2.ExecuteNonQuery();
laden();
}
}
catch (Exception ex)
{
MessageBox.Show("Sorry something crashed: \r\n" + ex.Message);
}
}
private void Menu_Insert_Click(object sender, RoutedEventArgs e)
{
detailedview Detailview = new detailedview();
Detailview.ShowDialog();
if (Detailview.DialogResult == true)
{
try
{
string SQLCommand3 = string.Format("INSERT INTO Personal VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", Detailview.ComboGeschlecht.Text, Detailview.TextBoxGeburtsdatum.Text, Detailview.TextBoxVorname.Text, Detailview.TextBoxNachname.Text, Detailview.TextBoxID.Text, Detailview.TextBoxVerNr.Text, Detailview.TextBoxAdresse.Text, Detailview.TextBoxTel.Text, Detailview.ComboRolle.Text);
MySqlCommand cmd3 = new MySqlCommand(SQLCommand3, conn);
cmd3.ExecuteNonQuery();
string SQLCommand4 = string.Format("INSERT INTO Berechtigung VALUES('{0}','{1}','{2}','{3}')", Detailview.TextBoxID.Text, Detailview.TextBoxBID.Text, Detailview.Combodai.Text, Detailview.TextBoxAusbildung.Text);
MySqlCommand cmd4 = new MySqlCommand(SQLCommand4, conn);
cmd4.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("An Error occured:\r\n" + ex.Message);
}
laden();
}
}