public List<ToDO> ViewAllNotes()
{
try
{
using (var conn = new SQLite.SQLiteConnection (dbPath))
{
var cmd = new SQLite.SQLiteCommand (conn);
var NoteList = cmd.ExecuteQuery<ToDO> ();
return NoteList;
}
} catch(Exception e)
{
Console.WriteLine ("Error: " + e.Message);
return null;
}
}
public List<ListInfo> ViewAll()
{
try
{
using (var conn = new SQLite.SQLiteConnection(dbPath)) //-------------------Prepares connection to database
{
var cmd = new SQLite.SQLiteCommand(conn); //----------------------------Prepares communication with database
cmd.CommandText = "Select NoteID, Title, Body, Dt from NOTES_TBL"; //---SQLite statement to pass back
var NoteList = cmd.ExecuteQuery<ListInfo>(); //-------------------------Reads information from db and prepares it in a list
return NoteList; //-----------------------------------------------------Passes list to data adapter
}
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message); //--------------------------------Write error in english to output
return null;
}
}
public List<city_names> loadWords()
{
try
{
using (var conn = new SQLite.SQLiteConnection (dbPath))
{
var cmd = new SQLite.SQLiteCommand (conn);
cmd.CommandText = "select * from cities";
var tempList = cmd.ExecuteQuery<city_names> ();
return tempList;
}
} catch (Exception ex) {
Console.WriteLine ("Error:" + ex.Message);
return null;
}
}
/// <summary>
/// Loads all the saved High scores
/// </summary>
/// <returns>highscores</returns>
public List<highscore> getScores()
{
try
{
using (var conn = new SQLite.SQLiteConnection (dbPath))
{
var cmd = new SQLite.SQLiteCommand (conn);
cmd.CommandText = "select * from highscores order by score desc";
var tempList = cmd.ExecuteQuery<highscore> ();
return tempList;
}
} catch (Exception ex) {
Console.WriteLine ("Error:" + ex.Message);
return null;
}
}
//Function for reading locations from the database
public List<ClassLocations> readLocations()
{
try
{
using (var conn = new SQLite.SQLiteConnection(dbPath))
{
var cmd = new SQLite.SQLiteCommand(conn);
//Select word from given category
cmd.CommandText = "SELECT * FROM LOCATIONS";
var LocationList = cmd.ExecuteQuery<ClassLocations>();
return LocationList;
}
}
catch (Exception e)
{
Console.WriteLine("Error:" + e.Message);
return null;
}
}
public List<ToDo> ViewAll()
{
try
{
using (var conn = new SQLite.SQLiteConnection(dbPath))
{
var cmd = new SQLite.SQLiteCommand(conn);
// cmd.CommandText = "Select * from words";
//SELECT ONE WORD RANDOMLY
cmd.CommandText = "SELECT * FROM words ORDER BY RANDOM() LIMIT 1";
var NoteList = cmd.ExecuteQuery<ToDo>();
return NoteList;
}
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
return null;
}
}
/// <summary>
/// Check if the specified user exists
/// </summary>
/// <param name="username">Username.</param>
public List<accounts> login(string username)
{
try
{
using (var conn = new SQLite.SQLiteConnection (dbPath))
{
var cmd = new SQLite.SQLiteCommand (conn);
cmd.CommandText = "select * from accounts where username like '%" + username + "%'";
var tempList = cmd.ExecuteQuery<accounts> ();
return tempList;
}
} catch (Exception ex) {
Console.WriteLine ("Error:" + ex.Message);
return null;
}
}
