Categories

final cache = CacheManager.instance;

// Expense category
final foodCategory = await cache.createCategory(
  name: 'Food & Dining',
  type: 'expense',
  color: 0xFFFF5722,  // Orange
  icon: 'restaurant',
);

// Income category
final salaryCategory = await cache.createCategory(
  name: 'Salary',
  type: 'income',
  color: 0xFF4CAF50,  // Green
  icon: 'attach_money',
);

final category = Category(
  id: cache.generateId(),
  name: 'Transportation',
  type: 'expense',
  color: 0xFF2196F3,  // Blue
  icon: 'directions_car',
  createdAt: DateTime.now(),
  updatedAt: DateTime.now(),
);

await cache.categories.save(category);

final allCategories = await cache.categories.findAll();

// Get only expense categories
final expenseCategories = await cache.categories.findByType('expense');

// Get only income categories
final incomeCategories = await cache.categories.findByType('income');

final category = await cache.categories.findById('category-uuid');

// Format: 0xAARRGGBB
final red = 0xFFFF0000;      // Red
final green = 0xFF00FF00;    // Green
final blue = 0xFF0000FF;     // Blue

// In Flutter, you can use:
final color = Color(0xFFFF5722);

final category = await cache.categories.findById(categoryId);
if (category != null) {
  final updated = category.copyWith(
    name: 'Updated Name',
    color: 0xFF9C27B0,  // Change to purple
  );
  await cache.categories.save(updated);
}

// Soft delete (recommended)
await cache.categories.delete(categoryId);

// Hard delete
await cache.categories.delete(categoryId, hardDelete: true);