public void New(FuzzyParameterModel model)
{
var sql = @"INSERT INTO FuzzyParameter(type,growthstages,absolutemin,optimummin,optimummax,absolutemax)
VALUES (@type,@growthstages,@absolutemin,@optimummin,@optimummax,@absolutemax)
SELECT CAST(SCOPE_IDENTITY() AS int)";
var id = db.Query <int>(sql, new
{
model.Type,
model.GrowthStages,
model.AbsoluteMin,
model.OptimumMin,
model.OptimumMax,
model.AbsoluteMax
}).Single();
model.Id = id;
}
public void Update(FuzzyParameterModel model)
{
var sql = @"UPDATE FuzzyParameter SET
type = @type,
growthstages = @growthstages,
absolutemin = @absolutemin,
optimummin = @optimummin,
optimummax = @optimummax,
absolutemax = @absolutemax
WHERE id = @id";
db.Execute(sql, new {
model.Type,
model.GrowthStages,
model.AbsoluteMin,
model.OptimumMin,
model.OptimumMax,
model.AbsoluteMax,
model.Id
});
}
