//add pollutant records from pvt api on the basis of lat long
public void AddPollutants(PollutantListModel oneStation)
{
try
{
double latitude = oneStation.StationLatitude;
double longitude = oneStation.StationLongitude;
foreach (var pollutant in oneStation.pollutantModelList)
{
conn = dbc.openConnection();
cmd = new MySqlCommand("sp_addPollutants", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("val_PollutantName", pollutant.PollutantName);
cmd.Parameters.AddWithValue("val_PollutantValue", pollutant.PollutantValue);
cmd.Parameters.AddWithValue("val_lat", latitude);
cmd.Parameters.AddWithValue("val_long", longitude);
int recordInserted = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
string message = ex.Message;
}
finally
{
dbc.closeConnection();
}
}
//fetch pollutant records from pvt api on the basis of lat long
public List <PollutantListModel> FetchPollutants(List <StationModel> objStationList)
{
List <PollutantListModel> objAllStationPollutantList = new List <PollutantListModel>();
ApiHelper objAp = new ApiHelper();
foreach (var records in objStationList)
{
List <PollutantModel> objStaionPollutant = new List <PollutantModel>();
PollutantListModel objPollutantList = new PollutantListModel();
double latitude = records.station.geo[0];
double longitude = records.station.geo[1];
objStaionPollutant = objAp.fetchPollutants(latitude, longitude);
objPollutantList.StationLatitude = latitude;
objPollutantList.StationLongitude = longitude;
objPollutantList.pollutantModelList = objStaionPollutant;
objAllStationPollutantList.Add(objPollutantList);
}
return(objAllStationPollutantList);
}
