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