//button Speichern Update Urlaube private void button2_Click(object sender, EventArgs e) { //Validating if (txtAnzahlTage.TextLength == 0) { this.txtAnzahlTage.Focus(); MessageBox.Show("Bitte Anzahl der Tage eingeben!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { try { string Query = "update um_db.urlaube set Type='" + UrlaubTypeUpdate + "', Arbeitstage_von='" + this.dateTimePicker_von.Text + "', Arbeitstage_bis='" + this.dateTimePicker_bis.Text + "', Anzahl_Tage='" + this.txtAnzahlTage.Text + "', M_Vorname='" + this.txtVorname.Text + "', M_Nachname='" + this.txtNachname.Text + "', DN_Nr='" + this.txtDNNr.Text + "' where URLID='" + this.txtURLID.Text + "' ;"; MySqlConnection conDataBase = new MySqlConnection(constring); MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase); MySqlDataReader myReader; //Connection Open conDataBase.Open(); myReader = cmdDataBase.ExecuteReader(); MessageBox.Show("Die Daten wurden aktualisiert.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); while (myReader.Read()) { } //Refresh datagridview on form Urlaube u_urlaubee.load_table(); u_urlaubee.dataGridView1.Update(); u_urlaubee.dataGridView1.Refresh(); //Close Connection conDataBase.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Close(); } } }
public void Add_just_Urlaub() { //Validating if (dateTimePicker_von.CustomFormat == " ") { this.dateTimePicker_von.Focus(); MessageBox.Show("Bitte alle Felder ausfüllen!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //Validating else if (dateTimePicker_bis.CustomFormat == " ") { this.dateTimePicker_bis.Focus(); MessageBox.Show("Bitte alle Felder ausfüllen!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //Validating else if (txtAnzahlTage.TextLength == 0) { this.txtAnzahlTage.Focus(); MessageBox.Show("Bitte Anzahl der Tage eingeben!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { try //Insert Urlaub to db START { string Query = "insert into um_db.urlaube (Type,Arbeitstage_von,Arbeitstage_bis,Anzahl_Tage,M_Vorname,M_Nachname,DN_Nr) values('" + UrlaubTypeInsert + "','" + this.dateTimePicker_von.Text + "','" + this.dateTimePicker_bis.Text + "','" + this.txtAnzahlTage.Text + "','" + this.txtVorname.Text + "','" + this.txtNachname.Text + "','" + this.comboDNr.SelectedItem.ToString() + "') ;"; MySqlConnection conDataBase = new MySqlConnection(constring); MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase); MySqlDataReader myReader; //Connection Open conDataBase.Open(); myReader = cmdDataBase.ExecuteReader(); MessageBox.Show("Urlaub erfolgreich eingegeben.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); while (myReader.Read()) { } //To avoid error in Mitarbeiterstatus add Urlaub if (btnSpeichern.Text == " Speichern") { //Open form Urlaube Urlaube obj_urlaube = (Urlaube)Application.OpenForms["Urlaube"]; //Refresh datagridview on form Urlaube obj_urlaube.load_table(); obj_urlaube.dataGridView1.Update(); obj_urlaube.dataGridView1.Refresh(); } //Close Connection conDataBase.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Close(); } //Insert Urlaub to db END } }