public async Task <IActionResult> PutAddress(int id, Address address)
{
if (id != address.addressId)
{
return(BadRequest());
}
_context.Entry(address).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AddressExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public virtual void Update(TEntity entity)
{
try
{
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IHttpActionResult> PutAddressModels(int id, AddressModels addressModels)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != addressModels.AddressId)
{
return(BadRequest());
}
db.Entry(addressModels).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AddressModelsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit([Bind(Include = "StreetPrefixId,Prefix")] StreetPrefix streetPrefix)
{
if (ModelState.IsValid)
{
db.Entry(streetPrefix).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(streetPrefix));
}
public void ExplicitLoadding()
{
using (var db = new AddressContext())
{
var citys = db.CityInfo
.Single(x => x.CityCode == 1);
db.Entry(citys)
.Collection(b => b.County)
.Load();
}
}
public async Task <IActionResult> PutAddress(int id, Address address)
{
if (id != address.addressId)
{
return(BadRequest());
}
if (!AddressExists(id))
{
return(BadRequest());
}
var updateAddress = await _context.Address.FirstOrDefaultAsync(a => a.studentId == address.studentId);
_context.Entry(updateAddress).State = EntityState.Modified;
updateAddress.streetNumber = address.streetNumber;
updateAddress.street = address.street;
updateAddress.suburb = address.suburb;
updateAddress.city = address.city;
updateAddress.postcode = address.postcode;
updateAddress.country = address.country;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AddressExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void CreatePointTest()
{
var allAddresses = _target.Addresses
.Where(x => x.Point == null)
.ToList();
void UpdateAddressWithPoint(Domain.Model.Address obj)
{
if (!obj.Latitude.HasValue || !obj.Longitude.HasValue)
{
return;
}
obj.Point = new Point(obj.Latitude.Value, obj.Longitude.Value);
_target.Attach(obj);
_target.Entry(obj).State = EntityState.Modified;
}
allAddresses.ForEach(UpdateAddressWithPoint);
_target.SaveChanges();
}
public async Task <IActionResult> UpdateAddress(int id, Address address)
{
if (id != address.addressId)
{
return(BadRequest());
}
_context.Entry(address).State = EntityState.Modified;
var todoItem = await _context.Address.FindAsync(id);
if (todoItem == null)
{
return(NotFound());
}
todoItem.addressId = address.addressId;
//todoItem.IsComplete = todoItemDTO.IsComplete;
try
{
await _context.SaveChangesAsync();
}
//catch (DbUpdateConcurrencyException)
catch (DbUpdateConcurrencyException) when(!AddressExists(id))
{
if (!AddressExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
