language requirements-c#,asp.net create an SQL database file in Visual Studio

 An international coffee company has customers from all over the world. They are looking to implement a web site solution to allow their customers to query stock levels and order items from their warehouse. The company have very little web experience in house and therefore would like a solution to allow their in house staff to administer the web site via a windows application, which in turn will feed the live web site with up to date information.

 Functional Requirements of the Content Management Application 

Admin page and login page.

· Only registered staff may add data to the system

· The web site should automatically update based on the data from the main system

· Users are required to login to the website to view stock levels

· Users of the website should be able to select the grind of the coffee.

· Coffee should be sortable by strength and origin.

· The main application should allow a picture to be included with a description of each coffee.

· Data required for the system includes:

·   Coffee Name

· Coffee Strength

· Coffee Grind

· Origin

· Price

· Quantity in stock

· The main application and web site should allow stock levels to change dynamically

· An automatic message should be created for the main application if stock is running below a assumed amount

· Users of the website should be able to leave their email address if stock is low and then receive an email when stock becomes available

Tasks for presentation

The following tasks will be used to assess the functionality of your system.

1. Perform a search on ALL coffee from a particular country

2. Add the following coffee:

Coffee Name - Hot Java

Coffee Strength - 6

Coffee Grind - Beans

Origin - Jamaica

Price -£3.49

Quantity in stock - 5

3. Search for the coffee above demonstrating ALL search options

4. Create the following user (feel free to add any data required by your solution):

Jhon Roy

167 Delves Way

London

ME1 5DX

07382845631

Email: [email protected]

Password: flower

5. Login with the credentials above

6. Search for the coffee entered earlier

7. Buy 10 units of the Hot Java coffee, how does your program deal with this? Demonstrate solution

8. Go back and buy ALL 5 remaining units of Hot Java

9. Demonstrate the change in your C# application

10. Add 20 units to the quantity in stock of Hot Java, show how your system deals with customers who attempted to purchase previously.

· Sample printouts of the low stock warning and email

Evidence of source code control

· Code listing

Additional searches

a. Search for all coffees of strength 3 and above

b. Search for all Full Bean coffees of strength 3 and below

c. Search for all coffees priced at between £3 and £6 per unit

Marking criteria

This is the work we have done so far

Outcomes

· Understand how to create an SQL database file in Visual Studio [ ]

· Know how to add structure and data to the database [ ]

· Understand how to display data in ASP.Net and C# [ ]

Tasks to be completed

1. Create a database for the coffee solution [ ]

2. Create a connection between C# and the database [ ]

3. Create a connection between ASP.NET and the database [ ]

4. Query the database [ ]

a. All Coffee [ ]

b. Coffee which is ground [ ]

c. Coffee from a particular country [ ]

Extension Work

Using what you learnt last semester, connect C# to the database [ ]

Add drop down boxes for search types in ASP [ ]

 Produces a very good piece of work that satisfies the specification and demonstrates above average ability in terms of all round subject knowledge. Application produced should be well designed, well developed and fully meet the specification. Good HCI. Well presented design documentation using techniques learned on the course. Good quality coding.