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));
}
