使用C#添加商机记录

public class Opportunity
{
    public string CustomerName { get; set; }
    public string CustomerEmail { get; set; }
    public string Description { get; set; }
    public bool PurchaseIntent { get; set; }
}

var opportunity = new Opportunity
{
    CustomerName = "John Doe",
    CustomerEmail = "johndoe@example.com",
    Description = "I need a new software solution for my company.",
    PurchaseIntent = true
};

using System.IO;
using System.Text.Json;

var jsonString = JsonSerializer.Serialize(opportunity);
File.WriteAllText("opportunity.json", jsonString);

using System.Data.SqlClient;

var connectionString = "Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True";
var insertCommand = "INSERT INTO Opportunities (CustomerName, CustomerEmail, Description, PurchaseIntent) VALUES (@CustomerName, @CustomerEmail, @Description, @PurchaseIntent)";

using (var connection = new SqlConnection(connectionString))
{
    var command = new SqlCommand(insertCommand, connection);
    command.Parameters.AddWithValue("@CustomerName", opportunity.CustomerName);
    command.Parameters.AddWithValue("@CustomerEmail", opportunity.CustomerEmail);
    command.Parameters.AddWithValue("@Description", opportunity.Description);
    command.Parameters.AddWithValue("@PurchaseIntent", opportunity.PurchaseIntent);

    connection.Open();
    command.ExecuteNonQuery();
}

using System.IO;
using System.Text.Json;
using Amazon.S3;

var jsonString = JsonSerializer.Serialize(opportunity);

var s3Client = new AmazonS3Client(Amazon.RegionEndpoint.USEast1);
using (var stream = new MemoryStream(Encoding.UTF8.GetBytes(jsonString)))
{
    var putObjectRequest = new Amazon.S3.Model.PutObjectRequest
    {
        BucketName = "my-bucket",
        Key = "opportunity.json",
        InputStream = stream
    };

    s3Client.PutObject(putObjectRequest);
}