public async Task <IActionResult> Create2(SuContentCreate2GetModel FromForm) { var CurrentUser = await _userManager.GetUserAsync(User); var ProjectId = FromForm.Content.ProjectId == null ? 0 : FromForm.Content.ProjectId; SqlParameter[] parameters = { new SqlParameter("@ContentTypeId", FromForm.Content.ContentTypeId), new SqlParameter("@ContentStatusId", FromForm.Content.ContentStatusId), new SqlParameter("@LangaugeId", FromForm.Content.LanguageId), new SqlParameter("@Title", FromForm.Content.Title), new SqlParameter("@Description", FromForm.Content.Description), new SqlParameter("@SecurityLevel", FromForm.Content.SecurityLevel), new SqlParameter("@OrganizationId", FromForm.Content.OrganizationId), new SqlParameter("@ProjectId", ProjectId ?? 0), new SqlParameter("@CreatorId", CurrentUser.Id), new SqlParameter("@ProcessTemplateId", FromForm.ProcessTemplateId), new SqlParameter { ParameterName = "@new_identity", SqlDbType = SqlDbType.Int , Direction = ParameterDirection.Output } }; _context.Database.ExecuteSqlCommand("ContentCreate2Post @ContentTypeId" + ", @ContentStatusId" + ", @LangaugeId" + ", @Title" + ", @Description" + ", @SecurityLevel" + ", @OrganizationId" + ", @ProjectId" + ", @CreatorId" + ", @ProcessTemplateId" + ", @new_identity OUTPUT", parameters); if (FromForm.NoOfClassifications != null) { // foreach (var x in FromForm.SelectedValues) { // SqlParameter[] parameters2 = new SqlParameter[2]; if (x.Value != 0) { SqlParameter[] parameters2 = { new SqlParameter("@ContentId", parameters[9].Value), new SqlParameter("@ClassificationValueId", x.Value) }; _context.Database.ExecuteSqlCommand("ContentValueCreate @ContentId, @ClassificationValueId", parameters2); } } } return(RedirectToRoute(new { controller = "Home", action = "Index2" })); }
public async Task <IActionResult> Create2(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[] parametersForAllowed = { new SqlParameter("@CurrentUser", CurrentUser.Id) , new SqlParameter("@Id", Id) }; var CheckIfAllowed = _context.ZdbInt.FromSql("ContentCreate2GetAllowed @CurrentUser, @Id", parametersForAllowed).First(); if (CheckIfAllowed.intValue == 0) { return(RedirectToRoute(new { controller = "Home", action = "Index2" })); } var StatusList = new List <SelectListItem>(); var OrganizationList = new List <SelectListItem>(); var ProjectList = new List <SelectListItem>(); var SecurityLevelList = new List <SelectListItem>(); var LanguageList = new List <SelectListItem>(); int NoOfClassifications = _classification.GetAllClassifcations().Count(); var parameterForProcess = new SqlParameter("@Id", Id); var ProcessTemplateId = _context.ZdbInt2.FromSql("ContentCreate2ProcessTemplateIdGet @Id", parameterForProcess).First(); List <SelectListItem>[] ClassificationValueSets = new List <SelectListItem> [NoOfClassifications]; SqlParameter[] parametersForClassifications = { new SqlParameter("@Id", Id) , new SqlParameter("@CurrentUser", CurrentUser.Id) }; var ClassificationIdsFromDb = _context.ZdbInt.FromSql("ContentCreate2GetClassifications @Id, @CurrentUser", parametersForClassifications).ToList(); // DbSet<SuValueList>[] dbValueList = new DbSet<SuValueList>[NoOfClassifications]; int y = 0; foreach (var ClassificationfromDb in ClassificationIdsFromDb) { List <SuValueList> ValuesFromDb = new List <SuValueList>(); SqlParameter[] parameters = { new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) , new SqlParameter("@Id", ClassificationfromDb.intValue) }; ValuesFromDb = _context.DbValueList.FromSql("ClassificationValueStructureValues @LanguageId, @Id", parameters).ToList(); ClassificationValueSets[y] = new List <SelectListItem> { new SelectListItem { Text = "-- no selection --", Value = "0" } }; foreach (var ValueFromDb in ValuesFromDb) { ClassificationValueSets[y].Add(new SelectListItem { Text = ValueFromDb.Name, Value = ValueFromDb.ClassificationValueId.ToString() }); } y++; } var ContentStatusFromDb = _context.ZDbStatusList.FromSql("ContentStatusList").ToList(); foreach (var StatusFromDb in ContentStatusFromDb) { StatusList.Add(new SelectListItem { Text = StatusFromDb.Name, Value = StatusFromDb.Id.ToString() }); } var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId); var OrganizationsFromDb = _context.ZdbOrganizationIndexGet.FromSql("OrgStructure @LanguageId", parameter).ToList(); foreach (var OrganizationFromDb in OrganizationsFromDb) { OrganizationList.Add(new SelectListItem { Text = OrganizationFromDb.Name, Value = OrganizationFromDb.Id.ToString() }); } var ProjectsFromDb = _context.ZDbGetProjectStructure.FromSql("ProjStructure @LanguageId", parameter).ToList(); ProjectList.Add(new SelectListItem { Value = "0", Text = "No project" }); foreach (var ProjectFromDb in ProjectsFromDb) { ProjectList.Add(new SelectListItem { Text = ProjectFromDb.Name, Value = ProjectFromDb.Id.ToString() }); } var SecurityLevelsFromDb = _context.ZDbSecurityLevelList.FromSql("SecurityLevelSelectAll").ToList(); foreach (var SecurityLevelFromDb in SecurityLevelsFromDb) { SecurityLevelList.Add(new SelectListItem { Text = SecurityLevelFromDb.Name, Value = SecurityLevelFromDb.Id.ToString() }); } var LanguagesFromDb = _context.ZDbLanguageList.FromSql("LanguageSelectAll").ToList(); foreach (var LanguageFromDb in LanguagesFromDb) { LanguageList.Add(new SelectListItem { Text = LanguageFromDb.Name, Value = LanguageFromDb.Id.ToString() }); } SuContentModel content = new SuContentModel { LanguageId = CurrentUser.DefaultLanguageId , ContentTypeId = Id }; int?[] SelectedValues = new int?[NoOfClassifications]; SuContentCreate2GetModel ContentWithDropDowns = new SuContentCreate2GetModel { Content = content , ProcessTemplateId = ProcessTemplateId.intValue , ContentStatus = StatusList , SecurityLevel = SecurityLevelList , Langauge = LanguageList , Organization = OrganizationList , Project = ProjectList , Values = ClassificationValueSets , NoOfClassifications = NoOfClassifications , SelectedValues = SelectedValues }; 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(ContentWithDropDowns)); }