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); var FieldTypeList = new List <SelectListItem>(); var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId); var FieldTypesFromDb = _context.ZDbTypeList.FromSql("ContentTypeSelectAllForLanguage @LanguageId", parameter).ToList(); foreach (var FieldTypeFromDb in FieldTypesFromDb) { FieldTypeList.Add(new SelectListItem { Text = FieldTypeFromDb.Name, Value = FieldTypeFromDb.Id.ToString() }); } SuProcessTemplateFieldEditGetModel ProcessTemplateFieldEditGet = new SuProcessTemplateFieldEditGetModel { PId = Id }; SuProcessTemplateFieldEditGetWithListModel ProcessTemplateFieldWithList = new SuProcessTemplateFieldEditGetWithListModel { ProcessTemplateField = ProcessTemplateFieldEditGet, FieldTypeList = FieldTypeList }; return(View(ProcessTemplateFieldWithList)); //var ProcessTemplateField = new SuObjectVM //{ // Id = Id // , // LanguageId = DefaultLanguageID //}; ////DataTypes //var DataTypeList = new List<SelectListItem>(); //var DataTypesFromDb = _context.ZDbStatusList.FromSql("DataTypeSelectAll").ToList(); //foreach (var DataTypeFromDb in DataTypesFromDb) //{ // DataTypeList.Add(new SelectListItem // { // Text = DataTypeFromDb.Name, // Value = DataTypeFromDb.Id.ToString() // }); //} ////ContentType ////MasterList //var MasterListList = new List<SelectListItem>(); //var MasterListsFromDb = _context.ZDbTypeList.FromSql("GetMasterList").ToList(); //foreach (var MasterListFromDb in MasterListsFromDb) //{ // MasterListList.Add(new SelectListItem // { // Text = MasterListFromDb.Name, // Value = MasterListFromDb.Id.ToString() // }); //} ////MasterList //var FieldsAndDropDowns = new SuProcessTemplateFieldWith2DropDown { Field = ProcessTemplateField, DataTypes = DataTypeList, MasterList = MasterListList }; //return View(FieldsAndDropDowns); }
public async Task <IActionResult> Edit(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); SqlParameter[] parameters = { new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) , new SqlParameter("@OId", Id) }; SuProcessTemplateFieldEditGetModel ProcessTemplateFieldEditGet = _context.ZdbSuProcessTemplateFieldEditGet.FromSql("ProcessTemplateFieldEditGet @LanguageId, @OId", parameters).First(); var FieldTypeList = new List <SelectListItem>(); var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId); var FieldTypesFromDb = _context.ZDbTypeList.FromSql("ContentTypeSelectAllForLanguage @LanguageId", parameter).ToList(); foreach (var FieldTypeFromDb in FieldTypesFromDb) { FieldTypeList.Add(new SelectListItem { Text = FieldTypeFromDb.Name, Value = FieldTypeFromDb.Id.ToString() }); } SuProcessTemplateFieldEditGetWithListModel ProcessTemplateFieldWithList = new SuProcessTemplateFieldEditGetWithListModel { ProcessTemplateField = ProcessTemplateFieldEditGet, FieldTypeList = FieldTypeList }; return(View(ProcessTemplateFieldWithList)); //var ProcessTemplateField = (from c in _processTemplateField.GetAllProcessTemplateFields() // join l in _processTemplateFieldLanguage.GetAllProcessTemplateFieldLanguages() // on c.Id equals l.ProcessTemplateFieldId // where c.Id == Id && l.LanguageId == DefaultLanguageID // orderby l.Name // select new SuObjectVM // { // Id = c.ProcessTemplateId // , // ObjectId = c.Id // , // LanguageId = l.LanguageId // , // ObjectLanguageId = l.Id // , // Name = l.Name // , // Description = l.Description // , // MouseOver = l.MouseOver // , NotNullId = c.FieldDataTypeId // , NotNullId2 = c.FieldMasterListId // }).First(); ////DataTypes //var DataTypeList = new List<SelectListItem>(); //var DataTypesFromDb = _context.ZDbStatusList.FromSql("DataTypeSelectAll").ToList(); //foreach (var DataTypeFromDb in DataTypesFromDb) //{ // DataTypeList.Add(new SelectListItem // { // Text = DataTypeFromDb.Name, // Value = DataTypeFromDb.Id.ToString() // }); //} ////ContentType ////MasterList //var MasterListList = new List<SelectListItem>(); //var MasterListsFromDb = _context.ZDbTypeList.FromSql("GetMasterList").ToList(); //foreach (var MasterListFromDb in MasterListsFromDb) //{ // MasterListList.Add(new SelectListItem // { // Text = MasterListFromDb.Name, // Value = MasterListFromDb.Id.ToString() // }); //} ////MasterList //var FieldsAndDropDowns = new SuProcessTemplateFieldWith2DropDown { Field = ProcessTemplateField, DataTypes = DataTypeList, MasterList = MasterListList } ; //return View(FieldsAndDropDowns); }