public void ProcessRequest(HttpContext context) { try { PortalController.Instance.GetCurrentPortalSettings(); if ((context.Request.QueryString["tabid"] == null || context.Request.QueryString["mid"] == null) || !(context.Request.IsAuthenticated)) { return; } // get TabId var tabId = Convert.ToInt32(-1); if (context.Request.QueryString["tabid"] != null) { tabId = int.Parse(context.Request.QueryString["tabid"]); } // get ModuleId var moduleId = Convert.ToInt32(-1); if (context.Request.QueryString["mid"] != null) { moduleId = int.Parse(context.Request.QueryString["mid"]); } var userInfo = UserController.Instance.GetCurrentUserInfo(); var mc = new ModuleController(); var moduleInfo = new ModuleController().GetModule(moduleId, tabId); var settings = moduleInfo.ModuleSettings; if (ModulePermissionController.CanManageModule(moduleInfo)) { var udt = new UserDefinedTableController(moduleId, tabId, userInfo); var ds = udt.GetDataSet(true); ds.Tables.Add(udt.Context(moduleInfo, userInfo, context.Request[Definition.QueryStringParameter].AsString(), settings[SettingName.SortField].AsString(), settings[SettingName.SortOrder].AsString(), settings[SettingName.Paging].AsString())); context.Response.ContentType = "Text/Xml"; ds.WriteXml(context.Response.OutputStream); } } catch (Exception) { context.Response.Write("Not defined"); } }
public void ProcessRequest(HttpContext context) { try { PortalController.GetCurrentPortalSettings(); if ((context.Request.QueryString["tabid"] == null || context.Request.QueryString["mid"] == null) || !(context.Request.IsAuthenticated)) { return; } // get TabId var tabId = Convert.ToInt32(-1); if (context.Request.QueryString["tabid"] != null) { tabId = int.Parse(context.Request.QueryString["tabid"]); } // get ModuleId var moduleId = Convert.ToInt32(-1); if (context.Request.QueryString["mid"] != null) { moduleId = int.Parse(context.Request.QueryString["mid"]); } var userInfo = UserController.GetCurrentUserInfo(); var mc = new ModuleController(); var settings = mc.GetModuleSettings(moduleId); var moduleInfo = new ModuleController().GetModule(moduleId, tabId); if (ModulePermissionController.CanManageModule(moduleInfo)) { var udt = new UserDefinedTableController(moduleId, tabId, userInfo); var ds = udt.GetDataSet(true); ds.Tables.Add(udt.Context(moduleInfo, userInfo, context.Request[Definition.QueryStringParameter].AsString(), settings[SettingName.SortField].AsString(), settings[SettingName.SortOrder].AsString(), settings[SettingName.Paging].AsString())); context.Response.ContentType = "Text/Xml"; ds.WriteXml(context.Response.OutputStream); } } catch (Exception) { context.Response.Write("Not defined"); } }
public DataSet ExportModuleDataSet(int moduleId, int tabId) { DataSet ds; if (tabId == Null.NullInteger) { var udtController = new UserDefinedTableController(moduleId); ds = udtController.GetDataSet(false); ds.Tables.Add(GetSettingsTable(moduleId, SettingsType.ModuleSettings)); } else { var moduleInfo = new ModuleController().GetModule(moduleId, tabId); var udtController = new UserDefinedTableController(moduleInfo); ds = udtController.GetDataSet(false); ds.Tables.Add(GetSettingsTable(moduleId, SettingsType.ModuleSettings)); ds.Tables.Add(GetSettingsTable(moduleInfo.TabModuleID, SettingsType.TabModuleSettings)); ds.Tables.Add(GetStylesheetTable(udtController.Settings, moduleInfo.PortalID)); } return(ds); }
/// ----------------------------------------------------------------------------- /// <summary> /// Implements the search interface for DotNetNuke /// </summary> /// ----------------------------------------------------------------------------- public SearchItemInfoCollection GetSearchItems(ModuleInfo modInfo) { var searchItemCollection = new SearchItemInfoCollection(); var udtController = new UserDefinedTableController(modInfo); try { var dsUserDefinedRows = udtController.GetDataSet(withPreRenderedValues: false); //Get names of ChangedBy and ChangedAt columns var colnameChangedBy = udtController.ColumnNameByDataType(dsUserDefinedRows, DataTypeNames.UDT_DataType_ChangedBy); var colnameChangedAt = udtController.ColumnNameByDataType(dsUserDefinedRows, DataTypeNames.UDT_DataType_ChangedAt); var moduleController = new ModuleController(); var settings = moduleController.GetModuleSettings(modInfo.ModuleID); var includeInSearch = !(settings[SettingName.ExcludeFromSearch].AsBoolean()); if (includeInSearch) { foreach (DataRow row in dsUserDefinedRows.Tables[DataSetTableName.Data].Rows) { var changedDate = DateTime.Today; var changedByUserId = 0; if (colnameChangedAt != string.Empty && !Information.IsDBNull(row[colnameChangedAt])) { changedDate = Convert.ToDateTime(row[colnameChangedAt]); } if (colnameChangedBy != string.Empty && !Information.IsDBNull(row[colnameChangedBy])) { changedByUserId = ModuleSecurity.UserId(row[colnameChangedBy].ToString(), modInfo.PortalID); } var desc = string.Empty; foreach (DataRow col in dsUserDefinedRows.Tables[DataSetTableName.Fields].Rows) { var fieldType = col[FieldsTableColumn.Type].ToString(); var fieldTitle = col[FieldsTableColumn.Title].ToString(); var visible = Convert.ToBoolean(col[FieldsTableColumn.Visible]); if (visible && (fieldType.StartsWith("Text") || fieldType == DataTypeNames.UDT_DataType_String)) { desc += string.Format("{0} • ", Convert.ToString(row[fieldTitle])); } } if (desc.EndsWith("<br/>")) { desc = desc.Substring(0, Convert.ToInt32(desc.Length - 5)); } var searchItem = new SearchItemInfo(modInfo.ModuleTitle, desc, changedByUserId, changedDate, modInfo.ModuleID, row[DataTableColumn.RowId].ToString(), desc); searchItemCollection.Add(searchItem); } } } catch (Exception ex) { Exceptions.LogException(ex); } return(searchItemCollection); }
private void LoadFnL() { EnsureConfigurationIsLoaded(); // Preferred way in Form and List var udt = new UserDefinedTableController(); var ds = udt.GetDataSet(ModuleId); DtDs = DataSource.GetDataSource<DataTableDataSource>(valueCollectionProvider: ConfigurationProvider); DtDs.Source = ds.Tables["Data"]; DtDs.EntityIdField = "UserDefinedRowId"; // default column created by UDT DtDs.ContentType = ContentType; // clean up column names if possible, remove spaces in the column-names for (var i = 0; i < DtDs.Source.Columns.Count; i++) DtDs.Source.Columns[i].ColumnName = DtDs.Source.Columns[i].ColumnName .Replace(" ", ""); // Set the title-field - either the configured one, or if missing, just the first column we find if (string.IsNullOrWhiteSpace(TitleField)) TitleField = DtDs.Source.Columns[1].ColumnName; DtDs.TitleField = TitleField; }
public DataSet ExportModuleDataSet(int moduleId, int tabId) { DataSet ds; if (tabId == Null.NullInteger) { var udtController = new UserDefinedTableController(moduleId); ds = udtController.GetDataSet(false); ds.Tables.Add(GetSettingsTable(moduleId, SettingsType.ModuleSettings)); } else { var moduleInfo = new ModuleController().GetModule(moduleId, tabId); var udtController = new UserDefinedTableController(moduleInfo); ds = udtController.GetDataSet(false); ds.Tables.Add(GetSettingsTable(moduleId, SettingsType.ModuleSettings)); ds.Tables.Add(GetSettingsTable(moduleInfo.TabModuleID, SettingsType.TabModuleSettings)); ds.Tables.Add(GetStylesheetTable(udtController.Settings, moduleInfo.PortalID)); } return (ds); }
/// ----------------------------------------------------------------------------- /// <summary> /// Implements the search interface for DotNetNuke /// </summary> /// ----------------------------------------------------------------------------- public SearchItemInfoCollection GetSearchItems(ModuleInfo modInfo) { var searchItemCollection = new SearchItemInfoCollection(); var udtController = new UserDefinedTableController(modInfo); try { var dsUserDefinedRows = udtController.GetDataSet(withPreRenderedValues: false); //Get names of ChangedBy and ChangedAt columns var colnameChangedBy = udtController.ColumnNameByDataType(dsUserDefinedRows, DataTypeNames.UDT_DataType_ChangedBy); var colnameChangedAt = udtController.ColumnNameByDataType(dsUserDefinedRows, DataTypeNames.UDT_DataType_ChangedAt); var moduleController = new ModuleController(); var settings = moduleController.GetModuleSettings(modInfo.ModuleID); var includeInSearch = !(settings[SettingName.ExcludeFromSearch].AsBoolean()); if (includeInSearch) { foreach (DataRow row in dsUserDefinedRows.Tables[DataSetTableName.Data].Rows) { var changedDate = DateTime.Today; var changedByUserId = 0; if (colnameChangedAt != string.Empty && ! Information.IsDBNull(row[colnameChangedAt])) { changedDate = Convert.ToDateTime(row[colnameChangedAt]); } if (colnameChangedBy != string.Empty && ! Information.IsDBNull(row[colnameChangedBy])) { changedByUserId = ModuleSecurity.UserId(row[colnameChangedBy].ToString(), modInfo.PortalID); } var desc = string.Empty; foreach (DataRow col in dsUserDefinedRows.Tables[DataSetTableName.Fields].Rows) { var fieldType = col[FieldsTableColumn.Type].ToString(); var fieldTitle = col[FieldsTableColumn.Title].ToString(); var visible = Convert.ToBoolean(col[FieldsTableColumn.Visible]); if (visible && (fieldType.StartsWith("Text") || fieldType == DataTypeNames.UDT_DataType_String)) { desc += string.Format("{0} • ", Convert.ToString(row[fieldTitle])); } } if (desc.EndsWith("<br/>")) { desc = desc.Substring(0, Convert.ToInt32(desc.Length - 5)); } var searchItem = new SearchItemInfo(modInfo.ModuleTitle, desc, changedByUserId, changedDate, modInfo.ModuleID, row[DataTableColumn.RowId].ToString(), desc); searchItemCollection.Add(searchItem); } } } catch (Exception ex) { Exceptions.LogException(ex); } return searchItemCollection; }