public static int Insert(SqlCategory o)
{
LAST_EXCEPTION = null;
try
{
using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(DATABASE_PATH))
{
conn.Insert(o);
}
Categories.Add(o.Id, o);
return(o.Id);
}
catch (Exception ex)
{
LAST_EXCEPTION = ex.Message;
return(-1);
}
}
public static bool Update(SqlCategory o)
{
LAST_EXCEPTION = null;
try
{
using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(DATABASE_PATH))
{
conn.RunInTransaction(() =>
{
conn.Update(o);
});
}
return(true);
}
catch (Exception ex)
{
LAST_EXCEPTION = ex.Message;
return(false);
}
}