public async Task <IActionResult> Create(SuPageSectionTypeEditGetModel FromForm)
        {
            if (ModelState.IsValid)
            {
                var CurrentUser = await _userManager.GetUserAsync(User);


                SqlParameter[] parameters =
                {
                    new SqlParameter("@IndexSection", FromForm.IndexSection),
                    new SqlParameter("@LanguageId",   CurrentUser.DefaultLanguageId),
                    new SqlParameter("@ModifierId",   CurrentUser.Id),
                    new SqlParameter("@Name",         FromForm.Name),
                    new SqlParameter("@Description",  FromForm.Description),
                    new SqlParameter("@MouseOver",    FromForm.MouseOver),
                    new SqlParameter("@MenuName",     FromForm.MenuName)
                };

                _context.Database.ExecuteSqlCommand("PageSectionTypeCreatePost " +
                                                    "@IndexSection " +
                                                    ", @LanguageId" +
                                                    ", @ModifierId" +
                                                    ", @Name" +
                                                    ", @Description" +
                                                    ", @MouseOver" +
                                                    ", @MenuName", parameters);
            }

            return(RedirectToAction("Index"));
        }
        public async Task <IActionResult> Edit(SuPageSectionTypeEditGetModel FromForm)
        {
            if (ModelState.IsValid)
            {
                var CurrentUser = await _userManager.GetUserAsync(User);

                SqlParameter[] parameters =
                {
                    new SqlParameter("@OId",          FromForm.OId),
                    new SqlParameter("@IndexSection", FromForm.IndexSection),
                    new SqlParameter("@LId",          FromForm.LId),
                    new SqlParameter("@Name",         FromForm.Name),
                    new SqlParameter("@Description",  FromForm.Description),
                    new SqlParameter("@MouseOver",    FromForm.MouseOver),
                    new SqlParameter("@MenuName",     FromForm.MenuName),
                    new SqlParameter("@ModifierId",   CurrentUser.Id)
                };
                _context.Database.ExecuteSqlCommand("PageSectionTypeEditPost " +
                                                    "@OId" +
                                                    ", @IndexSection" +
                                                    ", @LId" +
                                                    ", @Name" +
                                                    ", @Description" +
                                                    ", @MouseOver" +
                                                    ", @MenuName" +
                                                    ", @ModifierId"
                                                    , parameters);
            }
            return(RedirectToAction("Index"));


            //if (ModelState.IsValid)
            //{
            //    var PageSectionType = _PageSectionType.GetPageSectionType(test3.Id);
            //    var CurrentUser = await _userManager.GetUserAsync(User);

            //    PageSectionType.ModifiedDate = DateTime.Now;
            //    PageSectionType.ModifierId = CurrentUser.Id;
            //    PageSectionType.IndexSection = test3.IndexSection;
            //    _PageSectionType.UpdatePageSectionType(PageSectionType);

            //    var DefaultLanguageID = CurrentUser.DefaultLanguageId;
            //    var PageSectionTypeLanguage = _PageSectionTypeLanguage.GetPageSectionTypeLanguage(test3.ObjectLanguageId);
            //    PageSectionTypeLanguage.Name = test3.Name;
            //    PageSectionTypeLanguage.Description = test3.Description;
            //    PageSectionTypeLanguage.MouseOver = test3.MouseOver;
            //    PageSectionTypeLanguage.ModifiedDate = DateTime.Now;
            //    PageSectionTypeLanguage.ModifierId = CurrentUser.Id;
            //    _PageSectionTypeLanguage.UpdatePageSectionTypeLanguage(PageSectionTypeLanguage);

            //}
            //return RedirectToAction("Index");
        }
        public async Task <IActionResult> Create()
        {
            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);

            var PageSectionType = new SuPageSectionTypeEditGetModel();

            return(View(PageSectionType));
        }