public void PagesUpdate(Pages pages) { using (SqlConnection connection = base.GetConnection()) { SqlCommand command = new SqlCommand("_PageUpdate", connection) { CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("@Type", 1); command.Parameters.AddWithValue("@PageID", pages.PageID); command.Parameters.AddWithValue("@PageName", pages.PageName); command.Parameters.AddWithValue("@PageTitle", pages.PageTitle); command.Parameters.AddWithValue("@PageType", pages.PageType); command.Parameters.AddWithValue("@Imagethumb", pages.Imagethumb); command.Parameters.AddWithValue("@Describe", pages.Describe); command.Parameters.AddWithValue("@PageContent", pages.PageContent); command.Parameters.AddWithValue("@PostDate", pages.PostDate); command.Parameters.AddWithValue("@Author", pages.Author); command.Parameters.AddWithValue("@Status", pages.Status); command.Parameters.AddWithValue("@IsView", pages.IsView); command.Parameters.AddWithValue("@Language", pages.Language); command.Parameters.AddWithValue("@Icon", pages.Icon); command.Parameters.AddWithValue("@IsComment", pages.IsComment); command.Parameters.AddWithValue("@ApprovalDate", pages.ApprovalDate); command.Parameters.AddWithValue("@ApprovalUserName", pages.ApprovalUserName); command.Parameters.AddWithValue("@IsApproval", pages.IsApproval); command.Parameters.AddWithValue("@CreatedUserName", pages.CreatedUserName); command.Parameters.AddWithValue("@CommentTotal", pages.CommentTotal); command.Parameters.AddWithValue("@VisitTotal", pages.VisitTotal); command.Parameters.AddWithValue("@ParentPageID", pages.ParentPageID); connection.Open(); if (command.ExecuteNonQuery() <= 0) { throw new DataAccessException("Khong the cap nhat"); } command.Dispose(); } }
public void PageCreate(Pages pages) { new PagesDAO().PagesCreate(pages); }
protected Pages ReceiveHtml() { ConfigBSO configBSO = new ConfigBSO(); Config config = configBSO.GetAllConfig(Language.language); int thumb_w = Convert.ToInt32(config.New_thumb_w); int thumb_h = Convert.ToInt32(config.New_thumb_h); commonBSO commonBSO = new commonBSO(); string path = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/BlogPage/"; string image = commonBSO.UploadImage(file_image_thumb, path, thumb_w, thumb_h); Pages pages = new Pages(); pages.PageID = (hddPageID.Value != "") ? Convert.ToInt32(hddPageID.Value) : 0; pages.PageName = (ddlPage.SelectedIndex != 0) ? ddlPage.SelectedValue.ToString() : txtPageName.Text; pages.Icon = rdbGroup.SelectedItem.Value; pages.PageTitle = (txtTitle.Text != "") ? txtTitle.Text : ""; pages.PageType = Convert.ToBoolean(rdbType1.SelectedValue); pages.Describe = txtRadshort.Html; pages.Imagethumb = (image != "") ? image : hddImage.Value; pages.PageContent = txtRad_full.Html; pages.PostDate = txtRadDate.SelectedDate.Value; pages.Author = txtAuthor.Text; pages.Status = Convert.ToBoolean(rdbActive.SelectedItem.Value); pages.IsView = Convert.ToBoolean(rdbIsView.SelectedItem.Value); pages.Language = Language.language; pages.IsComment = Convert.ToBoolean(rdbComment.SelectedValue); pages.VisitTotal = (hddVisitTotal.Value != "") ? Convert.ToInt32(hddVisitTotal.Value) : 0; pages.CommentTotal = (hddCommentTotal.Value != "") ? Convert.ToInt32(hddCommentTotal.Value) : 0; pages.CreatedUserName = (hddCreateUserName.Value != "") ? hddCreateUserName.Value : Session["Admin_UserName"].ToString(); pages.IsApproval = Convert.ToBoolean(rdbApproval.SelectedValue); if (hddApprovalUserName.Value != "") { pages.ApprovalUserName = hddApprovalUserName.Value; pages.ApprovalDate = Convert.ToDateTime(hddApprovalDate.Value); } else if (Convert.ToBoolean(rdbApproval.SelectedValue)) { pages.ApprovalUserName = Session["Admin_UserName"].ToString(); pages.ApprovalDate = DateTime.Now; } else { pages.ApprovalUserName = ""; pages.ApprovalDate = DateTime.Now; } return pages; }
public void PagesUpdate(Pages pages) { new PagesDAO().PagesUpdate(pages); }