public SuContentModel UpdateContent(SuContentModel suContentChanges) { var changedContent = context.DbContent.Attach(suContentChanges); changedContent.State = Microsoft.EntityFrameworkCore.EntityState.Modified; context.SaveChanges(); return(suContentChanges); }
public SuContentModel AddContent(SuContentModel suContent) { context.DbContent.Add(suContent); context.SaveChanges(); return(suContent); }
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[] parametersForAllowed = { new SqlParameter("@Id", Id) , new SqlParameter("@CurrentUser", CurrentUser.Id) }; var CheckIfAllowed = _context.ZdbInt.FromSql("ContentEditGetAllowed @Id, @CurrentUser", parametersForAllowed).First(); if (CheckIfAllowed.intValue == 0) { return(RedirectToRoute(new { controller = "Home", action = "Index2" })); } var parameterContent = new SqlParameter("@Id", Id); var ContentFromDb = _context.ZdbContentEditGetContent.FromSql("ContentEditGetContent @Id", parameterContent).First(); var ContentClassificationValuesFromDb = _context.ZdbContentEditGetClassificationValues.FromSql("ContentEditGetClassificationValues @Id", parameterContent).ToList(); 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(); List <SelectListItem>[] ClassificationValueSets = new List <SelectListItem> [NoOfClassifications]; var parametersForClassifications = new SqlParameter("@Id", Id); var ClassificationIdsFromDb = _context.ZdbInt.FromSql("ContentEditGetClassifications @Id", 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("ContentEditGetStatusList").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 }; int?[] SelectedValues = new int?[NoOfClassifications]; SuContentEditGetAllLists ContentWithDropDowns = new SuContentEditGetAllLists { Content = ContentFromDb , ContentStatus = StatusList , SecurityLevel = SecurityLevelList , Langauge = LanguageList , Organization = OrganizationList , Project = ProjectList , Values = ClassificationValueSets , NoOfClassifications = NoOfClassifications , SelectedValues = ContentClassificationValuesFromDb }; 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)); }