getPredioDetails method

Implementation

Future<Map<String, String>?> getPredioDetails(int propertyId) async {
  final db = await database;
  final result = await db.rawQuery(
    '''
  SELECT
    departamento_name,
    municipio_name,
    first_name,
    last_name,
    nombre_predio,
    corregimiento,
    vereda
  FROM
    predios
  WHERE
    id = ?
  ''',
    [propertyId],
  );
  if (result.isNotEmpty) {
    final firstName = result.first['first_name'] as String;
    final lastName = result.first['last_name'] as String;
    return {
      'departamento_name': result.first['departamento_name'] as String,
      'municipio_name': result.first['municipio_name'] as String,
      'nombre_propietario': '$firstName $lastName',
      'nombre_predio': result.first['nombre_predio'] as String? ?? '',
      'corregimiento': result.first['corregimiento'] as String? ?? '',
      'localidad': result.first['vereda'] as String? ?? '',
    };
  }
  return null;
}