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