public void UpdateSYS_WidgetType(SYS_WidgetType sys_WidgetType) { using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_SYS_WidgetTypeUpdate", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Type", 1); command.Parameters.AddWithValue("@ID", sys_WidgetType.Id); command.Parameters.AddWithValue("@WidgetControl", sys_WidgetType.WidgetControl); command.Parameters.AddWithValue("@WidgetDir", sys_WidgetType.WidgetDir); command.Parameters.AddWithValue("@WidgetInfo", sys_WidgetType.WidgetInfo); command.Parameters.AddWithValue("@WidgetTypeName", sys_WidgetType.WidgetTypeName); command.Parameters.AddWithValue("@WidgetStatus", sys_WidgetType.WidgetStatus); command.Parameters.AddWithValue("@Orders", sys_WidgetType.Orders); connection.Open(); if (command.ExecuteNonQuery() <= 0) { throw new DataAccessException("khong cap nhat duoc sys_WidgetType"); } else { command.Dispose(); } } }
public int CreateSYS_WidgetTypeGet(SYS_WidgetType sys_WidgetType) { int i = 0; using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_SYS_WidgetTypeInsert", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Type", 0); command.Parameters.AddWithValue("@Id", 0); command.Parameters.AddWithValue("@WidgetControl", sys_WidgetType.WidgetControl); command.Parameters.AddWithValue("@WidgetDir", sys_WidgetType.WidgetDir); command.Parameters.AddWithValue("@WidgetInfo", sys_WidgetType.WidgetInfo); command.Parameters.AddWithValue("@WidgetTypeName", sys_WidgetType.WidgetTypeName); command.Parameters.AddWithValue("@WidgetStatus", sys_WidgetType.WidgetStatus); command.Parameters.AddWithValue("@Orders", sys_WidgetType.Orders); 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); }
public SYS_WidgetType GetSYS_WidgetTypeById(int Id) { SYS_WidgetType sys_WidgetType = null; using (SqlConnection connection = GetConnection()) { SqlCommand command = new SqlCommand("_SYS_WidgetTypeGetById", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Id", Id); connection.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.Read()) { sys_WidgetType = SYS_WidgetTypeReader(reader); } else { throw new DataAccessException("Khong tim thay gia tri sys_WidgetType"); } command.Dispose(); } } return(sys_WidgetType); }
private void NavigationTitle(int type) { SYS_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = _widgetTypeBSO.GetSYS_WidgetTypeById(Convert.ToInt32(Request["type"].ToString())); if (_widgetType != null) { litModules.Text = "Cấu hình " + _widgetType.WidgetTypeName; } }
private void NavigationTitle(int type) { //imgIcon.ImageUrl = "~/images/Admin_Theme/Icons/icon-32-config.png"; SYS_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = _widgetTypeBSO.GetSYS_WidgetTypeById(Convert.ToInt32(Request["type"].ToString())); if (_widgetType != null) { litModules.Text = "Cấu hình " + _widgetType.WidgetTypeName; } }
private SYS_WidgetType SYS_WidgetTypeReader(SqlDataReader reader) { SYS_WidgetType sys_WidgetType = new SYS_WidgetType(); sys_WidgetType.Id = (int)reader["Id"]; sys_WidgetType.WidgetControl = (string)reader["WidgetControl"]; sys_WidgetType.WidgetDir = (string)reader["WidgetDir"]; sys_WidgetType.WidgetInfo = (string)reader["WidgetInfo"]; sys_WidgetType.WidgetTypeName = (string)reader["WidgetTypeName"]; sys_WidgetType.WidgetStatus = (bool)reader["WidgetStatus"]; sys_WidgetType.Orders = (int)reader["Orders"]; return(sys_WidgetType); }
protected void btn_add_Click_more(object sender, EventArgs e) { SYS_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = ReceiveHtml(); try { int id = _widgetTypeBSO.CreateSYS_WidgetTypeGet(_widgetType); error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Thêm mới thành công !</div>"; AspNetCache.Reset(); ViewWidgetType(); } catch (Exception ex) { error.Text = ex.Message.ToString(); } }
protected void Edit() { SYS_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = ReceiveHtml(); try { _widgetTypeBSO.UpdateSYS_WidgetType(_widgetType); error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Cập nhật thành công !</div>"; initControl(_widgetType.Id); ViewWidgetType(); } catch (Exception ex) { error.Text = ex.Message.ToString(); } }
protected void Add() { SYS_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = ReceiveHtml(); try { int id = _widgetTypeBSO.CreateSYS_WidgetTypeGet(_widgetType); error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Thêm mới thành công !</div>"; initControl(id); ViewWidgetType(); } catch (Exception ex) { error.Text = ex.Message.ToString(); } }
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["type"])) { SYS_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = _widgetTypeBSO.GetSYS_WidgetTypeById(Convert.ToInt32(Request["type"].ToString())); if (_widgetType != null) { if (_widgetType.WidgetControl != "") { PlaceHolder1.Controls.Add(LoadControl(ResolveUrl("~") + _widgetType.WidgetDir + "/" + _widgetType.WidgetControl)); } } } }
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_WidgetTypeBSO _widgetTypeBSO = new SYS_WidgetTypeBSO(); SYS_WidgetType _widgetType = _widgetTypeBSO.GetSYS_WidgetTypeById(ID); txtWidgetTypeName.Text = _widgetType.WidgetTypeName; GetFile(); dropControl.SelectedValue = _widgetType.WidgetControl; hddDir.Value = _widgetType.WidgetDir; txtInfo.Text = _widgetType.WidgetInfo; chkStatus.Checked = _widgetType.WidgetStatus; hddOrders.Value = _widgetType.Orders.ToString(); } catch (Exception ex) { error.Text = ex.Message.ToString(); } } else { GetFile(); txtID.Value = ""; btn_add.Visible = true; btn_edit.Visible = false; btn_add1.Visible = true; btn_add2.Visible = true; btn_edit1.Visible = false; } }
public SYS_WidgetType ReceiveHtml() { SYS_WidgetType _widgetType = new SYS_WidgetType(); _widgetType.Id = (txtID.Value != "") ? Convert.ToInt32(txtID.Value) : 0; _widgetType.WidgetTypeName = (txtWidgetTypeName.Text != "") ? txtWidgetTypeName.Text.Trim() : ""; _widgetType.WidgetDir = (hddDir.Value != "") ? hddDir.Value : strParentFolder; if (dropControl.SelectedIndex > 0) { _widgetType.WidgetControl = dropControl.SelectedValue; } //_widgetType.WidgetControl = (dropControl.SelectedValue != "") ? dropControl.SelectedValue.Replace(".ascx", "") : ""; _widgetType.WidgetInfo = txtInfo.Text; _widgetType.WidgetStatus = chkStatus.Checked; _widgetType.Orders = (hddOrders.Value != "") ? Convert.ToInt32(hddOrders.Value) : 0; return(_widgetType); }
public void UpdateSYS_WidgetType(SYS_WidgetType sys_WidgetType) { SYS_WidgetTypeDAO sys_WidgetTypeDAO = new SYS_WidgetTypeDAO(); sys_WidgetTypeDAO.UpdateSYS_WidgetType(sys_WidgetType); }
public int CreateSYS_WidgetTypeGet(SYS_WidgetType sys_WidgetType) { SYS_WidgetTypeDAO sys_WidgetTypeDAO = new SYS_WidgetTypeDAO(); return(sys_WidgetTypeDAO.CreateSYS_WidgetTypeGet(sys_WidgetType)); }