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("@Id", Id) }; SqlParameter parameter = new SqlParameter("@Id", Id); SuClassificationValueEditGetModel ClassificationValueEditGet = _context.ZdbClassificationValueEditGet.FromSql("ClassificationValueEditGet @LanguageId, @Id", parameters).First(); SuClassificationValueEditGetLevelModel ClassificationValueEditGetLevel = _context.ZdbClassificationValueEditGetLevel.FromSql("ClassificationValueEditGetLevel @Id", parameter).First(); ClassificationValueEditGet.DateLevel = ClassificationValueEditGetLevel.DateLevel; ClassificationValueEditGet.InDropDown = ClassificationValueEditGetLevel.InDropDown; return(View(ClassificationValueEditGet)); }
public async Task <IActionResult> Create(SuClassificationValueEditGetModel FromForm) { var CurrentUser = await _userManager.GetUserAsync(User); SqlParameter[] parameters = { // new SqlParameter("@Id", FromForm.Classification.Id), new SqlParameter("@PId", FromForm.PId), new SqlParameter("@ParentId", FromForm.ParentId), new SqlParameter("@FromDate", FromForm.FromDate), new SqlParameter("@ToDate", FromForm.ToDate), new SqlParameter("@ModifierId", CurrentUser.Id), new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId), new SqlParameter("@Name", FromForm.Name ?? ""), new SqlParameter("@Description", FromForm.Description ?? ""), new SqlParameter("@MouseOver", FromForm.MouseOver ?? ""), new SqlParameter("@MenuName", FromForm.MenuName ?? ""), new SqlParameter("@DropDownName", FromForm.DropDownName ?? ""), new SqlParameter("@PageName", FromForm.PageName ?? ""), new SqlParameter("@PageDescription", FromForm.PageDescription ?? ""), new SqlParameter("@HeaderName", FromForm.HeaderName ?? ""), new SqlParameter("@HeaderDescription", FromForm.HeaderDescription ?? ""), new SqlParameter("@TopicName", FromForm.TopicName ?? "") }; _context.Database.ExecuteSqlCommand("ClassificationValueCreatePost " + "@PId" + ", @ParentId" + ", @FromDate" + ", @ToDate" + ", @ModifierId" + ", @LanguageId" + ", @Name" + ", @Description" + ", @MouseOver" + ", @MenuName" + ", @DropDownName" + ", @PageName" + ", @PageDescription" + ", @HeaderName" + ", @HeaderDescription" + ", @TopicName", parameters); return(RedirectToAction("Index", new { Id = FromForm.PId.ToString() })); }
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); SuClassificationValueEditGetModel NewValue = new SuClassificationValueEditGetModel { //ClassificationId PId = Convert.ToInt32(HttpContext.Request.Query["CId"]), //ParentValueId ParentId = Id }; SqlParameter[] parameters = { new SqlParameter("@ParentId", NewValue.ParentId) , new SqlParameter("@PId", NewValue.PId) }; SuClassificationValueEditGetLevelModel ClassificationValueEditGetLevel = _context.ZdbClassificationValueEditGetLevel.FromSql("ClassificationValueCreateGetLevel @ParentId, @PId", parameters).First(); NewValue.InDropDown = ClassificationValueEditGetLevel.InDropDown; NewValue.DateLevel = ClassificationValueEditGetLevel.DateLevel; return(View(NewValue)); }