protected SharpBoxDaoBase(SharpBoxDaoSelector.SharpBoxInfo sharpBoxInfo, SharpBoxDaoSelector sharpBoxDaoSelector)
{
SharpBoxProviderInfo = sharpBoxInfo.SharpBoxProviderInfo;
PathPrefix = sharpBoxInfo.PathPrefix;
SharpBoxDaoSelector = sharpBoxDaoSelector;
TenantID = CoreContext.TenantManager.GetCurrentTenant().TenantId;
}
public object RenameFolder(Folder folder, string newTitle)
{
var entry = GetFolderById(folder.ID);
var oldId = MakeId(entry);
var newId = oldId;
if ("/".Equals(MakePath(folder.ID)))
{
//It's root folder
SharpBoxDaoSelector.RenameProvider(SharpBoxProviderInfo, newTitle);
//rename provider customer title
}
else
{
var parentFolder = GetFolderById(folder.ParentFolderID);
newTitle = GetAvailableTitle(newTitle, parentFolder, IsExist);
//rename folder
if (SharpBoxProviderInfo.Storage.RenameFileSystemEntry(entry, newTitle))
{
//Folder data must be already updated by provider
//We can't search google folders by title because root can have multiple folders with the same name
//var newFolder = SharpBoxProviderInfo.Storage.GetFileSystemObject(newTitle, folder.Parent);
newId = MakeId(entry);
}
}
UpdatePathInDB(oldId, newId);
return(newId);
}
public IEnumerable <Tag> GetNewTags(Guid subject, Folder parentFolder, bool deepSearch)
{
var folderId = SharpBoxDaoSelector.ConvertId(parentFolder.ID);
var fakeFolderId = parentFolder.ID.ToString();
var entryIDs = DbManager.ExecuteList(Query("files_thirdparty_id_mapping")
.Select("hash_id")
.Where(Exp.Like("id", fakeFolderId, SqlLike.StartWith)))
.ConvertAll(x => x[0]);
if (!entryIDs.Any())
{
return(new List <Tag>());
}
var sqlQuery = new SqlQuery("files_tag ft")
.Select("ft.name",
"ft.flag",
"ft.owner",
"ftl.entry_id",
"ftl.entry_type",
"ftl.tag_count",
"ft.id")
.Distinct()
.LeftOuterJoin("files_tag_link ftl",
Exp.EqColumns("ft.tenant_id", "ftl.tenant_id") &
Exp.EqColumns("ft.id", "ftl.tag_id"))
.Where(Exp.Eq("ft.tenant_id", TenantID) &
Exp.Eq("ftl.tenant_id", TenantID) &
Exp.Eq("ft.flag", (int)TagType.New) &
Exp.In("ftl.entry_id", entryIDs));
if (subject != Guid.Empty)
{
sqlQuery.Where(Exp.Eq("ft.owner", subject));
}
var tags = DbManager.ExecuteList(sqlQuery).ConvertAll(r => new Tag
{
TagName = Convert.ToString(r[0]),
TagType = (TagType)r[1],
Owner = new Guid(r[2].ToString()),
EntryId = MappingID(r[3]),
EntryType = (FileEntryType)r[4],
Count = Convert.ToInt32(r[5]),
Id = Convert.ToInt32(r[6])
});
if (deepSearch)
{
return(tags);
}
var folderFileIds = new[] { fakeFolderId }
.Concat(GetFolderSubfolders(folderId).Select(x => MakeId(x)))
.Concat(GetFolderFiles(folderId).Select(x => MakeId(x)));
return(tags.Where(tag => folderFileIds.Contains(tag.EntryId.ToString())));
}
public Folder <int> CopyFolder(string folderId, int toFolderId, CancellationToken?cancellationToken)
{
var moved = CrossDao.PerformCrossDaoFolderCopy(
folderId, this, SharpBoxDaoSelector.GetFileDao(folderId), SharpBoxDaoSelector.ConvertId,
toFolderId, FolderDao, FileDao, r => r,
false, cancellationToken);
return(moved);
}
public SharpBoxFileDao(
IServiceProvider serviceProvider,
UserManager userManager,
TenantManager tenantManager,
TenantUtil tenantUtil,
DbContextManager <FilesDbContext> dbContextManager,
SetupInfo setupInfo,
IOptionsMonitor <ILog> monitor,
FileUtility fileUtility,
CrossDao crossDao,
SharpBoxDaoSelector sharpBoxDaoSelector,
IFileDao <int> fileDao)
: base(serviceProvider, userManager, tenantManager, tenantUtil, dbContextManager, setupInfo, monitor, fileUtility)
{
CrossDao = crossDao;
SharpBoxDaoSelector = sharpBoxDaoSelector;
FileDao = fileDao;
}
public SharpBoxFolderDao(SharpBoxDaoSelector.SharpBoxInfo sharpBoxInfo, SharpBoxDaoSelector sharpBoxDaoSelector)
: base(sharpBoxInfo, sharpBoxDaoSelector)
{
}
public SharpBoxSecurityDao(SharpBoxDaoSelector.SharpBoxInfo providerInfo, SharpBoxDaoSelector sharpBoxDaoSelector)
: base(providerInfo, sharpBoxDaoSelector)
{
}
public SharpBoxFileDao(SharpBoxDaoSelector.SharpBoxInfo providerInfo, SharpBoxDaoSelector sharpBoxDaoSelector)
: base(providerInfo, sharpBoxDaoSelector)
{
}
