private int insertTileset(string tilesetName)
{
try
{
_sqlite.BeginTransaction(true);
//return _sqlite.Insert(new tilesets { name = tilesetName });
tilesets newTileset = new tilesets {
name = tilesetName
};
int rowsAffected = _sqlite.Insert(newTileset);
if (1 != rowsAffected)
{
throw new Exception(string.Format("tileset [{0}] was not inserted, rows affected:{1}", tilesetName, rowsAffected));
}
return(newTileset.id);
}
catch (Exception ex)
{
Debug.LogErrorFormat("could not insert tileset [{0}]: {1}", tilesetName, ex);
return(-1);
}
finally
{
_sqlite.Commit();
}
}
private int?getTilesetId(string tilesetName)
{
tilesets tileset = _sqlite
.Table <tilesets>()
.Where(ts => ts.name.Equals(tilesetName))
.FirstOrDefault();
return(null == tileset ? (int?)null : tileset.id);
}