public static void AddItem(string title, string details)
{
try
{
var addThis = new tblToDo()
{
Title = title, Details = details
};
db.Insert(addThis);
}
catch (Exception e)
{
Console.WriteLine("Add Error:" + e.Message);
}
}
public static void EditItem(string title, string details, int listid)
{
try
{
// http://stackoverflow.com/questions/14007891/how-are-sqlite-records-updated
var EditThis = new tblToDo()
{
Title = title, Details = details, Id = listid
};
db.Update(EditThis);
//or this
// db.Execute("UPDATE tblToDoList Set Title = ?, Details =, WHERE ID = ?", title, details, listid);
}
catch (Exception e)
{
Console.WriteLine("Update Error:" + e.Message);
}
}
public static List <tblToDo> ViewAll()
{
try
{
return(db.Query <tblToDo>("select * from tblToDo"));
}
catch (Exception e)
{
Console.WriteLine("Error:" + e.Message);
//making some fake items to stop the system from crashing when the DB doesn't connect
List <tblToDo> fakeitem = new List <tblToDo>();
//make a single item
tblToDo item = new tblToDo();
item.Id = 100;
item.Date = DateTime.Now.Date;
item.Details = "There are no items";
item.Title = "No Items";
fakeitem.AddRange(new[] { item }); //add it to the fake item list
return(fakeitem);
}
}