Skip to content

Full-stack web application for managing telecom services, with features for administrators and customers, demonstrating expertise in web development, database design, and problem-solving.

Notifications You must be signed in to change notification settings

lamaabdeldayem/TelecommCompanyDBProj

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📱 Telecom Company Web Application 🌐

🌟 Project Overview

Welcome to the Telecom Company Web Application! 🚀 This full-stack web app is designed to manage telecom services, showcasing my skills in web development, database design, and problem-solving. The app connects to a structured SQL database and provides essential features for both administrators and customers.

The application is built to simulate real-world telecom scenarios, including account management, service subscriptions, transaction processing, and detailed reporting. It demonstrates how to create a robust and scalable system to handle complex business operations.


🚀 Features

Admin Features 🔧

  • Authentication: Secure login for administrators with credentials. 🔐
  • Customer Management: View customer profiles, active accounts, and service plans. 👤
  • Reports: Generate detailed reports on:
    • Resolved customer support tickets 🎫
    • Service usage and subscriptions 📊
    • SMS offers and promotions 💬
  • Database Operations: Add, edit, or remove customer benefits and service subscriptions. 💼

Customer Features 🌟

  • User Authentication: Secure login using a mobile number and password. 🔑
  • Service Overview: View active and available service plans. 📱
  • Usage Tracking: Monitor SMS, call minutes, and internet consumption. 📶
  • Transactions: Manage wallet transactions, cashback, and voucher redemptions. 💳

Core Highlights 🔥

  • Dynamic Navigation: Smooth transitions between functionalities with no URL changes. 🔄
  • Error Handling: Get informative feedback on successful and failed operations. ⚠️
  • Scalability: Modular design to easily add new features in the future. 📈

💡 Skills Demonstrated

  • Frontend Development: Created an intuitive user interface using HTML, CSS, and JavaScript (or your preferred framework). 🎨
  • Backend Development: Developed a robust backend using ASP.NET (or your chosen framework). ⚙️
  • Database Management: Designed an optimized SQL Server database with efficient queries. 🗃️
  • Problem Solving: Tackled complex requirements like multi-user functionality and seamless data integration. 🧠
  • Collaboration: Worked in a team environment to merge components and ensure smooth integration. 🤝

⚙️ Technologies Used

  • Frontend: HTML, CSS, JavaScript (add any frameworks like React, Bootstrap, etc.). 🌍
  • Backend: ASP.NET (or your chosen backend framework). 💻
  • Database: SQL Server (mention tools like SSMS if applicable). 🗄️
  • Version Control: Git & GitHub for version control and collaboration. 🔄

🚀 How to Run the Project

  1. Clone the repository:

    git clone <repository-url>
  2. Set up the database:

    • Use the included SQL script to create the database schema and populate it with data. 📊
  3. Run the backend server:

    • In Visual Studio, open the .sln file from the project folder.
    • Ensure SQL Server is installed and running. 🖥️
    • Execute the SQL script to set up the database schema and seed data. 🗃️
    • Update the connectionStrings in appsettings.json to match your database configuration. 🔧
    • Press Ctrl + F5 or click the "Start Without Debugging" button to run the server.
    • The web application will open in your browser at the configured URL (e.g., https://localhost:5001). 🌐
  4. Access the application:

    • Open the displayed URL in your browser to start using the app. 🌍

🎉 Ready to Manage Telecom Services? 🎉

Dive into the world of telecom management with this app! Explore features for admins and customers, and experience smooth navigation, error handling, and scalability. Happy coding! 😎


About

Full-stack web application for managing telecom services, with features for administrators and customers, demonstrating expertise in web development, database design, and problem-solving.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published