public async Task <IHttpActionResult> Putcitys(int id, citys citys)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != citys.id)
{
return(BadRequest());
}
db.Entry(citys).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!citysExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> Getcitys(int id)
{
citys citys = await db.citys.FindAsync(id);
if (citys == null)
{
return(NotFound());
}
return(Ok(citys));
}
public async Task <IHttpActionResult> Postcitys(citys citys)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.citys.Add(citys);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = citys.id }, citys));
}
public async Task <IHttpActionResult> Deletecitys(int id)
{
citys citys = await db.citys.FindAsync(id);
if (citys == null)
{
return(NotFound());
}
db.citys.Remove(citys);
await db.SaveChangesAsync();
return(Ok(citys));
}
public bool UpdateCityName(citys city)
{
using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities())
{
var currentCity = _context.citys.FirstOrDefault(l => l.Unique == city.Unique);
if (currentCity is null)
{
return(false);
}
currentCity.Name = city.Name;
_context.SaveChanges();
return(true);
}
}
public string GetNewRegionUnique(citys city)
{
using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities())
{
var cityCodeSrt = city.Unique.Substring(0, 4);
var newRegionCode = 1;
var lastRegion = _context.regions.Where(l => l.CityId == city.Id).OrderByDescending(l => l.Id).FirstOrDefault();
if (lastRegion != null)
{
newRegionCode = Convert.ToInt32(lastRegion.Unique.Substring(4, 2)) + 1;
}
var newRegionCodeStr = newRegionCode.ToString();
if (newRegionCodeStr.Length == 1)
{
newRegionCodeStr = "0" + newRegionCodeStr;
}
var newUnique = cityCodeSrt + newRegionCodeStr;
return(newUnique);
}
}
public bool AddCity(string provinceUnique, string cityName)
{
using (deyouyun_levellink_devEntities _context = new deyouyun_levellink_devEntities())
{
var province = _context.provinces.FirstOrDefault(l => l.Unique == provinceUnique);
if (province is null)
{
return(false);
}
var cityUnique = GetNewCityUniqueCode(province);
var newCity = new citys()
{
Unique = cityUnique,
Name = cityName,
ProvinceId = province.Id
};
_context.citys.Add(newCity);
_context.SaveChanges();
return(true);
}
}
private void metroTile8_Click(object sender, EventArgs e)
{
citys c = new citys();
c.Show();
}
