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
}
}
