public async Task <IActionResult> Edit(SuProcessTemplateFieldEditGetWithListModel FromForm) { if (ModelState.IsValid) { var CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@Id", FromForm.ProcessTemplateField.OId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@ProcessTemplateFieldTypeId", FromForm.ProcessTemplateField.ProcessTemplateFieldTypeId), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ProcessTemplateField.Name), new SqlParameter("@Description", FromForm.ProcessTemplateField.Description), new SqlParameter("@MouseOver", FromForm.ProcessTemplateField.MouseOver), new SqlParameter("@MenuName", FromForm.ProcessTemplateField.MenuName) }; _context.Database.ExecuteSqlCommand("ProcessTemplateFieldEditPost " + "@Id" + ", @LanguageId" + ", @ProcessTemplateFieldTypeId" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName", parameters); } return(RedirectToAction("Index", new { Id = FromForm.ProcessTemplateField.PId.ToString() })); }
public async Task <IActionResult> Create(SuProcessTemplateFieldEditGetWithListModel FromForm) { if (ModelState.IsValid) { var CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { new SqlParameter("@PId", FromForm.ProcessTemplateField.PId), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@ProcessTemplateFieldTypeId", FromForm.ProcessTemplateField.ProcessTemplateFieldTypeId), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@Name", FromForm.ProcessTemplateField.Name), new SqlParameter("@Description", FromForm.ProcessTemplateField.Description), new SqlParameter("@MouseOver", FromForm.ProcessTemplateField.MouseOver), new SqlParameter("@MenuName", FromForm.ProcessTemplateField.MenuName) }; _context.Database.ExecuteSqlCommand("ProcessTemplateFieldCreatePost " + "@PId" + ", @LanguageId" + ", @ProcessTemplateFieldTypeId" + ", @ModifierId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName", parameters); } return(RedirectToAction("Index", new { Id = FromForm.ProcessTemplateField.PId.ToString() })); // return RedirectToAction("Index"); // var CurrentUser = await _userManager.GetUserAsync(User); // // SqlParameter[] parameters = //{ // new SqlParameter("@ProcessTemplateId", FromForm.Field.Id) // , new SqlParameter("@FieldDataTypeId", FromForm.Field.NotNullId) // , new SqlParameter("@FieldMasterListId", FromForm.Field.NotNullId2) // , new SqlParameter("@LanguageId", FromForm.Field.LanguageId) // , new SqlParameter("@Name", FromForm.Field.Name) // , new SqlParameter("@Description", FromForm.Field.Description) // , new SqlParameter("@MouseOver", FromForm.Field.MouseOver) // }; // _context.Database.ExecuteSqlCommand("ProcessTemplateFieldCreate @ProcessTemplateId, @FieldDataTypeId, @FieldMasterListId, @LanguageId, @Name, @Description, @MouseOver", parameters); }
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); }