protected override void OnExecute(ThermoryContext context)
{
foreach (var command in _commands)
{
command.Execute(context);
}
}
protected override void OnExecute(ThermoryContext context)
{
Result =
context.MiscellaneousCategories.Include(
c => c.MiscellaneousSubCategories.Select(s => s.MiscellaneousProducts))
.ToList();
}
protected override void OnExecute(ThermoryContext context)
{
Result =
context.LumberCategories.Include(
c => c.LumberSubCategories.Select(s => s.LumberTypes.Select(t => t.LumberProducts)))
.ToList();
}
protected override void OnExecute(ThermoryContext context)
{
if (_result == null)
{
_result = context.OrderTypes.ToList();
}
Result = _result;
}
protected override void OnBeforeExecute(ThermoryContext context)
{
base.OnBeforeExecute(context);
if (_model.Id != Guid.Empty)
{
return;
}
_model.SortOrder = context.MiscellaneousCategories.Select(c => c.SortOrder).Max() + 1;
}
protected override void OnBeforeExecute(ThermoryContext context)
{
if (_transaction.Order != null)
{
_transaction.OrderId = _transaction.Order.Id;
_transaction.Order = null;
}
base.OnBeforeExecute(context);
}
protected override void OnExecute(ThermoryContext context)
{
var dbMiscellaneousProduct = context.MiscellaneousProducts.SingleOrDefault(lp => lp.Id == _miscProduct.Id);
if (dbMiscellaneousProduct == null)
{
return;
}
dbMiscellaneousProduct.Quantity = _miscProduct.Quantity;
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
if (_model.Id == Guid.Empty)
{
context.LumberProducts.Add(_model);
}
else
{
context.Entry(_model).State = EntityState.Modified;
}
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
if (_order.Id == Guid.Empty)
{
context.Orders.Add(_order);
}
else
{
context.Entry(_order).State = EntityState.Modified;
}
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
if (_model.Id == Guid.Empty)
{
context.MiscellaneousCategories.Add(_model);
}
else
{
context.Entry(_model).State = EntityState.Modified;
}
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
if (_packagingType.Id == Guid.Empty)
{
context.PackagingTypes.Add(_packagingType);
}
else
{
context.Entry(_packagingType).State = EntityState.Modified;
}
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
var lineItem = new OrderMiscellaneousLineItem
{
OrderId = _order.Id,
MiscellaneousProductId = _miscellaneousProductId,
Quantity = _quantity
};
context.OrderMiscellaneousLineItems.Add(lineItem);
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
var lineItem = new OrderLumberLineItem
{
OrderId = _order.Id,
LumberProductId = _lumberProductId,
Quantity = _quantity
};
context.OrderLumberLineItems.Add(lineItem);
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
if (_address.Id == Guid.Empty)
{
context.CustomerAddresses.Add(_address);
}
else
{
context.Entry(_address).State = EntityState.Modified;
}
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
var dbPackage = context.Packages.SingleOrDefault(p => p.Id == _package.Id);
if (dbPackage == null)
{
return;
}
dbPackage.Height = _package.Height;
dbPackage.Length = _package.Length;
dbPackage.Width = _package.Width;
context.SaveChanges();
}
protected override void OnBeforeExecute(ThermoryContext context)
{
base.OnBeforeExecute(context);
if (_model.Id != Guid.Empty)
{
return;
}
var existingMiscellaneousProducts =
context.MiscellaneousProducts.Where(c => c.MiscellaneousSubCategoryId == _model.MiscellaneousSubCategoryId);
_model.SortOrder = existingMiscellaneousProducts.Any()
? existingMiscellaneousProducts.Select(c => c.SortOrder).Max() + 1
: 1;
}
protected override void OnBeforeExecute(ThermoryContext context)
{
base.OnBeforeExecute(context);
if (_model.Id != Guid.Empty)
{
return;
}
var existingLumberTypes =
context.LumberTypes.Where(c => c.LumberSubCategoryId == _model.LumberSubCategoryId);
_model.SortOrder = existingLumberTypes.Any()
? existingLumberTypes.Select(c => c.SortOrder).Max() + 1
: 1;
}
protected override void OnExecute(ThermoryContext context)
{
Result =
context.Packages
.Include(p => p.Order.PackagingType)
.Include(p => p.Order.Customer)
.Include(
p =>
p.PackageLumberLineItems.Select(
li => li.LumberProduct.LumberType.LumberSubCategory.LumberCategory))
.Include(
p =>
p.PackageMiscellaneousLineItems.Select(
li => li.MiscellaneousProduct.MiscellaneousSubCategory))
.SingleOrDefault(p => p.Id == _id);
}
protected override void OnBeforeExecute(ThermoryContext context)
{
_order.CustomerId = _order.Customer == null ? null : (Guid?)_order.Customer.Id;
_order.PackagingTypeId = _order.PackagingType == null ? null : (Guid?)_order.PackagingType.Id;
_order.OrderTypeId = _order.OrderType.Id;
_order.ShipToAddressId = _order.ShipToAddress == null ? null : (Guid?)_order.ShipToAddress.Id;
_order.Customer = null;
_order.PackagingType = null;
_order.OrderStatus = null;
_order.OrderType = null;
_order.OrderLumberLineItems = null;
_order.OrderMiscellaneousLineItems = null;
_order.Packages = null;
_order.ShipToAddress = null;
}
protected override void OnExecute(ThermoryContext context)
{
Result = context.InventoryTransactions
.Include(t => t.TransactionType)
.Include(t => t.Order.OrderType)
.Include(t => t.CreatedBy)
.Include(
t =>
t.LumberTransactionDetails.Select(
d => d.LumberProduct.LumberType.LumberSubCategory.LumberCategory))
.Include(
t =>
t.MiscellaneousTransactionDetails.Select(
d => d.MiscellaneousProduct.MiscellaneousSubCategory.MiscellaneousCategory))
.Where(t => t.OrderId == _orderId)
.OrderBy(t => t.CreatedOn)
.ToList();
}
protected override void OnExecute(ThermoryContext context)
{
var lumberProduct = context.LumberProducts.Single(p => p.Id == _lumberProductId);
if (_newQuantity == lumberProduct.Quantity)
{
return;
}
var detail = new LumberTransactionDetail
{
InventoryTransactionId = _transaction.Id,
LumberProductId = _lumberProductId,
NewQuantity = _newQuantity,
PreviousQuantity = lumberProduct.Quantity
};
context.LumberTransactionDetails.Add(detail);
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
var miscProduct = context.MiscellaneousProducts.Single(p => p.Id == _miscProductId);
if (_newQuantity == miscProduct.Quantity)
{
return;
}
var detail = new MiscellaneousTransactionDetail
{
InventoryTransactionId = _transaction.Id,
MiscellaneousProductId = _miscProductId,
NewQuantity = _newQuantity,
PreviousQuantity = miscProduct.Quantity
};
context.MiscellaneousTransactionDetails.Add(detail);
context.SaveChanges();
}
public void Execute(ThermoryContext context)
{
try
{
OnBeforeExecute(context);
OnExecute(context);
OnAfterExecute(context);
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var fullErrorMessage = string.Join("\n", errorMessages);
HandleException(context, new Exception(fullErrorMessage));
}
catch (Exception ex)
{
HandleException(context, ex);
}
}
protected override void OnExecute(ThermoryContext context)
{
if (_delta == 0)
{
return;
}
var lumberProduct = context.LumberProducts.Single(p => p.Id == _lumberProductId);
var newQuantity = lumberProduct.Quantity + _delta;
if (_transaction != null)
{
var command = new CreateLumberTransactionDetails(_transaction, _lumberProductId, newQuantity);
command.Execute(context);
}
if (!_applyQuantityChanges)
{
return;
}
lumberProduct.Quantity = newQuantity;
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
context.PackageLumberLineItems.Add(_lineItem);
context.SaveChanges();
}
protected override void OnBeforeExecute(ThermoryContext context)
{
_lineItem.PackageId = _lineItem.Package.Id;
base.OnBeforeExecute(context);
}
protected override void OnExecute(ThermoryContext context)
{
Result = context.LumberProducts.ToList();
}
protected override void OnExecute(ThermoryContext context)
{
Result = context.Customers.Include(c => c.Addresses).OrderBy(c => c.Name).ToList();
}
protected override void OnExecute(ThermoryContext context)
{
context.OrderLumberLineItems.Attach(_lineItem);
context.OrderLumberLineItems.Remove(_lineItem);
context.SaveChanges();
}
protected override void OnExecute(ThermoryContext context)
{
Result = context.UserRoles.Include(ur => ur.WebPageRole).Where(ur => ur.UserId == _userId).OrderBy(ur => ur.WebPageRole.RoleName).ToList();
}
