public static function setModifMail(Utilisateur $user)
{
try {
$conn = Main::BDDConnexionPDO();
$req = $conn->prepare("UPDATE Utilisateur SET AdresseMail=? WHERE NumUser=? ");
$req->execute(array($user->getAdresse(), $user->getNumUser()));
$conn = null;
} catch (\Exception $ex) {
Main::setFlashMessage($ex->getMessage(), 'error');
}
}
/**
* @param Utilisateur $user
* @return Collection
*/
public static function getLesCommandesbyUser(Utilisateur $user)
{
$LesCommandes = new Collection();
try {
$conn = Main::BDDConnexionPDO();
$req = $conn->prepare("SELECT * FROM Commande\n\t\t\tWHERE NoUsers = ?");
$req->execute(array($user->getNumUser()));
$req = $req->fetchAll();
foreach ($req as $Commande) {
$user = MConnexion::getUnUserbyId($Commande['NoUsers']);
$commande = new Commande($Commande['NumCommande'], $user, $Commande['DateCommande']);
$LesCommandes->ajouter($commande);
}
} catch (\Exception $e) {
Main::setFlashMessage($e->getMessage(), 'error');
}
return $LesCommandes;
}
