using System;
using System.Net.Http;
using System.Threading.Tasks;
using System.Text.Json;

public class GDriveConfigService
{
    private static readonly string ApiUrl = "https://firestore.googleapis.com/v1/projects/qlykhachhang-f1396/databases/(default)/documents/system_settings/gdrive_config?key=...";

    public async Task<BackupConfig> FetchDriveConfigAsync()
    {
        using (var client = new HttpClient())
        {
            var response = await client.GetAsync(ApiUrl);
            response.EnsureSuccessStatusCode();
            var jsonString = await response.Content.ReadAsStringAsync();
            
            // Extract fields from Firestore Document REST format
            using (JsonDocument doc = JsonDocument.Parse(jsonString))
            {
                var fields = doc.RootElement.GetProperty("fields");
                return new BackupConfig
                {
                    ClientId = fields.GetProperty("client_id").GetProperty("stringValue").GetString(),
                    ClientSecret = fields.GetProperty("client_secret").GetProperty("stringValue").GetString(),
                    RefreshToken = fields.GetProperty("refresh_token").GetProperty("stringValue").GetString(),
                    FolderId = fields.GetProperty("folder_id").GetProperty("stringValue").GetString()
                };
            }
        }
    }
}

curl -X GET "https://firestore.googleapis.com/v1/projects/qlykhachhang-f1396/databases/(default)/documents/system_settings/gdrive_config?key=AIzaSyDMZEnRPZn6DLSntEroryP3Wmw6-M4cdXk"

using System;
using System.Net.Http;
using System.Text;
using System.Text.Json;
using System.Threading.Tasks;

public class BackupReportService
{
    private static readonly HttpClient _http = new HttpClient();

    // Gọi API này SAU KHI upload file backup lên Google Drive thành công
    public async Task<bool> ReportBackupResultAsync(
        string projectDocId,   // Firestore Document ID của dự án (lấy từ API cấu hình)
        string backupFile,     // Tên file backup đã upload (ví dụ: DB_20260729_220000.bak.gz)
        string driveFileId,    // File ID trên Google Drive sau khi upload
        bool isSuccess)        // true = thành công, false = thất bại
    {
        var projectId = "qlykhachhang-f1396";
        var apiKey    = "AIzaSyDMZEnRPZn6DLSntEroryP3Wmw6-M4cdXk";
        var collection = "QLykhachhang";

        var patchUrl = $"https://firestore.googleapis.com/v1/projects/{projectId}/databases/(default)/documents/{collection}/{projectDocId}" +
                       $"?key={apiKey}" +
                       "&updateMask.fieldPaths=lastBackupDate" +
                       "&updateMask.fieldPaths=lastBackupFile" +
                       "&updateMask.fieldPaths=lastBackupStatus" +
                       "&updateMask.fieldPaths=lastBackupDriveFileId";

        var now    = DateTime.Now.ToString("yyyy-MM-ddTHH:mm:sszzz");
        var status = isSuccess ? "success" : "failed";

        var body = new
        {
            fields = new
            {
                lastBackupDate       = new { stringValue = now },
                lastBackupFile       = new { stringValue = backupFile },
                lastBackupStatus     = new { stringValue = status },
                lastBackupDriveFileId = new { stringValue = driveFileId ?? "" }
            }
        };

        var json    = JsonSerializer.Serialize(body);
        var content = new StringContent(json, Encoding.UTF8, "application/json");

        var request = new HttpRequestMessage(new HttpMethod("PATCH"), patchUrl)
        {
            Content = content
        };

        var response = await _http.SendAsync(request);
        return response.IsSuccessStatusCode;
    }
}

curl -X PATCH \
  "https://firestore.googleapis.com/v1/projects/qlykhachhang-f1396/databases/(default)/documents/QLykhachhang/{PROJECT_DOC_ID}?key=AIzaSyDMZEnRPZn6DLSntEroryP3Wmw6-M4cdXk&updateMask.fieldPaths=lastBackupDate&updateMask.fieldPaths=lastBackupFile&updateMask.fieldPaths=lastBackupStatus" \
  -H "Content-Type: application/json" \
  -d '{
    "fields": {
      "lastBackupDate":   { "stringValue": "2026-07-29T22:00:00+07:00" },
      "lastBackupFile":   { "stringValue": "DB_backup_20260729_220000.bak.gz" },
      "lastBackupStatus": { "stringValue": "success" }
    }
  }'