public static int UpdatePage(string connString, PageDetailDTO page)
{
using (IDbConnection db = new SqlConnection(connString))
{
var update_pages_query = @"
update pages
set PageTitle = @PageTitle,
PageDescription = @PageDescription,
PageLink = @PageLink,
PagePublished = @PagePublished
where
Id = @PageId;" ;
var update_page_display_query = @"
update page_display
set PageBodyHtml = @PageBodyHtml,
PageHeadStyle = @PageHeadStyle
where PageId = @PageId;";
try
{
db.Execute(update_pages_query, new
{
PageTitle = page.PageTitle,
PageDescription = page.PageDescription,
PageLink = page.PageLink,
PagePublished = page.PagePublished,
PageId = page.PageId
});
}
catch (Exception e)
{
throw e;
}
try
{
return(db.Execute(update_page_display_query, new
{
PageBodyHtml = page.PageBodyHtml,
PageHeadStyle = page.PageHeadStyle,
PageId = page.PageId
}));
}
catch (Exception e)
{
throw e;
}
}
}
public static int CreatePage(string connString, PageDetailDTO page)
{
using (IDbConnection db = new SqlConnection(connString))
{
var update_pages_query = @"
insert into pages(PageTitle, PageDescription, PageLink, PagePublished)
values(@PageTitle, @PageDescription, @PageLink, @PagePublished)";
var update_page_display_query = @"
insert into page_display(PageBodyHtml, PageHeadStyle, PageId)
values(@PageBodyHtml, @PageHeadStyle, @PageId);";
try
{
db.Execute(update_pages_query, new
{
PageTitle = page.PageTitle,
PageDescription = page.PageDescription,
PageLink = page.PageLink,
PagePublished = page.PagePublished,
PageId = page.PageId
});
}
catch (Exception e)
{
throw e;
}
try
{
return(db.Execute(update_page_display_query, new
{
PageBodyHtml = page.PageBodyHtml,
PageHeadStyle = page.PageHeadStyle,
PageId = page.PageId
}));
}
catch (Exception e)
{
throw e;
}
}
}
public PageManagementCreateViewModel()
{
Page = new PageDetailDTO();
}
public IActionResult CreatePage([FromBody] PageDetailDTO page)
{
return(Ok(ModifyPageManagementData.CreatePage(_configuration.GetConnectionString("DefaultConnection"), page)));
}
public PageManagementDetailViewModel(string connString, int id)
{
Page = GetPageManagementData.GetPageDetail(connString, id);
}
