INTRODUCTION

This application is a collaborative tool that allows teams to review and analyse patents through an easy to use web interface. It is a Project management tool for Intellectual property team that review patents. The application is designed and built over ASP .NET and MS SQL on backend.

CHALLENGES

1. Import patent data from excel files to Sql server.
2. Attach patent information text file with patents.  
3. Provide dynamic functionality to create any no of Taxonomy category and their subcategory.  
4.  Dynamically assign checkbox for found and accept with every Taxonomy and perform text search in patent data for Taxonomy and check the checkbox if found.  
5. Maintaining User Log.   
6. Text search in patent data and highlighted it if found.

SOLUTIONS

1. To meet this as there may be any no. of records in excel file.  We create a thread that we start when admin click on import button and after every 1 minute we sleep that thread for 15 seconds and again start thread after the sleep time. It will continue until all records are inserted.
2. Dynamically create directory for storing patent content .txt files for every projects read these files and store in database to view in UI and performed text search for taxonomy.
3. For this create two tables one for category and other for subcategory and carete a relationship between them. And provide an interface to admin for create any no. of category and subcategory
4. For this we take a gridview and bind it with category and put other gridview in itemtemplate of the parent gridview. We bound it with subcategory and check the checkbox in rowdatabound of  inner gridview.
5. This is performed by comparing checkbox state while user submits the page.
6. This is performed by using JavaScript.