/// <summary> /// Charger les informations sur le client sélectionné dans la liste déroulante /// </summary> private void ActualiserListe() { Clientel monclient = new Clientel(); int index = cb_listecli.SelectedIndex; if (index != -1) { monclient.RechercheUnClient(cb_listecli.Items[index].ToString()); lbl_nom.Text = monclient.NomCl; lbl_prenom.Text = monclient.PrenomCl; lbl_scte.Text = monclient.Societe; lbl_adresse.Text = monclient.AdresseCl; lbl_ville.Text = monclient.VilleCl; lbl_cp.Text = monclient.CodePostCl; lbl_noclient.Text = "Client n°" + cb_listecli.Items[index].ToString(); } else { lbl_nom.Text = ""; lbl_prenom.Text = ""; lbl_scte.Text = ""; lbl_adresse.Text = ""; lbl_ville.Text = ""; lbl_cp.Text = ""; lbl_noclient.Text = "Veuillez choisir un client"; } }
/// <summary> /// Initialisation /// </summary> public Fclient() { InitializeComponent(); lbl_nom.Text = ""; lbl_prenom.Text = ""; lbl_scte.Text = ""; lbl_adresse.Text = ""; lbl_ville.Text = ""; lbl_cp.Text = ""; btn_details.Visible = false; List<String> mesNumeros; try { Clientel unClient = new Clientel(); mesNumeros = unClient.LectureNoClient(); foreach (String item in mesNumeros) { cb_listecli.Items.Add(item); } } catch (MonException exception) { MessageBox.Show(exception.MessageApplication(), exception.Message); } }
/// <summary> /// Charger les données pour les listes déroulantes de clients et vendeurs /// </summary> private void ChargerDonnees() { List<String> mesNumeros; try { Clientel unClient = new Clientel(); mesNumeros = unClient.LectureNoClient(); foreach (String item in mesNumeros) { cb_noclient.Items.Add(item); } Vendeur unVendeur = new Vendeur(); mesNumeros = unVendeur.LectureNoVendeur(); foreach (String item in mesNumeros) { cb_novendeur.Items.Add(item); } } catch (MonException exception) { MessageBox.Show(exception.MessageApplication(), exception.Message); } }
public List <Commande> getLesCommandes(String tris, String ordres) { DataTable dt; String mysql = "SELECT NO_COMMAND, NO_VENDEUR, NO_CLIENT, DATE_CDE, FACTURE " + "FROM COMMANDES " + "ORDER BY " + tris + " " + ordres; sErreurs er = new sErreurs("Erreur sur lecture des commandes", "Commande.getLesCommandes()"); try { dt = DbInterface.Lecture(mysql, er); List <Commande> mesCdes = new List <Commande>(); foreach (DataRow dataRow in dt.Rows) { Vendeur unvd = new Vendeur(); unvd.NoVendeur = dataRow[1].ToString(); Clientel uncli = new Clientel(); uncli.NoCl = dataRow[2].ToString(); Commande unecde = new Commande(dataRow[0].ToString(), ((DateTime)dataRow[3]), dataRow[4].ToString(), unvd, uncli); mesCdes.Add(unecde); } return(mesCdes); } catch (MonException erreur) { throw erreur; } }
/// <summary> /// Initialisation avec les paramètres /// </summary> public Commande(String noC, DateTime dateC, String factC, Vendeur ven, Clientel cli) { noCommande = noC; dateCommande = dateC; facture = factC; vendeur = ven; client = cli; }
/// <summary> /// Initialisation /// </summary> public Commande() { noCommande = ""; facture = ""; vendeur = new Vendeur(); client = new Clientel(); dateCommande = DateTime.Today; }
public List<Commande> getLesCommandes(String tri, String ordre) { DataTable dt; String mysql = "SELECT NO_COMMAND, NO_VENDEUR, NO_CLIENT, DATE_CDE, FACTURE "; mysql += "FROM COMMANDES "; mysql += "ORDER BY " + tri + " " + ordre; sErreurs er = new sErreurs("Erreur sur lecture des commandes", "Commande.getLesCommandes()"); try { dt = DbInterface.Lecture(mysql, er); List<Commande> mesCdes = new List<Commande>(); foreach (DataRow dataRow in dt.Rows) { Vendeur unvd = new Vendeur(); unvd.NoVendeur = dataRow[1].ToString(); Clientel uncli = new Clientel(); uncli.NoCl = dataRow[2].ToString(); Commande unecde = new Commande(dataRow[0].ToString(), ((DateTime)dataRow[3]), dataRow[4].ToString(), unvd, uncli); mesCdes.Add(unecde); } return mesCdes; } catch (MonException erreur) { throw erreur; } }