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