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)); }