public Boolean CurrentUserHasID()
{
string command = String.Format(
"SELECT id FROM {0} WHERE userName='******';",
DatabaseOperations.userNameTable,
Environment.UserName
);
SQLiteDataReader reader = dbOperations.GetDataReader(command);
return(reader.Read());
}
/// <summary>
/// Pulls entries for current user from database and returns list
/// of string array with encrypted content.
/// </summary>
/// <returns>List of string[3] where string[0], [1] & [2] corresponds to Index, content and Time respectively</returns>
public List <EncryptedTextContent> GetTextData()
{
string query = String.Format("SELECT * FROM {0} where byUser='******';", DatabaseOperations.textEntriesTable, user.id);
SQLiteDataReader databaseDataReader = dbOperations.GetDataReader(query);
List <EncryptedTextContent> outputList = new List <EncryptedTextContent>();
while (databaseDataReader.Read())
{
EncryptedTextContent contentToAdd = new EncryptedTextContent();
//ignored value at [0] since id of record is of no use in this context.
contentToAdd.index = databaseDataReader.GetInt32(1); //Index of record acording to clipboarder entry
contentToAdd.encryptedText = databaseDataReader.GetString(2); //content
contentToAdd.time = databaseDataReader.GetString(3); //time of entry in clipboarder
outputList.Add(contentToAdd);
}
return(outputList);
}
