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