public static UInventory_InventoryItem UInventory_InventoryItem(MInventory_LibraryEntry entry)
{
//var color = Color.FromAhsb(255, entry.Hue, entry.Saturation / 100.0, entry.Value / 100.0);
var result = new UInventory_InventoryItem()
{
Id = entry.InventoryItemId,
Type = entry.InventoryItemTypeCode,
Sku = entry.Sku,
Name = entry.Name,
Manufacturer = entry.Manufacturer,
Collection = entry.Collection,
Quantity = entry.Quantity,
ReservedQuantity = entry.ReservedQuantity,
Color = MCommon_Color(entry.Hue, entry.Saturation, entry.Value)
};
return(result);
}
public static AInventory_InventoryItem Create_InventoryItem_Data(MInventory_LibraryEntry entry)
{
//var color = Color.FromAhsb(255, entry.Hue, entry.Saturation / 100.0, entry.Value / 100.0);
var result = new AInventory_InventoryItem()
{
Id = entry.InventoryItemId,
Type = entry.InventoryItemTypeCode,
Sku = entry.Sku,
Name = entry.Name,
Manufacturer = entry.Manufacturer,
Collection = entry.Collection,
Quantity = entry.Quantity,
ReservedQuantity = entry.ReservedQuantity,
Color = Create_Common_ColorData(entry.Hue, entry.Saturation, entry.Value),
InventoryItemStocks = Create_Admin_InventoryItem_StockDataList(entry.Stocks)
};
return(result);
}
private List <MInventory_LibraryEntry> LoadEntries()
{
//Logger.LogMessage("InventoryItemLibrary::LoadEntries");
var entries = new List <MInventory_LibraryEntry>();
using (var ctx = QuiltContextFactory.Create())
{
var dbInventoryItems = ctx.InventoryItems
.Include(r => r.InventoryItemTypeCodeNavigation)
.Include(r => r.InventoryItemStocks)
.Include(r => r.InventoryItemTags)
.ThenInclude(r => r.Tag)
.Where(r => r.Quantity > 0)
.OrderBy(r => r.Hue).ThenBy(r => r.Value).ThenBy(r => r.Saturation)
.ToList();
foreach (var dbInventoryItem in dbInventoryItems)
{
var dbCollectionTag = dbInventoryItem.InventoryItemTags.Where(r => r.Tag.TagTypeCode == TagTypeCodes.Collection).SingleOrDefault();
var dbManufacturerTag = dbInventoryItem.InventoryItemTags.Where(r => r.Tag.TagTypeCode == TagTypeCodes.Manufacturer).SingleOrDefault();
IList <MInventory_LibraryItemStockEntry> stocks = null;
foreach (var dbInventoryItemStock in dbInventoryItem.InventoryItemStocks)
{
if (stocks == null)
{
stocks = new List <MInventory_LibraryItemStockEntry>();
}
var stock = new MInventory_LibraryItemStockEntry(
dbInventoryItemStock.InventoryItemStockId,
dbInventoryItemStock.UnitOfMeasureCodeNavigation.Name,
dbInventoryItemStock.UnitCost,
dbInventoryItemStock.StockDateTimeUtc,
dbInventoryItemStock.OriginalQuantity,
dbInventoryItemStock.CurrentQuantity);
stocks.Add(stock);
}
var entry = new MInventory_LibraryEntry(
dbInventoryItem.InventoryItemId,
dbInventoryItem.Sku,
dbInventoryItem.Name,
dbInventoryItem.InventoryItemTypeCode,
dbInventoryItem.PricingScheduleId,
dbManufacturerTag?.Tag.Value,
dbCollectionTag?.Tag.Value,
dbInventoryItem.Quantity,
dbInventoryItem.ReservedQuantity,
dbInventoryItem.Hue,
dbInventoryItem.Saturation,
dbInventoryItem.Value,
stocks ?? EMPTY_STOCK_LIST);
entries.Add(entry);
}
}
return(entries);
}
public static MProject_ProjectSnapshotComponent MProject_ProjectSnapshotComponent(ProjectSnapshotComponent dbProjectSnapshotComponent, MInventory_LibraryEntry mInventoryItem, InventoryItemType dbInventoryItemType, UnitOfMeasure dbUnitOfMeasure, decimal unitPrice, decimal totalPrice)
{
return(new MProject_ProjectSnapshotComponent()
{
ProjectSnapshotComponentId = dbProjectSnapshotComponent.ProjectSnapshotComponentId,
Description = mInventoryItem.Name,
Quantity = dbProjectSnapshotComponent.Quantity,
UnitPrice = unitPrice,
TotalPrice = totalPrice,
ConsumableReference = CreateConsumableReference.FromInventoryItemId(mInventoryItem.InventoryItemId),
Sku = mInventoryItem.Sku,
UnitOfMeasure = GetValue.MCommon_UnitOfMeasure(dbUnitOfMeasure.UnitOfMeasureCode),
UnitOfMeasureName = dbUnitOfMeasure.Name,
Category = dbInventoryItemType.Name,
Collection = mInventoryItem.Collection,
Manufacturer = mInventoryItem.Manufacturer
});
}
