insertATable function

dynamic insertATable(dynamic tablename, dynamic companyid, dynamic tableid, dynamic data,)

Implementation

insertATable(tablename, companyid, tableid, data) async {
  int iCompanyid = 1;
  if (companyid != '') {
    iCompanyid = int.parse(companyid);
  }
  await setDB();
  //final db = await database;
  //print('====insert msg $map');
  if (tablename == gSSTableName) {
    //check dup

    final List<Map<String, dynamic>> maps =
        await getATable(gSSTableName, companyid, tableid);
    dynamic dataSerial = getJsonEncode(data);
    if (maps.isNotEmpty) {
      //id = maps[0][gId];
      await db.update(tablename,
          {gCompanyid: iCompanyid, gTableID: tableid, gData: dataSerial},
          where: '$gCompanyid=? and $gTableID=?',
          whereArgs: [iCompanyid, tableid]);
      return;
    }
    /*dynamic result = await db.rawQuery('SELECT MAX(id) + 1 FROM $tablename');
    id = Sqflite.firstIntValue(result);*/
    await db.insert(
      tablename,
      {gCompanyid: iCompanyid, gTableID: tableid, gData: dataSerial},
      conflictAlgorithm: ConflictAlgorithm.replace,
    );
  }
}