private void loadHistory()
{
List <DialogHistoryInfo> historyList = DialogHistoryInfo.getDialogHistoryList(sessionInfo.dialogScript);
foreach (DialogHistoryInfo di in historyList)
{
this.showHistoryView(di);
}
}
public static DialogHistoryInfo dataToObject(SqliteDataReader reader)
{
DialogHistoryInfo dialogInfo = new DialogHistoryInfo();
dialogInfo.id = reader.GetInt16(reader.GetOrdinal("id"));
dialogInfo.avatar = reader.GetString(reader.GetOrdinal("avatar"));
dialogInfo.name = reader.GetString(reader.GetOrdinal("name"));
dialogInfo.actorId = reader.GetInt16(reader.GetOrdinal("actorId"));
dialogInfo.type = reader.GetString(reader.GetOrdinal("type"));
dialogInfo.delay = reader.GetInt16(reader.GetOrdinal("delay"));
dialogInfo.text = reader.GetString(reader.GetOrdinal("text"));
dialogInfo.voice = reader.GetString(reader.GetOrdinal("voice"));
dialogInfo.video = reader.GetString(reader.GetOrdinal("video"));
dialogInfo.image = reader.GetString(reader.GetOrdinal("image"));
dialogInfo.send = reader.GetString(reader.GetOrdinal("send"));
return(dialogInfo);
}
public static void writeDialogHistory(DialogHistoryInfo di)
{
SQLiteUtils sqlUtils = new SQLiteUtils();
string[] keys = new string[di.GetType().GetProperties().Length];
for (int i = 0; i < di.GetType().GetProperties().Length; i++)
{
PropertyInfo pi = di.GetType().GetProperties() [i];
keys [i] = pi.Name;
}
string[] values = new string[di.GetType().GetProperties().Length];
for (int i = 0; i < di.GetType().GetProperties().Length; i++)
{
PropertyInfo p = di.GetType().GetProperties() [i];
PropertyInfo pi = di.GetType().GetProperty(p.Name);
values [i] = pi.GetValue(pi, null).ToString();
}
sqlUtils.writeHistory(Constants.HistoryTable, keys, values);
sqlUtils.closeConnection();
}