public ActionResult Edit(CMSPage page) { DBCMSEntities dbContext = new DBCMSEntities(); var Id = dbContext.UpdatePage(page.Id, page.Slug, page.PTitle, page.PKeyword, page.PDescription, page.PageContent, page.IsActive, page.IsDelete); return(View()); }
public ActionResult Details(int Id) { DBCMSEntities dbContext = new DBCMSEntities(); System.Data.Entity.Core.Objects.ObjectResult <FetchPageById_Result> pageDetails = dbContext.FetchPageById(Id); return(View(pageDetails)); }
public ActionResult AddUpdatePage(CMSPage page) { using (var context = new DBCMSEntities()) { ObjectParameter result = new ObjectParameter("result", typeof(String)); ObjectParameter createdId = new ObjectParameter("createdId", typeof(String)); if (page.Id == 0) { context.InsertPage(page.Id, page.Slug, page.PTitle, page.PKeyword, page.PDescription, page.PageContent, page.IsActive, page.IsDelete, result, createdId); } else { context.EditPage(page.Id, page.Slug, page.PTitle, page.PKeyword, page.PDescription, page.PageContent, page.IsActive, page.IsDelete, result); } TempData["Result"] = createdId.Value == null ? result.Value : result.Value + " New Page Id is " + createdId.Value; if (page.Id == 0) { return(RedirectToAction("AddUpdatePage", new { Id = createdId.Value })); } } ViewBag.Operation = page.Id == 0 ? "Add Page" : "Edit Page"; return(View()); }
public ActionResult AllCMSPages() { DBCMSEntities dbContext = new DBCMSEntities(); var allcmspages = dbContext.Database.SqlQuery <CMSPage>("FetchAllPages").ToList(); return(View(allcmspages)); }
public ActionResult Create(CMSPage page) { DBCMSEntities dbContext = new DBCMSEntities(); var Id = dbContext.AddPage(page.Id, page.Slug, page.PTitle, page.PKeyword, page.PDescription, page.PageContent, page.IsActive, page.IsDelete); Response.Redirect("/admin/details/" + Id); return(View()); }
public ActionResult AddUpdatePage(Int32?Id) { CMSPage cmsPage = new CMSPage(); if (Id != null && Id != 0) { using (var context = new DBCMSEntities()) { var result = context.FetchPageInfoById(Id); var targetList = result.Select(x => new CMSPage() { Id = x.Id, Slug = x.Slug, PTitle = x.PTitle, PKeyword = x.PKeyword, PDescription = x.PDescription, PageContent = x.PageContent, IsActive = x.IsActive, IsDelete = x.IsDelete, Create_On = x.Create_On, Modify_On = x.Modify_On }).ToList(); cmsPage = targetList.ToList().FirstOrDefault(); return(View(cmsPage)); } } return(View()); }
public ActionResult Delete(long Id) { using (var context = new DBCMSEntities()) { ObjectParameter result = new ObjectParameter("result", typeof(String)); if (Id != 0) { context.DeletePageById(Id, result); } if (result.Value.ToString() == "deleted") { return(RedirectToAction("AllCMSPages")); } } return(View()); }