History

Commits on b5314923b6094deaf7daeaeb32b9bf89babd37d7 to Source/Libraries/GSF.Core/Data/Model/TableOperations.cs24

GSF.Core: Updated SearchableAttribute to accept a SearchType enumeration instead of a boolean for clarity in definition.J. Ritchie Carroll committed 10 years ago8040184
GSF.Core: Added "SearchableAttribute" for modeled table fields to allow which fields in the model should be searched. Added two overloads for QueryRecordCount and QueryRecords that now accept a multi-keyword search string that will be applied to all search fields.J. Ritchie Carroll committed 10 years ago398edd4
GSF.Data.Model: Corrected FieldHasAttribute function in table operations to validate attributes based on sub-classing.Billy Ernest committed 10 years ago691e081
GSF.Data.Model: Fixed issues with resolving unescaped table and field names.Ritchie Carroll committed 10 years ago6dead23
GSF.Data.Model: (1) Added ability to query unescaped fields from models in table operations; usesful in DataContext where field names were being used in rendered Javascript code, (2) Added "DataRow" operations to common table operations for handy interop when a model is defined and user has access to a queried DataRow, (3) Added overloads to field attribute functions in table operations to allow for situations when only a Type is available.Ritchie Carroll committed 10 years agob0c552e
GSF.Data.Model: Updated table operations to row based convert field extension for LoadRecord.Ritchie Carroll committed 10 years agoe50f39e
GSF.Data: Added ConvertField functions to AdoDataConnection that will properly handle Guid based fields in data rows based on database connection type. GSF.Data.Model: Updated TableOperations to use ConvertField function in AdoDataConnection when loading a record.J. Ritchie Carroll committed 10 years ago1c6899f
GSF.Data.Model: Fixed TableOperation interface implementation of GetFieldValue to return proper data.Ritchie Carroll committed 10 years ago42840c5
GSF.Data.Model: Added interface for TableOperations so that any modeled table operation can be accessed generically. GSF.Web: Updated data context to handle Type based parameters as well as generic functions, added paged view model data and hub types to RazorWeb rendering view bag configuration and ability to define types per page in WebServer implementations.Ritchie Carroll committed 10 years ago49562ca
GSF.Data.Model: Updated TableOperations commentsJ. Ritchie Carroll committed 10 years ago46e24a0
GSF.Web.Model: Added enableHotLinks flag to text input based rendering functions (defaults to true) that will handle automatic rendering of clickable URLs and e-mail addresses when AddNewEditDialog is shown in view mode. GSF.Web.Scripts: Updated and added other common scripts as embedded resources. GSF.Data.Model: Changed exception handler property of TableOperations to be read/write such that it could be changed as needed at runtime.Ritchie Carroll committed 10 years ago2483551
GSF.Data.Model: Improved exception messages for TableOperations to always properly include actual SQL statement that executed as well as any parameters.J. Ritchie Carroll committed 10 years ago7ba81ba
GSF.Data.Model: Added "UseCaseSensitiveFieldNames" property to TableOperations so that when databases are configured to use case-sensitive field names - the application of escaped field name targets can take this into account.J. Ritchie Carroll committed 10 years ago580c536
GSF.Data.Model: Updated comments.J. Ritchie Carroll committed 10 years ago21b95b6
GSF.Data.Model: Updated TableOperations to properly apply modeled escaped field names to RecordRestrictions and optimized application of field based escaped name targetsJ. Ritchie Carroll committed 10 years ago1200be2
GSF.Data.Model: Added "UseEscapedNameAttribute" to allow for database specific and ANSI standard targeted field and table identifier escaping - useful for cases where identifiers may be reserved words.Ritchie Carroll committed 10 years ago7587add
GSF.Data.Model: Added ability ot specify a custom table name for modeled table classes.Ritchie Carroll committed 10 years ago63da952
GSF.Data.Model: Added record limit parameter to basic QueryRecord operationRitchie Carroll committed 10 years ago513b930
GSF.Data.Model: Fixed error message format in TableOperations for QueryRecord overloads.J. Ritchie Carroll committed 10 years agodc875ec
(1) GSF.Data.Model: Added default sort field option for page based query in TableOperations when null is provided. (2) GSF.Web.Model: Added IDLabel option for serialized JSON drop-downs (3) GSF.Web.Security: Converted SearchUserAccounts security hub function to use IDLabel to include user account ID as part of return record during search operationsRitchie Carroll committed 10 years ago72f5a2f
GSF.Data.Model: Fixed issue in table operations when using a multifield primary key lookup.Ritchie Carroll committed 10 years ago720aa2f
GSF.Data.Model: Fixed null reference exception in GetFieldName method.Ritchie Carroll committed 10 years ago1c3fb42
GSF.Data.Model: Sealed attribute classes and changed readonly fields to get-only auto-properties.Ritchie Carroll committed 10 years ago5c8fc39
GSF.Data.Model: Added modeled table operations and related attributes and functions GSF.Collections: Added PagedList functionality for enumerationsJ. Ritchie Carroll committed 10 years ago2197be6