You have chosen to sponsor your bid up to a maximum amount of .
The project is an ASP.NET MVC 4 project with jQuery. The back-end consists of an SLQ Server 2008 R2. All data access is done through Entity Framework Code First. SQL scripts and C# code are provided.
There are 2 database tables: Categories and LocalizedTexts. The Categories table is a standard table containing business data. The LocalizedTexts table contains translations for some of the fields in the Categories.
E.g. The name of a category can exist in different languages: en, fr and nl. This means that in the Category table you will have a value of e.g. 20 in the column Name_Label_ID. In the LocalizedTexts table you will then have 3 rows with different IDs (the primary key) but the same LabelID, being 20. So one row per language. For the moment there are 3 supported languages. There is a LocalizedTextHelper class that returns these supported languages.
The goal is to build an editor template for this kind of work. This editor template will display for the Name_Label_ID field, not one, but 3 textboxes – one for each supported language. The displayed value will be the label in that language. This already works. The goal is now to be able to input new values so that these new values will be saved to the LocalizedText table with the right IDs.
A similar template should be build to display and update rich text content, based on a standard jQuery rich text editor.
The goal is also to build an extendable solution that can be used by other business tables.