public async Task <Guid> Add(MunicipalityEntity entity)
{
var municipality = _databaseContext.Municipalities.Add(entity);
await _databaseContext.SaveChangesAsync();
return(municipality.Entity.Id);
}
public async Task <MunicipalityEntity> Update(Guid id, MunicipalityEntity entity)
{
var municipality = await GetById(id);
municipality.Name = entity.Name;
_databaseContext.Municipalities.Update(municipality);
await _databaseContext.SaveChangesAsync();
return(municipality);
}
public async Task <IActionResult> Get(string format)
{
try
{
var states = await db.state.listEnableAsync();
var municipalities = await db.municipality.listEnableVisibleAsync();
var weatherstations = await db.weatherStation.listEnableVisibleAsync();
var crops = await db.crop.listEnableAsync();
List <StateEntity> json = new List <StateEntity>();
StateEntity geo_s;
MunicipalityEntity geo_m;
foreach (var s in states)
{
geo_s = new StateEntity()
{
id = s.id.ToString(), name = s.name, country = s.country.name, municipalities = new List <MunicipalityEntity>()
};
foreach (var m in municipalities.Where(p => p.state == s.id))
{
geo_m = new MunicipalityEntity()
{
id = m.id.ToString(), name = m.name, weather_stations = new List <WeatherStationEntity>()
};
foreach (var w in weatherstations.Where(p => p.municipality == m.id))
{
geo_m.weather_stations.Add(new WeatherStationEntity()
{
id = w.id.ToString(),
ext_id = w.ext_id,
name = w.name,
origin = w.origin,
latitude = w.latitude,
longitude = w.longitude,
ranges = w.ranges.Select(p => new YieldRangeEntity()
{
crop_id = p.crop.ToString(),
label = p.label,
lower = p.lower,
upper = p.upper,
crop_name = crops.Single(p2 => p2.id == p.crop).name
})
});
}
geo_s.municipalities.Add(geo_m);
}
json.Add(geo_s);
}
// Write event log
writeEvent("Geographic count [" + json.Count().ToString() + "]", LogEvent.lis);
//Evaluate the format to export
if (string.IsNullOrEmpty(format) || format.ToLower().Trim().Equals("json"))
{
return(Json(json));
}
else if (format.ToLower().Trim().Equals("csv"))
{
StringBuilder builder = new StringBuilder();
// add header
builder.Append(string.Join <string>(delimiter, new string[] { "country_name", "state_id", "state_name", "municipality_id", "municipality_name", "ws_id", "ws_name", "ws_origin", "\n" }));
foreach (var s in json)
{
foreach (var m in s.municipalities)
{
foreach (var w in m.weather_stations)
{
builder.Append(string.Join <string>(delimiter, new string[] { s.country, s.id, s.name, m.id, m.name, w.id, w.name, w.origin, "\n" }));
}
}
}
var file = UnicodeEncoding.Unicode.GetBytes(builder.ToString());
return(File(file, "text/csv", "geographic.csv"));
}
else
{
return(Content("Format not supported"));
}
}
catch (Exception ex)
{
writeException(ex);
return(new StatusCodeResult(500));
}
}
public async Task <IActionResult> GetCrop(string format)
{
try
{
// Get data
var states = await db.state.listEnableAsync();
var municipalities = await db.municipality.listEnableVisibleAsync();
var weatherstations = await db.weatherStation.listEnableVisibleAsync();
var crops = await db.crop.listEnableAsync();
// This cicle is to get all geographic information by crop
List <CropGeographicEntity> json = new List <CropGeographicEntity>();
foreach (var crop in crops)
{
var crops_cultivar = await db.cultivar.listByCropEnableAsync(crop.id);
var cultivars = crops_cultivar.Select(p => p.id);
var forecast = await db.forecast.getLatestAsync();
if (forecast != null)
{
var yield_forecast = await db.forecastYield.byForecastAsync(forecast.id);
// filter
List <ObjectId> ws_forecast = new List <ObjectId>();
// Get the weather station with data in the forecast for the crop
foreach (var y in yield_forecast)
{
if (cultivars.Contains(y.cultivar) && !ws_forecast.Contains(y.weather_station))
{
ws_forecast.Add(y.weather_station);
}
/*
* foreach (var c in y.yield)
* {
* if (cultivars.Contains(c.cultivar) && !ws_forecast.Contains(y.weather_station))
* ws_forecast.Add(y.weather_station);
* }*/
}
var ws_result = weatherstations.Where(p => ws_forecast.Contains(p.id));
var mn_result = municipalities.Where(p => ws_result.Select(p2 => p2.municipality).Contains(p.id));
var st_result = states.Where(p => mn_result.Select(p2 => p2.state).Contains(p.id));
StateEntity geo_s;
MunicipalityEntity geo_m;
List <StateEntity> json_state = new List <StateEntity>();
// This cicle is to get all states where is located the crop
foreach (var s in st_result)
{
geo_s = new StateEntity()
{
id = s.id.ToString(), name = s.name, country = s.country.name, municipalities = new List <MunicipalityEntity>()
};
foreach (var m in mn_result.Where(p => p.state == s.id))
{
geo_m = new MunicipalityEntity()
{
id = m.id.ToString(), name = m.name, weather_stations = new List <WeatherStationEntity>()
};
foreach (var w in ws_result.Where(p => p.municipality == m.id))
{
geo_m.weather_stations.Add(new WeatherStationEntity()
{
id = w.id.ToString(),
ext_id = w.ext_id,
name = w.name,
origin = w.origin,
ranges = w.ranges.Select(p => new YieldRangeEntity()
{
crop_id = p.crop.ToString(),
label = p.label,
lower = p.lower,
upper = p.upper,
crop_name = crop.name
})
});
}
geo_s.municipalities.Add(geo_m);
}
json_state.Add(geo_s);
}
json.Add(new CropGeographicEntity()
{
id = crop.id.ToString(), name = crop.name, states = json_state
});
}
}
// Write event log
writeEvent("Geographic forecast yield count [" + json.Count().ToString() + "]", LogEvent.lis);
//Evaluate the format to export
if (string.IsNullOrEmpty(format) || format.ToLower().Trim().Equals("json"))
{
return(Json(json));
}
else if (format.ToLower().Trim().Equals("csv"))
{
StringBuilder builder = new StringBuilder();
// add header
builder.Append(string.Join <string>(delimiter, new string[] { "crop_id", "crop_name", "country_name", "state_id", "state_name", "municipality_id", "municipality_name", "ws_id", "ws_name", "ws_origin", "\n" }));
foreach (var c in json)
{
foreach (var s in c.states)
{
foreach (var m in s.municipalities)
{
foreach (var w in m.weather_stations)
{
builder.Append(string.Join <string>(delimiter, new string[] { c.id, c.name, s.country, s.id, s.name, m.id, m.name, w.id, w.name, w.origin, "\n" }));
}
}
}
}
var file = UnicodeEncoding.Unicode.GetBytes(builder.ToString());
return(File(file, "text/csv", "geographic.csv"));
}
else
{
return(Content("Format not supported"));
}
}
catch (Exception ex)
{
writeException(ex);
return(new StatusCodeResult(500));
}
}
