public bool Insert(MenuEntityItem menuentityitem)
{
int autonumber = 0;
MenuEntityItemDAC menuentityitemComponent = new MenuEntityItemDAC();
bool endedSuccessfuly = menuentityitemComponent.InsertNewMenuEntityItem(ref autonumber, menuentityitem.MenuEntityParentId, menuentityitem.Name, menuentityitem.PagePath, menuentityitem.ContentEntityId, menuentityitem.DisplayAlways, menuentityitem.IsActive, menuentityitem.IconPath, menuentityitem.DisplayOrder, menuentityitem.ModifiedDate, menuentityitem.MenuEntityTypeId, menuentityitem.MenuEntityId, menuentityitem.LanguageID, menuentityitem.MenuEntityPositionID);
if (endedSuccessfuly)
{
menuentityitem.MenuEntityItemId = autonumber;
}
return(endedSuccessfuly);
}
public MenuEntityItem GetByID(int _menuEntityItemId)
{
MenuEntityItemDAC _menuEntityItemComponent = new MenuEntityItemDAC();
IDataReader reader = _menuEntityItemComponent.GetByIDMenuEntityItem(_menuEntityItemId);
MenuEntityItem _menuEntityItem = null;
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 bool Update(MenuEntityItem menuentityitem, int old_menuEntityItemId)
{
MenuEntityItemDAC menuentityitemComponent = new MenuEntityItemDAC();
return(menuentityitemComponent.UpdateMenuEntityItem(menuentityitem.MenuEntityParentId, menuentityitem.Name, menuentityitem.PagePath, menuentityitem.ContentEntityId, menuentityitem.DisplayAlways, menuentityitem.IsActive, menuentityitem.IconPath, menuentityitem.DisplayOrder, menuentityitem.ModifiedDate, menuentityitem.MenuEntityTypeId, menuentityitem.MenuEntityId, menuentityitem.LanguageID, menuentityitem.MenuEntityPositionID, old_menuEntityItemId));
}
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 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> 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);
}
