//Saves any changes to the Pages Table
protected void saveButton_Click(object sender, EventArgs e)
{
PagesTable pagesTable = new PagesTable(new DatabaseConnection());
pageTable.saveContentChanges();
pages.Pages = pageTable.getContent();
//Foreach tableRow do the applicable database command (update/insert/delete) to mirror what the user has done in the table.
int deleted = 0;
foreach (ObjectTableRow objRow in pageTable.ObjectRows)
{
CustomPage page = (CustomPage)objRow.Obj;
if (page.MarkedForDeletion == true) //delete page from database AND file structure
{
pagesTable.deleteCustomPage(page.PageID);
File.Delete(Server.MapPath("~/") + page.PageURL);
pages.Pages.Remove(page.SortIndex);
deleted++;
}
else
{
page.SortIndex -= deleted;
pagesTable.updateCustomPage(page); //update page
}
}
//Remove Content
Session.Remove("savedContent");
Session["message"] = new Message("Pages Saved!", System.Drawing.Color.Green);
//Reload page to clear any nonsense before loading
Response.Redirect("CustomPageTool");
}
