Posts Categorized: Lập trình

Best practice: Làm việc với DateTime

Tìm những records nào liên quan tới ngày đã chọn (Local to UTC) Bài toán: Tôi muốn lấy dữ liệu hoạt động của 1 user cụ thể trong ngày 12/08/2025 (GMT +8). Giả sử table Logs có các cột như sau “UserId, Data, CreatedOn (UTC)” Cách thực hiện: Chuyển từ giờ local sang UTC. Cài […]

SSMS Studio 21 Connection timeout

Trong quá trình làm việc với SQL Database bạn cần backup database nhưng liên tục bị báo lỗi timeout. Thì đây là cách giải quyết nhé. Tăng giá trị command timeout lên là ok

Multiple layout within Ionic app

When developing an Ionic app, implementing distinct layouts for different user roles is essential for usability and functionality. In this article, we’ll explore how to structure an Ionic app with two master layouts—one for regular users and another for administrators—each with its own unique navigation system.

Best Practices for Designing a Booking System Database

Designing a booking system database requires efficiency, flexibility, and scalability. A common mistake is creating separate tables for different item types, such as vehicles, security personnel, and additional services. Instead, a more optimized approach is to use a single table to manage all service items uniformly, simplifying queries and database maintenance.

Transaction Management in Systems using .NET Core and MS SQL

Introduction In financial or e-commerce systems, managing financial transactions is a crucial part. Each transaction can consist of multiple components such as purchasing items, platform fees, or payment gateway fees. To ensure data integrity and transparency, the system needs a mechanism to record transactions and financial journals clearly and accurately. This article will guide you […]

[Ionic] Dynamic Layout background color

Way 1: Using document body to set theme (preferred) 1. Set the document body inside the main layouts 2. Style the app in the variable.scss Way 2: Set them variables directly into Main layout page Structure the files Given you have folder structure like this. ui-pages/main: layout using for admin, moderator role ui-pages/user: layout using […]