public Folder SaveFolder(Folder folder)
{
using (var dao = FilesIntegration.GetFolderDao())
{
folder.ID = dao.SaveFolder(folder);
return(folder);
}
}
public string GetFiles()
{
var folderId = Global.EngineFactory.GetFileEngine().GetRoot(ProjectId);
var link = string.Format("tmdocs.aspx?prjID={0}", ProjectId);
var count = FilesIntegration.GetFolderDao().GetItemsCount(folderId, true);
return(string.Format("<a href='{0}'>{1}</a>", link, count));
}
public override string GetCount()
{
var folderId = Global.EngineFactory.GetFileEngine().GetRoot(CurrentProject.ID);
using (var folderDao = FilesIntegration.GetFolderDao())
{
var count = folderDao.GetItemsCount(folderId, true);
return(count != 0 ? string.Format(" ({0})", count) : "");
}
}
public Project GetFullProjectByID(int projectID)
{
var project = projectDao.GetById(projectID);
if (!CanRead(project))
{
return(null);
}
var filter = new TaskFilter
{
ProjectIds = new List <int> {
projectID
},
MilestoneStatuses = new List <MilestoneStatus> {
MilestoneStatus.Open
},
TaskStatuses = new List <TaskStatus> {
TaskStatus.Open
}
};
project.MilestoneCount = factory.GetMilestoneEngine().GetByFilterCount(filter);
project.TaskCount = factory.GetTaskEngine().GetByFilterCount(filter);
project.DiscussionCount = factory.GetMessageEngine().GetByFilterCount(filter);
using (var folderDao = FilesIntegration.GetFolderDao())
{
var folderId = factory.GetFileEngine().GetRoot(projectID);
project.DocumentsCount = folderDao.GetItemsCount(folderId, true);
}
var time = factory.GetTimeTrackingEngine().GetByProject(projectID).Sum(r => r.Hours);
var hours = (int)time;
var minutes = (int)(Math.Round((time - hours) * 60));
var result = hours + ":" + minutes.ToString("D2");
project.TimeTrackingTotal = !result.Equals("0:00", StringComparison.InvariantCulture) ? result : "";
project.ParticipantCount = GetTeam(projectID).Count;
return(project);
}
public Project GetFullProjectByID(int projectID)
{
var project = DaoFactory.ProjectDao.GetById(projectID);
if (!CanRead(project))
{
return(null);
}
var filter = new TaskFilter
{
ProjectIds = new List <int> {
projectID
},
MilestoneStatuses = new List <MilestoneStatus> {
MilestoneStatus.Open
}
};
var taskCount = TaskEngine.GetByFilterCount(filter);
project.MilestoneCount = MilestoneEngine.GetByFilterCount(filter);
project.TaskCount = taskCount.TasksOpen;
project.TaskCountTotal = taskCount.TasksTotal;
project.DiscussionCount = MessageEngine.GetByFilterCount(filter);
using (var folderDao = FilesIntegration.GetFolderDao())
{
var folderId = FileEngine.GetRoot(projectID);
project.DocumentsCount = folderDao.GetItemsCount(folderId);
}
project.TimeTrackingTotal = TimeTrackingEngine.GetTotalByProject(projectID);
project.ParticipantCount = GetTeam(projectID).Count();
return(project);
}
public List <SearchGroup> Search(String searchText, int projectId)
{
var queryResult = _searchDao.Search(searchText, projectId);
var groups = new Dictionary <int, SearchGroup>();
foreach (var r in queryResult)
{
var projId = 0;
SearchItem item = null;
if (r is Project)
{
var p = (Project)r;
if (ProjectSecurity.CanRead(p))
{
projId = p.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, p.Title);
}
item = new SearchItem(EntityType.Project, p.ID, p.Title, p.Description, p.CreateOn);
}
}
else
{
if (r is Milestone)
{
var m = (Milestone)r;
if (ProjectSecurity.CanRead(m))
{
projId = m.Project.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, m.Project.Title);
}
item = new SearchItem(EntityType.Milestone, m.ID, m.Title, null, m.CreateOn);
}
}
else if (r is Message)
{
var m = (Message)r;
if (ProjectSecurity.CanReadMessages(m.Project))
{
projId = m.Project.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, m.Project.Title);
}
item = new SearchItem(EntityType.Message, m.ID, m.Title, m.Content, m.CreateOn);
}
}
else if (r is Task)
{
var t = (Task)r;
if (ProjectSecurity.CanRead(t))
{
projId = t.Project.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, t.Project.Title);
}
item = new SearchItem(EntityType.Task, t.ID, t.Title, t.Description, t.CreateOn);
}
}
}
if (0 < projId && item != null)
{
groups[projId].Items.Add(item);
}
}
try
{
// search in files
var fileEntries = new List <Files.Core.FileEntry>();
using (var folderDao = FilesIntegration.GetFolderDao())
using (var fileDao = FilesIntegration.GetFileDao())
{
fileEntries.AddRange(folderDao.Search(searchText, Files.Core.FolderType.BUNCH).Cast <Files.Core.FileEntry>());
fileEntries.AddRange(fileDao.Search(searchText, Files.Core.FolderType.BUNCH).Cast <Files.Core.FileEntry>());
var projectIds = projectId != 0
? new List <int> {
projectId
}
: fileEntries.GroupBy(f => f.RootFolderId)
.Select(g => folderDao.GetFolder(g.Key))
.Select(f => f != null ? folderDao.GetBunchObjectID(f.RootFolderId).Split('/').Last() : null)
.Where(s => !string.IsNullOrEmpty(s))
.Select(s => int.Parse(s));
var rootProject = projectIds.ToDictionary(id => FilesIntegration.RegisterBunch("projects", "project", id.ToString()));
fileEntries.RemoveAll(f => !rootProject.ContainsKey(f.RootFolderId));
var security = FilesIntegration.GetFileSecurity();
fileEntries.RemoveAll(f => !security.CanRead(f));
foreach (var f in fileEntries)
{
var id = rootProject[f.RootFolderId];
if (!groups.ContainsKey(id))
{
var project = _projDao.GetById(id);
if (project != null && ProjectSecurity.CanRead(project) && ProjectSecurity.CanReadFiles(project))
{
groups[id] = new SearchGroup(id, project.Title);
}
else
{
continue;
}
}
var item = new SearchItem
{
EntityType = EntityType.File,
ID = f is Files.Core.File ? ((Files.Core.File)f).ViewUrl : string.Format("{0}tmdocs.aspx?prjID={1}#{2}", VirtualPathUtility.ToAbsolute("~/products/projects/"), id, f.ID),
Title = f.Title,
CreateOn = f.CreateOn,
};
groups[id].Items.Add(item);
}
}
}
catch (Exception err)
{
LogManager.GetLogger("ASC.Web").Error(err);
}
return(new List <SearchGroup>(groups.Values));
}
public IEnumerable <SearchItem> Search(string searchText, int projectId = 0)
{
var queryResult = DaoFactory.SearchDao.Search(searchText, projectId);
using (var scope = DIHelper.Resolve())
{
var projectSecurity = scope.Resolve <ProjectSecurity>();
foreach (var r in queryResult)
{
switch (r.EntityType)
{
case EntityType.Project:
var project = (Project)r;
if (projectSecurity.CanRead(project))
{
searchItems.Add(new SearchItem(project));
}
continue;
case EntityType.Milestone:
var milestone = (Milestone)r;
if (projectSecurity.CanRead(milestone))
{
searchItems.Add(new SearchItem(milestone));
}
continue;
case EntityType.Message:
var message = (Message)r;
if (projectSecurity.CanRead(message))
{
searchItems.Add(new SearchItem(message));
}
continue;
case EntityType.Task:
var task = (Task)r;
if (projectSecurity.CanRead(task))
{
searchItems.Add(new SearchItem(task));
}
continue;
case EntityType.Comment:
var comment = (Comment)r;
var entity = CommentEngine.GetEntityByTargetUniqId(comment);
if (entity == null)
{
continue;
}
searchItems.Add(new SearchItem(comment.EntityType,
comment.ID.ToString(CultureInfo.InvariantCulture), HtmlUtil.GetText(comment.Content),
comment.CreateOn, new SearchItem(entity)));
continue;
case EntityType.SubTask:
var subtask = (Subtask)r;
var parentTask = TaskEngine.GetByID(subtask.Task);
if (parentTask == null)
{
continue;
}
searchItems.Add(new SearchItem(subtask.EntityType,
subtask.ID.ToString(CultureInfo.InvariantCulture), subtask.Title, subtask.CreateOn,
new SearchItem(parentTask)));
continue;
}
}
}
try
{
// search in files
var fileEntries = new List <FileEntry>();
using (var folderDao = FilesIntegration.GetFolderDao())
using (var fileDao = FilesIntegration.GetFileDao())
{
fileEntries.AddRange(folderDao.Search(searchText, true));
fileEntries.AddRange(fileDao.Search(searchText, true));
var projectIds = projectId != 0
? new List <int> {
projectId
}
: fileEntries.GroupBy(f => f.RootFolderId)
.Select(g => folderDao.GetFolder(g.Key))
.Select(f => f != null ? folderDao.GetBunchObjectID(f.RootFolderId).Split('/').Last() : null)
.Where(s => !string.IsNullOrEmpty(s))
.Select(int.Parse);
var rootProject = projectIds.ToDictionary(id => FilesIntegration.RegisterBunch("projects", "project", id.ToString(CultureInfo.InvariantCulture)));
fileEntries.RemoveAll(f => !rootProject.ContainsKey(f.RootFolderId));
var security = FilesIntegration.GetFileSecurity();
fileEntries.RemoveAll(f => !security.CanRead(f));
foreach (var f in fileEntries)
{
var id = rootProject[f.RootFolderId];
var project = DaoFactory.ProjectDao.GetById(id);
if (ProjectSecurity.CanReadFiles(project))
{
var itemId = f.FileEntryType == FileEntryType.File
? FilesLinkUtility.GetFileWebPreviewUrl(f.Title, f.ID)
: Web.Files.Classes.PathProvider.GetFolderUrl((Folder)f, project.ID);
searchItems.Add(new SearchItem(EntityType.File, itemId, f.Title, f.CreateOn, new SearchItem(project), itemPath: "{2}"));
}
}
}
}
catch (Exception err)
{
LogManager.GetLogger("ASC").Error(err);
}
return(searchItems);
}
