public static function setModifAdresse(Utilisateur $user)
{
try {
$conn = Main::BDDConnexionPDO();
$req = $conn->prepare("UPDATE Utilisateur SET Adresse=?, CodePostal=?, Ville=? WHERE AdresseMail=? ");
$req->execute(array($user->getAdresse(), $user->getCodePostal(), $user->getVille(), $user->getAdresseMail()));
$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;
}
public static function setAjouterUser(Utilisateur $unUser)
{
try {
$mdp = sha1($unUser->getPassword());
$conn = Main::BDDConnexionPDO();
$reqprepare2 = $conn->prepare("INSERT INTO Utilisateur (Nom, Prenom, Password, AdresseMail, Adresse, CodePostal, Ville) VALUES (?,?,?,?,?,?,?)");
$reqprepare2->execute(array($unUser->getNom(), $unUser->getPrenom(), $mdp, $unUser->getAdresseMail(), $unUser->getAdresse(), $unUser->getCodePostal(), $unUser->getVille()));
$conn = null;
} catch (\PDOException $ex) {
Main::setFlashMessage($ex->getMessage(), 'error');
}
}
