Hansin Prema

200104

Interactive Development 300

The_Inventory

Chemical Manufacturer Stock Inventory
Explore the docs »

Report Bug · Request Feature

Table of Contents

• About the Project
  • Project Description
  • Built With
• Getting Started
  • Prerequisites
  • How to install
• Features and Functionality
• Concept Process
  • Ideation
  • Wireframes
  • User-flow
• Development Process
  • Implementation Process
    • Highlights
    • Challenges
  • Future Implementation
• Roadmap
• Contributing
• License
• Contact
• Acknowledgements

About the Project

Project Description

A chemical inventory for Chem Co. which allows you to pay raw chemicals and make chemical compounds as well as manage the inventory of multiple warehouses.

Built With

• ASP.NET
• mySQL database
• Visual Studio
• GitHub
• Mamp

Getting Started

The following instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

Ensure that you have the latest version of Visual Studio installed on your machine.

How to install

Installation

Here are a couple of ways to clone this repo:

1. Clone Repository
   Run the following in the command-line to clone the project:

   git clone https://github.com/userHP200104/The_Inventory.git

   Open Software and select File | Open... from the menu. Select cloned directory and press Open button.

2. Start your MAMP Server.

3. Export the TheInventory.sql file to your myPHPAdmin.

4. Make sure to change the access_key using SHA2('your_access_key') in the chemical and reaction tables using:

   UPDATE chemicals SET access_key = SHA2('your_access_key');
   UPDATE reaction SET access_key = SHA2('your_access_key');

5. In the Services folder open Database.cs and change the database connection string :

      private static string serverConfiguration = @"server=localhost;port=8889 userid=root;password=root;database=TheInventory";

6. To get the required NuGet packages right-click on the Dependencies Folder and click on Restore.

7. To run the project click on Play Button.

Features and Functionality

Home

From this page the user can see what chemicals are almost out of stock. They can choose to buy more from this page. You can

In the side navigation you can also view which ware house you are in and how many resources are available.

Lab

From this page you can veiw all the chemical you have in stock and in the reaction lab you can react raw chemical to form chemical componunds.

To buy or react you need to have an authorisation code to move forward with the tranaction or reaction.

Warehouse

From this page you can view the stock of all the warehouse. You can also change your location from this page to manage the inventories of the other locations.

Concept Process

Ideation

Wireframes

User-flow

Entity–Relationship Diagram

Development Process

The Development Process is the technical implementations and functionality done in the frontend and backend of the application.

Implementation Process

• Project created and Frontend implemented.
• SQL Database set up and link using MAMP and MyPhpAdmin.
• CRUD added to the chemical stock.

Highlights

• This was a very fun project and challenging project to create since it was my first time coding in C# and ASP.NET.

Challenges

• Making calls to the Database. This took some time to solve but once I got it right it was easy to continue implementing it.

Future Implementation

• Trading chemicals between warehouses.

Roadmap

See the open issues for a list of proposed features (and known issues).

Contributing

Contributions are what makes the open-source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

Authors

• Your Name & Surname - userHP200104(https://github.com/userHP200104)

License

Distributed under the MIT License. See LICENSE for more information.

Contact

• Hansin Prema - hansinprema@gmail.com
• Project Link - https://github.com/userHP200104/The_Inventory

Acknowledgements

• ASP.NET Docs