public async Task <IActionResult> Create(int Id) { var CurrentUser = await _userManager.GetUserAsync(User); var DefaultLanguageID = CurrentUser.DefaultLanguageId; var UICustomizationArray = new UICustomization(_context); ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID); Menus a = new Menus(_context); ViewBag.menuItems = await a.TopMenu(DefaultLanguageID); SuObjectVMPageSection SuObject = new SuObjectVMPageSection { ObjectId = Id }; //Existing levels List <SelectListItem> StepList = (from s in _processTemplateStep.GetAllProcessTemplateSteps() join l in _processTemplateStepLanguage.GetAllProcessTemplateStepLanguages() on s.Id equals l.StepId where l.LanguageId == CurrentUser.DefaultLanguageId && s.ProcessTemplateId == Id orderby l.Name select new SelectListItem { Value = s.Id.ToString() , Text = l.Name }).ToList(); StepList.Add(new SelectListItem { Text = "No selection", Value = "0" }); var ClassificationAndStatus = new PageSectionAndStatusViewModel { SuObject = SuObject, SomeKindINumSelectListItem = StepList }; return(View(ClassificationAndStatus)); }
public async Task <IActionResult> Create(int Id) { SuObjectVMPageSection ToForm = new SuObjectVMPageSection { Id = Id }; var CurrentUser = await _userManager.GetUserAsync(User); var DefaultLanguageID = CurrentUser.DefaultLanguageId; var UICustomizationArray = new UICustomization(_context); ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID); Menus a = new Menus(_context); ViewBag.menuItems = await a.TopMenu(DefaultLanguageID); ToForm.LanguageId = CurrentUser.DefaultLanguageId; var ProcessTemplateFlowConditionTypesFromDb = _context.ZDbTypeList.FromSql($"ProcessTemplateFlowConditionCreateGetType").ToList(); var ProcessTemplateFlowConditionTypeList = new List <SelectListItem>(); foreach (var ProcessTemplateFlowConditionTypeFromDb in ProcessTemplateFlowConditionTypesFromDb) { ProcessTemplateFlowConditionTypeList.Add(new SelectListItem { Text = ProcessTemplateFlowConditionTypeFromDb.Name, Value = ProcessTemplateFlowConditionTypeFromDb.Id.ToString() }); } SqlParameter[] parameters = { new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) , new SqlParameter("@Id", Id) }; var ProcessTemplateFlowFieldsFromDb = _context.ZDbStatusList.FromSql("GetProcessTemplateFlowConditionCreateGetFields @LanguageId, @Id", parameters).ToList(); var ProcessTemplateFlowFieldList = new List <SelectListItem> { new SelectListItem { Text = "No field", Value = "0" } }; foreach (var ProcessTemplateFlowFieldFromDb in ProcessTemplateFlowFieldsFromDb) { ProcessTemplateFlowFieldList.Add(new SelectListItem { Text = ProcessTemplateFlowFieldFromDb.Name, Value = ProcessTemplateFlowFieldFromDb.Id.ToString() }); } var ComparisonOperator = new List <SelectListItem> { new SelectListItem() { Text = "Equal", Value = "EQ" }, new SelectListItem() { Text = "Larger", Value = "LA" }, new SelectListItem() { Text = "Smaller", Value = "SM" }, new SelectListItem() { Text = "Larger or equal", Value = "LQ" }, new SelectListItem() { Text = "Smaller or equal", Value = "SQ" }, new SelectListItem() { Text = "Not equal", Value = "NQ" } }; var ClassificationAndStatus = new PageSectionAndStatusViewModel { SuObject = ToForm, SomeKindINumSelectListItem = ComparisonOperator, ProbablyTypeListItem = ProcessTemplateFlowConditionTypeList, ProbablyTypeListItem2 = ProcessTemplateFlowFieldList }; return(View(ClassificationAndStatus)); }
public async Task <IActionResult> Create(int Id) { var CurrentUser = await _userManager.GetUserAsync(User); var DefaultLanguageID = CurrentUser.DefaultLanguageId; var UICustomizationArray = new UICustomization(_context); ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID); Menus a = new Menus(_context); SuObjectVMPageSection SuObject = new SuObjectVMPageSection { ObjectId = Id }; List <SelectListItem> ExistingLevels = (from c in _pageSection.GetAllPageSections() join l in _pageSectionLanguage.GetAllPageSectionLanguages() on c.Id equals l.PageSectionId where c.PageId == Id && l.LanguageId == CurrentUser.DefaultLanguageId orderby c.Sequence select new SelectListItem { Value = c.Sequence.ToString() , Text = l.Name }).ToList(); var TestForNull = (from c in _pageSection.GetAllPageSections() join l in _pageSectionLanguage.GetAllPageSectionLanguages() on c.Id equals l.PageSectionId where c.Id == Id && l.LanguageId == CurrentUser.DefaultLanguageId select c.Sequence).ToList(); int MaxLevelSequence; if (TestForNull.Count() == 0) { MaxLevelSequence = 1; } else { MaxLevelSequence = (from c in _pageSection.GetAllPageSections() join l in _pageSectionLanguage.GetAllPageSectionLanguages() on c.Id equals l.PageSectionId where c.Id == Id && l.LanguageId == CurrentUser.DefaultLanguageId select c.Sequence).Max(); MaxLevelSequence++; } ExistingLevels.Add(new SelectListItem { Text = "add at bottom", Value = MaxLevelSequence.ToString() }); //PageSectionTypes var ToForm = (from o in _pageSectionType.GetAllPageSectionTypes() join l in _pageSectionTypeLanguage.GetAllPageSectionTypeLanguages() on o.Id equals l.PageSectionTypeId where l.LanguageId == CurrentUser.DefaultLanguageId select new SuObjectVM { Id = o.Id , Name = l.Name }).ToList(); var TypeList = new List <SelectListItem>(); foreach (var TypeFromDb in ToForm) { TypeList.Add(new SelectListItem { Text = TypeFromDb.Name, Value = TypeFromDb.Id.ToString() }); } //PageSectionTypes //ContentType var ContentTypes = (from o in _contentType.GetAllContentTypes() join l in _contentTypeLanguage.GetAllContentTypeLanguages() on o.Id equals l.ContentTypeId where l.LanguageId == CurrentUser.DefaultLanguageId select new SuObjectVM { Id = o.Id , Name = l.Name }).ToList(); var ContentTypeList = new List <SelectListItem> { new SelectListItem { Value = "0", Text = "No type" } }; foreach (var TypeFromDb in ContentTypes) { ContentTypeList.Add(new SelectListItem { Text = TypeFromDb.Name, Value = TypeFromDb.Id.ToString() }); } //ContentType var ClassificationAndStatus = new PageSectionAndStatusViewModel { SuObject = SuObject, SomeKindINumSelectListItem = ExistingLevels, ProbablyTypeListItem = TypeList, ProbablyTypeListItem2 = ContentTypeList }; return(View(ClassificationAndStatus)); }