Bovélo is a fictive company that produces and delivers different customizable bikes. This project includes two applications, one for managing client order and the other for production and stock management.
BoveloInternal
allows the manager to control and order parts stock and add new bikes to the current stock. The bike fitter can also use this application to see the production planning, validate an assembled bike when it is ready and reports broken bike parts.
BoveloClient
enables the company to make orders for its client with customizable bikes. It features client management and allows to register new clients to the company database.
For users, you can run the BoveloSetup.exe
file included in the repository to install both applications on your local machine. It runs on Windows 10 32/64 bits systems and requires .NET Framework 4.7.2 Runtime.
The database structure is based on MySql and here is the included Database Diagram.
Further UML diagrams are listed below:
- The Activity Diagram
- The Use Case Diagram
- The Sequence Diagram
- The Class Diagram
- The Supplier Order Sequence Diagram
- The Fitter Sequence Diagram
Download and install .NET Framework 4.7.2 Developer Pack for building and running C# applications.
Download and install MySQL Connector 8.0.23 that provides useful tools for accessing the database in C# applications and add MySql.Data
reference to BoveloLibrary if you have building issues.
You can find the backup file for the database on BoveloDatabase.sql. The schema name is bovelo
, just create it and use the backup in the "Import data" section in MySQL Workbench.
Clone the repository in a local folder on your computer. Then create a new file named Database.cs
in the BoveloLibrary
folder and copy the following lines.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace Bovelo
{
public class Database
{
public string MyConnection = "server=XXX.XXX.XXX.XX;user=3BE-GRP5;database=bovelo;port=XXXXX;password=************";
}
}
You need to change the following values :
- IP_address
- Port
- Username
- Password
- Database_name
Never share your information, it must remain confidential.
Build the solution and select either the BoveloInternal
or BoveloClient
folder as the main project to run the specific application.
Demarcin Louis [18090]
Denis Maximilien [18332]
Martinez Balbuena Sébastien [18360]
Mitrovic Nikola [18365]
Noël Logan [18003]
Penning Chloé [20264]