I have a small [url removed, login to view] program that is used to add new users to have rights to our apps.
The way it works is that you have to enter the user into several forms.
U can see a picture of this here: this shows the customers and other tabs needed.
<[url removed, login to view]>
this first screen doesn't do anything but show customers and the cust id.
the next screen enters the user for the customer selected. this works fine and no changes needed. <[url removed, login to view]>
the next one we will leave alone. Customer user/report will give right to a user for the [url removed, login to view] should be manual.
next 3 tabs we want to make automatic as an 'express' option:
[Manage Report Groups] [Manage User Groups] [Assignments]
in Manage report groups for example just update the table with the app name and default group name. <[url removed, login to view]>
the next 2 are similar. that is what is needed make this express option. There are already SQL statement doing the update from the form so you need to take these and apply in this 'batch' express process.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
[url removed, login to view], SQL Query, C#, sql server 2008