public static ObservableCollection <VendeurDAO> selectVendeurs()
{
ObservableCollection <VendeurDAO> l = new ObservableCollection <VendeurDAO>();
string query = "SELECT * FROM vendeur ORDER BY id_vendeur ASC;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
VendeurDAO p = new VendeurDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2));
l.Add(p);
}
}
catch (Exception e)
{
MessageBox.Show("Il y a un problème dans la table vendeur : {0}", e.StackTrace);
}
reader.Close();
return(l);
}
public static VendeurViewModel getVendeur(int idVendeur)
{
VendeurDAO pDAO = VendeurDAO.getVendeur(idVendeur);
VendeurViewModel p = new VendeurViewModel(pDAO.idVendeurDAO, pDAO.idPersonneDAO, pDAO.iDPeronneDAO, pDAO.nomVendeurDAO, pDAO.prenomVendeurDAO, pDAO.mailVendeurDAO, pDAO.numeroTelVendeurDAO, pDAO.motDePasseVendeurDAO, pDAO.adresseVendeurDAO, pDAO.codePostalVendeurDAO, pDAO.ageVendeurDAO);
return(p);
}
public static ObservableCollection <VendeurDAO> selectVendeur()
{
ObservableCollection <VendeurDAO> l = new ObservableCollection <VendeurDAO>();
string query = "SELECT * FROM vendeur LEFT JOIN personne ON vendeur.idPersonne = personne.id;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
VendeurDAO p = new VendeurDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetInt32(9), reader.GetInt32(10));
l.Add(p);
}
}
catch (Exception e)
{
MessageBox.Show("Il y a un problème dans la table Vendeur : {0}", e.StackTrace);
}
reader.Close();
return(l);
}
public static VendeurViewModel getVendeur(int idVendeur)
{
VendeurDAO pDAO = VendeurDAO.getVendeur(idVendeur);
VendeurViewModel p = new VendeurViewModel(pDAO.id_vendeur, pDAO.id_personne, pDAO.id_produit);
return(p);
}
public static void updateVendeur(VendeurDAO p)
{
string query = "UPDATE vendeur set id_personne=" + p.id_personne + ", id_produit=" + p.id_produit + " where id_vendeur=" + p.id_vendeur + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void updateVendeur(VendeurDAO p)
{
string query = "UPDATE vendeur LEFT JOIN personne ON vendeur.idPersonne = personne.id set idPersonne=\"" + p.idPersonneDAO + "\", nom=\"" + p.nomVendeurDAO + "\", prenom=\"" + p.prenomVendeurDAO + "\", mail=\"" + p.mailVendeurDAO + "\", numeroTel=\"" + p.numeroTelVendeurDAO + "\", motDePasse=\"" + p.motDePasseVendeurDAO + "\", adresse=\"" + p.adresseVendeurDAO + "\", codePostal=\"" + p.codePostalVendeurDAO + "\", age=\"" + p.ageVendeurDAO + "\" where vendeur.id=" + p.idVendeurDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertVendeur(VendeurDAO p)
{
int id = getMaxIdVendeur() + 1;
string query = "INSERT INTO vendeur VALUES (\"" + id + "\",\"" + p.id_personne + "\",\"" + p.id_produit + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static ObservableCollection <VendeurViewModel> listeVendeur()
{
ObservableCollection <VendeurDAO> lDAO = VendeurDAO.listeVendeur();
ObservableCollection <VendeurViewModel> l = new ObservableCollection <VendeurViewModel>();
foreach (VendeurDAO element in lDAO)
{
VendeurViewModel p = new VendeurViewModel(element.idVendeurDAO, element.idPersonneDAO, element.iDPeronneDAO, element.nomVendeurDAO, element.prenomVendeurDAO, element.mailVendeurDAO, element.numeroTelVendeurDAO, element.motDePasseVendeurDAO, element.adresseVendeurDAO, element.codePostalVendeurDAO, element.ageVendeurDAO);
l.Add(p);
}
return(l);
}
public static ObservableCollection <VendeurViewModel> listeVendeurs()
{
ObservableCollection <VendeurDAO> lDAO = VendeurDAO.listeVendeurs();
ObservableCollection <VendeurViewModel> l = new ObservableCollection <VendeurViewModel>();
foreach (VendeurDAO element in lDAO)
{
VendeurViewModel p = new VendeurViewModel(element.id_vendeur, element.id_personne, element.id_produit);
l.Add(p);
}
return(l);
}
// GET: Commande/Create
public ActionResult Create()
{
CommandeViewModel commandeVM;
Commande commande = new Commande();
IEnumerable <Clientel> clients = new ClientelDAO().GetAll();
IEnumerable <Vendeur> vendeurs = new VendeurDAO().GetAll();
commandeVM = new CommandeViewModel(commande);
commandeVM.Clients = GetClients(clients, commande.Client);
commandeVM.Vendeurs = GetVendeurs(vendeurs, commande.Vendeur);
return(View("~/Views/Commande/Modifier.cshtml", commandeVM));
}
public static VendeurDAO getVendeur(int idvendeur)
{
string query = "SELECT * FROM vendeur WHERE id_vendeur=" + idvendeur + "\";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
VendeurDAO pers = new VendeurDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2));
reader.Close();
return(pers);
}
public static VendeurDAO getVendeur(int id)
{
string query = "SELECT * FROM vendeur LEFT JOIN personne ON vendeur.idPersonne = personne.id WHERE vendeur.idPersonne = " + id + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
VendeurDAO cat = new VendeurDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetInt32(9), reader.GetInt32(10));
reader.Close();
return(cat);
}
// GET: Commande/Edit/5
public ActionResult Modifier(int?id)
{
CommandeViewModel commandeVM = null;
try
{
if (id == null)
{
throw new Exception();
}
Commande commande = new CommandeDAO().GetSingleById((int)id);
IEnumerable <Clientel> clients = new ClientelDAO().GetAll();
IEnumerable <Vendeur> vendeurs = new VendeurDAO().GetAll();
commandeVM = new CommandeViewModel(commande);
commandeVM.Clients = GetClients(clients, commande.Client);
commandeVM.Vendeurs = GetVendeurs(vendeurs, commande.Vendeur);
}
catch (Exception e)
{
ModelState.AddModelError("Erreur", "Erreur lors de la récupération du client : " + e.Message);
}
return(View(commandeVM));
}
public static void updateVendeur(VendeurViewModel p)
{
VendeurDAO.updateVendeur(new VendeurDAO(p.idVendeurProperty, p.idPersonneProperty, p.idPeronneProperty, p.nomVendeurProperty, p.prenomVendeurProperty, p.mailVendeurProperty, p.numeroTelVendeurProperty, p.motDePasseVendeurProperty, p.adresseVendeurProperty, p.codePostalVendeurProperty, p.ageVendeurProperty));
}
public static void insertVendeur(VendeurViewModel p)
{
VendeurDAO.insertVendeur(new VendeurDAO(p.idVendeurProperty, p.idPersonneProperty));
}
public static void insertVendeur(VendeurViewModel p)
{
VendeurDAO.insertVendeur(new VendeurDAO(p.id, p.id_personne, p.id_produit));
}
public static void supprimerVendeur(int id)
{
VendeurDAO.supprimerVendeur(id);
}
public static void updateVendeur(VendeurViewModel p)
{
VendeurDAO.updateVendeur(new VendeurDAO(p.id, p.id_personne, p.id_produit));
}
