private void btnCnx_Click(object sender, EventArgs e) { BaseDonneeConnecter.ouvrirconnection(); SqlCommand com = new SqlCommand("select * from users where login ='******' and password ='******'", BaseDonneeConnecter.connection); SqlDataReader dr = com.ExecuteReader(); if (dr.HasRows) { dr.Close(); SqlCommand com2 = new SqlCommand("select nameusers from users where login ='******' and password ='******'", BaseDonneeConnecter.connection); SqlDataReader dr2 = com2.ExecuteReader(); while (dr2.Read()) { nameuser = (string)dr2["nameusers"]; } dr2.Close(); SqlCommand com3 = new SqlCommand("select priorite from users where login ='******' and password ='******'", BaseDonneeConnecter.connection); SqlDataReader dr3 = com3.ExecuteReader(); while (dr3.Read()) { priorite = (int)dr3["priorite"]; } dr3.Close(); Home h = new Home(nameuser, priorite); h.ShowDialog(); } else { MessageBox.Show("Login ou le mot de passe sont Incorrect !!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); dr.Close(); } }
private void btnNext_Click(object sender, EventArgs e) { if (lsPresence.SelectedItem != null) { BaseDonneeConnecter.addAbsenseInRealeTime(lsPresence.SelectedItem.ToString(), usingDate, usingNumjour.ToString(), cbGroupe.SelectedItem.ToString(), usingTimeStart.ToString()); loadAbsense(); loadNotAbsense(); } }
private void loadNotAbsense() { lsPresence.Items.Clear(); List <string> aa = BaseDonneeConnecter.getNotAbsenseInRealeTime(usingDate, usingNumjour.ToString(), cbGroupe.SelectedItem.ToString(), usingTimeStart.ToString()); foreach (string ss in aa) { lsPresence.Items.Add(ss); } }
private void Home_Load(object sender, EventArgs e) { refreachTime(); label1.Text = DateTime.Today.ToString("d"); label3.Text = nameusers; foreach (string ss in BaseDonneeConnecter.getGroupes()) { cbGroupe.Items.Add(ss); } cbGroupe.SelectedIndex = 0; }
private void GestionEmploi_Load(object sender, EventArgs e) { foreach (string ss in BaseDonneeConnecter.getGroupes()) { grop.Items.Add(ss); } grop.SelectedIndex = 0; foreach (Users ss in BaseDonneeConnecter.getAllUsersinfo()) { cbusers.Items.Add(ss.nameusers); } clearfild(); }
private void btn_supr_Click(object sender, EventArgs e) { if (Utils.isVide(cbJour.SelectedIndex, cbtime.SelectedIndex, dgvEmploiTemps)) { label3.Text = "Cette Eregestrement est Deja vide !!"; label3.ForeColor = Color.Red; } else { BaseDonneeConnecter.deleteEnregestrempent(grop.SelectedItem.ToString(), (cbJour.SelectedIndex + 1) + "", (cbtime.SelectedIndex + 1) + ""); grop_SelectedIndexChanged(null, null); label3.Text = "Supprission reussite"; label3.ForeColor = Color.Green; clearfild(); } }
private void btnEmAjouter_Click(object sender, EventArgs e) { if (cbJour.SelectedIndex == -1 || cbtime.SelectedIndex == -1 || txtactivite.Text == "") { label3.Text = "Vieullez remplir les champs !!"; label3.ForeColor = Color.Red; } else if (Utils.isVide(cbJour.SelectedIndex, cbtime.SelectedIndex, dgvEmploiTemps)) { BaseDonneeConnecter.addSeance(grop.SelectedItem.ToString(), (cbJour.SelectedIndex + 1), (cbtime.SelectedIndex + 1), txtactivite.Text, cbusers.SelectedItem.ToString(), txtsalle.Text); grop_SelectedIndexChanged(null, null); txtactivite.Clear(); label3.Text = "Ajoutation reussite"; label3.ForeColor = Color.Green; clearfild(); } else { label3.Text = "Cette periode est Occupez vieullez selectionez une periode vide ou vider une preriode !!"; label3.ForeColor = Color.Red; } }
public static void rempli_liste(ComboBox l) { jours = BaseDonneeConnecter.getJourFromGroupe(l.SelectedItem.ToString()); }