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