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);
}
}
