public async Task <IActionResult> Create(SuClassificationEditGetWithListModel FromForm)
{
if (ModelState.IsValid)
{
var CurrentUser = await _userManager.GetUserAsync(User);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId),
new SqlParameter("@ClassificationStatusId", FromForm.Classification.ClassificationStatusId),
new SqlParameter("@DefaultClassificationPageId", FromForm.Classification.DefaultClassificationPageId),
new SqlParameter("@HasDropDown", FromForm.Classification.HasDropDown),
new SqlParameter("@DropDownSequence", FromForm.Classification.DropDownSequence),
new SqlParameter("@ModifierId", CurrentUser.Id),
new SqlParameter("@Name", FromForm.Classification.Name),
new SqlParameter("@Description", FromForm.Classification.Description),
new SqlParameter("@MouseOver", FromForm.Classification.MouseOver),
new SqlParameter("@MenuName", FromForm.Classification.MenuName)
};
_context.Database.ExecuteSqlCommand("ClassificationCreatePost " +
"@LanguageId" +
", @ClassificationStatusId" +
", @DefaultClassificationPageId" +
", @HasDropDown" +
", @DropDownSequence" +
", @ModifierId" +
", @Name" +
", @Description" +
", @MouseOver" +
", @MenuName", parameters);
}
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 ClassificationStatusList = new List <SelectListItem>();
var StatusList = await _context.ZDbStatusList.FromSql("ClassificationStatusList").ToListAsync();
foreach (var Status in StatusList)
{
ClassificationStatusList.Add(new SelectListItem
{
Text = Status.Name,
Value = Status.Id.ToString()
});
}
var Classification = new SuClassificationEditGetModel {
Description = "x"
};
var ClassificationAndStatus = new SuClassificationEditGetWithListModel {
Classification = Classification, StatusList = ClassificationStatusList
};
ViewBag.tools = new[] {
"Bold", "Italic", "Underline", "StrikeThrough",
"FontName", "FontSize", "FontColor", "BackgroundColor",
"LowerCase", "UpperCase", "|",
"Formats", "Alignments", "OrderedList", "UnorderedList",
"Outdent", "Indent", "|",
"CreateLink", "Image", "CreateTable", "|", "ClearFormat", "Print",
"SourceCode", "FullScreen", "|", "Undo", "Redo"
};
return(View(ClassificationAndStatus));
}
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)
};
var ClassificationEditGet = _context.ZdbClassificationEditGet.FromSql("ClassificationEditGet @LanguageId, @Id", parameters).First();
var ClassificationStatusList = new List <SelectListItem>();
var StatusList = _context.ZDbStatusList.FromSql("ClassificationGetStatusList").ToList();
foreach (var Status in StatusList)
{
ClassificationStatusList.Add(new SelectListItem
{
Text = Status.Name,
Value = Status.Id.ToString()
});
}
SuClassificationEditGetWithListModel ClassificationWithList = new SuClassificationEditGetWithListModel
{
Classification = ClassificationEditGet,
StatusList = ClassificationStatusList
};
return(View(ClassificationWithList));
}
