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