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);
}
