public static void Execute()
{
var manager = DocumentManagerProvider.Get() as SharepointDocumentManager;
if (manager != null && manager.SharepointUseInternalTagFolder)
{
using (var db = FactoryDbContext.Create())
{
var sql = @"WITH Folders (Id, Name, FullPath, EntityId, ReferenceId, InternalTag, IsProcessed, Level)
AS
(
SELECT F.Id, F.Name, F.FullPath, EF.EntityId, EF.ReferenceId, CAST(InternalId AS NVARCHAR(MAX)) AS InternalTag, EF.IsProcessed, 0 AS Level
FROM Folder F
INNER JOIN EntityFolder EF ON F.Id = EF.Id
WHERE F.ParentId IS NULL
UNION ALL
SELECT F.Id, F.Name, F.FullPath, EF.EntityId, EF.ReferenceId, CAST(F.InternalId AS NVARCHAR(MAX)) AS InternalTag, EF.IsProcessed, P.Level + 1
FROM Folder F
INNER JOIN Folders P ON F.ParentId = P.Id
INNER JOIN EntityFolder EF ON F.Id = EF.Id
)
SELECT Id, Name, FullPath, EntityId, ReferenceId, InternalTag AS Tag, IsProcessed
FROM Folders
ORDER BY EntityId, ReferenceId, Level DESC;";
var folders = db.Database.SqlQuery <FolderImport>(sql).ToList().Where(x => !x.IsProcessed).ToList();
var errors = new List <string>();
var i = 0;
var count = folders.Count;
folders.ForEach(folder =>
{
try
{
manager.RenameFolder(folder.EntityId, folder.ReferenceId, folder.Tag, folder.Name, folder.FullPath.HasValue() ? folder.FullPath : folder.Name, db);
db.Database.ExecuteSqlCommand("UPDATE EntityFolder SET IsProcessed = 1 WHERE Id = {0}", folder.Id);
i++;
}
catch (Exception ex)
{
errors.Add(string.Format("Id: {0}; Name: {1}; FullPath: {2}", folder.Id, folder.Name, folder.FullPath) + Environment.NewLine + ex.Message);
Console.WriteLine(ex.Message);
}
});
if (errors.HasValue())
{
var message = errors.JoinBy(Environment.NewLine);
MailUtilities.SendMail(new List <string>()
{
ConfigurationManager.AppSettings["AlertRecipient"]
}, "ERROR Rename Folder SharePoint", message);
}
}
}
}
private void ProcessFile(FileInfo file, Guid projectId, string comboxPath)
{
CLLogger.LogVerbose(string.Format("The file '{0}' --> '{2}' will be associated to project '{1}'", file.FullName.Substring(_rootFolder.Length), Cache.GetProjectName(projectId), comboxPath));
totalSize += (file.Length * 1d) / 1024 / 1024;
var cleanPath = comboxPath.TrimEnd('\\').Split('\\');
Guid?folderId = null;
using (var context = FactoryDbContext.Create())
{
for (var i = 0; i < cleanPath.Length; i++)
{
var currentFolder = CleanStringForWeb(cleanPath[i]);
var existingFolderId = context.EntityFolders.Where(x => x.ReferenceId == projectId && x.ParentId == folderId && x.Name == currentFolder).Select(x => x.Id).FirstOrDefault();
if (existingFolderId == Guid.Empty)
{
var folder = EntityFolder.New();
folder.CurrentUserId = Constants.User.Admin;
folder.Id = Guid.NewGuid();
folder.EntityId = Constants.EntityType.Project;
folder.ReferenceId = projectId;
folder.ParentId = folderId;
folder.Name = currentFolder;
folder.Save();
folderId = folder.Id;
}
else
{
folderId = existingFolderId;
}
}
}
var document = Document.New();
document.ReferenceId = projectId;
document.EntityId = Constants.EntityType.Project;
document.CurrentUserId = Constants.User.Admin;
document.CreatedOn = DateTime.Now;
document.LastUpdatedOn = DateTime.Now;
document.CreatedById = Constants.User.Admin;
document.LastUpdatedById = Constants.User.Admin;
document.Id = Guid.NewGuid();
document.FolderId = folderId;
document.DocumentTypeId = LookupServices.GetLookupItemIdFromTag("LST_DOCUMENT_TYPE_NOT_CLASSIFIED");
document.Filename = CleanStringForWeb(file.Name).Replace("..", ".");
document.FileExtension = file.Extension;
document.FileContentType = ContentTypes.GetContentTypeFromFileExtension(document.FileExtension);
try
{
using (var stream = file.OpenRead())
{
document.Insert <JMSL.Framework.DAL.Entities.Document, Document>(DocumentManagerProvider.Get(),
new TransferDocument()
{
FileName = document.Filename,
FileLength = file.Length,
FileByteStream = stream
});
}
}
catch (Exception ex)
{
CLLogger.LogError(ex);
}
}
