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