public IList <TipoInmueble> ObtenerTodos()
{
IList <TipoInmueble> res = new List <TipoInmueble>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = $"SELECT IdTipoInmueble, NombreTipo" +
$" FROM TipoInmueble";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
TipoInmueble p = new TipoInmueble
{
IdTipoInmueble = reader.GetInt32(0),
NombreTipo = reader.GetString(1),
};
res.Add(p);
}
connection.Close();
}
}
return(res);
}
public int Alta(TipoInmueble p)
{
int res = -1;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sql = $"INSERT INTO TipoInmueble (NombreTipo) " +
$"VALUES (@nombre);" +
$"SELECT SCOPE_IDENTITY();";//devuelve el id insertado
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@nombre", p.NombreTipo);
connection.Open();
res = Convert.ToInt32(command.ExecuteScalar());
p.IdTipoInmueble = res;
connection.Close();
}
}
return(res);
}
