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 static void Seed(CustomerAppDBContext context)
{
context.Customers.Add(new Customer
{
Firstname = "Lars",
Lastname = "Bilde",
Address = "Uhhahahstrasse1",
EMail = "jumbaimba.org"
}
);
context.SaveChanges();
}
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
}
});
}
public Country Create(Country country)
{
var entry = _ctx.Countries.Add(new CountrySql
{
Id = country.Id,
Name = country.Name
});
_ctx.SaveChanges();
return(new Country
{
Id = entry.Entity.Id,
Name = entry.Entity.Name
});
}
