<?php
require_once ("/../includes/claseConexion.php");
class Cliente{
private $conexion;
private $stm;
private $CUIT;
private $nombreyapellido;
private $domicilio;
private $ciudad;
private $telfijo;
private $cel;
private $cativa;
public function Listar()
{
try
{
$conexion = Conexion::singleton_conexion();
$stm=$conexion->prepare("SELECT * FROM cliente;");
$stm->execute();
return $stm->fetchAll(PDO::FETCH_OBJ);
}
catch(Exception $e)
{
die($e->getMessage());
}
}
public function Obtener($id)
{
try
{
$stm = $this->pdo
->prepare("SELECT * FROM cliente WHERE id = ?");
// $stm->execute(array($id));
return $stm->fetch(PDO::FETCH_OBJ);
} catch (Exception $e)
{
die($e->getMessage());
}
}
public function Eliminar($id)
{
try
{
$stm = $this->pdo
->prepare("DELETE FROM cliente WHERE id = ?");
$stm->execute(array($id));
} catch (Exception $e)
{
die($e->getMessage());
}
}
public function Actualizar($data)
{
try
{
$sql = "UPDATE cliente SET
dni = ?,
Nombre = ?,
Apellido = ?,
Correo = ?,
Telefono = ?
WHERE id = ?";
$this->pdo->prepare($sql)
->execute(
array(
$data->dni,
$data->Nombre,
$data->Apellido,
$data->Correo,
$data->telefono,
$data->id
)
);
} catch (Exception $e)
{
die($e->getMessage());
}
}
public function Registrar(cliente $data)
{
try
{
$sql = "INSERT INTO cliente (dni,Nombre,Apellido,Correo,telefono)
VALUES (?, ?, ?, ?, ?)";
$this->pdo->prepare($sql)
->execute(
array(
$data->dni,
$data->Nombre,
$data->Apellido,
$data->Correo,
$data->telefono
)
);
} catch (Exception $e)
{
die($e->getMessage());
}
}
}
?>