Skip to content

FullStack Approach w/ HTML5, CSS, JavaScript, ASP.NET and SQL.

License

Notifications You must be signed in to change notification settings

Zer0-Bug/LibraryManagementSystem

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Library Management System: Enterprise Web Solution

C# .NET MVC Entity Framework SQL Server Bootstrap AdminLTE

HTML5 CSS3 JavaScript jQuery

License

A comprehensive, full-stack ASP.NET MVC application designed for scalable library management. This project features a dual-panel ecosystem (Admin & Member), real-time transaction tracking, fine calculation logic, and an advanced dashboard powered by AdminLTE.

° ° ° °



Technical Architecture

The system leverages the Model-View-Controller (MVC) architectural pattern to ensure separation of concerns and maintainability. It utilizes a robust n-tier inspired approach:

  1. Presentation Layer: Dynamic web interface built with Razor View Engine, integrated with Bootstrap and AdminLTE 3.0 for a modern, responsive user experience.
  2. Logic Layer (Controllers): 19+ specialized controllers (e.g., KitapController, OduncController) manage complex business logic, from book inventory to lending workflows.
  3. Data Access Layer (Model/Entity): Uses Entity Framework (ORM) for seamless database operations and state management, providing an abstraction over raw SQL queries.
  4. Security Module: Implements custom hashing algorithms and role-based access control (RBAC) to distinguish between regular members and administrative personnel.


Project Structure

LibraryManagementSystem/
├── Database/                                 # SQL Data persistence
│   └── DBKUTUPHANE.bak                       # Full SQL Server Database backup
├── Project Documantation/                    # Scientific documentation
│   └── Project Documantation.pdf             # Comprehensive technical report
│
└── Project/                                  # Source Code (ASP.NET Solution)
    ├── Controllers/                          # Business Logic (C#)
    │   ├── AdminController.cs                # Management portal logic
    │   ├── OduncController.cs                # Borrowing & Transaction logic
    │   └── KitapController.cs                # Inventory management
    ├── Models/Entity/                        # Database Context & ORM Entities
    ├── Views/                                # UI Templates (Razor .cshtml)
    ├── AdminLTE-3.0.4/                       # Dashboard UI Framework
    ├── Web.config                            # Global application configuration
    └── MvcKutuphane.sln                      # Visual Studio Solution file


Core Features

  • Inventory Ecosystem: Complete CRUD cycle for books, authors, and genres with real-time stock status.
  • Borrowing System: Automated tracking of lending dates, return deadlines, and status updates.
  • Analytics Dashboard: Visual summary of library performance, including most borrowed books and active users.
  • User Roles: Distinct portal experiences for Librarians (Full access) and Members (Search & Read-only profiling).
  • Messaging System: Intra-system communication between management and members.


Technical Specifications

Component Technology Stack
Framework ASP.NET MVC 5.x
Language C# 7.0+
Frontend HTML5, CSS3, JavaScript, jQuery, AJAX
Styling Bootstrap 4 / AdminLTE 3.0.4
ORM Entity Framework 6
Database Microsoft SQL Server 2019+


Deployment & Installation

1. Environment Requirements

  • Visual Studio 2019 (or later) with the ASP.NET and web development workload.
  • SQL Server Management Studio (SSMS).
  • .NET Framework 4.7.2 (or compatible).

2. Repository Acquisition & Initialization

git clone https://github.com/Zer0-Bug/LibraryManagementSystem.git
cd LibraryManagementSystem

3. Database Restoration

  1. Open SSMS and connect to your local server.
  2. Right-click Databases > Restore Database.
  3. Select Device and navigate to Database/DBKUTUPHANE.bak.
  4. Restore the database with the name DBKUTUPHANE.

4. Application Configuration

Open Project/Web.config and locate the <connectionStrings> section. Update the connectionString attribute with your local SQL Server credentials:

<add name="DBKUTUPHANEEntities" connectionString="data source=YOUR_SERVER_NAME;initial catalog=DBKUTUPHANE;integrated security=True;..." />

5. Launching the System

  1. Open Project/MvcKutuphane.sln in Visual Studio.
  2. Right-click the project MvcKutuphane and select Restore NuGet Packages.
  3. Press F5 to build and launch the application in your default browser.


Usage Guide

  • Administrator Portal: Accessible via /Login/Index. Use the admin credentials to manage the library catalog, monitor personnel, and view system-wide analytics.
  • Member Portal: Members can log in to search the catalog, view their current borrowing status, and check for outstanding fines.
  • Public Showcase: The main landing page (Vitrin) provides a public view of available library assets without requiring authentication.


Contribution

Contributions are always appreciated. Open-source projects grow through collaboration, and any improvement—whether a bug fix, new feature, documentation update, or suggestion—is valuable.

To contribute, please follow the steps below:

  1. Fork the repository.
  2. Create a new branch for your change:
    git checkout -b feature/your-feature-name
  3. Commit your changes with a clear and descriptive message:
    git commit -m "Add: brief description of the change"
  4. Push your branch to your fork:
    git push origin feature/your-feature-name
  5. Open a Pull Request describing the changes made.

All contributions are reviewed before being merged. Please ensure that your changes follow the existing code style and include relevant documentation or tests where applicable.

Email × LinkedIn