Simple Modifications to Open Source C# Software

I require a few simple modifications to an open source software package. The software is called ClearCanvas. It is written in C# and developed in Visual Studio 2008. Code samples for the type of modifications that I want are available on the ClearCanvas website - see project details for further information. ## Deliverables I require a few simple modifications to an open source software package. The software is called ClearCanvas. It is written in C# and developed in Visual Studio 2008. Code samples for the type of modifications that I want are available on the ClearCanvas website - see details below. Full documentation on the project, including a Developer's Guide is available at [login to view URL] The source code and information on how to compile it can be found at [login to view URL] I Will Provide: (1) A full demo of how the application works. (2) A full explanation of the existing database and the database modifications that will be required. (3) Remote access to a test environment with the software installed and loaded with test data. (4) A Subversion repository with the ClearCanvas source code loaded. This will be used for the modifications. Required Modifications: ======================== (1) Add a submenu to the existing context menu - see screenshot_1.jpg. An example of the menu is shown below. Each item in the menu corresponds to an Excel template (aka worksheet) that the user can attach to the record in the database. The names of the menu items and the Excel spreadsheets that each name links to will be specified in an xml configuration file (see below). When the user selects a worksheet from the list, a copy of the Excel template gets created and opened up in Excel, allowing the user to do their edits. When the user saves the Excel spreadsheet, it gets written to a folder on their computer. The folder that to save in will be specified in the xml config file. The algorithm to use for copying and saving spreadsheets is also provided (see below). Add Worksheet -->Worksheet1 -->Worksheet2 -->Worksheet3 An example of the code to add a context menu can be found at [login to view URL] Click on "I want to ..." --> "Miscellaneous" --> "Add a tool to the study browser" (2) Add a column to one screen - see screenshot_2.jpg. The column will be called “Worksheet??. If the user has attached a worksheet, the row will contain a paper clip icon or something similar to indicate that a worksheet has been attached. If no worksheet has been attached, the row will be blank. A discussion about how to add a custom column to the interface is described at: [login to view URL] (3) Add “Edit Worksheet?? to the context menu. If the row does not have a worksheet attached, Open Worksheet will be grayed out. If the row has a worksheet attached, Open Worksheet will be selectable. Clicking Open Worksheet will open the Excel spreadsheet for editing. Additional Details: =================== * The solution must function with Office 2003 and Office 2007 * The solution must function with both 32 bit and 64 bit versions of Windows Algorithm for Adding a New Worksheet: ===================================== Each entry in the context menu corresponds to an Excel template that a user can "attach" to the row. When the user selects an entry from the context menu, the process has to do the following: (a) Read the xml config file to obtain worksheet_target_directory - see below for an example of the xml config file. (b) Create a directory with today's date in worksheet_target_directory. The directory will be in the format YYYYMMDD. For example, the directory might be c:\target_directory\20100620\ (c) Copy the selected Excel template from template_directory to the directory created in (b). The template_directory will be specified in the xml config file. The process will generate a GUID for the target file name. For example, the full file name might be c:\target_directory\20100620\[login to view URL] (d) Store the YYYYMMDD and GUID portion of the file name in the database so that it can be opened for editing later (part 3 of the project). For example, the name stored in the database might be 20100620\97012341234123411.xls. (e) Open the file in Excel for editing. This must work for Excel 2003 and Excel 2007. Example XML Configuration: ========================== <config_file> <template_directory>c:\excel_templates\</template_directory> <target_directory>c:\worksheet_store\</target_directory> <worksheets> <worksheet> <filename>[login to view URL]</filename> <menu_title>Worksheet1</menu_title> </worksheet> <worksheet> <filename>[login to view URL]</filename> <menu_title>Worksheet2</menu_title> </worksheet> <worksheet> <filename>[login to view URL]</filename> <menu_title>Worksheet3</menu_title> </worksheet> </worksheets> </config_file>