private void btnSupprimerPigiste_Click(object sender, RoutedEventArgs e) { Pigiste SupprPigiste = dtgPigiste.SelectedItem as Pigiste; cPigiste.Remove(SupprPigiste); cPigiste.Clear(); cPigiste = bdd.SelectPigiste(); dtgPigiste.ItemsSource = cPigiste; }
private void btnAjouterPigiste_Click(object sender, RoutedEventArgs e) { Pigiste unPigiste = new Pigiste(cPigiste.Count + 1, txtNomPigiste.Text, txtPrenomPigiste.Text, txtAdressePigiste.Text, txtCPPigiste.Text, txtVillePigiste.Text, txtEmail.Text, txtNumSecuPigiste.Text, txtContratCadre.Text); cPigiste.Add(unPigiste); cPigiste.Clear(); cPigiste = bdd.SelectPigiste(); dtgPigiste.ItemsSource = cPigiste; }
public Contrat(int n, double mtb, double mtn, bool d, bool f, int e, Pigiste p, Magazine m) { _numContrat = n; _lettreAccordContrat = "1m2p-la-" + m.NumMagazine + "-" + p.NumPigiste; _montantBrutContrat = mtb; _montantNetContrat = mtn; _declarationAgessaContrat = d; _factureContrat = f; _etatContrat = e; _pigisteContrat = p; _magazineContrat = m; }
public Contrat(int n, string la, double mtb, double mtn, bool d, bool f, int e, Pigiste p, Magazine m) { _numContrat = n; _lettreAccordContrat = la; _montantBrutContrat = mtb; _montantNetContrat = mtn; _declarationAgessaContrat = d; _factureContrat = f; _etatContrat = e; _pigisteContrat = p; _magazineContrat = m; }
public static List <Contrat> SelectContrat() { //Select statement string query = "SELECT * FROM Collaboration"; //Create a list to store the result List <Contrat> dbContrat = new List <Contrat>(); List <Pigiste> dbPigiste = SelectPigiste(); List <Magazine> dbMagazine = SelectMagazine(); //Ouverture connection if (bdd.OpenConnection() == true) { //Creation Command MySQL MySqlCommand cmd = new MySqlCommand(query, connection); //Création d'un DataReader et execution de la commande MySqlDataReader dataReader = cmd.ExecuteReader(); //Lecture des données et stockage dans la collection while (dataReader.Read()) { Pigiste trouvepigiste = dbPigiste.Find(r => r.NumPigiste == Convert.ToInt16(dataReader["NumPigiste"])); Magazine trouveMagazine = dbMagazine.Find(r => r.NumMagzine == Convert.ToInt16(dataReader["NumMagazine"])); Contrat leContrat = new Contrat (Convert.ToInt32(dataReader["NumCollaboration"]), Convert.ToString(dataReader["LettreAccordCollaboration"]), Convert.ToInt32(dataReader["MontantCollaboration"]), Convert.ToInt32(dataReader["MontantNCollaboration"]), Convert.ToBoolean(dataReader["EtatCollaboration"]), Convert.ToBoolean(dataReader["FactureCollaboration"]), Convert.ToInt32(dataReader["AgessaCollaboration"]), trouvepigiste, trouveMagazine, Convert.ToString(dataReader["DatePaiementCollaboration"])); dbContrat.Add(leContrat); } //fermeture du Data Reader dataReader.Close(); //fermeture Connection bdd.CloseConnection(); //retour de la collection pour être affichée return(dbContrat); } else { return(dbContrat); } }
public static List <Pigiste> SelectPigiste() { //Select statement string query = "SELECT * FROM Pigiste"; //Create a list to store the result List <Pigiste> dbPigiste = new List <Pigiste>(); //Ouverture connection if (bdd.OpenConnection() == true) { //Creation Command MySQL MySqlCommand cmd = new MySqlCommand(query, connection); //Création d'un DataReader et execution de la commande MySqlDataReader dataReader = cmd.ExecuteReader(); //Lecture des données et stockage dans la collection while (dataReader.Read()) { Pigiste lePigiste = new Pigiste (Convert.ToInt16(dataReader["NumPigiste"]), Convert.ToString(dataReader["NomPigiste"]), Convert.ToString(dataReader["PrenomPigiste"]), Convert.ToString(dataReader["AdressePigiste"]), Convert.ToString(dataReader["CPPigiste"]), Convert.ToString(dataReader["VillePigiste"]), Convert.ToString(dataReader["MailPigiste"]), Convert.ToString(dataReader["NumSecuPigiste"]), Convert.ToString(dataReader["ContratCadrePigiste"])); dbPigiste.Add(lePigiste); } //fermeture du Data Reader dataReader.Close(); //fermeture Connection bdd.CloseConnection(); //retour de la collection pour être affichée return(dbPigiste); } else { return(dbPigiste); } }
private void dtgPigiste_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (dtgPigiste.SelectedIndex == -1) { dtgPigiste.SelectedIndex = 0; } Pigiste selectedPigiste = dtgPigiste.SelectedItem as Pigiste; txtNumPigiste.Text = Convert.ToString(selectedPigiste.NumPigiste); txtNomPigiste.Text = Convert.ToString(selectedPigiste.NomPigiste); txtPrenomPigiste.Text = Convert.ToString(selectedPigiste.PrenomPigiste); txtAdressePigiste.Text = Convert.ToString(selectedPigiste.AdressePigiste); txtCPPigiste.Text = Convert.ToString(selectedPigiste.CpPigiste); txtVillePigiste.Text = Convert.ToString(selectedPigiste.VillePigiste); txtNumSecuPigiste.Text = Convert.ToString(selectedPigiste.NumSecuPigiste); }
public ContratFacture(int numcon, string lettacccon, double montbrutcon, double montnetcon, bool factcon, int etatcon, Pigiste pigcon, Magazine magcon, string datepaie) : base(numcon, lettacccon, montbrutcon, montnetcon, etatcon, pigcon, magcon, datepaie) { _factureContrat = factcon; }
public ContratAgessa(int numcon, string lettacccon, double montbrutcon, double montnetcon, bool declagessacon, int etatcon, Pigiste pigcon, Magazine magcon, string datepaie) : base(numcon, lettacccon, montbrutcon, montnetcon, etatcon, pigcon, magcon, datepaie) { _declarationAgessaContrat = declagessacon; }
private void btnAjouterContrat_Click(object sender, RoutedEventArgs e) { Pigiste LePigiste = cboPigiste.SelectedItem as Pigiste; if (txtLettreAccordContrat.Text == "") { La = "la-"; La = La + Convert.ToString(txtNumContrat.Text) + "-" + LePigiste.NumPigiste; Contrat unContrat = new Contrat ( cContrat.Count + 1, La, Convert.ToDouble(txtMontantBrutContrat.Text), Convert.ToDouble(txtMontantNetContrat.Text), Convert.ToBoolean(chkAgessa.IsChecked), Convert.ToBoolean(chkFacture.IsChecked), cboEtatContrat.SelectedIndex, (Pigiste)cboPigiste.SelectedItem, (Magazine)cboMagazine.SelectedItem, dtpPaiment.Text ); bdd.InsertContrat(La, Convert.ToDouble(txtMontantBrutContrat.Text), Convert.ToDouble(txtMontantNetContrat.Text), cboEtatContrat.SelectedIndex, Convert.ToBoolean(chkFacture.IsChecked), Convert.ToBoolean(chkAgessa.IsChecked), (Pigiste)cboPigiste.SelectedItem, (Magazine)cboMagazine.SelectedItem); cContrat.Add(unContrat); cContrat.Clear(); cContrat = bdd.SelectContrat(); dtgContrat.ItemsSource = cContrat; } else { Contrat unContrat = new Contrat ( cContrat.Count + 1, txtLettreAccordContrat.Text, Convert.ToDouble(txtMontantBrutContrat.Text), Convert.ToDouble(txtMontantNetContrat.Text), Convert.ToBoolean(chkAgessa.IsChecked), Convert.ToBoolean(chkFacture.IsChecked), cboEtatContrat.SelectedIndex, (Pigiste)cboPigiste.SelectedItem, (Magazine)cboMagazine.SelectedItem, dtpPaiment.Text ); bdd.InsertContrat(La, Convert.ToDouble(txtMontantBrutContrat.Text), Convert.ToDouble(txtMontantNetContrat.Text), cboEtatContrat.SelectedIndex, Convert.ToBoolean(chkFacture.IsChecked), Convert.ToBoolean(chkAgessa.IsChecked), (Pigiste)cboPigiste.SelectedItem, (Magazine)cboMagazine.SelectedItem); cContrat.Add(unContrat); cContrat.Clear(); cContrat = bdd.SelectContrat(); dtgContrat.ItemsSource = cContrat; } }
public static void InsertContrat(string la, double mttB, double mttN, int etat, bool fact, bool agessa, Pigiste lePigiste, Magazine leMagazine) { //Requête Insertion Contrat string query = "INSERT INTO Contrat (LettreAccordContrat, MontantBrutContrat, MontantNetContrat, EtatContrat, FactureContrat, DeclarationAgessaContrat, PigisteContrat, MagazineContrat ) VALUES('" + la + "','" + mttB + "'," + mttN + "'," + etat + "'," + fact + "'," + agessa + "'," + lePigiste + "'," + leMagazine + ")"; Console.WriteLine(query); //open connection if (bdd.OpenConnection() == true) { //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); //Execute command cmd.ExecuteNonQuery(); //close connection bdd.CloseConnection(); } }