如何利用周数和年份获取一周的开始和结束日期，并将这些日期插入到c#中的mysql表中

int year = 2022; // 年份
int week = 1; // 周数

// 计算该周的开始日期
DateTime startOfWeek = DateTime.ParseExact($"{year}-W{week.ToString("00")}-1", "yyyy-'W'ww-d", CultureInfo.InvariantCulture);

// 计算该周的结束日期
DateTime endOfWeek = startOfWeek.AddDays(6);

using MySql.Data.MySqlClient;

string connectionString = "server=your_server;user=your_username;password=your_password;database=your_database;";
string tableName = "your_table";

// 创建MySQL连接对象
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
    connection.Open();

    // 插入开始日期和结束日期到表中
    string insertQuery = $"INSERT INTO {tableName} (start_date, end_date) VALUES (@startDate, @endDate)";
    using (MySqlCommand command = new MySqlCommand(insertQuery, connection))
    {
        command.Parameters.AddWithValue("@startDate", startOfWeek);
        command.Parameters.AddWithValue("@endDate", endOfWeek);
        command.ExecuteNonQuery();
    }
}