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