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