protected void btn_copy_Click(object sender, EventArgs e)
{
DataTable datatable = WidgetID();
SYS_WidgetPageLayoutBSO _widgetBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widget = new SYS_WidgetPageLayout();
try
{
if (datatable.Rows.Count > 0)
{
foreach (DataRow subrow in datatable.Rows)
{
_widget = _widgetBSO.GetSYS_WidgetPageLayoutById(Convert.ToInt32(subrow["Id"].ToString()));
if (ddlPageLayout2.SelectedIndex > 0)
{
_widget.PageLayoutId = Convert.ToInt32(ddlPageLayout2.SelectedValue);
_widget.RegionId = ddlRegion2.SelectedValue;
_widgetBSO.CreateSYS_WidgetPageLayoutGet(_widget);
}
}
error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Cập nhật Thành công !</div>";
ViewWidgetAll2(Convert.ToInt32(ddlPageLayout2.SelectedValue), ddlRegion2.SelectedValue);
}
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
public SYS_WidgetPageLayout GetSYS_WidgetPageLayoutById(int Id)
{
SYS_WidgetPageLayout sys_WidgetPageLayout = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_SYS_WidgetPageLayoutGetById", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", Id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
sys_WidgetPageLayout = SYS_WidgetPageLayoutReader(reader);
}
else
{
throw new DataAccessException("Khong tim thay gia tri sys_WidgetPageLayout");
}
command.Dispose();
}
}
return(sys_WidgetPageLayout);
}
public SYS_WidgetPageLayout ReceiveHtml()
{
SYS_WidgetPageLayout _widgetPageLayout = new SYS_WidgetPageLayout();
//string path = Request.PhysicalApplicationPath.Replace(@"\", "/") + "/Upload/Widgets/Icons/";
//commonBSO commonBSO = new commonBSO();
//ConfigBSO configBSO = new ConfigBSO();
//Config _config = configBSO.GetAllConfig(Language.language);
//string icon_upload = commonBSO.UploadImage(uploadIcon, path, Convert.ToInt32(_config.New_thumb_w), Convert.ToInt32(_config.New_thumb_h));
_widgetPageLayout.Id = (txtID.Value != "") ? Convert.ToInt32(txtID.Value) : 0;
_widgetPageLayout.PageLayoutId = (ddlPageLayout.SelectedValue != "") ? Convert.ToInt32(ddlPageLayout.SelectedValue) : 0;
_widgetPageLayout.WidgetId = (ddlWidget.SelectedValue != "") ? Convert.ToInt32(ddlWidget.SelectedValue) : 0;
_widgetPageLayout.RegionId = (ddlRegion.SelectedValue != "") ? ddlRegion.SelectedValue : "";
_widgetPageLayout.Title = (txtWidgetTitle.Text != "") ? txtWidgetTitle.Text.Trim() : "";
_widgetPageLayout.Orders = (hddOrders.Value != "") ? Convert.ToInt32(hddOrders.Value) : 0;
_widgetPageLayout.Status = chkStatus.Checked;
_widgetPageLayout.Icon = (hddIcon.Value != "") ? hddIcon.Value : hddIcon.Value;
_widgetPageLayout.Info = (hddRadInfo.Value != "") ? hddRadInfo.Value.Trim() : "";
_widgetPageLayout.HTML = (hddRadHTML.Value != "") ? hddRadHTML.Value.Trim() : "";
_widgetPageLayout.Value = (lboGallary.SelectedIndex >= 0) ? lboGallary.SelectedValue : "0"; //sửa
_widgetPageLayout.Value2 = (lboGallary2.SelectedIndex >= 0) ? lboGallary2.SelectedValue : "0"; //sửa
_widgetPageLayout.Record = (txtRecord.Text != "") ? Convert.ToInt32(txtRecord.Text) : 5; //sửa
_widgetPageLayout.Record2 = (txtRecord2.Text != "") ? Convert.ToInt32(txtRecord2.Text) : 5; //sửa
_widgetPageLayout.Language = Language.language;
return(_widgetPageLayout);
}
public void UpdateSYS_WidgetPageLayout(SYS_WidgetPageLayout sys_WidgetPageLayout)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_SYS_WidgetPageLayoutUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 1);
command.Parameters.AddWithValue("@ID", sys_WidgetPageLayout.Id);
command.Parameters.AddWithValue("@PageLayoutId", sys_WidgetPageLayout.PageLayoutId);
command.Parameters.AddWithValue("@RegionId", sys_WidgetPageLayout.RegionId);
command.Parameters.AddWithValue("@WidgetId", sys_WidgetPageLayout.WidgetId);
command.Parameters.AddWithValue("@HTML", sys_WidgetPageLayout.HTML);
command.Parameters.AddWithValue("@Icon", sys_WidgetPageLayout.Icon);
command.Parameters.AddWithValue("@Info", sys_WidgetPageLayout.Info);
command.Parameters.AddWithValue("@Orders", sys_WidgetPageLayout.Orders);
command.Parameters.AddWithValue("@Record", sys_WidgetPageLayout.Record);
command.Parameters.AddWithValue("@Record2", sys_WidgetPageLayout.Record2);
command.Parameters.AddWithValue("@Status", sys_WidgetPageLayout.Status);
command.Parameters.AddWithValue("@Title", sys_WidgetPageLayout.Title);
command.Parameters.AddWithValue("@Value", sys_WidgetPageLayout.Value);
command.Parameters.AddWithValue("@Value2", sys_WidgetPageLayout.Value2);
command.Parameters.AddWithValue("@Language", sys_WidgetPageLayout.Language);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("khong cap nhat duoc sys_WidgetPageLayout");
}
else
{
command.Dispose();
}
}
}
protected void initControl(int ID)
{
if (ID > 0)
{
txtID.Value = Convert.ToString(ID);
//btn_add.Visible = false;
btn_edit.Visible = true;
//btn_add1.Visible = false;
//btn_add2.Visible = false;
btn_edit1.Visible = true;
try
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = _widgetPageLayoutBSO.GetSYS_WidgetPageLayoutById(ID);
Bind_ddlPageLayout();
ddlPageLayout.SelectedValue = Convert.ToString(_widgetPageLayout.PageLayoutId);
//Bind_ddlWidgetType();
Bind_ddlWidget(0);
ddlWidget.SelectedValue = Convert.ToString(_widgetPageLayout.WidgetId);
GetRegion();
ddlRegion.SelectedValue = _widgetPageLayout.RegionId;
txtWidgetTitle.Text = _widgetPageLayout.Title;
hddIcon.Value = _widgetPageLayout.Icon;
//if (_widgetPageLayout.Icon != "")
// ltl_icon.Text = "<img src='" + ResolveUrl("~/") + "Upload/Widgets/Icons/" + _widgetPageLayout.Icon + "' width='48px'>";
chkStatus.Checked = _widgetPageLayout.Status;
hddRadInfo.Value = _widgetPageLayout.Info;
hddRadHTML.Value = _widgetPageLayout.HTML;
BindListCate(_widgetPageLayout.Value);
BindToCateNewsGroup();
BindToCateNews(Convert.ToInt32(lboGroupCate.SelectedValue));
txtRecord.Text = _widgetPageLayout.Record.ToString();//sửa
hddRecord2.Value = _widgetPageLayout.Record2.ToString();
//lboGallary.SelectedValue = _widgetPageLayout.Value; //sửa
hddValue2.Value = _widgetPageLayout.Value2;
hddOrders.Value = _widgetPageLayout.Orders.ToString();
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
else
{
Page.ClientScript.RegisterOnSubmitStatement(typeof(Page), "closePage", "window.onunload = CloseWindow();");
}
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie_lang = Request.Cookies["LangInfo_CMS"];
if (cookie_lang == null || cookie_lang["Lang"] == null || cookie_lang["Lang"] == string.Empty)
{
cookie_lang = new HttpCookie("LangInfo_CMS");
cookie_lang["Lang"] = "vi-VN";
cookie_lang.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie_lang);
}
Language.language = cookie_lang["Lang"].ToString();
Session["Lang"] = cookie_lang["Lang"].ToString();
Config config = new Config();
if (AspNetCache.CheckCache("Config_" + Language.language) == false)
{
ConfigBSO configBSO = new ConfigBSO();
config = configBSO.GetAllConfig(Language.language);
AspNetCache.SetCacheWithTime("Config_" + Language.language, config, 150);
}
else
{
config = (Config)AspNetCache.GetCache("Config_" + Language.language);
}
Page.Title = config.Titleweb;
if (!string.IsNullOrEmpty(Request["id"]))
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = _widgetPageLayoutBSO.GetSYS_WidgetPageLayoutById(Convert.ToInt32(Request["id"].ToString()));
if (_widgetPageLayout != null)
{
SYS_WidgetBSO _widgetBSO = new SYS_WidgetBSO();
SYS_Widget _widget = _widgetBSO.GetSYS_WidgetById(_widgetPageLayout.WidgetId);
if (_widget != null)
{
if (_widget.WidgetControl != "")
{
Control objControl1 = (Control)this.Page.LoadControl(ResolveUrl("~") + "Client/Modules/" + _widget.WidgetDir + "/" + _widget.WidgetControl + ".ascx");
objControl1.ID = _widgetPageLayout.Id.ToString();
PlaceHolder1.Controls.Add(objControl1);
// PlaceHolder1.Controls.Add(LoadControl(ResolveUrl("~") + _widget.WidgetDir + "/" + _widget.WidgetControl));
ControlAddParameter(objControl1, _widgetPageLayout.Title, _widgetPageLayout.Icon, _widgetPageLayout.Value, Convert.ToInt32(_widgetPageLayout.Record), _widgetPageLayout.Info, _widgetPageLayout.Value2, Convert.ToInt32(_widgetPageLayout.Record2), _widgetPageLayout.HTML);
}
}
}
}
}
protected void btn_add_Click_more(object sender, EventArgs e)
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = ReceiveHtml();
try
{
int id = _widgetPageLayoutBSO.CreateSYS_WidgetPageLayoutGet(_widgetPageLayout);
error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Thêm mới thành công !</div>";
AspNetCache.Reset();
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
protected void Edit()
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = ReceiveHtml();
try
{
_widgetPageLayoutBSO.UpdateSYS_WidgetPageLayout(_widgetPageLayout);
error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Cập nhật thành công !</div>";
initControl(_widgetPageLayout.Id);
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
protected void btn_add_Click_more(object sender, EventArgs e)
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = ReceiveHtml();
try
{
int id = _widgetPageLayoutBSO.CreateSYS_WidgetPageLayoutGet(_widgetPageLayout);
error.Text = "<div style='color:#ff0000;font:bold 12px Arial;padding:5px 0;'>Thêm mới thành công !</div>";
AspNetCache.Reset();
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
protected void Add()
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = ReceiveHtml();
try
{
int id = _widgetPageLayoutBSO.CreateSYS_WidgetPageLayoutGet(_widgetPageLayout);
error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Thêm mới thành công !</div>";
initControl(id);
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
protected void Edit()
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = ReceiveHtml();
try
{
_widgetPageLayoutBSO.UpdateSYS_WidgetPageLayout(_widgetPageLayout);
error.Text = "<div style='color:#ff0000;font:bold 12px Arial;padding:5px 0;'>Cập nhật thành công !</div>";
initControl(_widgetPageLayout.Id);
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
protected void Add()
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = ReceiveHtml();
try
{
int id = _widgetPageLayoutBSO.CreateSYS_WidgetPageLayoutGet(_widgetPageLayout);
error.Text = "<div style='color:#ff0000;font:bold 12px Arial;padding:5px 0;'>Thêm mới thành công !</div>";
initControl(id);
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
public int CreateSYS_WidgetPageLayoutGet(SYS_WidgetPageLayout sys_WidgetPageLayout)
{
int i = 0;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_SYS_WidgetPageLayoutInsert", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@Id", 0);
command.Parameters.AddWithValue("@PageLayoutId", sys_WidgetPageLayout.PageLayoutId);
command.Parameters.AddWithValue("@RegionId", sys_WidgetPageLayout.RegionId);
command.Parameters.AddWithValue("@WidgetId", sys_WidgetPageLayout.WidgetId);
command.Parameters.AddWithValue("@HTML", sys_WidgetPageLayout.HTML);
command.Parameters.AddWithValue("@Icon", sys_WidgetPageLayout.Icon);
command.Parameters.AddWithValue("@Info", sys_WidgetPageLayout.Info);
command.Parameters.AddWithValue("@Orders", sys_WidgetPageLayout.Orders);
command.Parameters.AddWithValue("@Record", sys_WidgetPageLayout.Record);
command.Parameters.AddWithValue("@Record2", sys_WidgetPageLayout.Record2);
command.Parameters.AddWithValue("@Status", sys_WidgetPageLayout.Status);
command.Parameters.AddWithValue("@Title", sys_WidgetPageLayout.Title);
command.Parameters.AddWithValue("@Value", sys_WidgetPageLayout.Value);
command.Parameters.AddWithValue("@Value2", sys_WidgetPageLayout.Value2);
command.Parameters.AddWithValue("@Language", sys_WidgetPageLayout.Language);
SqlParameter parameter = new SqlParameter("@ReturnId", SqlDbType.Int);
parameter.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(parameter);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Khong them duoc");
}
else
{
i = (int)parameter.Value;
command.Dispose();
}
}
return(i);
}
private SYS_WidgetPageLayout SYS_WidgetPageLayoutReader(SqlDataReader reader)
{
SYS_WidgetPageLayout sys_WidgetPageLayout = new SYS_WidgetPageLayout();
sys_WidgetPageLayout.Id = (int)reader["Id"];
sys_WidgetPageLayout.PageLayoutId = (int)reader["PageLayoutId"];
sys_WidgetPageLayout.RegionId = (string)reader["RegionId"];
sys_WidgetPageLayout.WidgetId = (int)reader["WidgetId"];
sys_WidgetPageLayout.HTML = (string)reader["HTML"];
sys_WidgetPageLayout.Icon = (string)reader["Icon"];
sys_WidgetPageLayout.Info = (string)reader["Info"];
sys_WidgetPageLayout.Orders = (int)reader["Orders"];
sys_WidgetPageLayout.Record = (int)reader["Record"];
sys_WidgetPageLayout.Record2 = (int)reader["Record2"];
sys_WidgetPageLayout.Status = (bool)reader["Status"];
sys_WidgetPageLayout.Title = (string)reader["Title"];
sys_WidgetPageLayout.Value = (string)reader["Value"];
sys_WidgetPageLayout.Value2 = (string)reader["Value2"];
sys_WidgetPageLayout.Language = (string)reader["Language"];
return(sys_WidgetPageLayout);
}
public void UpdateSYS_WidgetPageLayout(SYS_WidgetPageLayout sys_WidgetPageLayout)
{
SYS_WidgetPageLayoutDAO sys_WidgetPageLayoutDAO = new SYS_WidgetPageLayoutDAO();
sys_WidgetPageLayoutDAO.UpdateSYS_WidgetPageLayout(sys_WidgetPageLayout);
}
protected void initControl(int ID)
{
if (ID > 0)
{
txtID.Value = Convert.ToString(ID);
btn_add.Visible = false;
btn_edit.Visible = true;
btn_add1.Visible = false;
btn_add2.Visible = false;
btn_edit1.Visible = true;
try
{
SYS_WidgetPageLayoutBSO _widgetPageLayoutBSO = new SYS_WidgetPageLayoutBSO();
SYS_WidgetPageLayout _widgetPageLayout = _widgetPageLayoutBSO.GetSYS_WidgetPageLayoutById(ID);
// Bind_ddlPageLayout();
// ddlPageLayout.SelectedValue = Convert.ToString(_widgetPageLayout.PageLayoutId);
hddPageLayout.Value = Convert.ToString(_widgetPageLayout.PageLayoutId);
GetRegion(_widgetPageLayout.PageLayoutId);
ddlRegion.SelectedValue = _widgetPageLayout.RegionId;
Bind_ddlWidgetType();
Bind_ddlWidget(0);
ddlWidget.SelectedValue = Convert.ToString(_widgetPageLayout.WidgetId);
txtWidgetTitle.Text = _widgetPageLayout.Title;
hddIcon.Value = _widgetPageLayout.Icon;
//if (_widgetPageLayout.Icon != "")
// ltl_icon.Text = "<img src='" + ResolveUrl("~/") + "Upload/Widgets/Icons/" + _widgetPageLayout.Icon + "' width='48px'>";
chkStatus.Checked = _widgetPageLayout.Status;
hddRadInfo.Value = _widgetPageLayout.Info;
hddRadHTML.Value = _widgetPageLayout.HTML;
hddRecord.Value = _widgetPageLayout.Record.ToString();
hddRecord2.Value = _widgetPageLayout.Record2.ToString();
hddValue.Value = _widgetPageLayout.Value;
hddValue2.Value = _widgetPageLayout.Value2;
hddOrders.Value = _widgetPageLayout.Orders.ToString();
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
else
{
// Bind_ddlPageLayout();
Bind_ddlWidgetType();
Bind_ddlWidget(0);
txtID.Value = "";
GetRegion(Convert.ToInt32(hddPageLayout.Value));
// ddlPageLayout.SelectedIndex = 0;
btn_add.Visible = true;
btn_edit.Visible = false;
btn_add1.Visible = true;
btn_add2.Visible = true;
btn_edit1.Visible = false;
}
}
public int CreateSYS_WidgetPageLayoutGet(SYS_WidgetPageLayout sys_WidgetPageLayout)
{
SYS_WidgetPageLayoutDAO sys_WidgetPageLayoutDAO = new SYS_WidgetPageLayoutDAO();
return(sys_WidgetPageLayoutDAO.CreateSYS_WidgetPageLayoutGet(sys_WidgetPageLayout));
}
