public ActionResult DeletePage(StaticPage page)
{
//if (ModelState.IsValid)
{
var manager = new AdminManager();
manager.DeletePage(page);
}
return RedirectToAction("Index", "Home");
}
public void EditPage(StaticPage page)
{
var selectedPage = _staticPages.FirstOrDefault(p => p.PageID == page.PageID);
selectedPage.PageID = page.PageID;
// selectedPage.User = page.User;
selectedPage.PageTitle = page.PageTitle;
selectedPage.PageBody = page.PageBody;
// selectedPage.PageCategory = page.PageCategory;
//selectedPage.Status = Page.Status;
//selectedPage.PageTags = Page.PageTags;
selectedPage.PageDate = DateTime.Now;
}
public ActionResult CreatePage(StaticPage page)
{
var manager = new AdminManager();
var pageCount = manager.GetAllPages().Count;
manager.AddPage(page);
page.PageDate = DateTime.Now;
if (pageCount == 0)
{
page.PageID = 1;
}
else
page.PageID = manager.GetAllPages().Count + 1;
return RedirectToAction("Index", "Home");
}
public void AddPage(StaticPage page)
{
if (GetAllPages().Count != 0)
{
page.PageID = GetAllPages().LastOrDefault().PageID + 1;
}
else
{
page.PageID = 1;
}
page.PageDate = DateTime.Now;
_pageRepo.AddPage(page);
}
public void EditPage(StaticPage page)
{
using (SqlConnection cn = new SqlConnection(_connectionString))
{
var p = new DynamicParameters();
p.Add("PageID", page.PageID);
// p.Add("UserID", page.User.UserID);
p.Add("PageBody", page.PageBody);
//p.Add("StaticPageStatus", page. ); Pages don't have a status; for some reason they have them in the database
p.Add("PageTitle", page.PageTitle);
p.Add("PageDate", page.PageDate.ToShortDateString());
cn.Execute("UpdateStaticPage", p,
commandType: CommandType.StoredProcedure);
}
}
public void CanAddStaticPage()
{
var manager = new AdminManager();
var pageCount = manager.GetAllPages().Count;
var toAdd = new StaticPage();
toAdd.PageID = pageCount + 1;
toAdd.PageTitle = "Test title";
toAdd.PageBody = "test static page";
toAdd.PageDate = DateTime.Now;
manager.AddPage(toAdd);
var secondCount = manager.GetAllPages().Count;
Assert.AreEqual(pageCount +1, secondCount);
}
public void AddPage(StaticPage page)
{
// page.User = new User();
using (SqlConnection cn = new SqlConnection(_connectionString))
{
var p = new DynamicParameters();
p.Add("PageID", page.PageID);
// p.Add("UserID", page.User.UserID);
// p.Add("CategoryID", page.PageCategory.CategoryID);
p.Add("PageTitle", page.PageTitle);
//p.Add("PostSubTitle", post.PostSubtitle);
p.Add("PageBody",page.PageBody);
//p.Add("PostStatus", post.Status);
p.Add("PageDate", page.PageDate);
cn.Execute("AddStaticPage", p,
commandType: CommandType.StoredProcedure);
}
}
public StaticPage GetStaticPageById(int id)
{
var page = new StaticPage();
using (SqlConnection cn = new SqlConnection(_connectionString))
{
var p = new DynamicParameters();
p.Add("StaticPageID", id);
page = cn.QuerySingle<StaticPage>("GetStaticPage", p,
commandType: CommandType.StoredProcedure);
}
return page;
}
public StaticPage GetStaticPageById(int id)
{
var page = new StaticPage();
page = _staticPages.FirstOrDefault(p => p.PageID == id);
return page;
}
public void AddPage(StaticPage page)
{
_staticPages.Add(page);
}
public void EditPage(StaticPage page)
{
page.PageDate = DateTime.Now;
_pageRepo.EditPage(page);
}
public void DeletePage(StaticPage page)
{
_pageRepo.DeletePage(page.PageID);
_tagRepo.DeletePostTagsById(page.PageID);
}
