/// <summary>
/// Enter a new order into db
/// </summary>
/// <param name="appOrder"></param>
public void CreateOrder(Order appOrder)
{
using var context = new P1DbContext(_contextOptions);
//map library order to db
var dbOrder = new OrderEntity()
{
Store = context.Stores.First(s => s.Id == appOrder.TargetStore.Id),
Customer = context.Customers.First(c => c.Id == appOrder.Orderer.Id),
Time = appOrder.Time
};
//map all items in the order to db
foreach (Product selection in appOrder.Selections)
{
//create a new item, Store = null unless item is part of an inventory
var dbOrderItems = new OrderItemsEntity()
{
Product = context.Products.First(p => p.Name == selection.Name),
Quantity = selection.Quantity,
Order = dbOrder
};
context.Add(dbOrderItems);
}
context.Add(dbOrder);
context.SaveChanges();
}
public bool Delete(Guid Id)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
OrderItemsEntity _OrderItemsEntity = new OrderItemsEntity(Id);
if (adapter.FetchEntity(_OrderItemsEntity))
{
adapter.DeleteEntity(_OrderItemsEntity);
toReturn = true;
}
}
return toReturn;
}
public static OrderItemsEntity Mapper(OrderItemsModel oim)
{
if (oim != null)
{
OrderItemsEntity oie = new OrderItemsEntity
{
Id = oim.Id,
Quantity = oim.Quantity,
SellerId = oim.Seller.Id,
SkuId = oim.Sku.Id,
OrderId = oim.Order.Id
};
return(oie);
}
return(null);
}
public static OrderItemsModel Mapper(OrderItemsEntity oie)
{
if (oie != null)
{
OrderItemsModel oim = new OrderItemsModel
{
Id = oie.Id,
Quantity = oie.Quantity,
Seller = UserMapper.Mapper(oie.Seller),
Sku = SkuMapper.Mapper(oie.Sku),
Order = OrderMapper.Mapper(oie.Order)
};
return(oim);
}
return(null);
}
public static List <OrderItemsEntity> Mapper(List <OrderItemsModel> oimList)
{
if (oimList != null)
{
List <OrderItemsEntity> oieList = new List <OrderItemsEntity>();
foreach (var oim in oimList)
{
OrderItemsEntity oie = new OrderItemsEntity
{
Id = oim.Id,
Quantity = oim.Quantity,
SellerId = oim.Seller.Id,
SkuId = oim.Sku.Id,
OrderId = oim.Order.Id
};
oieList.Add(oie);
}
;
return(oieList);
}
return(null);
}
OrderItemsEntity getOrderItem(OrdersEntity order)
{
OrderItemsEntity orderItem = new OrderItemsEntity();
orderItem.Id = Guid.NewGuid();
orderItem.OrderId = order.Id;
orderItem.TotalAmountBeforeTax = order.TotalAmountBeforeTax;
orderItem.TotalAmountAfterTax = order.TotalAmountAfterTax;
orderItem.TotalDiscount = order.TotalDiscount;
orderItem.SupplierId = CartsSession.CreateInstant().GetCarts(Page)[0].SupplierId;
orderItem.TotalCommission = 0;
orderItem.TotalToSupplier = 0;
return orderItem;
}
OrderDetailEntity[] getOrderDetail(OrderItemsEntity item)
{
List<CartItem> carts = CartsSession.CreateInstant().GetCarts(Page);
OrderDetailEntity[] details = new OrderDetailEntity[carts.Count];
for (int i = 0; i < carts.Count; i++)
{
details[i] = new OrderDetailEntity();
details[i].Id = Guid.NewGuid();
if (carts[i].ProductParentId == Guid.Empty)
{
ProductsEntity product = ProductsManager.CreateInstant().SelectOne(carts[i].ProductId, true);
if (product != null)
{
int cnt = carts[i].Total;
if (cnt > Config.GetMaxItemInCart())
cnt = Config.GetMaxItemInCart();
details[i].ProductId = product.Id;
details[i].ProductName = product.ProductName;
details[i].OrderItemId = item.Id;
details[i].PriceBeforeTax = 0;
details[i].PriceAfterTax = product.Price;
details[i].Amount = cnt;
details[i].PoPrice = product.ProductInfo.PriceBuy;
details[i].ProductCode = product.ProductCode;
}
}
else
{
ProductsEntity product = ProductsManager.CreateInstant().SelectOne(carts[i].ProductParentId, true);
ProductSubEntity sub = ProductSubManager.CreateInstant().SelectOne(carts[i].ProductId);
if (product != null && sub != null)
{
int cnt = carts[i].Total;
if (cnt > Config.GetMaxItemInCart())
cnt = Config.GetMaxItemInCart();
details[i].ProductId = product.Id;
details[i].OrderItemId = item.Id;
details[i].PriceBeforeTax = 0;
details[i].PriceAfterTax = sub.Price;
details[i].Amount = cnt;
details[i].PoPrice = product.ProductInfo.PriceBuy;
details[i].ProductSubId = sub.Id;
details[i].ProductName = product.ProductName + " - " + sub.ProductName;
details[i].ProductCode = product.ProductCode;
}
}
}
return details;
}
public OrderItemsEntity Insert(Guid OrderId, Guid SupplierId, decimal TotalAmountBeforeTax, decimal TotalAmountAfterTax, decimal TotalDiscount, decimal TotalToSupplier, bool PaidComplete, decimal TotalCommission, string CreatedBy, DateTime CreatedDate, string UpdatedBy, DateTime UpdatedDate)
{
OrderItemsEntity _OrderItemsEntity = new OrderItemsEntity();
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
_OrderItemsEntity.OrderId = OrderId;
_OrderItemsEntity.SupplierId = SupplierId;
_OrderItemsEntity.TotalAmountBeforeTax = TotalAmountBeforeTax;
_OrderItemsEntity.TotalAmountAfterTax = TotalAmountAfterTax;
_OrderItemsEntity.TotalDiscount = TotalDiscount;
_OrderItemsEntity.TotalToSupplier = TotalToSupplier;
_OrderItemsEntity.PaidComplete = PaidComplete;
_OrderItemsEntity.TotalCommission = TotalCommission;
_OrderItemsEntity.CreatedBy = CreatedBy;
_OrderItemsEntity.CreatedDate = CreatedDate;
_OrderItemsEntity.UpdatedBy = UpdatedBy;
_OrderItemsEntity.UpdatedDate = UpdatedDate;
adapter.SaveEntity(_OrderItemsEntity, true);
}
return _OrderItemsEntity;
}
public OrderItemsEntity Insert(OrderItemsEntity _OrderItemsEntity)
{
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.SaveEntity(_OrderItemsEntity, true);
}
return _OrderItemsEntity;
}
public bool Update(OrderItemsEntity _OrderItemsEntity, RelationPredicateBucket filter)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
adapter.UpdateEntitiesDirectly(_OrderItemsEntity, filter);
toReturn = true;
}
return toReturn;
}
public bool Update(OrderItemsEntity _OrderItemsEntity)
{
bool toReturn = false;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(OrderItemsFields.Id == _OrderItemsEntity.Id);
filter.PredicateExpression.Add(_PredicateExpression);
adapter.UpdateEntitiesDirectly(_OrderItemsEntity, filter);
toReturn = true;
}
return toReturn;
}
public OrderItemsEntity SelectOne(Guid Id)
{
OrderItemsEntity toReturn = null;
using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
OrderItemsEntity _OrderItemsEntity = new OrderItemsEntity(Id);
if (adapter.FetchEntity(_OrderItemsEntity))
{
toReturn = _OrderItemsEntity;
}
}
return toReturn;
}
