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); }