/// <summary>
/// Get all the owners that has reports owned
/// </summary>
/// <param name="userAlias"></param>
/// <param name="siteGuid"></param>
/// <param name="isCurrentSiteAdmin"></param>
/// <returns></returns>
public ICollection <UserLoginApp> GetOwnerList(string userAlias, string siteGuid, bool isCurrentSiteAdmin)
{
int teamId = _teamRepository.GetFiltered(_ => _.TeamGuid == new Guid(siteGuid)).FirstOrDefault().Id;
int allReportTileID = _tileRepository.GetAllReportsTileId(teamId);
EditReportService editService = new EditReportService(_reportRepository, _userRepository, _teamRepository, _categoryRepository, _tagRepository, _tileRepository);
ICollection <Statistics> ls = editService.GetTeamSiteReportsStatistics(allReportTileID, userAlias, siteGuid, isCurrentSiteAdmin);
IEnumerable <UserLoginApp> userList = new List <UserLoginApp>();
if (ls.Count() > 0)
{
Statistics OwnerStatistics = ls.Where(_ => _.Name == "Owner").FirstOrDefault();
userList = OwnerStatistics.Values.Select(_ => new UserLoginApp
{
Id = _.GUID,
UserName = _.Name
}).OrderBy(_ => _.UserName);
}
return(userList.ToList());
}
private string GetFilter()
{
string sitetype = Request["sitetype"];
string siteGUID = Request["SiteGuid"];
string searchWords = Request["SearchWords"];
int tileId = int.Parse(Request["tileId"]);
//if (tileId == 0)
//{
// TileManager tm = new TileManager();
// if (sitetype.ToLower() == "selfservice")
// {
// tileId = SystemDefinedTile.SelfService_AllBIModels.SystemDefinedTileId;
// }
// else
// {
// tileId = SystemDefinedTile.MyReports_AllReports.SystemDefinedTileId;
// }
//}
string logonUser = Session["UserName"] == null ? "" : Session["UserName"].ToString();
bool isCurrentSiteAdmin = logonUser == "" ? false : service.GetUserAdminTeams(logonUser).Count() > 0;
using (MainDBUnitWorkContext context = new MainDBUnitWorkContext())
{
IReportRepository report_repository = new ReportRepository(context);
IUserRepository user_repository = new UserRepository(context);
ITeamRepository team_repository = new TeamRepository(context);
ICategoryRepository category_repository = new CategoryRepository(context);
ITagRepository tag_repository = new TeamTagRepository(context);
ITileRepository tile_repository = new TileRepository(context);
ITileQueryLogicRepository tile_query_repository = new TileQueryLogicRepository(context);
EditReportService sa = new EditReportService(report_repository, user_repository, team_repository, category_repository, tag_repository, tile_repository, tile_query_repository);
FilterListViewModel filterList = new FilterListViewModel();
#region query filter data
int DataCount = 0;
ICollection <Statistics> ls = null;
switch (sitetype.ToLower())
{
case "teamsite":
ls = sa.GetTeamSiteReportsStatistics(tileId, logonUser, siteGUID, isCurrentSiteAdmin);
break;
case "reportcatalog":
break;
//case "myreport":
// ls = sa.GetMyReportsStatistics(tileId, logonUser, teamSiteGuidUnderControl);
// break;
//case "selfservice":
// ls = sa.GetSelfServiceStatistics(tileId, logonUser, teamSiteGuidUnderControl);
// break;
//case "searchreport":
// ls = sa.GetSearchReportsStatistics(logonUser, teamSiteGuidUnderControl, searchWords, out DataCount);
// break;
default:
break;
}
#endregion
filterList.DataCount = DataCount;
#region Get Statistics business moel
foreach (Statistics l in ls)
{
FilterEntityViewModel filterEty = new FilterEntityViewModel();
filterEty.FilterType = l.Name;
foreach (AttributeValue attr in l.Values)
{
Application.MainBoundedContect.ViewModel.Filters.FilterItem item = new Application.MainBoundedContect.ViewModel.Filters.FilterItem();
item.Name = attr.Name;
if (l.Name == "Owner")
{
item.Value = attr.GUID.ToString();
}
else
{
item.Value = attr.Value.ToString();
}
item.Count = attr.Count;
item.ParentValue = attr.ParentValue;
filterEty.FilterItemList.Add(item);
}
if (!filterEty.FilterType.Equals("Category"))
{
filterEty.FilterItemList.OrderByDescending(c => c.Count).ThenBy(n => n.Value);
}
filterList.FilterList.Add(filterEty);
}
JavaScriptSerializer jss = new JavaScriptSerializer();
#endregion
return(jss.Serialize(filterList));
}
}
