private static void DisplayOneZipCode(NpgsqlConnection connection)
{
var zipRepo = new ZipRepository(connection);
var zip = zipRepo.FindByKey("0001");
Console.WriteLine($"DisplayOneZipCode: code: {zip.ZipCode}, name: {zip.ZipName}");
}
private static void UpdateOneZipCode(NpgsqlConnection connection)
{
var repo = new ZipRepository(connection);
var zip = repo.FindByKey("0003");
zip.ZipName = "中王路十二巷";
repo.Update(zip);
}
private static void AddOneZipCode(NpgsqlConnection connection)
{
var zip = new Zip {
ZipCode = "0004", ZipName = "中王路十四巷"
};
var repo = new ZipRepository(connection);
repo.Add(zip);
}
public static void DisplayAllZipCode(IDbConnection connection, ILogger logger)
{
var zipRepo = new ZipRepository(connection);
var zips = zipRepo.GetAll();
foreach (var zip in zips)
{
// logger.LogInformation($"Logger: code: {zip.ZipCode}, name: {zip.ZipName}");
Console.WriteLine($"DisplayAllZipCode: code: {zip.ZipCode}, name: {zip.ZipName}");
}
}
