Skip to content

JasonLWalker/Jlw.LocalizedContent

Repository files navigation

Jlw.LocalizedContent

Pipeline Status

Test Alpha Staging Release
Build and Test Build and Deploy - Alpha Build and Deploy - RC Build and Deploy

Data Repository

Nuget Nuget (with prereleases)

Information / Requirements

Namespace Jlw.Data.LocalizedContent
Target Framework netstandard2.1
Author(s) Jason L. Walker
Copyright Copyright ©2012-2022 Jason L. Walker

Dependencies

Dependency Version License Purpose
Jlw.Utilities.Data 4.6.8318.8346 MIT
Microsoft.Extensions.Options 6.0.0 MIT
Newtonsoft.Json 13.0.1 MIT

Razor Class Library

Nuget Nuget (with prereleases)

Information / Requirements

Namespace Jlw.Web.Rcl.LocalizedContent
Target Framework net6.0
Author(s) Jason L. Walker
Copyright Copyright ©2019-2022 Jason L. Walker

Back-End Dependencies

Dependency Version License Purpose
BuildWebCompiler 1.12.405 ...
BuildBundlerMinifier 3.2.449 ...
Microsoft.Extensions.FileProviders.Embedded 6.0.9 MIT
Jlw.Utilities.WebApiUtility 1.5.7928.8091 MIT

Front-end Dependencies

Dependency Version License Purpose
@jasonlwalker/jlwappbuilder 1.0.24 MIT
@jasonlwalker/jlwutility 1.1.9 MIT
bootbox.js 5.5.3 MIT
bootswatch 5.1.3 MIT
datatables.net 1.12.1 MIT
datatables.net-bs5 1.12.1 MIT
font-awesome 5.15.4 (OFL-1.1 OR MIT OR CC-BY-4.0)
jquery 3.6.0 MIT Framework library used by other libraries for HTML, DOM, Event, and AJAX manipulation
mar10/fancytree@2.38.1
popper.js 2.11.5 MIT
prism 1.28.0 MIT
prism-themes 1.9.0 MIT
Sortable 1.15.0 MIT
swisnl/jQuery-contextMenu@2.9.2
tinymce 5.8.1 LGPL-2.0
toastr.js 2.1.4 MIT
twitter-bootstrap 5.1.3 MIT Responsive UI, layout, and design framework

SQL Schema

Tables:

Server Database Table Purpose
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.DatabaseAuditTrail Used to store an audit trail of records in JSON format
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.LocalizedContentFields
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.LocalizedContentText
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.LocalizedGroupDataItems

Stored Procedures:

Server Database Stored Procedure Purpose
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_AuditTrailSave_LocalizedContentField Used to insert or update an audit trail record for [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_AuditTrailSave_LocalizedContentText Used to insert or update an audit trail record for [LocalizedContentText]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_AuditTrailSave_LocalizedGroupDataItems Used to insert or update an audit trail record for [LocalizedGroupDataItems]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_DeleteLocalizedContentFieldRecord Used to remove matching record from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_DeleteLocalizedContentTextRecord Used to remove the matching record from [LocalizedContentText]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_DeleteLocalizedGroupDataItemRecord Used to remove matching record from [LocalizedGroupDataItems]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_DeleteWizardFieldRecursive Used to recursively remove the matching records from [LocalizedContentFields] and [LocalizedContentText]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetComponentList
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetFormFields
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedContentFieldRecord Used to retrieve the first matching record from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedContentFieldsDt Used to generate a DataTable list of matching records from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedContentTextDt Used to generate a DataTable list of matching records from [LocalizedContentText]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedContentTextRecord Used to retrieve the first matching record from [LocalizedContentText]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedGroupDataItemRecord Used to retrieve the first matching record from [LocalizedGroupDataItems]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedGroupDataItems Used to retrieve the matching records from [LocalizedGroupDataItems]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedGroupDataItemsDt Used to generate a DataTable list of matching records from [LocalizedGroupDataItems]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetLocalizedGroupDataItemValue Used to retrieve the first matching record from [LocalizedGroupDataItems]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetWizardContentFieldRecord Used to retrieve the first matching record from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetWizardFields Used to retrieve a grouped list of wizard fields with localized text
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_GetWizardModelFields Used to retrieve a list of the Model Fields that will be passed by the API during wizard interactions.
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_RenameWizardFieldRecursive Used to recursively rename the matching records from [LocalizedContentFields] and [LocalizedContentText] by changing the [FieldKey] column
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_SaveLocalizedContentFieldData Used to retrieve the first matching record from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_SaveLocalizedContentFieldParentOrder Used to retrieve the first matching record from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_SaveLocalizedContentFieldRecord Used to retrieve the first matching record from [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_SaveLocalizedContentTextRecord Used to retrieve the first matching record from [LocalizedContentText]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.sp_SaveLocalizedGroupDataItemRecord Used to retrieve the first matching record from [LocalizedGroupDataItems]

Views:

Server Database View Purpose
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.vwLocalizedContentField_Audit Used to retrieve the Audit records for the table [LocalizedContentFields]
(localdb)SqlLocalDb-SampleApp LocalizedContent dbo.vwLocalizedContentText_Audit Used to retrieve the Audit records for the table [LocalizedContentText]