🏢 Jobless & Found

🚀 Project Overview

Jobless & Found is a web application project developed for the Epitech Nancy Web course. The project aims to create an online job board website similar to platforms like Welcome to the Jungle or LinkedIn. It leverages C# for the backend and React with TypeScript for the frontend, integrating a MySQL database to store all job-related data.

📋 Table of Contents

• 🛠 Technologies Used
• 🌟 Project Features
• 🗃 Database Design
• 🌐 Application Pages and Functionality
• 🔒 API and Authentication
• 📝 Step-by-Step Guide
• ✨ Bonus Features

🛠 Technologies Used

• Backend: C# with Entity Framework and MySQL
• Frontend: React (TypeScript)
• Database Management: MySQL (Workbench)
• API Documentation: Swagger + RESTful API
• Authentication: Email, Password (hashed), Session Cookies, Websockets

🌟 Project Features

1. Job Advertisements: Create, view, and manage job advertisements.
2. User Management: Handle users (applicants and companies) and their details.
3. Application Management: Track job applications, send emails, and record interactions.
4. Admin Panel: A dedicated admin page to perform CRUD operations on all tables.
5. Authentication: Secure user login and session management.

🗃 Database Design

The project uses MySQL to store information with the following tables:

• Several Table types that globally encapsulate the following:
  1. Companies Tables: Stores company information such as name, location, and size.
  2. User Tables: Stores user data, including applicants and HR personnel.
  3. Job Application Tables: Tracks emails, messages, and applications.

🌐 Application Pages and Functionality

• Home Page: Displays a scrollable feed of job postings (LinkedIn-like view).
• Job Details Page: Shows detailed job information when clicking "Learn More".
• Application Form: Opens a form to enter user info (name, email, phone) and send messages to the ad owner.
• Admin Panel: Lists all database records with options to create, update, or delete entries.

🔒 API and Authentication

The API provides CRUD operations for managing the database and supports secure access using:

• RESTful Routes: For fetching and managing job ads and user data.
• Authentication: User login and registration with hashed passwords and session cookies (Jwt keys).
• Authorization: Only admin users can access the admin panel.

📝 Step-by-Step Guide

1. Step 01: Create the SQL database with tables for advertisements, companies, people, and job applications.

2. Step 02: Develop a basic HTML/CSS page to display job advertisements with "Learn More" buttons.

3. Step 03: Implement "Learn More" button functionality to show job details dynamically.

4. Step 04: Create a REST API with CRUD operations to interact with the database.

5. Step 05: Add an "Apply" button for each ad that opens a form to enter user details and send messages.

6. Step 06: Integrate an authentication mechanism for secure login and session handling.

7. Step 07: Build an admin page for monitoring and managing the database with pagination support.

8. Step 08: Polish the front-end pages, refine styles, and enhance the UI/UX.

9. 📊 Job Market Insights:

   • Offer job market insights like average salaries, demand for roles, and career growth statistics.

   • Display this data visually in a separate section or integrate it into job posts.

     We hope you find Jobless & Found a helpful project for job seekers and recruiters alike! Feel free to contribute or suggest new features. 😊