public List <MasterCityDTO> Admin_MasterCityCheckExists(MasterCityDTO masterCityDTO) { try { return(_dataAccessMasterCity.Admin_MasterCityCheckExists(masterCityDTO)); } catch (Exception ex) { throw ex; } }
public void Admin_MasterCityUpdate(MasterCityDTO masterCityDTO) { try { _dataAccessMasterCity.Admin_MasterCityUpdate(masterCityDTO); } catch (Exception ex) { throw ex; } }
public void Admin_MasterCityUpdate(MasterCityDTO masterCityDTO) { try { _client.Admin_MasterCityUpdate(masterCityDTO); } catch (Exception ex) { throw ex; } }
public MasterCityDTO Admin_MasterCityGetOnCityId(int cityId) { try { MasterCityDTO _returnResult = SqlHelper.QuerySP <MasterCityDTO>("Admin_MasterCityGetOnCityId", new { CityId = cityId }).ToList().FirstOrDefault(); return(_returnResult); } catch (Exception ex) { throw ex; } }
public ActionResult UpdateCity(int CityId) { ModelMasterCity model = new ModelMasterCity(); if (CityId > 0) { MasterCityDTO _adminUser = _IMasterCity.Admin_MasterCityGetOnCityId(CityId); model.CountryId = _adminUser.CountryId; model.StateId = _adminUser.StateId; model.IsDefault = _adminUser.IsDefault; model.CityId = _adminUser.CityId; model.CityName = _adminUser.CityName; model.CityShortName = _adminUser.CityShortName; } return(View(model)); }
public List <MasterCityDTO> Admin_MasterCityCheckExists(MasterCityDTO masterCityDTO) { try { List <MasterCityDTO> _returnResult = SqlHelper.QuerySP <MasterCityDTO>("Admin_MasterCityCheckExists", new { CityId = masterCityDTO.CityId, CityName = masterCityDTO.CityName }).ToList(); return(_returnResult); } catch (Exception ex) { throw ex; } }
public ActionResult UpdateCity(ModelMasterCity model) { MasterCityDTO _dto = new MasterCityDTO(); _dto.StateId = userEntity.MasterStateId; _dto.IsDefault = model.IsDefault; _dto.CityId = model.CityId; _dto.CityName = model.CityName; _dto.CityShortName = model.CityShortName; if (_IMasterCity.Admin_MasterCityCheckExists(_dto).Count > 0) { model.ErrorMessage = "City name already existed"; } else { _IMasterCity.Admin_MasterCityUpdate(_dto); Response.Redirect("ManageCity"); } return(View(model)); }
public void Admin_MasterCityUpdate(MasterCityDTO masterCityDTO) { try { SqlHelper.QuerySP("Admin_MasterCityUpdate", new { CityId = masterCityDTO.CityId , CityName = masterCityDTO.CityName , StateId = masterCityDTO.StateId , CityShortName = masterCityDTO.CityShortName , IsDefault = masterCityDTO.IsDefault }); } catch (Exception ex) { throw ex; } }
private void NearestLocationApiCall(string latitude, string longitude, bool isCityInfo, MasterCityDTO masterCityDto, List <GoogleTypes> googleType, int countryId, int attractionId, MapsXAPIXFeature mapsXapixFeature, string attractionName, int attractionTravelStepsId = 0) { string radiusData = string.Empty; string url = string.Empty; if (!string.IsNullOrEmpty(latitude) && !string.IsNullOrEmpty(longitude)) { foreach (var googleTypes in googleType) { try { radiusData = string.Empty; url = string.Empty; switch (mapsXapixFeature.MapsId) { //google case 1: { url = mapsXapixFeature.API + latitude + "," + longitude + "&radius=25000&key=" + mapsXapixFeature.apiKeyOrapiId; if (!string.IsNullOrEmpty(googleTypes.TypeName)) { url = url + "&type=" + googleTypes.TypeName; } radiusData = webRequest.WebServiceInformation(url); var returnsInformation = JsonConvert.DeserializeObject <NearBySearchEntity>( radiusData); if (returnsInformation != null && returnsInformation.results.Any()) { if (isCityInfo) { dALSchedulers.UpdateCityNearestLocationDont(masterCityDto .CityId); } InsertSearchResult(returnsInformation, countryId, url, longitude, latitude, attractionId, attractionTravelStepsId, mapsXapixFeature.MapsId, mapsXapixFeature); dALSchedulers.Scheduler_MapsLogging("NearestLocationApiCall", mapsXapixFeature.MapsId, mapsXapixFeature.MapsCredentialsId, mapsXapixFeature.MapFeaturesId, radiusData, string.Empty, string.Empty, countryId, attractionId, url, false, attractionTravelStepsId); } else { dALSchedulers.Scheduler_MapsLogging("NearestLocationApiCall", mapsXapixFeature.MapsId, mapsXapixFeature.MapsCredentialsId, mapsXapixFeature.MapFeaturesId, radiusData, string.Empty, string.Empty, countryId, attractionId, url, true, attractionTravelStepsId); } break; } //locationiq case 2: { url = mapsXapixFeature.API + "key=" + mapsXapixFeature.apiKeyOrapiId + "&format=json" + "&lat=" + latitude + "&lon=" + longitude + "&tag=" + googleTypes.TypeName; radiusData = webRequest.WebServiceInformation(url); var returnsInformation = JsonConvert .DeserializeObject <List <NearBy> >(radiusData); if (returnsInformation != null && returnsInformation.Any()) { var result = returnsInformation.Where(x => !string.IsNullOrEmpty(x.name)).Select( y => new ResultsList { geometry = new geometryList { location = new locationList { lat = y.lat, lng = y.lon } }, name = y.name, types = (new List <string>() { googleTypes.TypeName }).ToArray() }).ToList(); InsertSearchResult(new NearBySearchEntity { results = result }, countryId, url, longitude, latitude, attractionId, attractionTravelStepsId, mapsXapixFeature.MapsId, mapsXapixFeature); dALSchedulers.Scheduler_MapsLogging("NearestLocationApiCall", mapsXapixFeature.MapsId, mapsXapixFeature.MapsCredentialsId, mapsXapixFeature.MapFeaturesId, string.Empty, string.Empty, string.Empty, countryId, attractionId, url, false, attractionTravelStepsId); } else { dALSchedulers.Scheduler_MapsLogging("NearestLocationApiCall", mapsXapixFeature.MapsId, mapsXapixFeature.MapsCredentialsId, mapsXapixFeature.MapFeaturesId, radiusData, string.Empty, string.Empty, countryId, attractionId, url, true, attractionTravelStepsId); } //Every request after taking a break of one second Thread.Sleep(1000); break; } case 3: { if (!string.IsNullOrEmpty(attractionName)) { url = mapsXapixFeature.API + "at=" + latitude + "," + longitude + "&q=" + attractionName + "&app_id=" + mapsXapixFeature.apiKeyOrapiId + "&app_code=" + mapsXapixFeature.apiCode; radiusData = webRequest.WebServiceInformation(url); var returnsInformation = JsonConvert .DeserializeObject <BusinessEntites.Scheduler.here.NearBy>(radiusData); } break; } } } catch (Exception ex) { dALSchedulers.Scheduler_MapsLogging("NearestLocationApiCall", mapsXapixFeature.MapsId, mapsXapixFeature.MapsCredentialsId, mapsXapixFeature.MapFeaturesId, radiusData, ex.Message, ex.StackTrace, countryId, attractionId, url, true, attractionTravelStepsId); if (ex.Message == "The remote server returned an error: (429) Too Many Requests.") { Thread.Sleep(1000 * 60); } } } } }