Library Management System using Entity frame work & windows forms

Technologies: C#, WinForms, EF Core, Dapper, SQL Server

Functional Requirements:

1. User Management

Admin can add, update, delete, and view users (librarians & members).

Each user has a username and password for authentication.

2. Book Management

Add new books with details: Title, Author, ISBN, Category, Quantity, and Published

Year.

Search books by title, author, or category.

Update book details.

Delete books when no copies are left.

3. Member Management

Add new members with details: Name, Email, Phone, Membership Type

(Student/Faculty/Other).

View and update member details.

4. Borrowing & Return System

Members can borrow books with a due date.

Track book availability (decrease stock when borrowed, increase when returned).

Notify users when books are overdue.

5. Reports & Logging

Generate reports for borrowed books, available books, and overdue books.

Log actions like book borrowing, returning, and user actions.