private void Home_Load(object sender, EventArgs e) { //label for showing dateTime Now label_date.Text = DateTime.Now.ToString("dd/MM/yyyy"); //Format 30.5.2015 //HomeMenu buttons in Panel Manipulation HomePage1.Visible = true; HomePage2.Visible = false; ////////Form Termine Action START/////// Termine termine = new Termine(); termine.Opacity = 0; termine.lblVisible.Text = "Hide"; termine.ShowDialog(); //Show notifyIcon1 in Home Form if (notifyIcon1 != null) { //NotifyIcon balloon notifyIcon1.Visible = true; //notifyIcon1.ShowBalloonTip(3000); } ////////Form Termine Action END/////// ////////FeierTage Message START/////// var feiertage = new FeierTage(); feiertage.check_Holiday_dates(); ////////FeierTage Message END/////// ////////Urlaube Message START/////// var urlaube = new Urlaube(); urlaube.check_Urlaube_dates(); ////////Urlaube Message END/////// ////////Krankenstand Message START/////// var krankendstand_update = new Mitarbeiter_Krankenstand_Update(); krankendstand_update.check_Krankenstand_dates(); ////////Krankendstand Message END/////// ////////Firma Einstellungen START/////// get_firma_settings(); ////////Firma Einstellungen END/////// //Check Mitarbeiter Expired Visum Mitarbeiter mit = new Mitarbeiter(); mit.check_expired_visum(); mit.check_Birthdays(); ////////Daily_report(Tagesbericht) START/////// check_AwailableMessages(); ////////Daily_report END/////// }
private void urlaubeToolStripMenuItem_Click(object sender, EventArgs e) { var Urlaube = new Urlaube(); Urlaube.ShowDialog(); }
private void button2_Click(object sender, EventArgs e) { var Urlaube = new Urlaube(); Urlaube.ShowDialog(); }
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 } }