e-Bookstore Management

Reviewing management of book buying-selling online with MS SQL Server database and developed on simple C# winform application

Database

Microsoft SQL Server

Version

• Visual Studio 2017
• .NET Framwork 4.6.1 or 4.7.2
• SQL Server Management Studio (SSMS) 2018

Member

1. Trương Công Thành - 1810766
2. Trần Thanh Bình - 1810689
3. Phan Minh Thống - 1811249
4. Đoàn Quang Chính - 1710685

Usage

# Open git bash and typing
clone https://github.com/binhtranmcs/DBAssignment.git

# Open SQL Server Management Studio (SSMS) and Connenct Your Server

# Open Bookstore.sql, INSERT.sql, EProcedure.sql, KHProcedure1.sql, KHProcedure2.sql, testAss2.sql in SSMS above

# Execute all the program in the order above

# Open project in Visual Studio (open WindowsFormsApp1.sln)

# And try our project ^_^ ^_^.

User Authorization

General Feature

• Login
• Update Info

Feature of Customer

• Sign Up
• View Information
• Find/Get Book
• Find/Get Author of Book
• List Transaction

Feature of Employee

• Update Book
• View Book with Function
• Add Book in Bookstore

You can login with registered account at testAss2.sql

• username: e2
• password: 1234