public override Elements.IElement <Data.Entities.Person> Save()
{
if (_resource.Id == Guid.Empty || _resource.Id == null)
{
_resource.Id = Guid.NewGuid();
}
foreach (var address in _resource.Addresses)
{
if (address.PersonId == Guid.Empty || address.PersonId == null)
{
address.PersonId = Guid.NewGuid();
}
}
lock ( _cust_writeLock ) {
using (var context = new Data.PizzaBoxDbContext()) {
if (context.People.Find(_resource.Id) == null)
{
context.Entry(_resource);
context.Attach <Data.Entities.Person> (_resource);
context.Add <Data.Entities.Person> (_resource);
}
context.SaveChanges();
}
}
return(new Customer(_resource));
}
protected override Elements.Customer Read(Elements.CustomerQuery entityArgs)
{
if (entityArgs == Elements.CustomerQuery.Empty)
{
return(Elements.Customer.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.Id != null && entityArgs.Id != Guid.Empty)
{
return(new Elements.Customer(context.People.Find(entityArgs.Id)));
}
else if (entityArgs.Email != null && entityArgs.Email != String.Empty)
{
return(new Elements.Customer
((from rec in context.People where rec.Email == entityArgs.Email select rec).FirstOrDefault()));
}
else
{
return(Elements.Customer.Empty);
}
}
}
}
protected override Elements.Order Read(Elements.OrderQuery entityArgs)
{
if (entityArgs == Elements.OrderQuery.Empty)
{
return(Elements.Order.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.Id != null && entityArgs.Id != Guid.Empty)
{
return(new Elements.Order(context.Orders.Find(entityArgs.Id)));
}
else if (entityArgs.OutletId != null && entityArgs.OutletId != Guid.Empty)
{
return(new Elements.Order
((from rec in context.Orders where rec.OutletId == entityArgs.OutletId select rec).FirstOrDefault()));
}
else if (entityArgs.PersonId != null && entityArgs.PersonId != Guid.Empty)
{
return(new Elements.Order
((from rec in context.Orders where rec.PersonId == entityArgs.PersonId select rec).FirstOrDefault()));
}
else if (entityArgs.DateOrdered != null)
{
return(new Elements.Order
((from rec in context.Orders where rec.DateOrdered == entityArgs.DateOrdered select rec).FirstOrDefault()));
}
else
{
return(Elements.Order.Empty);
}
}
}
}
protected override Elements.Product Read(Elements.ProductQuery entityArgs)
{
if (entityArgs == Elements.ProductQuery.Empty)
{
return(Elements.Product.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.Id != null && entityArgs.Id != Guid.Empty)
{
return(new Elements.Product(context.Items.Find(entityArgs.Id)));
}
else if (entityArgs.Name != null && entityArgs.Name != String.Empty)
{
return(new Elements.Product(
(from rec in context.Items where rec.Name == entityArgs.Name select rec).FirstOrDefault()));
}
else if (entityArgs.Features != null && entityArgs.Features != String.Empty)
{
return(new Elements.Product(
(from rec in context.Items where rec.Features == entityArgs.Features select rec).FirstOrDefault()));
}
else
{
return(Elements.Product.Empty);
}
}
}
}
protected override Elements.SalesTax Read(Elements.TaxQuery entityArgs)
{
if (entityArgs == Elements.TaxQuery.Empty)
{
return(Elements.SalesTax.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.Id != null && entityArgs.Id != Guid.Empty)
{
return(new Elements.SalesTax(context.StateTaxes.Find(entityArgs.Id)));
}
else if (entityArgs.Territory != null && entityArgs.Territory != String.Empty)
{
return(new Elements.SalesTax
((from rec in context.StateTaxes where rec.Territory == entityArgs.Territory select rec).FirstOrDefault()));
}
else
{
return(Elements.SalesTax.Empty);
}
}
}
}
protected override Elements.Business Read(Elements.BusinessQuery entityArgs)
{
if (entityArgs == Elements.BusinessQuery.Empty)
{
return(Elements.Business.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.Id != null && entityArgs.Id != Guid.Empty)
{
return(new Elements.Business(context.Outlets.Find(entityArgs.Id)));
}
else if (entityArgs.Name != null && entityArgs.Name != string.Empty)
{
return(new Elements.Business
((from rec in context.Outlets where rec.Organization == entityArgs.Name select rec).FirstOrDefault()));
}
else
{
return(Elements.Business.Empty);
}
}
}
}
protected override Elements.Employee Read(Elements.EmployeeQuery entityArgs)
{
if (entityArgs == Elements.EmployeeQuery.Empty)
{
return(Elements.Employee.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.Id != null && entityArgs.Id != Guid.Empty)
{
return(new Elements.Employee(context.Employees.Find(entityArgs.Id)));
}
else if (entityArgs.Username != null && entityArgs.Username != string.Empty)
{
return(new Elements.Employee
((from rec in context.Employees where rec.Username == entityArgs.Username select rec).FirstOrDefault()));
}
else
{
return(Elements.Employee.Empty);
}
}
}
}
public override void Delete()
{
lock ( _cust_writeLock ) {
using (var context = new Data.PizzaBoxDbContext()) {
context.Remove <Data.Entities.Person> (_resource);
context.SaveChanges();
}
}
}
protected override HashSet <Elements.Order> ReadAll()
{
using (var context = new Data.PizzaBoxDbContext()) {
var result = new HashSet <Elements.Order> ();
foreach (var record in context.Orders)
{
result.Add(new Elements.Order(record));
}
return(result);
}
}
protected override HashSet <Elements.SalesTax> ReadAll()
{
using (var context = new Data.PizzaBoxDbContext()) {
var result = new HashSet <Elements.SalesTax> ();
foreach (var record in context.StateTaxes)
{
result.Add(new Elements.SalesTax(record));
}
return(result);
}
}
public override Elements.IElement <Data.Entities.Address> Save()
{
if (_resource.Id == Guid.Empty || _resource.Id == null)
{
_resource.Id = Guid.NewGuid();
}
lock ( _addr_writeLock ) {
using (var context = new Data.PizzaBoxDbContext()) {
if (context.Addresses.Find(_resource.Id) == null)
{
context.Entry(_resource);
context.Attach(_resource);
context.Add <Data.Entities.Address> (_resource);
}
context.SaveChanges();
}
}
return(new Address(_resource));
}
protected override Elements.Address Read(Elements.AddressQuery entityArgs)
{
if (entityArgs == Elements.AddressQuery.Empty)
{
return(Elements.Address.Empty);
}
else
{
using (var context = new Data.PizzaBoxDbContext()) {
if (entityArgs.AddressId != null && entityArgs.AddressId != Guid.Empty)
{
return(new Elements.Address(context.Addresses.Find(entityArgs.AddressId)));
}
else if (
entityArgs.State != String.Empty &&
entityArgs.City != String.Empty &&
entityArgs.Street != String.Empty &&
entityArgs.Zip != String.Empty &&
entityArgs.Apartment != String.Empty
)
{
return(new Elements.Address(
(from rec in context.Addresses where
rec.State != entityArgs.State &&
rec.City != entityArgs.City &&
rec.Street != entityArgs.State &&
rec.Zip != entityArgs.Zip &&
rec.Apt != entityArgs.Apartment
select rec).FirstOrDefault()));
}
else
{
return(Elements.Address.Empty);
}
}
}
}
public override Elements.IElement <Data.Entities.Outlet> Save()
{
if (_resource.Id == Guid.Empty || _resource.Id == null)
{
_resource.Id = Guid.NewGuid();
}
foreach (var address in _resource.Addresses)
{
if (address.Id == Guid.Empty || address.Id == null)
{
address.Id = Guid.NewGuid();
}
}
foreach (var employee in _resource.Employees)
{
if (employee.Id == Guid.Empty || employee.Id == null)
{
employee.Id = Guid.NewGuid();
}
}
foreach (var feature in _resource.Features)
{
if (feature.Id == Guid.Empty || feature.Id == null)
{
feature.Id = Guid.NewGuid();
}
}
foreach (var item in _resource.Items)
{
if (item.Id == Guid.Empty || item.Id == null)
{
item.Id = Guid.NewGuid();
}
}
foreach (var order in _resource.Orders)
{
if (order.Id == Guid.Empty || order.Id == null)
{
order.Id = Guid.NewGuid();
}
}
lock ( _biz_writeLock ) {
using (var context = new Data.PizzaBoxDbContext()) {
if (context.Outlets.Find(_resource.Id) == null)
{
context.Entry(_resource);
context.Attach(_resource);
context.Add <Data.Entities.Outlet> (_resource);
}
context.SaveChanges();
}
}
return(new Business(_resource));
}
