protected void btnSubmit_Click(object sender, EventArgs e) { string tag = _tag + "[btnSubmit_Click]"; MenuBOL obj = new MenuBOL() { Name_VN = tbxNameVN.Text, Description_VN = tbxDesVN.Text, Name_EN = tbxNameEN.Text, Description_EN = tbxDesEN.Text, InsertDate = DateTime.Now, UpdatedDate = DateTime.Now }; if (_menuId > 0) { obj.Id = _menuId; } else if (_parentId > 0) { obj.ParentId = _parentId; } var result = MenuDAL.InsertOrUpdate(obj); if (result.Code < 0) { LogHelpers.WriteError(tag, result.ErrorMessage); } else { GoBackPage(); } }
public static AllCategoriesModel GetAll(bool removeRoot = false) { string stored = "sp_GetAllData_WithType"; ResultData <DataSet> result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, new { }); if (result.Code < 0) { _log.Error(result.Message); } AllCategoriesModel model = new AllCategoriesModel(); if (result.Data != null && result.Data.Tables.Count > 1) { foreach (DataRow row in result.Data.Tables[0].Rows) { MenuBOL menu = new MenuBOL(row); if (removeRoot && menu.ParentId <= 0) { continue; } model.Roots.Add(menu); } foreach (DataRow row in result.Data.Tables[1].Rows) { model.News.Add(new NewsBOL(row)); } } return(model); }
private void StartLoadMenuInfo(int id) { if (id <= 0) { return; } var result = MenuDAL.Get(id); if (result.Code < 0) { return; } MenuBOL menuBOL = new MenuBOL(result.Data.Tables[0].Rows[0]); tbxNameVN.Text = menuBOL.Name_VN; tbxDesVN.Text = menuBOL.Description_VN; tbxNameEN.Text = menuBOL.Name_EN; tbxDesEN.Text = menuBOL.Description_EN; //--- if (menuBOL.ParentId > 0) { _parentId = menuBOL.ParentId; } }
public void StartLoadMenuDetail(int id, bool enableEdit = true) { string tag = _tag + "[St-artLoadMenuDetail]"; if (id <= 0) { return; } var result = MenuDAL.Get(id); if (result.Code < 0) { lbError.InnerText = result.ErrorMessage; lbError.Visible = true; return; } lbError.Visible = false; hfMenuId.Value = id.ToString(); //--- try { if (!enableEdit) { this.btnAddSubMenu.Visible = false; this.btnDeleteSubMenu.Visible = false; } MenuBOL menu = new MenuBOL(result.Data.Tables[0].Rows[0]); btnAddSubMenu.Attributes.Add("data-id", menu.Id.ToString()); tbxNameVN.Text = menu.Name_VN; tbxDesVN.Text = menu.Description_VN; tbxNameEN.Text = menu.Name_EN; tbxDesEN.Text = menu.Description_EN; if (!string.IsNullOrEmpty(menu.Image)) { imgImage.ImageUrl = "~/" + Path.Combine(Utilities.GetDirectory("ImagesDir"), menu.Image); //imgImage.Visible = true; } //else //{ // imgImage.Visible = false; //} //--- //if (menu.ParentId <= 0) //{ // tbxNameVN.Enabled = false; // tbxNameEN.Enabled = false; //} } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); //--- lbError.InnerText = ex.Message; lbError.Visible = true; } }
public static ResultBOL <int> InsertOrUpdate(MenuBOL obj) { string stored = "sp_Menu_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters()); return(result); }
private void CreateMenuBar() { var result = MenuDAL.GetAll(); if (result.Code < 0 || result.Data == null || result.Data.Tables.Count == 0) { return; } foreach (DataRow row in result.Data.Tables[0].Rows) { MenuBOL menu = new MenuBOL(row); if (menu.ParentId > 0) { continue; } //--- _parentUrl = menu.RedirectUrl; HtmlGenericControl li = new HtmlGenericControl("li"); li.InnerHtml = string.Format("<a href='{0}'>{1}</a>", menu.RedirectUrl, menu.Name_VN); StartAddMenuItem(li, menu.Id, result.Data.Tables[0].Rows); this.ulMenuBar.Controls.Add(li); } }
public static ResultBOL <int> InsertOrUpdate(MenuBOL obj) { //string type = GetType(obj.ParentId); //if (!string.IsNullOrEmpty(type)) //{ // switch (type) // { // case "DichVu": // return NewsDAL.InsertOrUpdate(new NewsBOL() { // Name_EN = obj.Name_EN, // Name_VN = obj.Name_VN, // ImageLink = obj.Image, // Type = type, // ParentId = obj.ParentId // }); // default: // break; // } //} string stored = "sp_Menu_Insert_Update"; var result = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters()); return(result); }
public void StartLoadMenuDetail(int id) { string tag = _tag + "[StartLoadMenuDetail]"; if (id <= 0) { return; } var result = MenuDAL.Get(id); if (result.Code < 0) { lbError.InnerText = result.ErrorMessage; lbError.Visible = true; return; } lbError.Visible = false; hfMenuId.Value = id.ToString(); //--- try { MenuBOL menu = new MenuBOL(result.Data.Tables[0].Rows[0]); btnAddSubMenu.Attributes.Add("data-id", menu.Id.ToString()); tbxNameVN.Text = menu.Name_VN; tbxDesVN.Text = menu.Description_VN; tbxNameEN.Text = menu.Name_EN; tbxDesEN.Text = menu.Description_EN; //--- //if (menu.ParentId <= 0) //{ // tbxNameVN.Enabled = false; // tbxNameEN.Enabled = false; //} } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); //--- lbError.InnerText = ex.Message; lbError.Visible = true; } }
public static AllCategoriesModel GetAllServices(int id = 0) { #if DEBUG _log.Debug("=================== Start =================="); #endif string stored = "sp_GetAllData_WithType"; object obj = new { Type = "DichVu", Id = id }; ResultData <DataSet> result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { _log.Error(result.Message); } AllCategoriesModel model = new AllCategoriesModel(); if (result.Data != null && result.Data.Tables.Count > 1) { foreach (DataRow row in result.Data.Tables[0].Rows) { MenuBOL menu = new MenuBOL(row); if (menu.ParentId > 0) { model.Roots.Add(menu); } } foreach (DataRow row in result.Data.Tables[1].Rows) { NewsBOL news = new NewsBOL(row); if (!news.Disable) { model.News.Add(news); } } } return(model); }
private void UpdateMenuProcessing() { string tag = _tag + "[UpdateMenuProcessing]"; LogHelpers.WriteStatus(tag, "Start..."); try { MenuBOL menu = new MenuBOL() { Id = string.IsNullOrEmpty(hfMenuId.Value) ? 0 : int.Parse(hfMenuId.Value), Name_VN = tbxNameVN.Text, Name_EN = tbxNameEN.Text, Image = StartUploadImage(), Description_VN = tbxDesVN.Text, Description_EN = tbxDesEN.Text, InsertDate = DateTime.Now, UpdatedDate = DateTime.Now }; var result = MenuDAL.InsertOrUpdate(menu); if (result.Code < 0) { lbError.InnerText = result.ErrorMessage; lbError.Visible = true; return; } } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); //--- lbError.InnerText = ex.Message; lbError.Visible = true; } finally { LogHelpers.WriteStatus(tag, "End."); } }
private void CreateMenuBar() { var result = MenuDAL.GetAll(); if (result.Code < 0 || result.Data == null || result.Data.Tables.Count == 0) { return; } foreach (DataRow row in result.Data.Tables[0].Rows) { MenuBOL menu = new MenuBOL(row); if (menu.ParentId > 0) { continue; } //--- _parentUrl = menu.RedirectUrl; HtmlGenericControl li = new HtmlGenericControl("li"); //--- if (!string.IsNullOrEmpty(menu.RedirectUrl) && menu.RedirectUrl.Contains("About.aspx")) { li.InnerHtml = string.Format("<a href='{0}'>{1}</a>", "Introductions.aspx", menu.Name_VN); } else { li.InnerHtml = string.Format("<a href='{0}'>{1}</a>", menu.RedirectUrl, menu.Name_VN); } StartAddMenuItem(li, menu.Id, result.Data.Tables[0].Rows); this.ulMenuAdmin.Controls.Add(li); } //--- StartAddMenuOther(); }
private void StartAddMenuItem(HtmlGenericControl ctrlRoot, int parentId, DataRowCollection rows) { HtmlGenericControl ul = new HtmlGenericControl("ul"); foreach (DataRow row in rows) { MenuBOL menu = new MenuBOL(row); if (menu.ParentId == parentId) { HtmlGenericControl li = new HtmlGenericControl("li"); li.InnerHtml = string.Format("<a href='{0}?MenuId={1}'>{2}</a>", _parentUrl, menu.Id, menu.Name_VN); //--- ul.Controls.Add(li); StartAddMenuItem(li, menu.Id, rows); } } if (ul.Controls.Count > 0) { ctrlRoot.Controls.Add(ul); } }
public void ProcessRequest(HttpContext context) { string tag = "[AddSubMenuHandler][ProcessRequest]"; var jsonString = string.Empty; context.Request.InputStream.Position = 0; try { var inputStream = new StreamReader(context.Request.InputStream); jsonString = inputStream.ReadToEnd(); inputStream.Close(); //-- MenuBOL menu = JsonConvert.DeserializeObject <MenuBOL>(jsonString); menu.InsertDate = DateTime.Now; menu.UpdatedDate = DateTime.Now; var result = MenuDAL.InsertOrUpdate(menu); //--- object obj = new { Code = result.Code, Message = result.ErrorMessage, Id = result.DbReturnValue, Name = menu.Name_VN }; //--- string responseString = JsonConvert.SerializeObject(obj); context.Response.ContentType = "application/json"; context.Response.Write(responseString); } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); } }
private void StartAddSubMenuItem(HtmlGenericControl ctrlRoot, int parentId, DataRowCollection rows) { HtmlGenericControl ul = new HtmlGenericControl("ul"); foreach (DataRow row in rows) { MenuBOL menu = new MenuBOL(row); if (menu.ParentId == parentId) { HtmlGenericControl li = new HtmlGenericControl("li"); if (menu.Childrens > 0) { li.InnerHtml = string.Format("<a href='{0}?MenuId={1}'>{2}</a>", _parentUrl, menu.Id, Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN); } else { li.InnerHtml = string.Format("<a href='#'>{0}</a>", Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN); } //--- ul.Controls.Add(li); StartAddSubMenuItem(li, menu.Id, rows); _menuFooter.Add(menu); } } if (ul.Controls.Count > 0) { ctrlRoot.Controls.Add(ul); } }
public static AllCategoriesModel GetAllWithTypeGetAll(bool removeRoot = false) { string controller = HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString(); string type = ""; switch (controller) { case "About": type = "GioiThieu"; break; case "News": type = "TinTuc"; break; case "Train": type = "DaoTao"; break; case "Gallery": type = "ThuVienHinh"; break; default: type = "DichVu"; break; } #if DEBUG _log.Debug("type: {0}", type); #endif string stored = "sp_GetAllData_WithType"; object obj = new { Type = type }; ResultData <DataSet> result = DataAccessHelpers.ExecuteStoredReturnDataSet(stored, obj); if (result.Code < 0) { _log.Error(result.Message); } AllCategoriesModel model = new AllCategoriesModel(); model.PageType = (controller == "Home" || string.IsNullOrEmpty(controller)) ? "Service" : controller; if (result.Data != null && result.Data.Tables.Count > 1) { foreach (DataRow row in result.Data.Tables[0].Rows) { MenuBOL menu = new MenuBOL(row); if (removeRoot && menu.ParentId <= 0) { continue; } model.Roots.Add(menu); } if (controller.ToLower() != "gallery") { foreach (DataRow row in result.Data.Tables[1].Rows) { model.News.Add(new NewsBOL(row)); } } } return(model); }
public List <MenuBOL> CreateMenuBar() { //--- HtmlGenericControl liHome = new HtmlGenericControl("li"); string nameHome = Utilities.IsLangueEN() ? "Home" : "Trang Chủ"; liHome.InnerHtml = string.Format("<a href='{0}'>{1}</a>", "Home.aspx", nameHome); //--- ulMenuBar.Controls.Add(liHome); //---- var result = MenuDAL.GetAll(); if (result.Code < 0 || result.Data == null || result.Data.Tables.Count == 0) { return(null); } _menuFooter = new List <MenuBOL>(); foreach (DataRow row in result.Data.Tables[0].Rows) { MenuBOL menu = new MenuBOL(row); if (menu.ParentId > 0) { continue; } this._menuFooter.Add(menu); //--- _parentUrl = menu.RedirectUrl; HtmlGenericControl li = new HtmlGenericControl("li"); //-- if (menu.Childrens > 0 || menu.Type == "DuAn") { li.InnerHtml = string.Format("<a href='{0}'>{1}</a>", menu.RedirectUrl, Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN); } else { li.InnerHtml = string.Format("<a href='#'>{0}</a>", Utilities.IsLangueEN() ? menu.Name_EN : menu.Name_VN); } if (menu.Type == "GioiThieu") { StartAddSubItemAbout(li, menu.Id); } else if (menu.Type == "LienHe") { StartAddSubMenuContact(li, menu.Id); } else { StartAddSubMenuItem(li, menu.Id, result.Data.Tables[0].Rows); } this.ulMenuBar.Controls.Add(li); } return(_menuFooter); }