public List <UniversalUserEntity> GetAllUnSyncUserLimit()
{
List <UniversalUserEntity> entities = new List <UniversalUserEntity>();
ConnectDbCustom();
IDataReader reader = GetDataByStringLimit(KEY_SYNC, "false", 10);
Debug.Log("Reader fieldCount : " + reader.FieldCount);
while (reader.Read())
{
UniversalUserEntity entity = new UniversalUserEntity();
for (int i = 0; i < reader.FieldCount; i++)
{
// Debug.Log("Index i : " + i);
entity.name = reader[1].ToString();
entity.email = reader[2].ToString();
entity.contact = reader[3].ToString();
// entity.age = reader[4].ToString();
// entity.dob = reader[5].ToString();
// entity.gender = reader[6].ToString();
entity.game_result = reader[7].ToString();
entity.game_score = reader[8].ToString();
entity.created_at = reader[9].ToString();
entity.is_submitted = reader[10].ToString();
}
entities.Add(entity);
}
Close();
return(entities);
}
public List <UniversalUserEntity> GetAllUnSyncUserSlow()
{
List <UniversalUserEntity> entities = new List <UniversalUserEntity>();
ConnectDbCustom();
FieldInfo[] fieldInfo = Type.GetType(gameSettings.sQliteDBSettings.UniversalUserClassName).GetFields();
IDataReader reader = GetDataByString(KEY_SYNC, "false");
// Debug.Log("Reader fieldCount : " + reader.FieldCount);
while (reader.Read())
{
UniversalUserEntity entity = new UniversalUserEntity();
for (int i = 0; i < reader.FieldCount; i++)
{
// Debug.Log("Index i : " + i);
fieldInfo[i].SetValue(entity, reader[i].ToString());
}
entities.Add(entity);
}
Close();
return(entities);
}
public void UpdateSyncUser(UniversalUserEntity userEntity)
{
List <string> col = new List <string>();
List <string> con = new List <string>();
col.Add("is_submitted");
con.Add("true");
string condition = KEY_EMAIL + " = '" + userEntity.email + "'";
try { UpdateData(col, con, condition); Debug.Log("Update user " + userEntity.email + " to submitted"); }
catch (Exception ex)
{
Debug.LogError(ex.Message);
}
}
private IEnumerator CompareLocalAndServerData()
{
SetUpDb();
DataBank.UniversalUserEntity u = new DataBank.UniversalUserEntity();
for (int m = 0; m < emailList.Count; m++)
{
UniversalUserEntity foundUser = FindDuplicatedStringItem(emailList[m], unSyncUsers);
if (foundUser != null)
{
// SetUpDb();
// if (udb.GetDataByString("email", foundUser.email) != null) udb.UpdateSyncUser(foundUser);
yield return(new WaitForEndOfFrame());
unSyncUsers.Remove(foundUser);
Debug.Log(foundUser.email + " is removed from sync");
}
}
}
public List <UniversalUserEntity> GetAllUser()
{
List <UniversalUserEntity> entities = new List <UniversalUserEntity>();
FieldInfo[] fieldInfo = Type.GetType(gameSettings.sQliteDBSettings.UniversalUserClassName).GetFields();
IDataReader reader = GetAllData();
while (reader.Read())
{
UniversalUserEntity entity = new UniversalUserEntity();
for (int i = 0; i < reader.FieldCount; i++)
{
fieldInfo[i].SetValue(entity, reader[i].ToString());
}
entities.Add(entity);
}
Close();
return(entities);
}