public static double?GetMultiplierFor(SprayQuality sq, LabelSprayQuality lsq, BoomHeight bh, WindSpeed ws)
{
// Work around, use local variable
var sqId = sq.Id;
var lsqId = lsq.Id;
var bhId = bh.Id;
var wsId = ws.Id;
var ret = from m in _db.Table <Multiplier>()
where m.SprayQualityId == sqId && m.LabelSprayQualityId == lsqId && m.BoomHeightId == bhId && m.WindSpeedId == wsId
select m;
Debug.Assert(ret.Count() == 1);
var f = ret.FirstOrDefault();
return(f != null ? f.Value : (double?)null);
}
public void GetSprayQuality(Action <IList <SprayQuality> > action)
{
DownloadAndParseJsonData("http://demeter.usask.ca/buffer_zone_multiplier/bufferzone_db_data.php?table=spray_quality", jValue =>
{
var ret = new List <SprayQuality>();
foreach (var v in jValue)
{
var j = (JsonValue)v;
var curr = new SprayQuality()
{
Id = j["spray_quality_id"],
Name = j["spray_quality_name"],
};
ret.Add(curr);
}
action(ret);
});
}