private void OnAddLibrary(object obj)
{
LibraryItemEntity item = (from library in CacheLibraryList
where (0 == string.Compare(library.Path, TargetPath, true))
select library).FirstOrDefault <LibraryItemEntity>();
if (item.IsNull())
{
//Add to library
MessageBox.Show("new");
newAddedList.Add(new LibraryItemEntity()
{
Path = TargetPath, Level = (int)SelectedScanRank
});
}
else
{
if (item.Level == (int)SelectedScanRank)
{
MessageBox.Show("Exist same");
}
else
{
MessageBox.Show("Exist need update");
item.Level = (int)SelectedScanRank;
updatedList.Add(item);
}
}
TargetPath = string.Empty;
}
public void SaveLibrary(IList <IFolder> selectedFolders, Action callback)
{
if (selectedFolders.IsNull())
{
return;
}
IList <LibraryItemEntity> list = new List <LibraryItemEntity>();
foreach (IFolder folder in selectedFolders)
{
LibraryItemEntity item = new LibraryItemEntity()
{
Path = folder.FullPath
};
list.Add(item);
}
DataManager.Instance.StartScanAndUpdateDB(list, callback);
}
public IList <LibraryItemEntity> GetItems()
{
IList <LibraryItemEntity> items = new List <LibraryItemEntity>();
string sqlSelect = "SELECT * FROM " + DataAccess.TABLE_NAME_LIBRARY;
SQLiteDataReader dr = SqliteHelper.ExecuteReader(DataAccess.ConnectionStringProfile, CommandType.Text, sqlSelect, null);
while (dr.Read())
{
if (dr.IsDBNull(1))
{
continue;
}
LibraryItemEntity item = new LibraryItemEntity();
item.ID = dr.GetInt32(0);
item.Path = dr.GetString(1);
item.Level = dr.GetInt32(2);
item.IsDeleted = dr.GetInt32(3) == 1 ? true : false;
items.Add(item);
}
dr.Close();
return(items);
}
