public void UpdateSYS_Widget(SYS_Widget sys_Widget)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_SYS_WidgetUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 1);
command.Parameters.AddWithValue("@ID", sys_Widget.Id);
command.Parameters.AddWithValue("@WidgetControl", sys_Widget.WidgetControl);
command.Parameters.AddWithValue("@WidgetDir", sys_Widget.WidgetDir);
command.Parameters.AddWithValue("@WidgetInfo", sys_Widget.WidgetInfo);
command.Parameters.AddWithValue("@WidgetName", sys_Widget.WidgetName);
command.Parameters.AddWithValue("@WidgetStatus", sys_Widget.WidgetStatus);
command.Parameters.AddWithValue("@WidgetType", sys_Widget.WidgetType);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("khong cap nhat duoc sys_Widget");
}
else
{
command.Dispose();
}
}
}
public SYS_Widget GetSYS_WidgetById(int Id)
{
SYS_Widget sys_Widget = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_SYS_WidgetGetById", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Id", Id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
sys_Widget = SYS_WidgetReader(reader);
}
else
{
throw new DataAccessException("Khong tim thay gia tri sys_Widget");
}
command.Dispose();
}
}
return(sys_Widget);
}
public int CreateSYS_WidgetGet(SYS_Widget sys_Widget)
{
int i = 0;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_SYS_WidgetInsert", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@Id", 0);
command.Parameters.AddWithValue("@WidgetControl", sys_Widget.WidgetControl);
command.Parameters.AddWithValue("@WidgetDir", sys_Widget.WidgetDir);
command.Parameters.AddWithValue("@WidgetInfo", sys_Widget.WidgetInfo);
command.Parameters.AddWithValue("@WidgetName", sys_Widget.WidgetName);
command.Parameters.AddWithValue("@WidgetStatus", sys_Widget.WidgetStatus);
command.Parameters.AddWithValue("@WidgetType", sys_Widget.WidgetType);
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);
}
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_WidgetBSO sys_WidgetBSO = new SYS_WidgetBSO();
SYS_Widget sys_Widget = sys_WidgetBSO.GetSYS_WidgetById(ID);
Bind_ddlWidgetType();
ddlWidgetType.SelectedValue = Convert.ToString(sys_Widget.WidgetType);
txtWidgetName.Text = sys_Widget.WidgetName;
GetFile();
GetFileControl = sys_Widget.WidgetControl + ".ascx";
ActipFile();
try
{
dropFolder.SelectedItem.Text = sys_Widget.WidgetDir.ToString();
dropFolder.SelectedValue = sys_Widget.WidgetDir.ToString();
}
catch { }
txtInfo.Text = sys_Widget.WidgetInfo;
chkStatus.Checked = sys_Widget.WidgetStatus;
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
else
{
GetFile();
ActipFile();
Bind_ddlWidgetType();
txtID.Value = "";
ddlWidgetType.SelectedIndex = 0;
btn_add.Visible = true;
btn_edit.Visible = false;
btn_add1.Visible = true;
btn_add2.Visible = true;
btn_edit1.Visible = false;
}
}
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);
}
}
}
}
}
private SYS_Widget SYS_WidgetReader(SqlDataReader reader)
{
SYS_Widget sys_Widget = new SYS_Widget();
sys_Widget.Id = (int)reader["Id"];
sys_Widget.WidgetControl = (string)reader["WidgetControl"];
sys_Widget.WidgetDir = (string)reader["WidgetDir"];
sys_Widget.WidgetInfo = (string)reader["WidgetInfo"];
sys_Widget.WidgetName = (string)reader["WidgetName"];
sys_Widget.WidgetType = (int)reader["WidgetType"];
sys_Widget.WidgetStatus = (bool)reader["WidgetStatus"];
return(sys_Widget);
}
public SYS_Widget ReceiveHtml()
{
SYS_Widget sys_Widget = new SYS_Widget();
sys_Widget.Id = (txtID.Value != "") ? Convert.ToInt32(txtID.Value) : 0;
sys_Widget.WidgetName = (txtWidgetName.Text != "") ? txtWidgetName.Text.Trim() : "";
sys_Widget.WidgetDir = (dropFolder.SelectedValue != "") ? dropFolder.SelectedItem.Text : "";
sys_Widget.WidgetControl = (dropControl.SelectedValue != "") ? dropControl.SelectedValue.Replace(".ascx", "") : "";
sys_Widget.WidgetType = (ddlWidgetType.SelectedValue != "") ? Convert.ToInt32(ddlWidgetType.SelectedValue) : 0;
sys_Widget.WidgetInfo = txtInfo.Text;
sys_Widget.WidgetStatus = chkStatus.Checked;
return(sys_Widget);
}
protected void Edit()
{
SYS_WidgetBSO sys_WidgetBSO = new SYS_WidgetBSO();
SYS_Widget sys_Widget = ReceiveHtml();
try
{
sys_WidgetBSO.UpdateSYS_Widget(sys_Widget);
error.Text = "<div style='color:#ff0000;font:bold 12px Arial;padding:5px 0;'>Cập nhật thành công !</div>";
initControl(sys_Widget.Id);
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
protected void Add()
{
SYS_WidgetBSO sys_WidgetBSO = new SYS_WidgetBSO();
SYS_Widget sys_Widget = ReceiveHtml();
try
{
int id = sys_WidgetBSO.CreateSYS_WidgetGet(sys_Widget);
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();
}
}
protected void btn_add_Click_more(object sender, EventArgs e)
{
SYS_WidgetBSO sys_WidgetBSO = new SYS_WidgetBSO();
SYS_Widget sys_Widget = ReceiveHtml();
try
{
int id = sys_WidgetBSO.CreateSYS_WidgetGet(sys_Widget);
error.Text = "<div style='color:#ff0000;font:bold 12px Arial;padding:5px 0;'>Thêm mới thành công !</div>";
AspNetCache.Reset();
ViewWidgetAll();
}
catch (Exception ex)
{
error.Text = ex.Message.ToString();
}
}
public void UpdateSYS_Widget(SYS_Widget sys_Widget)
{
SYS_WidgetDAO sys_WidgetDAO = new SYS_WidgetDAO();
sys_WidgetDAO.UpdateSYS_Widget(sys_Widget);
}
public int CreateSYS_WidgetGet(SYS_Widget sys_Widget)
{
SYS_WidgetDAO sys_WidgetDAO = new SYS_WidgetDAO();
return(sys_WidgetDAO.CreateSYS_WidgetGet(sys_Widget));
}