private static void EnrichCityWeatherInfo(DbCity city, int existedCityId)
{
foreach (var cityCityWeatherInfo in city.CityWeatherInfos)
{
cityCityWeatherInfo.CityId = existedCityId;
cityCityWeatherInfo.CreatedAt = DateTime.UtcNow;
}
}
/// <summary>
/// Add new city
/// </summary>
public async Task <int> AddAsync(DbCity city)
{
try
{
using (IDbConnection connection = new SqlConnection(_connectionString))
{
var insertCityQuery =
"INSERT INTO Cities(Name, DataUrl, IsActive, CreatedAt) OUTPUT INSERTED.[Id] VALUES (@Name, @DataUrl, @IsActive, @CreatedAt)";
return(await connection.QuerySingleAsync <int>(insertCityQuery,
new { city.Name, city.DataUrl, city.IsActive, CreatedAt = DateTime.UtcNow }));
}
}
catch (Exception e)
{
_logger.LogError($"CityRepository AddAsync error - [{e}]");
return(CityParameters.AddCityErrorId);
}
}
