This won't take more than 2hours.
This program stores information on upcoming projects in a collection of tabs each containing a SourceGrid component.
Changes to the grid result in the tag of the cell being changed.
each cells tag contains information on the answers position in the grid, i.e. the country that the cell relates to, the row's key, the question that the answer in that cell corresponds to etc.
Upon clicking the save button, the required information is put into a comma delimited string for each cell and sent to a stored procedure to save the data.
The problem is that some cells (seemingly randomly) are not getting saved.
Another problem is that the rows are being saved in order of the rows key being entered onto the grid instead of the actual rows position in the grid (reason for this is that on a row key being entered, an array list containing new rows to add is appended to - in the order that the user enters the keys)
I need both of these problems resolved in my application. BEWARE the code is not easy to follow and not commented in a very readable way. A knowlege of stored procedures (PL/SQL), C# , general SQL and Object Orientated Programming knowlege is REQUIRED for this project.
Please do not bid if you do not have experience in these areas and are confident of being able to solve the problem.
The sourcecode for the Grid is included (this is a class that inherits the properties of a standard SourceGrid and adds functions to it for saving of data, formatting etc.)
Be aware that this file is only a small portion of the overall application. I will send full sources on acceptance of a bid.
All grid formats work except the QMA (Question Multi Answer) grid where a key is required and subsequent answers rely on this key, but the code to save the grids is generic so should still work for all other grids when any fixes are applied.
Please note, I think i now might have an idea why the seemingly random cells get saved, I think it is in the save_template_cells stored procedure. The table structure used to allow duplicates and the grid was just picking up the original values.I have now changed this and made a constraint that all values are unique however I think the stored procedure needs to be modified to do a correct update or insert based on this.
The code is a mess, sorry about this!
This is urgent so bids will most likely be accepted soon after posting.
Thanks for looking!