/// <summary> /// Action: GetMenuItem /// </summary> public static void GetMenuItem(HeContext heContext, int inParamId, out RCMenuItemRecord outParamRecord) { outParamRecord = new RCMenuItemRecord(null); try { outParamRecord = ENMenuItemEntity.GetRecordById(inParamId); } catch { using (Transaction trans = DatabaseAccess.ForCurrentDatabase.GetRequestTransaction()) { string sql = "SELECT " + " [ID]" + ", [ORDER]" + ", [CAPTION]" + " FROM " + ENMenuItemEntity.LocalViewName(heContext.AppInfo.Tenant.Id, BuiltInFunction.GetCurrentLocale()) + " " + "WHERE [ID] = @inParamId"; Command sqlCmd = trans.CreateCommand(sql); sqlCmd.CreateParameter("@inParamId", DbType.Int32, inParamId); using (IDataReader reader = sqlCmd.ExecuteReader("Entity Action GetMenuItem", true, false, false)) { if (reader.Read()) { outParamRecord.ReadDB(reader); } else { throw new DataBaseException(ENMenuItemEntity.LocalViewName(heContext.AppInfo.Tenant.Id, BuiltInFunction.GetCurrentLocale()) + " with key " + inParamId + " was not found"); } } } } }
protected override string EntityToTablename(string entity, int tenantId) { string entityLC = entity.ToLowerInvariant(); switch (entityLC) { case "recentitem": return(ENRecentItemEntity.LocalViewName(AppInfo.GetAppInfo().Tenant.Id, BuiltInFunction.GetCurrentLocale())); case "messagetype": return(ENMessageTypeEntity.LocalViewName(AppInfo.GetAppInfo().Tenant.Id, BuiltInFunction.GetCurrentLocale())); case "menuitem": return(ENMenuItemEntity.LocalViewName(AppInfo.GetAppInfo().Tenant.Id, BuiltInFunction.GetCurrentLocale())); case "contact": return(ENContactEntity.LocalViewName(AppInfo.GetAppInfo().Tenant.Id, BuiltInFunction.GetCurrentLocale())); case "application": return(ENApplicationEntity.LocalViewName(AppInfo.GetAppInfo().Tenant.Id, BuiltInFunction.GetCurrentLocale())); case "user": return(ENUserEntity.LocalViewName(AppInfo.GetAppInfo().Tenant.Id, BuiltInFunction.GetCurrentLocale())); } throw new DataBaseException("'" + entity + "' found in 'Expand Inline' parameter is an unknown Entity"); }