//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 retrieve a single Legal Entity public LegalEntity GetSingleLegalEntity(int id) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { LegalEntity LegalEntityToFind = (from l in context.LegalEntities where l.id == id select l).FirstOrDefault(); return(LegalEntityToFind); } }
//Method to retrieve a single Legal Entity public LegalEntity GetSingleLegalEntity(int id) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { LegalEntity LegalEntityToFind = (from l in context.LegalEntities where l.id == id select l).FirstOrDefault(); return LegalEntityToFind; } }
//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 retrieve a single address public Address GetSingleAddress(int id) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { /* Address addressToFind = (from a in context.Addresses * where a.ID == id * select a).FirstOrDefault();*/ Address addressToFind = context.Addresses.First(a => a.ID == id); return(addressToFind); } }
//Retrieve all addresses method public List <Address> GetAddresses() { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { List <Address> allAddresses = new List <Address>(); foreach (Address a in context.Addresses) { allAddresses.Add(a); } return(allAddresses); } }
//Method to retrieve a single address public Address GetSingleAddress(int id) { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { /* Address addressToFind = (from a in context.Addresses where a.ID == id select a).FirstOrDefault();*/ Address addressToFind = context.Addresses.First(a => a.ID == id); return addressToFind; } }
//Retrieve all addresses method public List<Address> GetAddresses() { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { List<Address> allAddresses = new List<Address>(); foreach (Address a in context.Addresses) { allAddresses.Add(a); } return allAddresses; } }
//Retrieve all Legal Entities method public List <LegalEntity> GetLegalEntities() { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { List <LegalEntity> allLegalEntities = new List <LegalEntity>(); foreach (LegalEntity l in context.LegalEntities) { allLegalEntities.Add(l); } return(allLegalEntities); } }
//Retrieve all Legal Entities method public List<LegalEntity> GetLegalEntities() { using (TradingDatabaseEntities context = new TradingDatabaseEntities()) { List<LegalEntity> allLegalEntities = new List<LegalEntity>(); foreach (LegalEntity l in context.LegalEntities) { allLegalEntities.Add(l); } return allLegalEntities; } }
//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(); } } }