public bool InsertGameInfo(GameInfoDB gameInfoDB) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(_folderPathString, NAME_DB_STRING))) { connection.Insert(gameInfoDB); return(true); } } catch (SQLiteException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }
public bool updateTable(GameInfoDB gameInfoDB) { try { using (var connection = new SQLiteConnection(System.IO.Path.Combine(_folderPathString, NAME_DB_STRING))) { connection.Query <GameInfoDB>("UPDATE GameInfoDB set OpponentDeviceMac=?, OpponentDeviceName=?, amountOfOpponentWin=?, amountOfYourWin=?, lastDateTimeGame=? Where Id=?", gameInfoDB.OpponentDeviceMac, gameInfoDB.OpponentDeviceName, gameInfoDB.amountOfOpponentWin, gameInfoDB.amountOfYourWin, gameInfoDB.lastDateTimeGame, gameInfoDB.Id); return(true); } } catch (SQLiteException ex) { Log.Info("SQLiteEx", ex.Message); return(false); } }