public bool SaveDataToDB(IDataModel data) { try { LevelSuccessTime lst = (LevelSuccessTime)data; _db.Open(); IDbCommand cmd = _db.CreateCommand(); cmd.CommandText = LEVEL_SUCCESS_INSERT_TIME; IDbDataParameter levelId = cmd.CreateParameter(); levelId.ParameterName = "@param1"; levelId.Value = lst.LevelID; cmd.Parameters.Add(levelId); IDbDataParameter successTime = cmd.CreateParameter(); successTime.ParameterName = "@param2"; successTime.Value = lst.SuccessTime; cmd.Parameters.Add(successTime); bool res = cmd.ExecuteNonQuery() > 0; _db.Close(); _db.Dispose(); return(res); } catch (Exception e) { Debug.LogError(e.Message); return(false); } }
public bool LoadAllDataFromDB() { try { _db.Open(); IDbCommand cmd = _db.CreateCommand(); cmd.CommandText = LEVEL_SUCCESS_TIME_DATA; IDataReader reader = cmd.ExecuteReader(); listLevelSuccessTime = new List <LevelSuccessTime>(); while (reader.Read()) { LevelSuccessModel = new LevelSuccessTime() { SuccessID = reader.GetInt32(0), LevelID = reader.GetInt32(1), SuccessTime = reader.GetInt32(2) }; listLevelSuccessTime.Add(LevelSuccessModel); } reader.Close(); _db.Close(); _db.Dispose(); return(true); } catch (Exception e) { Debug.LogError(e.Message); _db.Close(); _db.Dispose(); return(false); } }
public void GetRandomEntryFromLevelSuccessTime() { di = new DependencyInjector(); lst = new LevelSuccessTime(); llst = new List <LevelSuccessTime>(); llst = di.GetAllLevelSuccessTime(); lst = llst[Random.Range(1, llst.Count)]; }
public void CreateNewEntryForLevelSuccessTime() { di = new DependencyInjector(); lst = new LevelSuccessTime(); lst.LevelID = (int)Random.Range(1f, 3f); lst.SuccessTime = (int)Random.Range(0f, 100f); di.SaveSuccesTime(lst); }
public bool SavePerformanceForLevel(IDataModel data) { LevelSuccessTime _lst = (LevelSuccessTime)data; if (SavePerformanceInNewEntry(_lst.LevelID, 5)) { return(SaveDataToDB(data)); } return(UpdateOldestEntry(data)); }
private LevelSuccessTime GetOldestEntryByLevelID(IDataModel data) { try { LevelSuccessTime _lst = (LevelSuccessTime)data; LevelSuccessTime _rlst = new LevelSuccessTime(); _db.Open(); IDbCommand cmd = _db.CreateCommand(); cmd.CommandText = OLDEST_LEVEL_SUCCESS_TIME_DATA_BY_LEVELID; IDbDataParameter levelId = cmd.CreateParameter(); levelId.ParameterName = "@param1"; levelId.Value = _lst.LevelID; cmd.Parameters.Add(levelId); IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { _rlst.SuccessID = reader.GetInt32(0); _rlst.LevelID = reader.GetInt32(1); _rlst.SuccessTime = reader.GetInt32(2); } reader.Close(); _db.Close(); _db.Dispose(); return(_rlst); } catch (Exception e) { Debug.LogError(e.Message); _db.Close(); _db.Dispose(); return(null); } }