public static List <SelectListItem> RetrievePageContentBlocks(int PageId)
{
List <SelectListItem> ContentBlocks = new List <SelectListItem>()
{
new SelectListItem {
Value = "0", Text = "Please select a content block..."
}
};
using (var db = new DBHRDBContext())
{
var values = db.ContentBlock.Where(x => x.PageId == PageId).ToList();
if (values.Any())
{
foreach (var val in values)
{
ContentBlocks.Add(new SelectListItem {
Value = val.Id.ToString(), Text = val.Header
});
}
}
}
return(ContentBlocks);
}
public static List <SelectListItem> RetrievePages()
{
List <SelectListItem> Pages = new List <SelectListItem>()
{
new SelectListItem {
Value = "0", Text = "Please select a page..."
}
};
using (var db = new DBHRDBContext())
{
var values = db.Page.ToList();
if (values.Any())
{
foreach (var val in values)
{
Pages.Add(new SelectListItem {
Value = val.Id.ToString(), Text = val.Name
});
}
}
}
return(Pages);
}
public IActionResult Index()
{
using (var db = new DBHRDBContext()){
PageVM model = new PageVM(db.Page.Include(x => x.ContentBlock).FirstOrDefault(x => x.Name == "Home"));
return(View(model));
}
//return View();
}
public ActionResult UpdateContentBlock(int Id, string Header, int ViewIndex, string Content)
{
using (var db = new DBHRDBContext()) {
var value = db.ContentBlock.FirstOrDefault(x => x.Id == Id);
if (value != null)
{
value.Header = Header;
value.ViewIndex = ViewIndex;
value.Content = Content;
value.UpdatedDate = DateTime.Now;
db.SaveChanges();
}
return(PartialView("ContentBlockEdit", new ContentBlockVM(value)));
}
}
public ActionResult RetrieveContentBlock(int ContentId)
{
List <SelectListItem> ContentBlocks = new List <SelectListItem>()
{
new SelectListItem {
Value = "0", Text = "Please select a content block..."
}
};
using (var db = new DBHRDBContext()) {
var value = db.ContentBlock.FirstOrDefault(x => x.Id == ContentId);
ContentBlockVM content = new ContentBlockVM {
Id = value.Id,
Content = value.Content,
ViewIndex = value.ViewIndex,
Header = value.Header,
DateAdded = value.CreatedDate,
DateUpdated = value.UpdatedDate
};
return(PartialView("ContentBlockEdit", content));
}
}
