Dir

WinForms Application

Final version (Uncompleted)

• This application requires local database to be loaded, as well as triggers, procedures,...
• This application is not completed yet, but has no plans to be develop in the future. Well, we stepped on ours deadline.
• Open source for education purpose.

Login

Sign Up

As A Customer

Sign Up To Be A Shipper

Sign Up To Be A Partner

Profile (As A Customer)

Products Manage

Orders Manage

Customer Manage

Staff Manage

Shipper Manage

Partner Manage

Concurrency Demo

Dirty Read

Problem

• Staff updates price for all products of a department, a customer request to read all product of this department at the same time, too.
• Well, after the customer read data, a issue occured that staff's transaction has to be rolled back.

Handled

• Customer has to wait until the staff's transaction is commited or rolled back. (??? :D How silly)

Unreapeatable Read

Problem

• Shipper want to search specified products quantity of an order
• But the customer makes change of quantity at the same time.

Handled

• Customer has to waits until shipper's transaction is finished.
• 

Phantom Read

Problem

• Customer search all products have price bigger than given value.
• Staff added a new product has price in range which to be searched by customer.
• Staff's transaction is rolled back.

Handled

• Staff has to wait for customer.