Hello everybody,
I'm creating a C# module and I really need an advice.
In my module I have a table called MyModule_Category. The items of this table will fill a dropdownlist. Columns of MyModule_Category table are ItemId, ModuleId and Category. Users which have edit permissions for the module can add or remove the categories. But I also need to insert some categories in the table when the module is added to the page. These categories are fixed (but must be localized). dawoa in a recent post has suggest me how to do to call a method only one time, when the module is added to the page. So I've thought to do in this way:
I create a string array which contains my fixed categories and another array which will contain the corresponding localized categories. I add the categories to the resource files. When the module is added to the page I use a foreach statement to cycle the categories in the array, and for each category I call the method Localization.GetString to obtain the corresponding localized category. Then I add the localized string to the array. Then I pass the array and the moduleId to a stored procedure which insert the categories into the table.
My question is: is this way a good way? Or there is a better way?
And also: is it possible to pass an array to a stored procedure?
Please reply!