//Create new legal entity public void CreateLegalEntity(LegalEntity legalEntity) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { if (legalEntity == null) { context.LegalEntities.Add(legalEntity); context.SaveChanges(); } } }
//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 delete a Legal Entity public void DeleteLegalEntity(int id) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { LegalEntity legalEntityToDelete = (from l in context.LegalEntities where l.id == id select l).FirstOrDefault(); if (legalEntityToDelete != null) { context.LegalEntities.Remove(legalEntityToDelete); context.SaveChanges(); } } }
//Method to delete an address public void DeleteAddress(int id) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { Address addressToDelete = (from a in context.Addresses where a.ID == id select a).FirstOrDefault(); if (addressToDelete != null) { context.Addresses.Remove(addressToDelete); context.SaveChanges(); } } }
//Method to update an existing legal entity public void UpdateLegalEntity(int id, LegalEntity newLegalEntity) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { LegalEntity legalEntityToUpdate = (from l in context.LegalEntities where l.id == id select l).FirstOrDefault(); if (newLegalEntity != null) { legalEntityToUpdate.Name = legalEntityToUpdate.Name; legalEntityToUpdate.Address = legalEntityToUpdate.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(); } } }