[HttpGet("{controllerName}/{actionName}")] //("{Controller}/{Action}/{LanguageID}")]
public async Task <IActionResult> MVC(string controllerName, string actionName) //string Controller = "a", string Action = "b", string LanguageId = "1")
{
var CurrentUser = await _userManager.GetUserAsync(User);
//Namecontroller = "Classification";
//action = "Index";
string UserId;
if (CurrentUser == null)
{
UserId = await _homeProvider.StringSetting(4);
}
else
{
UserId = CurrentUser.Id;
}
var a = _uITermProvider.IndexGet(controllerName, actionName, UserId);
return(Ok(a));
}
public async Task <IActionResult> Index()
{
var PublicUserId = await _homeProvider.StringSetting(4);
var PublicUser = await _userManager.FindByIdAsync(PublicUserId);
var FrontPanels = new FrontPanels(_classificationValueProvider, _contentProvider, _processProvider, _organizationProvider, _personProvider, _projectProvider);
// if (await _claimCheck.CheckClaim(CurrentUser, "ApplicationRight", this.ControllerContext.RouteData.Values["controller"].ToString() + "\\" + this.ControllerContext.RouteData.Values["action"].ToString()))
{
var dashboard = await _homeProvider.HomeIndexGetDashboard();
var panels = await _homeProvider.HomeIndexGetPanels();
foreach (var panel in panels)
{
switch (panel.PageSectionTypeId)
{
case 1: //List (TYPE)
switch (panel.PageSectionDataTypeId)
{
case 1: //Content (DATA TYPE)
// string ContentConditionSQLFrom =
// " DECLARE @LanguageId int; " +
// " select @LanguageId =IntValue from settings where SettingID = 1 ; " +
// " SELECT Contents.ContentID " +
// ", Contents.Title " +
// ", Contents.Description " +
// ", ISNULL(UserLanguage.Name, ISNULL(DefaultLanguage.Name, 'No name for this ContentType')) ContentTypeName " +
// ", Creator.FirstName + ' ' + Creator.LastName CreatorName " +
// ", Creator.PersonID CreatorID " +
// ", Contents.CreatedDate " +
// ", Modifier.FirstName + ' ' + Modifier.LastName ModifierName " +
// ", Modifier.PersonId ModifierID " +
// ", Contents.ModifiedDate " +
// ", CONCAT('controlID', Contents.ContentId) ControlId " +
// " FROM Contents " +
// " JOIN ContentTypes " +
// " ON Contents.ContentTypeID = ContentTypes.ContentTypeID " +
//" LEFT JOIN(SELECT ContentTypeId, Name, Description, MenuName, MouseOver, ContentTypeLanguageID FROM ContentTypeLanguages WHERE LanguageId = @LanguageID) UserLanguage " +
// " ON UserLanguage.ContentTypeID = ContentTypes.ContentTypeID " +
//" LEFT JOIN(SELECT ContentTypeId, Name, Description, MenuName, MouseOver, ContentTypeLanguageID FROM ContentTypeLanguages JOIN Settings ON ContentTypeLanguages.LanguageId = Settings.IntValue WHERE Settings.SettingId = 1) DefaultLanguage " +
// " ON DefaultLanguage.ContentTypeId = ContentTypes.ContentTypeID " +
//" JOIN Persons Creator " +
// " ON Creator.UserId = Contents.CreatorID " +
//" JOIN Persons Modifier " +
// " ON Modifier.UserId = Contents.ModifierID "
// ;
// string ContentConditionSQLWhere = " WHERE Contents.SecurityLevelId = 1 ";
// string ContentConditionSQLContains = "";
// var ContentConditions = await _contentProvider.ContentForPanelCondition(panel.PageSectionId);
// foreach(var ContentCondition in ContentConditions)
// {
// switch(ContentCondition.PageSectionContentConditionTypeId)
// {
// case 1: // User
// ContentConditionSQLWhere += "";
// break;
// case 2: // Contains
// ContentConditionSQLContains += "";
// break;
// case 3: // Organization
// ContentConditionSQLWhere += " AND Contents.OrganizationId = " + ContentCondition.PageSectionContentConditionInt + " ";
// break;
// case 4: // Project
// ContentConditionSQLWhere += " AND Contents.ProjectId = " + ContentCondition.PageSectionContentConditionInt + " ";
// break;
// case 5: // Content type
// ContentConditionSQLWhere += " AND Contents.ContentTypeId = " + ContentCondition.PageSectionContentConditionInt + " ";
// break;
// case 6: // Content status
// ContentConditionSQLWhere += " AND Contents.ContentStatusId = " + ContentCondition.PageSectionContentConditionInt + " ";
// break;
// case 7: // Language
// ContentConditionSQLWhere += " AND Contents.LanguageId = " + ContentCondition.PageSectionContentConditionInt + " ";
// break;
// case 8: // Security level
// ContentConditionSQLWhere += " AND Contents.SecurityLevelId = " + ContentCondition.PageSectionContentConditionInt + " ";
// break;
// case 9: // Creator
// ContentConditionSQLWhere += " AND Contents.CreatorId = '" + ContentCondition.PageSectionContentConditionString + "' ";
// break;
// case 10: // Modifier
// ContentConditionSQLWhere += " AND Contents.ModifierId = '" + ContentCondition.PageSectionContentConditionString + "' ";
// break;
// case 11: // ClassificationValue
// ContentConditionSQLWhere += " AND Contents.ContentId IN (SELECT CotentId FROM ContentClassificationValues WHERE ClassificationValueId = " + ContentCondition.PageSectionContentConditionInt+ ") ";
// break;
// case 12: // Created from date
// ContentConditionSQLWhere += " AND Contents.CreatedDate > '" + ContentCondition.PageSectionContentConditionDate + "' ";
// break;
// case 13: // Created to date
// ContentConditionSQLWhere += " AND Contents.CreatedDate < '" + ContentCondition.PageSectionContentConditionDate + "' ";
// break;
// case 14: // Created from date
// ContentConditionSQLWhere += " AND Contents.ModifiedDate > '" + ContentCondition.PageSectionContentConditionDate + "' ";
// break;
// case 15: // Created to date
// ContentConditionSQLWhere += " AND Contents.ModifiedDate < '" + ContentCondition.PageSectionContentConditionDate + "' ";
// break;
// }
// }
// var ContentList = await _contentProvider.ContentForPanel(ContentConditionSQLFrom, ContentConditionSQLWhere, ContentConditionSQLContains);
panel.Contents = await FrontPanels.ContentList(PublicUser, panel.PageSectionId);
break;
case 2: //Pocess (DATA TYPE) List (Type)
//string ProcessConditionSQLFrom = " SELECT Processes.ProcessId, ISNULL(ProcessFieldSubject.StringValue,'') As Subject, ProcessTypeLanguages.Name ProcessTypeName FROM Processes JOIN ProcessFields ProcessFieldSubject ON ProcessFieldSubject.ProcessId = Processes.ProcessId " +
// " JOIN ProcessTypefields ProcessTypeFieldSubject ON ProcessTypeFieldSubject.ProcessTypefieldId = ProcessFieldSubject.ProcessTypefieldId " +
// " JOIN ProcessTypes ON Processes.ProcessTypeId = ProcessTypes.ProcessTypeId " +
// " JOIN ProcessTypeFields SecurityTemplateField ON Processes.ProcessTypeID = SecurityTemplateField.ProcessTypeID JOIN ProcessFields SecurityField ON Processes.ProcessID = SecurityField.ProcessID AND SecurityField.ProcessTypeFieldID = SecurityTemplateField.ProcessTypeFieldID ";
//string ProcessConditionSQLWhere = " WHERE SecurityTemplateField.ProcessTypeFieldTypeID = 28 AND SecurityField.IntValue = 1 ";
//string ProcessConditionSQLContains = "";
//var ProcessConditions = await _processProvider.ProcessForPanelCondition(panel.PageSectionId);
//foreach (var ProcessCondition in ProcessConditions)
//{
// switch (ProcessCondition.PageSectionProcessConditionTypeId)
// {
// case 1: // Template
// ProcessConditionSQLWhere += " AND TemplateId = " + ProcessCondition.PageSectionProcessConditionInt;
// break;
// case 2: // Template group
// ProcessConditionSQLFrom += " JOIN ProcessTypeGroups ON ProcessTypes.ProcessTypeGroupId = ProcessTypeGroups.ProcessTypeGroupId ";
// ProcessConditionSQLWhere += " AND ProcessTypeGroups.TemplateGroupId = " + ProcessCondition.PageSectionProcessConditionInt;
// break;
// case 3: // My calendar
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldMyCalendar ON Processes.ProcessId = ProcessFieldMyCalendar.ProcessId JOIN ProcessTypeFields ProcessTypeFieldMyCalendar ON ProcessTypeFieldMyCalendar.ProcessTypeFieldId = ProcessFieldMyCalendar.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInPersonalCalendar = 1 AND ProcessTypeFieldMyCalendar.ProcessTypefieldTypeId = 12 ";
// break;
// case 4: // Personal calendar
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInPersonalCalendar = 1 ";
// break;
// case 5: // Organization calendar
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInOrganizationCalendar = 1 ";
// break;
// case 6: // Project calendar
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInProjectCalendar = 1 ";
// break;
// case 7: // Event calendar
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInEventCalendar = 1 ";
// break;
// case 8: // Is personal
// ProcessConditionSQLWhere += " AND ProcessTypes.IsPersonal = 1 " ;
// break;
// case 9: // Show new
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInNew = 1 ";
// break;
// case 10: // Show search
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInSearch = 1 ";
// break;
// case 11: // show report
// ProcessConditionSQLWhere += " AND ProcessTypes.ShowInReport = 1 ";
// break;
// case 12: // Organization
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldOrganization ON Processes.ProcessId = ProcessFieldOrganization.ProcessId JOIN ProcessTypeFields ProcessTypeFieldOrganization ON ProcessTypeFieldOrganization.ProcessTypeFieldId = ProcessFieldOrganization.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldOrganization.IntValue = " + ProcessCondition.PageSectionProcessConditionInt + " AND (ProcessTypeFieldOrganization.ProcessTypefieldTypeId = 14 OR ProcessTypeFieldOrganization.ProcessTypefieldTypeId = 15 ) ";
// break;
// case 13: // Project
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldProject ON Processes.ProcessId = ProcessFieldProject.ProcessId JOIN ProcessTypeFields ProcessTypeFieldProject ON ProcessTypeFieldProject.ProcessTypeFieldId = ProcessFieldProject.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldProject.IntValue = " + ProcessCondition.PageSectionProcessConditionInt + "' AND (ProcessTypeFieldProject.ProcessTypefieldTypeId = 16 OR ProcessTypeFieldProject.ProcessTypefieldTypeId = 17) ";
// break;
// case 14: // creator is user
// // ProcessConditionSQLWhere += " AND Processes.CreatorId = '" + CurrentUser.Id + "' ";
// break;
// case 15: // role
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldRole ON Processes.ProcessId = ProcessFieldRole.ProcessId JOIN ProcessTypeFields ProcessTypeFieldRole ON ProcessTypeFieldRole.ProcessTypeFieldId = ProcessFieldRole.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldRole.stringValue = '" + ProcessCondition.PageSectionProcessConditionString + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 30 ";
// break;
// case 16: // securitylevel
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldSecurityLevel ON Processes.ProcessId = ProcessFieldSecurityLevel.ProcessId JOIN ProcessTypeFields ProcessTypeFieldSecurityLevel ON ProcessTypeFieldSecurityLevel.ProcessTypeFieldId = ProcessFieldSecurityLevel.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldSecurityLevel.IntValue <= '" + ProcessCondition.PageSectionProcessConditionInt + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 28 ";
// break;
// case 18: // Default Organization
// ProcessConditionSQLWhere += " AND ProcessFieldOrganization.IntValue = @DefaultOrganization AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 14 ";
// break;
// case 19: // UserOrganization
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldUserOrganization ON Processes.ProcessId = ProcessFieldUserOrganization.ProcessId JOIN ProcessTypeFields ProcessTypeFieldUserOrganization ON ProcessTypeFieldUserOrganization.ProcessTypeFieldId = ProcessFieldUserOrganization.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldUserOrganization.IntValue IN (SELECT OrganizationId FROM AspNetRoles JOIN AspNetUserRoles ON AspNetRoles.Id = AspNetUserRoles.RoleId WHERE UserId = '" + CurrentUserId + "') AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 14 ";
// break;
// case 20: // Specific Organization
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldOrganizationRole ON Processes.ProcessId = ProcessFieldOrganizationRole.ProcessId JOIN ProcessTypeFields ProcessTypeFieldOrganizationRole ON ProcessTypeFieldOrganizationRole.ProcessTypeFieldId = ProcessFieldOrganizationRole.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldOrganizationRole.StringValue = '" + ProcessCondition.PageSectionProcessConditionString + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 30 ";
// break;
// case 21: // UserProject
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldUserProject ON Processes.ProcessId = ProcessFieldUserProject.ProcessId JOIN ProcessTypeFields ProcessTypeFieldUserProject ON ProcessTypeFieldUserProject.ProcessTypeFieldId = ProcessFieldUserProject.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldUserProject.IntValue IN (SELECT ProjectId FROM AspNetRoles JOIN AspNetUserRoles ON AspNetRoles.Id = AspNetUserRoles.RoleId WHERE UserId = '" + CurrentUserId + "') AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 16 ";
// break;
// case 22: // Specific project
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldProjectRole ON Processes.ProcessId = ProcessFieldProjectRole.ProcessId JOIN ProcessTypeFields ProcessTypeFieldProjectRole ON ProcessFieldProjectRole.ProcessTypeFieldId = ProcessTypeFieldProjectRole.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldProjectRole.StringValue = '" + ProcessCondition.PageSectionProcessConditionString + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 30 ";
// break;
// case 25: // Content
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldContent ON Processes.ProcessId = ProcessFieldContent.ProcessId JOIN ProcessTypeFields ProcessTypeFieldContent ON ProcessFieldContent.ProcessTypeFieldId = ProcessTypeFieldContent.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldContent.IntValue = " + ProcessCondition.PageSectionProcessConditionInt + " AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 24 ";
// break;
// case 26: // Content type
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldContentType ON Processes.ProcessId = ProcessFieldContentType.ProcessId JOIN ProcessTypeFields ProcessTypeFieldContentType ON ProcessFieldContentType.ProcessTypeFieldId = ProcessTypeFieldContentType.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldContentType.IntValue IN (SELECT ContentId FROM Contents WHERE ContentTypeID = " + ProcessCondition.PageSectionProcessConditionInt + ") AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 24 ";
// break;
// case 27: // User is user
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldUserIsUser ON Processes.ProcessId = ProcessFieldUserIsUser.ProcessId JOIN ProcessTypeFields ProcessTypeFieldUserIsUser ON ProcessFieldUserIsUser.ProcessTypeFieldId = ProcessTypeFieldUserIsUser.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldUserIsUser.StringValue = '" + ProcessCondition.PageSectionProcessConditionString + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 12 ";
// break;
// case 32: // From date
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldFromDate ON Processes.ProcessId = ProcessFieldFromDate.ProcessId JOIN ProcessTypeFields ProcessTypeFieldFromDate ON ProcessFieldFromDate.ProcessTypeFieldId = ProcessTypeFieldFromDate.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldFromDate.DateTimeValue >= '" + ProcessCondition.PageSectionProcessConditionDate + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 4 ";
// //PETER TO DO the date time and date time range and date range
// break;
// case 33: // To date
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldToDate ON Processes.ProcessId = ProcessFieldToDate.ProcessId JOIN ProcessTypeFields ProcessTypeFieldToDate ON ProcessFieldToDate.ProcessTypeFieldId = ProcessTypeFieldToDate.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldToDate.DateTimeValue <= '" + ProcessCondition.PageSectionProcessConditionDate + "' AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 4 ";
// break;
// case 37: // Person
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldPerson ON Processes.ProcessId = ProcessFieldPerson.ProcessId JOIN ProcessTypeFields ProcessTypeFieldPerson ON ProcessFieldPerson.ProcessTypeFieldId = ProcessTypeFieldPerson.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldPerson.IntValue = " + ProcessCondition.PageSectionProcessConditionInt + " AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 36 ";
// break;
// case 38: // Content type group
// ProcessConditionSQLFrom += " JOIN ProcessFields ProcessFieldContentTypeGroup ON Processes.ProcessId = ProcessFieldContentTypeGroup.ProcessId JOIN ProcessTypeFields ProcessTypeFieldContentTypeGroup ON ProcessFieldContentTypeGroup.ProcessTypeFieldId = ProcessTypeFieldContentTypeGroup.ProcessTypeFieldId ";
// ProcessConditionSQLWhere += " AND ProcessFieldContentTypeGroup.IntValue IN (SELECT ContentId FROM Contents JOIN ContentTypes ON Contents.ContentTypeId = ContentTypes.ContentTypeId WHERE ContentTypeGroupID = " + ProcessCondition.PageSectionProcessConditionInt + ") AND ProcessTypeFieldUser.ProcessTypefieldTypeId = 24 ";
// break;
// }
//}
//var ProcessList = await _processProvider.ProcessForPanel(CurrentUserId, ProcessConditionSQLFrom, ProcessConditionSQLWhere, ProcessConditionSQLContains);
panel.Processes = await FrontPanels.ProcessList(PublicUser, panel.PageSectionId);
break;
case 3: //Organizatio (DATA TYPE) List (Type)
panel.Organizations = await FrontPanels.OrganizationList(PublicUser, panel.PageSectionId);
break;
case 4: //Person (DATA TYPE) List (Type)
panel.Persons = await FrontPanels.PersonList(PublicUser, panel.PageSectionId);
break;
case 5: //Project (DATA TYPE) List (Type)
panel.Projects = await FrontPanels.ProjectList(PublicUser, panel.PageSectionId);
break;
case 6: //Favorites (DATA TYPE) List (Type)
break;
case 7: //Classification (DATA TYPE) List (Type)
panel.ClassificationValues = await FrontPanels.ClassificationValueList(PublicUser, panel.PageSectionId);
break;
}
break;
case 2: //Index only classification (TYPE)
break;
case 3: //Chat not yet (TYPE)
break;
case 4: //Personal canendar (TYPE)
var PersonalCalendar = await _homeProvider.HomeIndexPersonalCalendar(PublicUserId);
panel.PersonalCalendars = PersonalCalendar;
break;
case 5: //Organization calendar (TYPE)
var OrganizationCalendar = await _homeProvider.HomeIndexOrganizationCalendar(1);
panel.OrganizationCalendars = OrganizationCalendar;
break;
case 6: //Project calendar (TYPE)
var ProjectCalendar = await _homeProvider.HomeIndexProjectCalendar(1);
panel.ProjectCalendars = ProjectCalendar;
break;
case 7: //Platform calendar (TYPE)
var EventCalendar = await _homeProvider.HomeIndexEventCalendar();
panel.EventCalendars = EventCalendar;
break;
case 8: //General calendar (TYPE)
break;
case 9: //to do (TYPE)
var todo = new FrontProcessToDoLogic(_projectProvider, _organizationProvider, _userRoleProvider, _roleProvider, _userProvider, _processProvider, _frontProcessProvider);
panel.ToDos = await todo.ReturnProcessList(PublicUser);
break;
}
}
dashboard.Panels = panels;
return(Ok(dashboard));
}
return(BadRequest(new
{
IsSuccess = false,
Message = "No rights",
}));
}