public IActionResult Save(FuzzySuitabilityIntervalModel item)
{
if (item.Id == 0)
{
_model.New(item);
}
else
{
_model.Update(item);
}
return(View("Index", _model.GetAll()));
}
private bool IsSuitable(FuzzySuitabilityIntervalModel suitability, decimal temp, decimal rainfall)
{
if (temp > 0)
{
return(temp >= suitability.Min && temp <= suitability.Max);
}
if (rainfall > 0)
{
return(rainfall >= suitability.Min && rainfall <= suitability.Max);
}
return(false);
}
public void New(FuzzySuitabilityIntervalModel model)
{
var sql = @"INSERT INTO FuzzySuitabilityInterval(name,min,max)
VALUES (@name,@min,@max)
SELECT CAST(SCOPE_IDENTITY() AS int)";
var id = db.Query <int>(sql, new
{
model.Name,
model.Min,
model.Max
}).Single();
model.Id = id;
}
public void Update(FuzzySuitabilityIntervalModel model)
{
var sql = @"UPDATE FuzzySuitabilityInterval SET
name = @name,
min = @min,
max = @max
WHERE id = @id";
db.Execute(sql, new {
model.Name,
model.Min,
model.Max,
model.Id
});
}
public IActionResult New()
{
var item = new FuzzySuitabilityIntervalModel();
return(View("Form", item));
}
