// Retrieve the node list found by Base64Handle in the database table.
public static ObservableCollection <SavedForOffline> ReadNodesByBase64Handle(String base64Handle)
{
return(DataBaseHelper <SavedForOffline> .ReadNodes(DB_TABLE_NAME, FIELD_BASE_64_HANDLE, base64Handle));
}
// Retrieve the node list found by Fingerprint in the database table.
public static ObservableCollection <SavedForOffline> ReadNodesByFingerprint(String fingerprint)
{
return(DataBaseHelper <SavedForOffline> .ReadNodes(DB_TABLE_NAME, FIELD_FINGERPRINT, fingerprint));
}
// Retrieve the first node found by Base64Handle in the database table.
public static SavedForOffline ReadNodeByBase64Handle(String base64Handle)
{
return(DataBaseHelper <SavedForOffline> .ReadNode(DB_TABLE_NAME, FIELD_BASE_64_HANDLE, base64Handle));
}
// Retrieve the node list found by LocalPath in the database table.
public static ObservableCollection <SavedForOffline> ReadNodesByLocalPath(String localPath)
{
return(DataBaseHelper <SavedForOffline> .ReadNodes(DB_TABLE_NAME, FIELD_LOCAL_PATH, localPath));
}
// Retrieve the first node found by Fingerprint in the database table.
public static SavedForOffline ReadNodeByFingerprint(String fingerprint)
{
return(DataBaseHelper <SavedForOffline> .ReadNode(DB_TABLE_NAME, FIELD_FINGERPRINT, fingerprint));
}
/// <summary>
/// Delete all node list or delete table
/// </summary>
/// <returns>TRUE if all went well or FALSE in other case</returns>
public static bool DeleteAllNodes()
{
return(DataBaseHelper <SavedForOffline> .DeleteAllNodes());
}
// Retrieve the first node found by LocalPath in the database table.
public static SavedForOffline ReadNodeByLocalPath(String localPath)
{
return(DataBaseHelper <SavedForOffline> .ReadNode(DB_TABLE_NAME, FIELD_LOCAL_PATH, localPath));
}
// Delete the first node found with the specified field value
public static void DeleteNodeByLocalPath(String localPath)
{
DataBaseHelper <SavedForOffline> .DeleteNode(DB_TABLE_NAME, FIELD_LOCAL_PATH, localPath);
}
// Delete specific node
public static void DeleteNode(SavedForOffline node)
{
DataBaseHelper <SavedForOffline> .DeleteNode(node);
}
// Update existing node
public static void UpdateNode(SavedForOffline node)
{
DataBaseHelper <SavedForOffline> .UpdateNode(node);
}
// Insert the new node in the database.
public static void Insert(SavedForOffline newNode)
{
DataBaseHelper <SavedForOffline> .Insert(newNode);
}
// Retrieve the all node list from the database table.
public static ObservableCollection <SavedForOffline> ReadAllNodes()
{
return(DataBaseHelper <SavedForOffline> .ReadAllNodes());
}
// Retrieve the node list found by IsSelectedForOffline in the database table.
public static ObservableCollection <SavedForOffline> ReadNodesByIsSelectedForOffline(bool isSelectedForOffline)
{
return(DataBaseHelper <SavedForOffline> .ReadNodes(DB_TABLE_NAME, FIELD_IS_SELECTED_FOR_OFFLINE, isSelectedForOffline.ToString()));
}
// Retrieve the first node found by IsSelectedForOffline in the database table.
public static SavedForOffline ReadNodeByIsSelectedForOffline(bool isSelectedForOffline)
{
return(DataBaseHelper <SavedForOffline> .ReadNode(DB_TABLE_NAME, FIELD_IS_SELECTED_FOR_OFFLINE, isSelectedForOffline.ToString()));
}
// Indicate if the node exists by ParentBase64Handle in the database table.
public static bool ExistNodeByParentBase64Handle(String parentBase64Handle)
{
return(DataBaseHelper <SavedForOffline> .ExistsNode(DB_TABLE_NAME, FIELD_PARENT_BASE_64_HANDLE, parentBase64Handle));
}
// Delete all node list or delete table
public static void DeleteAllNodes()
{
DataBaseHelper <SavedForOffline> .DeleteAllNodes();
}
