public ActionResult GetCustomDataGroupAndFields(string baseDataId) { var genObj = new GenericObjectModel { CustomGroupViewModels = new List <CustomGroupViewModel>() }; try { var baseDataList = _baseDataService.Query(b => b.EnrollmentId == baseDataId).Select().ToList(); if (!baseDataList.Any()) { return(Json(genObj, JsonRequestBehavior.AllowGet)); } var baseData = baseDataList[0]; genObj.Name = baseData.Firstname + " " + baseData.Surname; genObj.ProjectSiteId = baseData.ProjectSiteId; genObj.EnrollmentId = baseData.EnrollmentId; genObj.ProjectPrimaryCode = baseData.ProjectPrimaryCode; var customGroups = new List <CustomGroupViewModel>(); var enrolledCustomDataList = _customDataService.Query(q => q.EnrollmentId == baseDataId).Select().ToList(); if (!enrolledCustomDataList.Any()) { return(Json(genObj, JsonRequestBehavior.AllowGet)); } enrolledCustomDataList.ForEach(r => { var customFields = _customFieldService.Query(g => g.CustomFieldId == r.CustomFieldId).Select().ToList(); if (customFields.Any()) { var cFieldView = customFields[0]; var customFieldTypes = _customFieldTypeService.Query(f => f.FieldTypeId == cFieldView.FieldTypeId).Select().ToList(); if (!customFieldTypes.Any()) { return; } var groupF = customGroups.Find(t => t.CustomGroupId == cFieldView.CustomGroupId); if (groupF == null || groupF.TableId < 1) { var fieldCustomGroups = _customGroupService.Query(o => o.CustomGroupId == cFieldView.CustomGroupId).Select().ToList(); if (!fieldCustomGroups.Any()) { return; } var g = fieldCustomGroups[0]; groupF = new CustomGroupViewModel { TableId = g.TableId, CustomGroupId = g.CustomGroupId, GroupName = g.GroupName, TabIndex = g.TabIndex, CustomFieldViewModels = new List <GenericViewModel>() }; } var customFieldType = customFieldTypes[0]; var customFieldViewModel = new GenericViewModel { FieldTypeName = customFieldTypes[0].FieldTypeName }; if (!string.IsNullOrEmpty(r.CustomListId)) { var customList = _customListService.Query(s => s.CustomListId == r.CustomListId && string.IsNullOrEmpty(s.ParentListId)).Select().ToList(); if (customList.Any()) { var list = customList[0]; customFieldViewModel.CustomListId = r.CustomListId; var l1Data = _customListDataService.Query(s => s.CustomListDataId == r.CrimsCustomData).Select().ToList(); if (l1Data.Any()) { customFieldViewModel.CustomListDataName = l1Data[0].ListDataName; } var childList = _customListService.Query(s => s.ParentListId == list.CustomListId).Select().ToList(); if (childList.Any()) { customFieldViewModel.HasChildren = true; } customFieldViewModel.TableId = r.TableId; customFieldViewModel.TabIndex = cFieldView.TabIndex; customFieldViewModel.CustomFieldId = r.CustomFieldId; customFieldViewModel.CustomFieldName = cFieldView.CustomFieldName; customFieldViewModel.CustomListId = cFieldView.CustomListId; customFieldViewModel.CustomListName = list.CustomListName; customFieldViewModel.CustomGroupId = cFieldView.CustomGroupId; customFieldViewModel.FieldTypeId = cFieldView.FieldTypeId; customFieldViewModel.FieldTypeName = customFieldType.FieldTypeName; customFieldViewModel.CrimsCustomData = r.CrimsCustomData; customFieldViewModel.EnrollmentId = r.EnrollmentId; customFieldViewModel.CustomDataId = r.CustomDataId; } } else { customFieldViewModel = new GenericViewModel { TableId = r.TableId, CustomFieldId = r.CustomFieldId, CustomFieldName = cFieldView.CustomFieldName, CustomListId = cFieldView.CustomListId, TabIndex = cFieldView.TabIndex, CustomGroupId = cFieldView.CustomGroupId, FieldTypeId = cFieldView.FieldTypeId, CustomFieldType = customFieldType, FieldTypeName = customFieldType.FieldTypeName, CrimsCustomData = r.CrimsCustomData, EnrollmentId = r.EnrollmentId, CustomDataId = r.CustomDataId, }; } if (customGroups.Exists(t => t.CustomGroupId == groupF.CustomGroupId)) { groupF.CustomFieldViewModels.Add(customFieldViewModel); } else { groupF.CustomFieldViewModels.Add(customFieldViewModel); customGroups.Add(groupF); } } }); customGroups.ForEach(g => { if (g.CustomFieldViewModels != null && g.CustomFieldViewModels.Any()) { g.CustomFieldViewModels = g.CustomFieldViewModels.OrderBy(f => f.TabIndex).ToList(); } }); customGroups = customGroups.OrderBy(m => m.TabIndex).ToList(); genObj.CustomGroupViewModels = customGroups; return(Json(genObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new GenericObjectModel(), JsonRequestBehavior.AllowGet)); } }
public ActionResult GetCustomDataGroupFields_New(string baseDataId) { var genObj = new GenericObjectModel { CustomGroupViewModels = new List <CustomGroupViewModel>() }; try { var currentProject = GetProjectInSession(); if (string.IsNullOrEmpty(currentProject?.ProjectCode)) { return(Json(new List <CustomGroupViewModel>(), JsonRequestBehavior.AllowGet)); } var projectCustomGroups = _projectCustomGroupService.Query(g => g.ProjectCode == currentProject.ProjectCode).Select().ToList(); if (!projectCustomGroups.Any()) { return(Json(new List <CustomGroupViewModel>(), JsonRequestBehavior.AllowGet)); } var baseDataList = _baseDataService.Query(b => b.EnrollmentId == baseDataId).Select().ToList(); if (!baseDataList.Any()) { return(Json(genObj, JsonRequestBehavior.AllowGet)); } var baseData = baseDataList[0]; genObj.Name = baseData.Firstname + " " + baseData.Surname; genObj.ProjectSiteId = baseData.ProjectSiteId; genObj.EnrollmentId = baseData.EnrollmentId; genObj.ProjectPrimaryCode = baseData.ProjectPrimaryCode; genObj.FormPath = baseData.FormPath; var customGroups = new List <CustomGroupViewModel>(); projectCustomGroups.ForEach(t => { var newGroups = _customGroupService.Query(d => d.CustomGroupId == t.CustomGroupId).Select(g => new CustomGroupViewModel { TableId = g.TableId, CustomGroupId = g.CustomGroupId, GroupName = g.GroupName, TabIndex = g.TabIndex }).ToList(); if (newGroups.Any()) { customGroups.Add(newGroups[0]); } }); if (!customGroups.Any()) { return(Json(genObj, JsonRequestBehavior.AllowGet)); } customGroups.ForEach(c => { c.CustomFieldViewModels = new List <GenericViewModel>(); var customFields = _customFieldService.Query(g => g.CustomGroupId == c.CustomGroupId).Select().ToList(); if (customFields.Any()) { customFields.ForEach(cFieldView => { var customFieldTypes = _customFieldTypeService.Query(f => f.FieldTypeId == cFieldView.FieldTypeId).Select().ToList(); if (!customFieldTypes.Any()) { return; } var customFieldType = customFieldTypes[0]; var customFieldViewModel = new GenericViewModel { CustomList = new CustomListViewModel(), CustomFieldType = new CustomFieldType() }; if (customFieldType.FieldTypeName == "List") { var customList = _customListService.Query(s => s.CustomListId == cFieldView.CustomListId && string.IsNullOrEmpty(s.ParentListId)).Select().ToList(); if (customList.Any()) { var list = customList[0]; var l1 = new CustomListViewModel { CustomListName = list.CustomListName, CustomListId = list.CustomListId, HasChildren = false, ParentListId = list.ParentListId, CustomListDatas = new List <CustomListData>() }; //var l1Data = _customListDataService.Query(s => s.CustomListId == l1.CustomListId).Select().ToList(); //if (l1Data.Any()) //{ // l1.CustomListDatas = l1Data; //} var childList = _customListService.Query(s => s.ParentListId == list.CustomListId).Select().ToList(); if (childList.Any()) { l1.HasChildren = true; } customFieldViewModel.TableId = cFieldView.TableId; customFieldViewModel.CustomFieldId = cFieldView.CustomFieldId; customFieldViewModel.CustomFieldName = cFieldView.CustomFieldName; customFieldViewModel.CustomFieldSize = cFieldView.CustomFieldSize; customFieldViewModel.CustomListId = cFieldView.CustomListId; customFieldViewModel.ParentFieldId = cFieldView.ParentFieldId; customFieldViewModel.CustomGroupId = cFieldView.CustomGroupId; customFieldViewModel.FieldTypeId = cFieldView.FieldTypeId; customFieldViewModel.TabIndex = cFieldView.TabIndex; customFieldViewModel.Required = cFieldView.Required; customFieldViewModel.CustomFieldType = customFieldType; customFieldViewModel.CustomList = l1; } } else { customFieldViewModel = new GenericViewModel { TableId = cFieldView.TableId, CustomFieldId = cFieldView.CustomFieldId, CustomFieldName = cFieldView.CustomFieldName, CustomFieldSize = cFieldView.CustomFieldSize, ParentFieldId = cFieldView.ParentFieldId, CustomListId = cFieldView.CustomListId, CustomGroupId = cFieldView.CustomGroupId, FieldTypeId = cFieldView.FieldTypeId, TabIndex = cFieldView.TabIndex, Required = cFieldView.Required, CustomFieldType = customFieldType }; } c.CustomFieldViewModels.Add(customFieldViewModel); }); } genObj.CustomGroupViewModels.Add(c); }); genObj.CustomGroupViewModels.ForEach(g => { g.CustomFieldViewModels = g.CustomFieldViewModels.OrderBy(f => f.TabIndex).ToList(); }); var ordered = genObj.CustomGroupViewModels.OrderBy(m => m.TabIndex).ToList(); return(Json(ordered, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new List <CustomGroupViewModel>(), JsonRequestBehavior.AllowGet)); } }