public static MenuViewData Load() { WhereClause w = new WhereClause(); SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true); if (!dataReader.Read()) { dataReader.Close(); throw new FinderException("Load found no rows for MenuView."); } MenuViewData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
private void InitMenuViewData(ActionExecutingContext filterContext) { MenuViewData menuViewData = new MenuViewData(); User user = this._cuyahogaContext.CurrentUser; if (user != null && user.IsAuthenticated) { var nodes = this._sitemapProvider.GetMvcChildNodes(this._sitemapProvider.RootNode); var currentNode = this._sitemapProvider.CurrentNode; UrlHelper urlHelper = new UrlHelper(filterContext.RequestContext); // mainmenu foreach (MvcSiteMapNode node in nodes) { if (this._sitemapProvider.IsAccessibleToUser(filterContext.HttpContext, node, this._cuyahogaContext.CurrentSite)) { MenuItemData menuItemData = GenerateMenuItemFromSiteMapNode(filterContext, node, currentNode, urlHelper); bool isSystem = Convert.ToBoolean(node["system"]); if (isSystem) { menuViewData.AddOptionalMenuItem(menuItemData); } else { menuViewData.AddStandardMenuItem(menuItemData); } if (node.HasChildNodes) { foreach (var childNode in node.ChildNodes) { MvcSiteMapNode mvcChildNode = childNode as MvcSiteMapNode; if (mvcChildNode != null) { if (this._sitemapProvider.IsAccessibleToUser(filterContext.HttpContext, mvcChildNode, this._cuyahogaContext.CurrentSite)) { menuItemData.AddChildMenuItem(GenerateMenuItemFromSiteMapNode(filterContext, mvcChildNode, currentNode, urlHelper)); } } } } } } } filterContext.Controller.ViewData.Add("MenuViewData", menuViewData); }
public static void Insert(MenuViewData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "ParentMenuItemsID," + "Description," + "url," + "SortOrder," + "Target," + "DateStart," + "DateEnd," + "NodeImgSrc," + "MenuItemsID," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@ParentMenuItemsID," + "@Description," + "@url," + "@SortOrder," + "@Target," + "@DateStart," + "@DateEnd," + "@NodeImgSrc," + "@MenuItemsID," ; sql = sql.Substring(0, sql.Length - 1) + ")"; SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object cmd.Parameters.Add(new SqlParameter("@ParentMenuItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ParentMenuItemsID", DataRowVersion.Proposed, data.ParentMenuItemsID.DBValue)); cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue)); cmd.Parameters.Add(new SqlParameter("@url", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "url", DataRowVersion.Proposed, data.Url.DBValue)); cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.TinyInt, 0, ParameterDirection.Input, false, 0, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue)); cmd.Parameters.Add(new SqlParameter("@Target", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "Target", DataRowVersion.Proposed, data.Target.DBValue)); cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue)); cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue)); cmd.Parameters.Add(new SqlParameter("@NodeImgSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "NodeImgSrc", DataRowVersion.Proposed, data.NodeImgSrc.DBValue)); cmd.Parameters.Add(new SqlParameter("@MenuItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "MenuItemsID", DataRowVersion.Proposed, data.MenuItemsID.DBValue)); // Execute the query cmd.ExecuteNonQuery(); }
public static void Update(MenuViewData data) { // Create and execute the command MenuViewData oldData = Load(); string sql = "Update " + TABLE + " set "; if (!oldData.ParentMenuItemsID.Equals(data.ParentMenuItemsID)) { sql = sql + "ParentMenuItemsID=@ParentMenuItemsID,"; } if (!oldData.Description.Equals(data.Description)) { sql = sql + "Description=@Description,"; } if (!oldData.Url.Equals(data.Url)) { sql = sql + "url=@url,"; } if (!oldData.SortOrder.Equals(data.SortOrder)) { sql = sql + "SortOrder=@SortOrder,"; } if (!oldData.Target.Equals(data.Target)) { sql = sql + "Target=@Target,"; } if (!oldData.DateStart.Equals(data.DateStart)) { sql = sql + "DateStart=@DateStart,"; } if (!oldData.DateEnd.Equals(data.DateEnd)) { sql = sql + "DateEnd=@DateEnd,"; } if (!oldData.NodeImgSrc.Equals(data.NodeImgSrc)) { sql = sql + "NodeImgSrc=@NodeImgSrc,"; } if (!oldData.MenuItemsID.Equals(data.MenuItemsID)) { sql = sql + "MenuItemsID=@MenuItemsID,"; } WhereClause w = new WhereClause(); sql = sql.Substring(0, sql.Length - 1) + w.FormatSql(); SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT); //Create the parameters and append them to the command object if (!oldData.ParentMenuItemsID.Equals(data.ParentMenuItemsID)) { cmd.Parameters.Add(new SqlParameter("@ParentMenuItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ParentMenuItemsID", DataRowVersion.Proposed, data.ParentMenuItemsID.DBValue)); } if (!oldData.Description.Equals(data.Description)) { cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue)); } if (!oldData.Url.Equals(data.Url)) { cmd.Parameters.Add(new SqlParameter("@url", SqlDbType.VarChar, 300, ParameterDirection.Input, false, 0, 0, "url", DataRowVersion.Proposed, data.Url.DBValue)); } if (!oldData.SortOrder.Equals(data.SortOrder)) { cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.TinyInt, 0, ParameterDirection.Input, false, 0, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue)); } if (!oldData.Target.Equals(data.Target)) { cmd.Parameters.Add(new SqlParameter("@Target", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "Target", DataRowVersion.Proposed, data.Target.DBValue)); } if (!oldData.DateStart.Equals(data.DateStart)) { cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue)); } if (!oldData.DateEnd.Equals(data.DateEnd)) { cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue)); } if (!oldData.NodeImgSrc.Equals(data.NodeImgSrc)) { cmd.Parameters.Add(new SqlParameter("@NodeImgSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "NodeImgSrc", DataRowVersion.Proposed, data.NodeImgSrc.DBValue)); } if (!oldData.MenuItemsID.Equals(data.MenuItemsID)) { cmd.Parameters.Add(new SqlParameter("@MenuItemsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "MenuItemsID", DataRowVersion.Proposed, data.MenuItemsID.DBValue)); } // Execute the query if (cmd.Parameters.Count > 0) { cmd.ExecuteNonQuery(); } }
private static MenuViewData GetDataObjectFromReader(SqlDataReader dataReader) { MenuViewData data = new MenuViewData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("ParentMenuItemsID"))) { data.ParentMenuItemsID = IntegerType.UNSET; } else { data.ParentMenuItemsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ParentMenuItemsID"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Description"))) { data.Description = StringType.UNSET; } else { data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("url"))) { data.Url = StringType.UNSET; } else { data.Url = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("url"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder"))) { data.SortOrder = IntegerType.UNSET; } else { data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("Target"))) { data.Target = StringType.UNSET; } else { data.Target = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Target"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart"))) { data.DateStart = DateType.UNSET; } else { data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd"))) { data.DateEnd = DateType.UNSET; } else { data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("NodeImgSrc"))) { data.NodeImgSrc = StringType.UNSET; } else { data.NodeImgSrc = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NodeImgSrc"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("MenuItemsID"))) { data.MenuItemsID = IntegerType.UNSET; } else { data.MenuItemsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("MenuItemsID"))); } return(data); }