been asked to develop a web based student/stock management system.
students are able to buy credits for use of purchases at for example the canteen or books etc.
Used Bulk insert to insert all students from a .CSV file.
for the products i jst used a simple Gridview that is bound to the database.
Now the front page should be like a invoice system
i have 3 droplists on the page
Category, product & Quantity.
when you choose ur category the product drplist is automatically filled with the products for that category etc
now once the person has chosen there category for instance like lets say Crisps and they chose Lays-light & salty and they chose 3 packets.
when they click the add button i want that information to be added to like a quotation page field in the middle of the page.
QUantity Description Price Total
----------------------------------------------------------------------------------------------------------
1 Lays-Light & Salty $5-00 $5-00
1 Coca Cola 500ml $7-00 $7-00
--------------------------------------------------------------------------------------------------------
SUB TOTAL : $12-00
VAT: $1-00
TOTAL : $13-00
something like that......
then once they have chosen whatever they want an ALERT() must come up to ask the person his studentID and password.....when this is done and the transaction is complete the total will be debited from the Student's credit in the db and the amount of each stop deducted from each product in the DB
that i can do, i jst cant add the products to the middle table field effort thing and SUM up the totals....
If anyone can help it wld be appreciated.