I need an order form that will be linked to dynamics nav on a network server. It will only be a simple order form where users will be encoding orders.
The current database has been customized by a dynamics nav partner and from the looks of it, it looks really dirty. Many redundancies, etc. thus I need the database to be cleaned up as well. I want it to be a real database - with rules. I already have the relationships, the data entities (model, brand, type) and the .bak file. I just need the data to adapt to the the schema. The .bak file is 7GB because most of it is trash. I think only about 5% of the database is used. I already placed the .bak file in a virtual windows xp which you will be accessing remotely since I can't send it.
User credentials are from the database too. They must have the ability to manually add orders and form objects must be intelligent. For example, only show brands that are available for that model.
Most orders will be coming from texts so I need a feature where orders are copied from the clipboard then when pasted will segrate orders automatically in the data grid for checking. The text message will be in a certain format so the system will know what to do. For example text will start with 'ORDER' and orders are seperated in commas. Users have the ability to add, edit, delete orders multiline or one line at a time from the data grid.
When pressed order, will put the data on the cleanup version database and to the existing database used by NAV. We need the exisiting database because it is being used in the current NAV system. Model can have conversions. For example, TS70 = TS150. Conversion tab and product information sheet will be included in addition to the order tab. I also have the conversions in an excel file. This information is not inside of the .bak file but must be included in the new cleanup database.
I need this project to be finished within 15 hours at maximum so I'm seeking to for a programmer or team highly skilled in .NET, SQL Server, and Dynamics Nav database. Recommendations are also welcome. The main objective of this program is to process text orders easily, manually add orders, conversion table and product information sheet. Don't bid if you feel a slight hesitation on the project.I will pay full once the program works perfectly on the client machine. Questions will be discussed over skype.