TTTM Case Study
Description
Customer: Tan Thanh Tole (Website) is one of the top ten companies in Vietnam specializing in manufacturing and providing construction steel. The company has a headquarters and five branches in southern Vietnam.
TTTM (Tan Thanh Tole Manager) is a typical ERP software that manages all business activities for Tan Thanh Company. It includes the following features:
- Human Resource Management: Manages employee information, salary/bonus calculations, and personal history data.
- Financial and Management Accounting: Generates reports on financial status, revenue, profit, and financial plans.
- Sales Management: Manages orders, billing, and daily reporting.
- CRM: Manages customer relationships and order statuses.
- Inventory Management: Manages devices, equipment, and materials in both manufacturing and office locations.
- Price Management: Tracks and updates goods' prices, allowing for backtracking of past quotes.
Challenges and Solutions
Challenges:
- How to synchronize data between the headquarters and branches with quick response times to user interactions?
- How to track the price list as it is updated daily?
Solutions:
- A local database was built for each site, and a background thread synchronized changes between all local databases. Users' actions were updated in the local database to ensure smooth operations.
- Price changes were tracked with a timestamp for each item, allowing queries for item prices at any time in the past. A temporary table was created for the current price list.
Technologies:
- C#
- .NET Framework
- MS SQL Server
- MS Visual Studio
- Multithread and Socket Programming
Achievements:
- The product was released on time with minimal bugs and is currently being used smoothly by Tan Thanh Company.
Shopping Cart Case Study
Description
The shopping cart website (Website) offers a wide range of products across various categories. It uses data mining to suggest products based on the customer's gender and age. The site manages orders through multiple stages and includes a smart admin tool to track user behavior, helping to identify which pages users frequent. The framework is designed to handle daily pricing, tax calculations, and stock management (with FIFO, LIFO options).
Challenges and Solutions
Challenges:
- Designing a framework that can be reused for both web and application, using MVC architecture, and supporting caching when the database is located on a different server.
Technologies:
- C#
- MVC Architecture
- Database-Oriented Design
- .NET Framework 3.5
- Web Services
- SQL Server 2005
- SQL Jobs
- HTML/DHTML
- XML
- ExtJS
- Ajax
- jQuery
Achievements:
- The website operates efficiently even with heavy data and user access.
ResToDesk POS Case Study
Description
ResToDesk is a web application designed for food ordering and seat management. Features include:
- Allowing customers to order food, select seats from a map, edit orders, and print their orders via a POS machine.
- Orders are transferred to the kitchen and stored in the waiting list. Once the order is handled, the kitchen notifies the waiter to deliver the food.
- Supports splitting orders and sharing payments among customers.
Challenges and Solutions
Challenges:
- Designing a 3D map for customers to choose their seats, with each table displaying information such as the number of people per table and its current status (e.g., busy, free, or ordered).
Technologies:
- C#
- MVC
- Database-Oriented Design
- DevExpress
- Crystal Reports
- SQL Server 2005
- InstallShield
- XML
- XSLT
- Import/Export CSV
Achievements:
- The project was successfully completed and met the customer’s expectations.
