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();
}
}
