public MenuEntityItem GetAllParentItemSideForSiteIdByLanguageId(int SiteId,int LanguageId) { MenuEntityItemDAC _menuEntityItemComponent = new MenuEntityItemDAC(); IDataReader reader = _menuEntityItemComponent.GetAllMenuEntityItem(String.Format("MenuEntityPositionID = 2 and MenuEntityParentId is null and MenuEntityTypeId = {0} and ContentEntityId = {1} and LanguageId = {2}", Convert.ToInt32(MenuEntityTypeEnum.ExternalLink), SiteId,LanguageId)).CreateDataReader(); MenuEntityItem _menuEntityItem = new MenuEntityItem(); while (reader.Read()) { _menuEntityItem = new MenuEntityItem(); if (reader["MenuEntityItemId"] != DBNull.Value) _menuEntityItem.MenuEntityItemId = Convert.ToInt32(reader["MenuEntityItemId"]); if (reader["MenuEntityParentId"] != DBNull.Value) _menuEntityItem.MenuEntityParentId = Convert.ToInt32(reader["MenuEntityParentId"]); if (reader["Name"] != DBNull.Value) _menuEntityItem.Name = Convert.ToString(reader["Name"]); if (reader["PagePath"] != DBNull.Value) _menuEntityItem.PagePath = Convert.ToString(reader["PagePath"]); if (reader["ContentEntityId"] != DBNull.Value) _menuEntityItem.ContentEntityId = Convert.ToInt32(reader["ContentEntityId"]); if (reader["DisplayAlways"] != DBNull.Value) _menuEntityItem.DisplayAlways = Convert.ToBoolean(reader["DisplayAlways"]); if (reader["IsActive"] != DBNull.Value) _menuEntityItem.IsActive = Convert.ToBoolean(reader["IsActive"]); if (reader["IconPath"] != DBNull.Value) _menuEntityItem.IconPath = Convert.ToString(reader["IconPath"]); if (reader["DisplayOrder"] != DBNull.Value) _menuEntityItem.DisplayOrder = Convert.ToInt32(reader["DisplayOrder"]); if (reader["ModifiedDate"] != DBNull.Value) _menuEntityItem.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); if (reader["MenuEntityTypeId"] != DBNull.Value) _menuEntityItem.MenuEntityTypeId = Convert.ToInt32(reader["MenuEntityTypeId"]); if (reader["MenuEntityId"] != DBNull.Value) _menuEntityItem.MenuEntityId = Convert.ToInt32(reader["MenuEntityId"]); if (reader["LanguageID"] != DBNull.Value) _menuEntityItem.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["MenuEntityPositionID"] != DBNull.Value) _menuEntityItem.MenuEntityPositionID = Convert.ToInt32(reader["MenuEntityPositionID"]); _menuEntityItem.NewRecord = false; } reader.Close(); return _menuEntityItem; }
public List<MenuEntityItem> GetAllParents(int MenuEntityId) { MenuEntityItemDAC _menuEntityItemComponent = new MenuEntityItemDAC(); IDataReader reader = _menuEntityItemComponent.GetAllMenuEntityItem("MenuEntityParentId is null AND MenuEntityId = " + MenuEntityId).CreateDataReader(); List<MenuEntityItem> _menuEntityItemList = new List<MenuEntityItem>(); while (reader.Read()) { if (_menuEntityItemList == null) _menuEntityItemList = new List<MenuEntityItem>(); MenuEntityItem _menuEntityItem = new MenuEntityItem(); if (reader["MenuEntityItemId"] != DBNull.Value) _menuEntityItem.MenuEntityItemId = Convert.ToInt32(reader["MenuEntityItemId"]); if (reader["MenuEntityParentId"] != DBNull.Value) _menuEntityItem.MenuEntityParentId = Convert.ToInt32(reader["MenuEntityParentId"]); if (reader["Name"] != DBNull.Value) _menuEntityItem.Name = Convert.ToString(reader["Name"]); if (reader["PagePath"] != DBNull.Value) _menuEntityItem.PagePath = Convert.ToString(reader["PagePath"]); if (reader["ContentEntityId"] != DBNull.Value) _menuEntityItem.ContentEntityId = Convert.ToInt32(reader["ContentEntityId"]); if (reader["DisplayAlways"] != DBNull.Value) _menuEntityItem.DisplayAlways = Convert.ToBoolean(reader["DisplayAlways"]); if (reader["IsActive"] != DBNull.Value) _menuEntityItem.IsActive = Convert.ToBoolean(reader["IsActive"]); if (reader["IconPath"] != DBNull.Value) _menuEntityItem.IconPath = Convert.ToString(reader["IconPath"]); if (reader["DisplayOrder"] != DBNull.Value) _menuEntityItem.DisplayOrder = Convert.ToInt32(reader["DisplayOrder"]); if (reader["ModifiedDate"] != DBNull.Value) _menuEntityItem.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); if (reader["MenuEntityTypeId"] != DBNull.Value) _menuEntityItem.MenuEntityTypeId = Convert.ToInt32(reader["MenuEntityTypeId"]); if (reader["MenuEntityId"] != DBNull.Value) _menuEntityItem.MenuEntityId = Convert.ToInt32(reader["MenuEntityId"]); _menuEntityItem.NewRecord = false; _menuEntityItemList.Add(_menuEntityItem); } reader.Close(); return _menuEntityItemList; }
public List<MenuEntityItem> GetAll() { MenuEntityItemDAC _menuEntityItemComponent = new MenuEntityItemDAC(); IDataReader reader = _menuEntityItemComponent.GetAllMenuEntityItem().CreateDataReader(); List<MenuEntityItem> _menuEntityItemList = new List<MenuEntityItem>(); while(reader.Read()) { if(_menuEntityItemList == null) _menuEntityItemList = new List<MenuEntityItem>(); MenuEntityItem _menuEntityItem = new MenuEntityItem(); if(reader["MenuEntityItemId"] != DBNull.Value) _menuEntityItem.MenuEntityItemId = Convert.ToInt32(reader["MenuEntityItemId"]); if(reader["MenuEntityParentId"] != DBNull.Value) _menuEntityItem.MenuEntityParentId = Convert.ToInt32(reader["MenuEntityParentId"]); if(reader["Name"] != DBNull.Value) _menuEntityItem.Name = Convert.ToString(reader["Name"]); if(reader["PagePath"] != DBNull.Value) _menuEntityItem.PagePath = Convert.ToString(reader["PagePath"]); if (reader["ContentEntityId"] != DBNull.Value) _menuEntityItem.ContentEntityId = Convert.ToInt32(reader["ContentEntityId"]); if(reader["DisplayAlways"] != DBNull.Value) _menuEntityItem.DisplayAlways = Convert.ToBoolean(reader["DisplayAlways"]); if(reader["IsActive"] != DBNull.Value) _menuEntityItem.IsActive = Convert.ToBoolean(reader["IsActive"]); if(reader["IconPath"] != DBNull.Value) _menuEntityItem.IconPath = Convert.ToString(reader["IconPath"]); if(reader["DisplayOrder"] != DBNull.Value) _menuEntityItem.DisplayOrder = Convert.ToInt32(reader["DisplayOrder"]); if(reader["ModifiedDate"] != DBNull.Value) _menuEntityItem.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]); if (reader["MenuEntityTypeId"] != DBNull.Value) { _menuEntityItem.MenuEntityTypeId = Convert.ToInt32(reader["MenuEntityTypeId"]); if (_menuEntityItem.MenuEntityTypeId == (int)MenuEntityTypeEnum.SiteContent) { SitePage page = new SitePageLogic().GetByID(_menuEntityItem.ContentEntityId); if (page != null) { _menuEntityItem.PageName = page.PageName; _menuEntityItem.SiteName = new SiteLogic().GetByID(new SiteSectionLogic().GetByID(page.SectionId).SiteId).Name; } } else if (_menuEntityItem.MenuEntityTypeId == (int)MenuEntityTypeEnum.ExternalLink) { _menuEntityItem.SiteName = new SiteLogic().GetByID(_menuEntityItem.ContentEntityId).Name; } else if (_menuEntityItem.MenuEntityTypeId == (int)MenuEntityTypeEnum.SystemPage) { _menuEntityItem.PageName = new SystemPageLogic().GetByID(_menuEntityItem.ContentEntityId).Name; } } if(reader["MenuEntityId"] != DBNull.Value) _menuEntityItem.MenuEntityId = Convert.ToInt32(reader["MenuEntityId"]); if (reader["LanguageID"] != DBNull.Value) _menuEntityItem.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["MenuEntityPositionID"] != DBNull.Value) _menuEntityItem.MenuEntityPositionID = Convert.ToInt32(reader["MenuEntityPositionID"]); _menuEntityItem.NewRecord = false; _menuEntityItemList.Add(_menuEntityItem); } reader.Close(); return _menuEntityItemList; }