public void eliminar(int id)
{
SqlConnection conn = Conexion.getConnection();
conn.Open();
List <Alquiler> alquileres = new AlquilerData().obtenerAlquileresDeInmueble(id);
foreach (Alquiler a in alquileres)
{
new AlquilerData().eliminar(a.Id);
new InquilinoData().eliminar(a.Inquilino.Id);
}
String sql = "DELETE FROM inmueble WHERE id = " + id;
SqlCommand command1 = new SqlCommand(sql, conn);
command1.ExecuteReader();
conn.Close();
}
public List <Pagos> obtenerPagos(int idAlquiler)
{
//SqlConnection conn = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=inmobiliaria;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlConnection conn = Conexion.getConnection();
String sql = "SELECT * FROM pagos WHERE id_alquiler = " + idAlquiler;
SqlCommand command = new SqlCommand(sql, conn);
conn.Open();
var reader = command.ExecuteReader();
List <Pagos> pagos = new List <Pagos>();
while (reader.Read())
{
System.Diagnostics.Debug.WriteLine("HOLAAAAAAAA");
AlquilerData alquilerData = new AlquilerData();
Alquiler alquiler = alquilerData.obtenerAlquiler(idAlquiler);
Pagos p = new Pagos {
Id = reader.GetInt32(0),
NroPago = Convert.ToInt32(reader["nro_pago"]),
Fecha = Convert.ToDateTime(reader["fecha"]),
Importe = Convert.ToInt32(reader["importe"]),
Alquiler = alquiler,
};
pagos.Add(p);
}
conn.Close();
return(pagos);
}
