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));
        }
Ejemplo n.º 2
0
        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));
        }
Ejemplo n.º 3
0
        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));
        }