/Lanban

Kanban board web application for LAMK

Primary LanguageC#

Lanban

Kanban board web application for Lahti University of Applied Sciences (LAMK)

This web application development is a visual management tool which was developed as OSS and dedicated to LAMK. It can be used to control the flow of teamwork. With the help of this tool, team is able to see who is working for which task, thus enable better visual communication over team’s overall work in a time box. Further the tool would be enabling better visibility to see how the work is progressing over time and illustrating received business value that is created in a project.


Value of the application: LAMK project teams can utilize agile methodology with lean approach. Electronic Kanban board would bring visibility to not only current work and team level but also to individual level: who is doing what and how much “points” have been earned within a sprint. Team leaders or “scrum masters” could see directly how efficiently the team is working and where to find the obstacles or barriers for working. The board also works as basis for every day standup meeting content (Show-and-tell)




Main Feature

1) Working kanban board (default 5 swimlanes). Possible to add custom swimlanes and modifying them.
  1. Graphical charts and tracking data to sprint
  • Illustrate Burndown data chart (Hours remaining)
  • Illustrate tasks done by persons pie chart
  • Illustrate Points earned by persons
  • Illustrate Burn up data chart (Business value cumulated)
  • Illustrate Team estimation factor
  1. Attaching documents and comments to tasks in kanban board
  • Multiple uploading files with various file types
  • Real-time chatting in comments section

  1. Supporting multiple project with multiple user

  2. User's account management (Display name, Profile picture, Password)

Platform and Technology

The project is developed in ASP.NET with C#

Prerequisites - Server side:

  • The server support ASP.NET with .NET framework 4 and later
  • SQL Server or SQL Azure for the database.

Prerequisites - Client side:

  • Client desktop/laptop with internet connection.
  • Browsers: Internet Explorer 10+, Firefox 20+, Chrome 20+

Database instruction

List of tables

  Name Description
1 Users Stores information of the user
2 Project Stores information of the project
3 Swimlane Stores information of swimlane in a project
4 Backlog Stores information of backlog in a project
5 Task Stores information task in a project
6 Project_Supervisor Store supervisor list of project
7 Project_User Store member list of project
8 Backlog_User Store data of a user who is assigned to a backlog
9 Task_User Store data of a user who is assigned to a backlog
10 Task_Comment Store comment of a task
11 Task_File Store attachment’s information of a task

Setup and configuration

  • Check DatabaseSchema.sql file for more details of the schema and script to create new database.
  • Create your custom new account in Users table
  • Setup the connection string by set environment variable `SQLCONNSTR_Lanban`

Preferences

List of used C# libraries:
  1. JSON.Net
  2. SignalR 2.1.1 (Server)

List of used Javascript libraries

  1. JQuery 2.1.1
  2. JQuery UI
  3. SignalR 2.1.2 (Client)
  4. Perfect scrollbar
  5. Chart.JS
  6. JustGage (and Raphael)
  7. JCrop

Author

  • Minh Son Nguyen (minh.son.nguyen.1209@gmail.com)