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); }