private DbClothingRule DbModelFromDomainModel(DomainClothingRule rule)
{
return(new DbClothingRule {
Id = rule.Id,
FromTemperature = rule.FromTemperature,
ToTemperature = rule.ToTemperature,
IsRaining = rule.IsRaining,
Clothes = rule.Clothes
});
}
public async Task <int> Delete(DomainClothingRule rule)
{
await using var connection = new SqlConnection(_configuration.ConnectionString);
const string update = @"
DELETE FROM [dbo].[ClothingRule]
WHERE Id = @Id
";
var data = DbModelFromDomainModel(rule);
var rows = await connection.ExecuteAsync(update, data);
return(rows);
}
public async Task <int> Update(DomainClothingRule rule)
{
await using var connection = new SqlConnection(_configuration.ConnectionString);
const string update = @"
UPDATE [dbo].[ClothingRule]
SET [IsRaining] = @IsRaining
,[FromTemperature] = @FromTemperature
,[ToTemperature] = @ToTemperature
,[Clothes] = @Clothes
WHERE Id = @Id
";
var data = DbModelFromDomainModel(rule);
var rows = await connection.ExecuteAsync(update, data);
return(rows);
}
public async Task <int> Create(DomainClothingRule rule)
{
await using var connection = new SqlConnection(_configuration.ConnectionString);
const string update = @"
INSERT INTO [dbo].[ClothingRule]
([Id]
,[IsRaining]
,[FromTemperature]
,[ToTemperature]
,[Clothes])
VALUES
(@Id
,@IsRaining
,@FromTemperature
,@ToTemperature
,@Clothes)
";
var data = DbModelFromDomainModel(rule);
var rows = await connection.ExecuteAsync(update, data);
return(rows);
}
