public void CreateSinglePage(SinglePage singlepage)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_SinglePageUpdate", connection) {
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@SinglePageID", singlepage.SinglePageID);
command.Parameters.AddWithValue("@SinglePageName", singlepage.SinglePageName);
command.Parameters.AddWithValue("@Icon", singlepage.Icon);
command.Parameters.AddWithValue("@SinglePageDesc", singlepage.SinglePageDesc);
command.Parameters.AddWithValue("@SinglePageContent", singlepage.SinglePageContent);
command.Parameters.AddWithValue("@Language", singlepage.Language);
command.Parameters.AddWithValue("@CreateDate", singlepage.CreateDate);
command.Parameters.AddWithValue("@Status", singlepage.Status);
command.Parameters.AddWithValue("@CreatedUserName", singlepage.CreatedUserName);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Khong them moi duoc singlepage");
}
command.Dispose();
}
}
private SinglePage ReceiveHtml()
{
ConfigBSO configBSO = new ConfigBSO();
Config config = configBSO.GetAllConfig(Language.language);
int icon_w = Convert.ToInt32(config.New_thumb_w);
int icon_h = Convert.ToInt32(config.New_thumb_h);
commonBSO commonBSO = new commonBSO();
string path = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/SinglePage/";
string imgIcon = commonBSO.UploadImage(fileIcon, path, icon_w, icon_h);
SinglePage singlepage = new SinglePage();
singlepage.SinglePageID = (hddSinglePageID.Value != "") ? Convert.ToInt32(hddSinglePageID.Value) : 0;
singlepage.SinglePageName = txtSinglePageName.Text;
singlepage.Icon = (imgIcon != "") ? imgIcon : hddIcon.Value;
singlepage.SinglePageDesc = txtRadSinglePageDesc.Html;
singlepage.SinglePageContent = txtRadSinglePageContent.Html;
singlepage.Language = Language.language;
singlepage.Status = Convert.ToBoolean(rdbStatus.SelectedValue);
singlepage.CreateDate = DateTime.Now;
singlepage.CreatedUserName = Session["Admin_UserName"].ToString();
return singlepage;
}
public void CreateSinglePage(SinglePage singlepage)
{
new SinglePageDAO().CreateSinglePage(singlepage);
}
public void UpdateSinglePage(SinglePage singlepage)
{
new SinglePageDAO().UpdateSinglePage(singlepage);
}
