public Address Create(Address address)
{
//_ctx.DetachAll();
//_ctx.Attach(address.City).State = EntityState.Unchanged;
var addressEntry = _ctx.Add(new AddressSql
{
Id = address.Id,
Additional = address.Additional,
CityId = address.City?.ZipCode ?? 0,
StreetName = address.StreetName,
StreetNr = address.StreetNr
});
_ctx.SaveChanges();
return(new Address()
{
Id = addressEntry.Entity.Id,
Additional = addressEntry.Entity.Additional,
City = new City()
{
ZipCode = addressEntry.Entity.CityId
},
StreetName = addressEntry.Entity.StreetName,
StreetNr = addressEntry.Entity.StreetNr
});
}
public City Create(City city)
{
try
{
var cityEntry = _ctx.Add(_mapper.Map <City, CitySql>(city));
_ctx.SaveChanges();
var newCity = cityEntry.Entity;
return(_mapper.Map <CitySql, City>(newCity));
}
catch (Exception e)
{
throw new DataSourceException(e.InnerException?.Message);
}
}
public Customer Create(Customer customer)
{
//_ctx.Attach(customer.Address).State = EntityState.Unchanged;
var customerEntity = new CustomerSql
{
FirstName = customer.FirstName,
LastName = customer.LastName,
AddressId = customer.Address.Id
};
var customerEntry = _ctx.Add(customerEntity);
_ctx.SaveChanges();
return(new Customer
{
Id = customerEntry.Entity.Id,
LastName = customerEntry.Entity.LastName,
FirstName = customerEntry.Entity.FirstName,
Address = new Address
{
Id = customer.Address.Id
}
});
}