public List<MenuEntityItemLanguage> GetAll(int ParentID) { MenuEntityItemLanguageDAC _menuEntityItemLanguageComponent = new MenuEntityItemLanguageDAC(); IDataReader reader = _menuEntityItemLanguageComponent.GetAllMenuEntityItemLanguage("ParentId="+ParentID).CreateDataReader(); List<MenuEntityItemLanguage> _menuEntityItemLanguageList = new List<MenuEntityItemLanguage>(); while (reader.Read()) { if (_menuEntityItemLanguageList == null) _menuEntityItemLanguageList = new List<MenuEntityItemLanguage>(); MenuEntityItemLanguage _menuEntityItemLanguage = new MenuEntityItemLanguage(); if (reader["MenuEntityItemId"] != DBNull.Value) _menuEntityItemLanguage.MenuEntityItemId = Convert.ToInt32(reader["MenuEntityItemId"]); if (reader["Name"] != DBNull.Value) _menuEntityItemLanguage.Name = Convert.ToString(reader["Name"]); if (reader["LanguageID"] != DBNull.Value) _menuEntityItemLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["ParentId"] != DBNull.Value) _menuEntityItemLanguage.ParentId = Convert.ToInt32(reader["ParentId"]); _menuEntityItemLanguage.NewRecord = false; _menuEntityItemLanguageList.Add(_menuEntityItemLanguage); } reader.Close(); return _menuEntityItemLanguageList; }
public MenuEntityItemLanguage GetByID(int _menuEntityItemId) { MenuEntityItemLanguageDAC _menuEntityItemLanguageComponent = new MenuEntityItemLanguageDAC(); IDataReader reader = _menuEntityItemLanguageComponent.GetByIDMenuEntityItemLanguage(_menuEntityItemId); MenuEntityItemLanguage _menuEntityItemLanguage = null; while(reader.Read()) { _menuEntityItemLanguage = new MenuEntityItemLanguage(); if(reader["MenuEntityItemId"] != DBNull.Value) _menuEntityItemLanguage.MenuEntityItemId = Convert.ToInt32(reader["MenuEntityItemId"]); if(reader["Name"] != DBNull.Value) _menuEntityItemLanguage.Name = Convert.ToString(reader["Name"]); if(reader["LanguageID"] != DBNull.Value) _menuEntityItemLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if(reader["ParentId"] != DBNull.Value) _menuEntityItemLanguage.ParentId = Convert.ToInt32(reader["ParentId"]); _menuEntityItemLanguage.NewRecord = false; } reader.Close(); return _menuEntityItemLanguage; }
public bool Insert(MenuEntityItemLanguage menuentityitemlanguage) { int autonumber = 0; MenuEntityItemLanguageDAC menuentityitemlanguageComponent = new MenuEntityItemLanguageDAC(); bool endedSuccessfuly = menuentityitemlanguageComponent.InsertNewMenuEntityItemLanguage( ref autonumber, menuentityitemlanguage.Name, menuentityitemlanguage.LanguageID, menuentityitemlanguage.ParentId); if(endedSuccessfuly) { menuentityitemlanguage.MenuEntityItemId = autonumber; } return endedSuccessfuly; }
public bool Update(MenuEntityItemLanguage menuentityitemlanguage ,int old_menuEntityItemId) { MenuEntityItemLanguageDAC menuentityitemlanguageComponent = new MenuEntityItemLanguageDAC(); return menuentityitemlanguageComponent.UpdateMenuEntityItemLanguage( menuentityitemlanguage.Name, menuentityitemlanguage.LanguageID, menuentityitemlanguage.ParentId, old_menuEntityItemId); }
public MenuEntityItemLanguage GetNameItemByLanguageId(int id) { MenuEntityItemLanguage lang = new MenuEntityItemLanguage(); var availableSitePageLanguages = from x in ItemLanguages where x.LanguageID == id select x; foreach (MenuEntityItemLanguage l in availableSitePageLanguages) { lang = l; } return lang; }