//Method to create a new address public void CreateAddress(Address address) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { if (address == null) { context.Addresses.Add(address); context.SaveChanges(); } } }
//Method to update an existing address public void UpdateAddress(int id, Address newAddress) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { Address addressToUpdate = (from a in context.Addresses where a.ID == id select a).FirstOrDefault(); if (newAddress != null) { addressToUpdate.Line_1 = newAddress.Line_1; addressToUpdate.Line_2 = newAddress.Line_2; addressToUpdate.Line_3 = newAddress.Line_3; addressToUpdate.City = newAddress.City; addressToUpdate.Country = newAddress.Country; addressToUpdate.Postcode = newAddress.Postcode; context.SaveChanges(); } } }
//Update address public void UpdateAddress(int id, Address address) { db.UpdateAddress(id, address); }
//Create address public void CreateAddress(Address address) { db.CreateAddress(address); }