getOptionList method

dynamic getOptionList({
  1. dynamic model = "",
  2. String selectQuery = "",
  3. String queryFieldName = "FieldName",
  4. String queryFieldValue = "",
  5. String optionTextName = "OptionText",
  6. String optionValueName = "OptionValue",
})

Implementation

getOptionList({dynamic model = "", String selectQuery = "", String queryFieldName = "FieldName", String queryFieldValue = "",  String optionTextName = "OptionText", String optionValueName = "OptionValue" }) async {
  final db = await DatabaseHelper().getDatabaseInstance;
  List<Map<String, dynamic>> maps = [];
  if (selectQuery != "") {
    maps = await db.rawQuery(selectQuery);
  } else {
    maps = await db.rawQuery("Select $optionTextName,$optionValueName From ${model.runtimeType.toString()} where $queryFieldName = '$queryFieldValue'");
  }
  return maps;
}