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