public object SaveUpdate(CitysDTO modelDTO) { modelDTO.UpdatedDate = Converters.GetCurrentEpochTime(); Citys model = Mapper.Map <CitysDTO, Citys>(modelDTO); if (model.Id == 0) { model.CreatedDate = modelDTO.UpdatedDate; model.IsActive = true; model.IsDeleted = false; this._dbContext.Citys.Add(model); this._dbContext.SaveChanges(); } else { this._dbContext.Entry(model).State = EntityState.Modified; this._dbContext.SaveChanges(); } modelDTO = Mapper.Map <Citys, CitysDTO>(model); return(model); }
/// <summary> /// 查找省级区划 /// </summary> /// <returns>bool 是否找到省级区划</returns> private void FindProvinc() { var list = (from p in Provinces let index = GetIndex(p.Alias, 5) where index >= 0 orderby index select new { region = p, index }).ToList(); if (!list.Any()) { FindProvinceReverse(); return; } var prov = list.First(); _Province = prov.region; _Citys = Citys.Where(c => c.ParentId == _Province.ID).ToList(); SetIndex(prov.index, _Province.Name, _Province.Alias); FindCity(); }
private void SelectCity() { if (String.IsNullOrEmpty(InputModel.Bank.Address.City)) { if (Citys.Count > 0) { SelectedCity = Citys[0]; } return; } var exist = Citys.FirstOrDefault(m => m.City == InputModel.Bank.Address.City); if (exist == null && Citys.Count > 0) { SelectedCity = Citys[0]; } else { SelectedCity = exist; } }
public ActionResult Edit(int symbol) { Citys city = null; Locations locations = null; using (var ctx = new ResourcesServicesContext()) { city = ctx.City.SingleOrDefault(x => x.Id_City == symbol); locations = ctx.Location.SingleOrDefault(x => x.Id_Locations == symbol); } var locationswithcity = new LocationWithCityModel { City = city.City, Street = city.Street, Postal_Code = city.Postal_Code, Floor = locations.Floor, Room = locations.Room }; return(View(locationswithcity)); }
public void readInfo() { var url = "https://query.data.world/s/6ankomqkxpsxwh4nnxjnw4ffvc7knf"; var client = new WebClient(); using (var stream = client.OpenRead(url)) using (var reader = new StreamReader(stream)) { String line = reader.ReadLine(); int count = 0; //Acomodar numero de entradas que lee (puse solo 100). while ((count < 500) && (line = reader.ReadLine()) != null) { String[] args = line.Split(','); String city = args[15].Replace("\"", ""); String delay = args[31].Replace("\"", ""); if (citysNames.Contains(city)) { if (Convert.ToDouble(delay) > 0) { citys.ElementAt(citysNames.IndexOf(city)).addDelay(Convert.ToDouble(delay)); } } else { citysNames.Add(city); Citys newCity = new Citys(city); citys.Add(newCity); citys.ElementAt(citysNames.IndexOf(city)).addDelay(Convert.ToDouble(delay)); } count++; } reader.Close(); } }
public void SavePOIData(string fileName, Citys city, Scenes scene, List <poi> pois) { try { StringBuilder sb = new StringBuilder(); foreach (var p in pois) { string wgs_loaction = ""; if (p.location != "" && p.location.Contains(",")) { //火星坐标转为WGS84坐标 LngLatPoint wgs = new Transform().GCJ2WGS(double.Parse(p.location.Split(',')[1]), double.Parse(p.location.Split(',')[0])); wgs_loaction = wgs.Lng + "," + wgs.Lat; } string s = p.id + " "; s += p.name + " "; s += p.type + " "; s += p.address + " "; s += p.pname + " "; s += p.cityname + " "; s += p.adname + " "; s += wgs_loaction; s += "\r\n"; sb.Append(s); } FileStream fs = File.OpenWrite(fileName); fs.Position = fs.Length; byte[] bytes = Encoding.UTF8.GetBytes(sb.ToString()); fs.Write(bytes, 0, bytes.Length); fs.Dispose(); fs.Close(); } catch (Exception ex) { new Log().PageLog.Error(string.Format("保存{0}-{1}-{2}-{3}-{4}-{5}-POI数据:{6}", scene.l_class, scene.m_class, scene.s_class, city.Province, city.CityName, city.Country, ex)); } }
/// <summary> /// 通过县级行政区划反查省市 /// </summary> /// <returns>Address 结构化地址数据</returns> private void ReverseFromCounty() { var list = (from c in Countys let alias = c.Alias.Split(',').FirstOrDefault(_Address.Contains) let key = alias ?? c.Name let index = GetIndex(key) where index >= 0 orderby index select new { region = c, index, key }).ToList(); if (!list.Any()) { return; } var county = list.First(); _County = county.region; _City = Citys.Single(c => c.ID == _County.ParentId); _Province = Provinces.Single(p => p.ID == _City.ParentId); SetIndex(county.index, _County.Name, county.key); FindTown(); }
public void DownPoiData(string fileName, Citys city, Scenes scene) { try { //构造web服务的Url string httpUrl = string.Format("https://restapi.amap.com/v3/place/text?key=a1cf3409aacac2f92df039ba818e42c5&keywords=&types={0}&city={1}&output=JSON&offset=20&page=1&extensions=all&citylimit=true", scene.code, city.adcode); string s = HttpUtil.HTTPSGet(httpUrl); while (s == "") { s = HttpUtil.HTTPSGet(httpUrl); } POI p = JsonConverter.FromJson <Model.POI>(s); SavePOIData(fileName, city, scene, p.pois); double Count = double.Parse(p.count); if (Count > 20) { GetPageData(fileName, city, scene, Count); } } catch (Exception ex) { new Log().PageLog.Error(string.Format("请求{0}-{1}-{2}-{3}-{4}-{5}-POI数据:{6}", scene.l_class, scene.m_class, scene.s_class, city.Province, city.CityName, city.Country, ex)); } }
public JsonResult Get_Api_Result(string city_id, string unit_id, string selected_date) { DateTime date = DateTime.Parse(selected_date); DateTime today = DateTime.Today; int days = (date - today.Date).Days + 1; //double days = 5; string json_content = ""; string unit_description = ""; City city = city_id != "undefined" ? Citys.FirstOrDefault(c => c.City_id == int.Parse(city_id)) : Citys.FirstOrDefault(); Unit unit = unit_id != "undefined" ? Units.FirstOrDefault(u => u.Unit_id == int.Parse(unit_id)) : Units.FirstOrDefault(); unit_description = unit.api_description == string.Empty ? "" : "&units=" + unit.api_description; WebRequest request = WebRequest.Create("https://api.weatherbit.io/v2.0/forecast/daily?lat=" + city.lat + "&lon=" + city.lon + unit_description + "&days=" + days.ToString() + "&key=a1ea39d3341d431cb1cb0bb718a062af"); WebResponse response = request.GetResponse(); Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); json_content = reader.ReadLine(); //string json = JsonConvert.SerializeObject(json_content); object obj = new JavaScriptSerializer().DeserializeObject(json_content); //request.CreateResponse(HttpStatusCode.Accepted, obj); return(Json(obj, JsonRequestBehavior.AllowGet)); }
public void Update(Citys entity) { _repositoryBase.Update(entity); }
public void Delete(Citys entity) { _repositoryBase.Delete(entity); }
public void Add(Citys entity) { _repositoryBase.Add(entity); }
public async Task <Responce <bool> > UpsertCity(CityDTO model) { Responce <bool> Responce = new Responce <bool>(); Responce.Success = true; try { using (var db = new SSCEntities()) { if (model.IsCreate) { } else { } var IsAdminEmailExist = db.AspNetUsers.Where(a => a.Email.ToLower() == model.AdminEmail.ToLower())?.ToList(); if (IsAdminEmailExist.Count > 0) { DateTime dateTime = DateTime.UtcNow; Citys citys = db.Citys.Find(model.Id) ?? new Citys(); citys.MCEmail = model.MCEmail; citys.FcciEmail = model.FcciEmail; citys.CityName = model.CityName; citys.IsActive = model.IsActive; citys.AdminEmail = model.AdminEmail; if (citys.Id == 0) { citys.CreatedBy = model.CreatedBy; citys.CreatedDate = dateTime; citys.ModifiedBy = model.ModifiedBy; citys.ModifiedDate = dateTime; db.Entry(citys).State = System.Data.Entity.EntityState.Added; await db.SaveChangesAsync(); } else { citys.ModifiedBy = model.ModifiedBy; citys.ModifiedDate = dateTime; citys.ModifiedBy = model.ModifiedBy; citys.ModifiedDate = DateTime.UtcNow; db.Entry(citys).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } Responce.ResponeContent = true; } else { Responce.ResponeContent = false; Responce.Success = false; Responce.Message = "Admin email is not register"; } } } catch (Exception ex) { Responce.Success = false; Responce.ResponeContent = false; Responce.Message = $"ERROR UpsertCity :{ex.InnerException}"; } return(Responce); }
public async Task <IHttpActionResult> UpdateCity(CityDTO citydto) { Responce <bool> responce = new Responce <bool>(); try { using (var db = new SSCEntities()) { var CheckCity = db.Citys.Find(citydto.Id); if (CheckCity == null) { responce.ResponeContent = false; responce.Success = false; responce.Message = "This city should not exist"; return(Content(HttpStatusCode.BadRequest, responce)); } var GetDefaultCityAdminUser = db.AspNetUsers.Where(a => a.IsDefaultAdmin == true && a.CityId == citydto.Id)?.FirstOrDefault(); if (GetDefaultCityAdminUser != null) { var appUser = await UserManager.FindByNameAsync(GetDefaultCityAdminUser.UserName); if (appUser != null) { if (appUser.UserName.ToLower() != citydto.AdminEmail.ToLower()) { appUser.UserName = citydto.AdminEmail; appUser.Email = citydto.AdminEmail; //appUser.City = citydto.CityName; //appUser.CityId = citydto.Id; IdentityResult result = await UserManager.UpdateAsync(appUser); if (!result.Succeeded) { var Errors = GetIdentityErrorResult(result); responce.Fail(Errors); responce.ResponeContent = false; return(Content(HttpStatusCode.BadRequest, responce)); } } } } DateTime dateTime = DateTime.UtcNow; Citys citys = CheckCity; citys.MCEmail = citydto.MCEmail; citys.FcciEmail = citydto.FcciEmail; citys.CountryId = citydto.CountryId ?? 1; citys.CityName = citydto.CityName; citys.IsActive = citydto.IsActive; citys.AdminEmail = citydto.AdminEmail; citys.ModifiedBy = citydto.ModifiedBy; citys.ModifiedDate = dateTime; db.Entry(citys).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); List <AspNetUsers> aspNetUsers = new List <AspNetUsers>(); aspNetUsers = db.AspNetUsers.Where(a => a.CityId == citys.Id).ToList(); foreach (var item in aspNetUsers) { item.City = citys.CityName; db.Entry(item).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); } responce.Success = true; responce.ResponeContent = true; } return(Ok(responce)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task <IHttpActionResult> CreateCity(CityDTO citydto) { Responce <bool> responce = new Responce <bool>(); try { var IsUserExist = await UserManager.FindByNameAsync(citydto.AdminEmail); if (IsUserExist != null) { var Errors = "User email already registered."; responce.Fail(Errors); responce.ResponeContent = false; return(Content(HttpStatusCode.BadRequest, responce)); } using (var db = new SSCEntities()) { var CheckCity = db.Citys.Where(a => a.CityName.ToLower() == citydto.CityName.ToLower())?.ToList() ?? new List <Citys>(); if (CheckCity.Count > 0) { responce.ResponeContent = false; responce.Success = false; responce.Message = "City already added"; return(Content(HttpStatusCode.BadRequest, responce)); } DateTime dateTime = DateTime.UtcNow; Citys citys = new Citys(); citys.MCEmail = citydto.MCEmail; citys.FcciEmail = citydto.FcciEmail; citys.CityName = citydto.CityName; citys.IsActive = citydto.IsActive; citys.AdminEmail = citydto.AdminEmail; citys.CreatedBy = citydto.CreatedBy; citys.CreatedDate = dateTime; citys.ModifiedBy = citydto.ModifiedBy; citys.ModifiedDate = dateTime; db.Entry(citys).State = System.Data.Entity.EntityState.Added; await db.SaveChangesAsync(); var lows = db.Lows.ToList(); SSCEntities sscEntities = new SSCEntities(); foreach (var item in lows) { CityLows cityLows = new CityLows(); cityLows.Id = citys.Id; cityLows.LowId = item.Id; sscEntities.Entry(cityLows).State = System.Data.Entity.EntityState.Added; await sscEntities.SaveChangesAsync(); } var user = new ApplicationUser() { UserName = citydto.AdminEmail, Email = citydto.AdminEmail, City = citydto.CityName, PhoneNumber = citydto.MobileNo, Name = citydto.UserName, IsDefaultAdmin = true, CityId = citys.Id }; IdentityResult result = await UserManager.CreateAsync(user, citydto.Password); if (!result.Succeeded) { var Errors = GetIdentityErrorResult(result); responce.Fail(Errors); responce.ResponeContent = false; return(Content(HttpStatusCode.BadRequest, responce)); } db.UpdateUserRole("989D2937-0FC5-497D-980C-B2E8583602B9", user.Id); responce.ResponeContent = true; responce.Success = true; } return(Ok(responce)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
private void містаToolStripMenuItem_Click(object sender, EventArgs e) { Citys city = new Citys(mysqlCSB); city.Show(); }