Multiple Asset Manager

Create a Visual Basic 2005 .NET application. The solution will work with two tables having a Master/Detail relationship. The first table contains asset category records, and the second table contains asset detail records for each category (File Provided). A screen shot of the desired layout is also provided.

## Deliverables

**Table Specifications**

**Table 1 -- Schema for the tblCategories table**

| **Column Name** | **Data Type** |

| fldCategoryID | Integer |

| fldCategoryDesc | String |

**Table 2 -- Schema for table named tblAssets**

| **Column Name** | **Data Type** |

| fldAssetID | Integer |

| fldCategoryID | Integer |

| fldAssetName | String |

| fldDescription | String |

| fldDateAcquired | Date |

| fldCost | Single |

Use the following database schema, which has two tables. Database is provided for the application.

· The input form contains a ListBox and a DataGrid control. Select asset categories in the list box and then the corresponding asset information will appear in the DataGrid. As you select different categories, the total costs are recalculated for the selected category and displayed in a label on your form, formatted as currency.

· Configure the form so it appears on the center of the desktop when the solution is run.

· Do not allow the user to resize the form.

· Remove minimize, maximize, and close buttons from the title bar.

· Perform the appropriate steps to create a connection to the sample database. Be sure to select the option to copy the database to your project so it will be automatically be included in the project.

· Create an instance of the ListBox control. Set the necessary properties so the ListBox control will display the field fldCategoryDesc.

· Create an instance of the DataGrid control on the form. Configure the DataGrid control instance so it displays records from the table named tblAssets, but only for those records matching the selected category shown in the list box.

· Format the DataGrid so the column header names are the same as the ones shown in the Figure. Set appropriate column widths, and format the cost column as currency, right justified. The date column should also be right justified.

· Write the necessary code to calculate the total cost of the displayed assets. Display the results in a Label control above the cost column of the DataGrid. Format the output as currency. Right-justify the output in the Label control instance.

· Create an Update button that will allow the user to save any changes made to the DataGrid back to the database. Write the necessary code for the button. Allow the user to add, change, and delete records in the Asset table.

· Create an Exit button for the solution. In the Click event handler for the button, display a message box to get confirmation from the user before exiting the solution.

· Add a basic help system to your application.

****Notes***

· Name your project and set the title of your form (the Text property of the main form) to “ITP400_IP3??.

· Be sure to include good comments in your code.

· Name your objects, variables, functions, and others with appropriate and consistent names.

· Keep the code as simple as possible nothing fancy

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

OS Windows XP and built in visual studio 2005

.NET Engenharia Microsoft MySQL PHP Arquitetura de software Teste de Software Visual Basic Área de trabalho do Windows

ID do Projeto: #3673482

Sobre o projeto