public void InventoryItem_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _inventoryitem_item_inventoryitems = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "33eeefb1-ac7b-43ab-a3bf-c69fa7d98121Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 2692, SupplierPackSize = 2570, InnerPackSize = 5055, PalletType = "Item_PalletType", PalTI = 6008, PalHI = 1352, UOM = "Item_UOM", }; var _inventoryitem_warehouse_inventoryitems = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.InventoryItem>(Session) .CheckProperty(p => p.CoverageDays, 4875) .CheckProperty(p => p.SafetyStock, 7640) .CheckProperty(p => p.Status, "InventoryItem_Status") .CheckReference(p => p.Item, _inventoryitem_item_inventoryitems) .CheckReference(p => p.Warehouse, _inventoryitem_warehouse_inventoryitems) .VerifyTheMappings(); }
public void SLAStatistics_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _sla_item_slastatistics = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "6b3d7c77-f0ad-4078-b835-9bb64cf69ac9Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 3157, SupplierPackSize = 6837, InnerPackSize = 1593, PalletType = "Item_PalletType", PalTI = 618, PalHI = 2257, UOM = "Item_UOM", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.SLAStatistics>(Session) .CheckProperty(p => p.Percentage, 222222.22M) .CheckProperty(p => p.Threshold, 222222.22M) .CheckProperty(p => p.Month, "SLAStatistics_Month") .CheckReference(p => p.Item, _sla_item_slastatistics) .VerifyTheMappings(); }
public void WasteOld_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _itemwaste_item_wasteold = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "5377d7f9-ce05-494c-a9be-2471ce561381Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 393, SupplierPackSize = 3073, InnerPackSize = 7494, PalletType = "Item_PalletType", PalTI = 4586, PalHI = 5268, UOM = "Item_UOM", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.WasteOld>(Session) .CheckProperty(p => p.WastedStock, 222222.22M) .CheckProperty(p => p.StockPerSKU, "WasteOld_StockPerSKU") .CheckProperty(p => p.SKU, "WasteOld_SKU") .CheckProperty(p => p.WastePercentage, 222222.22M) .CheckProperty(p => p.ItemDescription, "WasteOld_ItemDescription") .CheckProperty(p => p.DateFormatted, "WasteOld_DateFormatted") .CheckReference(p => p.Item, _itemwaste_item_wasteold) .VerifyTheMappings(); }
public void ItemParameter_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _orderproposal_item_itemcriterion = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "38fd002c-87a3-45be-8fe4-9a8f480d7295Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 2226, SupplierPackSize = 4979, InnerPackSize = 6924, PalletType = "Item_PalletType", PalTI = 5123, PalHI = 5807, UOM = "Item_UOM", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.ItemParameter>(Session) .CheckProperty(p => p.CoverageDays, 5525) .CheckProperty(p => p.SupplierCanDeliver, true) .CheckProperty(p => p.SupplierQuantity, 2429) .CheckProperty(p => p.SupplierComments, "ItemParameter_SupplierComments") .CheckReference(p => p.Item, _orderproposal_item_itemcriterion) .VerifyTheMappings(); }
public void MinimumQuantity_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _minimumquantity_item_minimumquantity = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "135a803a-e650-4865-b6af-627277d14ed8Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 428, SupplierPackSize = 9864, InnerPackSize = 1088, PalletType = "Item_PalletType", PalTI = 4293, PalHI = 958, UOM = "Item_UOM", }; var _minimumquantity_supplier_minimumquantity = new DSS1_RetailerDriverStockOptimisation.BO.Supplier { Code = "Supplier_Code", Name = "Supplier_Name", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.MinimumQuantity>(Session) .CheckProperty(p => p.Country, "MinimumQuantity_Country") .CheckProperty(p => p.Quantity, 695) .CheckReference(p => p.Item, _minimumquantity_item_minimumquantity) .CheckReference(p => p.Supplier, _minimumquantity_supplier_minimumquantity) .VerifyTheMappings(); }
public void Sales_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _sale_item_itemsforecast = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "8737af96-31fe-464d-8ef6-cb1e588c4593Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 6151, SupplierPackSize = 6114, InnerPackSize = 376, PalletType = "Item_PalletType", PalTI = 5455, PalHI = 1822, UOM = "Item_UOM", }; var _sale_warehouse_sales = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.Sales>(Session) .CheckProperty(p => p.ForecastDate, now) .CheckProperty(p => p.Units, 88) .CheckReference(p => p.Item, _sale_item_itemsforecast) .CheckReference(p => p.Warehouse, _sale_warehouse_sales) .VerifyTheMappings(); }
public void SupplierCapacity_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _item_item_suppliercapacities = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "6c860b10-22f5-4832-9d5c-61dd38ee90c8Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 9701, SupplierPackSize = 9067, InnerPackSize = 8518, PalletType = "Item_PalletType", PalTI = 3887, PalHI = 354, UOM = "Item_UOM", }; var _item_supplier_suppliercapacities = new DSS1_RetailerDriverStockOptimisation.BO.Supplier { Code = "Supplier_Code", Name = "Supplier_Name", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.SupplierCapacity>(Session) .CheckProperty(p => p.DateOfStockUpdate, now) .CheckProperty(p => p.DailyProduction, 2503) .CheckProperty(p => p.Stock, 1388) .CheckReference(p => p.Item, _item_item_suppliercapacities) .CheckReference(p => p.Supplier, _item_supplier_suppliercapacities) .VerifyTheMappings(); }
public void Notification_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _notification_item_notifications = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "8a430ffc-1da7-4374-ad34-4d3f1a331aeaItem_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 7256, SupplierPackSize = 5965, InnerPackSize = 7979, PalletType = "Item_PalletType", PalTI = 3577, PalHI = 998, UOM = "Item_UOM", }; var _notification_warehouse_notification = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _orderproposal_orderforecastdetails_notification = new DSS1_RetailerDriverStockOptimisation.BO.OrderForecastDetails { ReplenishmentCycle = 5236, AutomatedForecast = 349, Quantity = 2222222222.22222M, RoundQuantity = 6891, OrderInventoryDays = 2222222222.22222M, RecommendedOrderDate = now, SalesForecastDate = now, SupplierCanDeliver = true, SupplierMaxQuantity = 2222222222.22222M, SupplierCoverageDays = 3753, ItemCoverageDays = 9727, InitialStockLevel = 6612, SupplierAvailableQuantity = 484, SupplierSharesStock = true, CreatedOn = now, Status = "OrderForecastDetails_Status", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.Notification>(Session) .CheckProperty(p => p.Message, "Notification_Message") .CheckProperty(p => p.TotalSupplierStock, 9421) .CheckProperty(p => p.OrderForecastQuantity, 7030) .CheckProperty(p => p.Diff, 1721) .CheckProperty(p => p.SalesForecastDate, now) .CheckProperty(p => p.CreatedBy, "Notification_CreatedBy") .CheckReference(p => p.Item, _notification_item_notifications) .CheckReference(p => p.Warehouse, _notification_warehouse_notification) .CheckReference(p => p.OrderForecastDetails, _orderproposal_orderforecastdetails_notification) .VerifyTheMappings(); }
public void Statistics_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _dashboard_warehouse_statistics = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _dashboard_item_statistics = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "cbcf0ee7-73f9-4a9d-91ba-53b7b1592c82Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 2247, SupplierPackSize = 5584, InnerPackSize = 506, PalletType = "Item_PalletType", PalTI = 1012, PalHI = 9698, UOM = "Item_UOM", }; var _dashboard_supplier_statistics = new DSS1_RetailerDriverStockOptimisation.BO.Supplier { Code = "Supplier_Code", Name = "Supplier_Name", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.Statistics>(Session) .CheckProperty(p => p.TotalUnits, 9280) .CheckProperty(p => p.Description, "Statistics_Description") .CheckProperty(p => p.Result, 9298) .CheckProperty(p => p.LeadTime, 6133) .CheckProperty(p => p.WeekDay, "Statistics_WeekDay") .CheckProperty(p => p.StockOnHandDate, now) .CheckProperty(p => p.StockOnHand, 2924) .CheckProperty(p => p.OrderQuantity, 5073) .CheckProperty(p => p.SalesQuantity, 2255) .CheckProperty(p => p.QuantitySalesForecast, 6658) .CheckProperty(p => p.StockOnHandDateFormatted, "Statistics_StockOnHandDateFormatted") .CheckProperty(p => p.SupplierStock, 9709) .CheckProperty(p => p.QuantitySum, 1034) .CheckProperty(p => p.SalesForecastDate, now) .CheckProperty(p => p.SalesForecastDateFormatted, "Statistics_SalesForecastDateFormatted") .CheckProperty(p => p.Threshold, 222222.22M) .CheckProperty(p => p.OrderDate, now) .CheckProperty(p => p.OrderDateFormatted, "Statistics_OrderDateFormatted") .CheckProperty(p => p.RealOrderQuantity, 580) .CheckReference(p => p.Warehouse, _dashboard_warehouse_statistics) .CheckReference(p => p.Item, _dashboard_item_statistics) .CheckReference(p => p.Supplier, _dashboard_supplier_statistics) .VerifyTheMappings(); }
public void StockOnHand_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _agreement_agreement_stockonhands = new DSS1_RetailerDriverStockOptimisation.BO.Agreement { FullTruckLoad = true, AgreementDocument = "Agreement_AgreementDocument", LeadTime = "Agreement_LeadTime", DateCreated = now, WDDeliveries = true, TargetInventoryDays = 8764, Profile = "Agreement_Profile", }; var _stockonhand_warehouse_stockonhand = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _stockonhand_item_stocksonhand = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "92a3478b-812b-4ac5-aa84-8457682959a9Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 2137, SupplierPackSize = 4261, InnerPackSize = 1604, PalletType = "Item_PalletType", PalTI = 6908, PalHI = 310, UOM = "Item_UOM", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.StockOnHand>(Session) .CheckProperty(p => p.Units, 7896) .CheckProperty(p => p.CurrentInventoryDays, 222222.22M) .CheckProperty(p => p.StockOnHandDate, now) .CheckProperty(p => p.LeadTime, "StockOnHand_LeadTime") .CheckProperty(p => p.TargetInventoryDays, 222222.22M) .CheckProperty(p => p.FullTrackLoad, true) .CheckProperty(p => p.WDDays, true) .CheckReference(p => p.Agreement, _agreement_agreement_stockonhands) .CheckReference(p => p.Warehouse, _stockonhand_warehouse_stockonhand) .CheckReference(p => p.Item, _stockonhand_item_stocksonhand) .VerifyTheMappings(); }
public void SLALeadTime_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _sla_item_slaleadtimes = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "2b4359a7-87fa-4b7d-8e90-5033a6f6c94dItem_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 3627, SupplierPackSize = 5852, InnerPackSize = 8255, PalletType = "Item_PalletType", PalTI = 162, PalHI = 7438, UOM = "Item_UOM", }; var _sla_warehouse_slaleadtimes = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.SLALeadTime>(Session) .CheckProperty(p => p.AgreedLeadTime, 522) .CheckProperty(p => p.RealLeadTime, 3380) .CheckProperty(p => p.Percentage, 222222.22M) .CheckProperty(p => p.ItemDescription, "SLALeadTime_ItemDescription") .CheckProperty(p => p.DateFormatted, "SLALeadTime_DateFormatted") .CheckProperty(p => p.Threshold, 222222.22M) .CheckProperty(p => p.SLALeadDate, now) .CheckProperty(p => p.Month, 5619) .CheckProperty(p => p.MonthlyDelayed, 222222.22M) .CheckProperty(p => p.MontlhyOrders, 222222.22M) .CheckProperty(p => p.MonthlyPercentage, 222222.22M) .CheckReference(p => p.Item, _sla_item_slaleadtimes) .CheckReference(p => p.Warehouse, _sla_warehouse_slaleadtimes) .VerifyTheMappings(); }
public void DeliverySchedule_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _forecast_supplier_deliveryschedules = new DSS1_RetailerDriverStockOptimisation.BO.Supplier { Code = "Supplier_Code", Name = "Supplier_Name", }; var _forecast_item_deliveryschedules = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "eed02b3d-68f4-4b88-8ce3-b98afc728fd4Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 1930, SupplierPackSize = 7383, InnerPackSize = 9520, PalletType = "Item_PalletType", PalTI = 7431, PalHI = 6344, UOM = "Item_UOM", }; var _forecast_warehouse_deliveryschedules = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.DeliverySchedule>(Session) .CheckProperty(p => p.LeadTime, 5120) .CheckProperty(p => p.Weekday, 9596) .CheckProperty(p => p.NameOfDay, "DeliverySchedule_NameOfDay") .CheckProperty(p => p.DBWeekday, 6539) .CheckReference(p => p.Supplier, _forecast_supplier_deliveryschedules) .CheckReference(p => p.Item, _forecast_item_deliveryschedules) .CheckReference(p => p.Warehouse, _forecast_warehouse_deliveryschedules) .VerifyTheMappings(); }
public void SLADelivery_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _sla_item_sladeliveries = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "8d5821db-dd6a-4780-933a-440d5e960329Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 6460, SupplierPackSize = 4445, InnerPackSize = 4626, PalletType = "Item_PalletType", PalTI = 1779, PalHI = 950, UOM = "Item_UOM", }; var _sla_warehouse_sladelivery = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.SLADelivery>(Session) .CheckProperty(p => p.OrderedQuantities, 222222.22M) .CheckProperty(p => p.DeliveredQuantities, 222222.22M) .CheckProperty(p => p.Percentage, 222222.22M) .CheckProperty(p => p.ItemDescription, "SLADelivery_ItemDescription") .CheckProperty(p => p.Threshold, 222222.22M) .CheckProperty(p => p.SLADate, now) .CheckProperty(p => p.DateFormatted, "SLADelivery_DateFormatted") .CheckProperty(p => p.Month, 7434) .CheckReference(p => p.Item, _sla_item_sladeliveries) .CheckReference(p => p.Warehouse, _sla_warehouse_sladelivery) .VerifyTheMappings(); }
public void PastOrder_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _pastorder_item_pastorders = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "b1ac3a9d-90df-4b3c-b365-057e200f9ed2Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 4261, SupplierPackSize = 8639, InnerPackSize = 4286, PalletType = "Item_PalletType", PalTI = 3193, PalHI = 2821, UOM = "Item_UOM", }; var _pastorder_warehouse_pastorders = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.PastOrder>(Session) .CheckProperty(p => p.OrderNumber, 8141) .CheckProperty(p => p.WrittenDate, now) .CheckProperty(p => p.NotBeforeDate, now) .CheckProperty(p => p.QuantityOrdered, 536) .CheckProperty(p => p.ReceiveDate, now) .CheckProperty(p => p.QuantityReceived, 6161) .CheckProperty(p => p.Caller, "PastOrder_Caller") .CheckReference(p => p.Item, _pastorder_item_pastorders) .CheckReference(p => p.Warehouse, _pastorder_warehouse_pastorders) .VerifyTheMappings(); }
public void Platform_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _sla_item_platform = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "09fb359d-afca-4807-ab3f-42b4f4e6bdd1Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 1983, SupplierPackSize = 1897, InnerPackSize = 8760, PalletType = "Item_PalletType", PalTI = 2174, PalHI = 6771, UOM = "Item_UOM", }; var _sla_warehouse_platform = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.Platform>(Session) .CheckProperty(p => p.percentage, 222222.22M) .CheckProperty(p => p.ItemDescription, "Platform_ItemDescription") .CheckProperty(p => p.RealOrderedQuantities, 222222.22M) .CheckProperty(p => p.ForecastOrders, 222222.22M) .CheckProperty(p => p.Month, "Platform_Month") .CheckReference(p => p.Item, _sla_item_platform) .CheckReference(p => p.Warehouse, _sla_warehouse_platform) .VerifyTheMappings(); }
public void OrderForecastStatistic_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _orderforecastdashboard_item_orderforecaststatistics = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "5e0455f2-825e-4980-a681-4c7ad91b8b82Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 2356, SupplierPackSize = 6474, InnerPackSize = 6358, PalletType = "Item_PalletType", PalTI = 1603, PalHI = 9285, UOM = "Item_UOM", }; var _orderforecastdashboard_warehouse_orderforecaststatistics = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.OrderForecastStatistic>(Session) .CheckProperty(p => p.Quantity, 222222.22M) .CheckProperty(p => p.RoundQuantity, 7821) .CheckProperty(p => p.OrderDate, now) .CheckProperty(p => p.OrderDateFormatted, "OrderForecastStatistic_OrderDateFormatted") .CheckReference(p => p.Item, _orderforecastdashboard_item_orderforecaststatistics) .CheckReference(p => p.Warehouse, _orderforecastdashboard_warehouse_orderforecaststatistics) .VerifyTheMappings(); }
public void Stats_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _stocklevelkpi_warehouse_stats = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _stocklevelkpi_item_stats = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "503bf3c8-467b-47d4-8acd-02c46ab23130Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 940, SupplierPackSize = 5009, InnerPackSize = 6760, PalletType = "Item_PalletType", PalTI = 6022, PalHI = 7389, UOM = "Item_UOM", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.Stats>(Session) .CheckProperty(p => p.Percentage, 222222.22M) .CheckProperty(p => p.Threshold, 222222.22M) .CheckProperty(p => p.DateFormatted, "Stats_DateFormatted") .CheckProperty(p => p.Date, now) .CheckReference(p => p.Warehouse, _stocklevelkpi_warehouse_stats) .CheckReference(p => p.Item, _stocklevelkpi_item_stats) .VerifyTheMappings(); }
public static DSS1_RetailerDriverStockOptimisation.BO.Response ImportImplementation(System.Collections.Generic.List <DSS1_RetailerDriverStockOptimisation.BO.Item> items) { foreach (var item in items ?? Enumerable.Empty <DSS1_RetailerDriverStockOptimisation.BO.Item>()) { if (((item?.SKU ?? "") == null || (item?.SKU ?? "") == "")) { return(DSS1_RetailerDriverStockOptimisation.BO.ResponseExtensions.GenerateResponse("Failed", "Found an item with empty SKU.", "", "-1")); } if ((item?.Exists() ?? false)) { zAppDev.DotNet.Framework.Utilities.DebugHelper.Log(zAppDev.DotNet.Framework.Utilities.DebugMessageType.Info, "API", DSS1_RetailerDriverStockOptimisation.Hubs.EventsHub.RaiseDebugMessage, "Item exists."); DSS1_RetailerDriverStockOptimisation.BO.Item existingItem = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetById <DSS1_RetailerDriverStockOptimisation.BO.Item>((item?.SKU ?? "")); var _var0 = item?.Supplier?.Code; existingItem.Supplier = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.Supplier>((a) => a.Code == _var0)?.FirstOrDefault(); var _var1 = item?.BusinessUnit?.Number; existingItem.BusinessUnit = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.BusinessUnit>((b) => b.Number == _var1)?.FirstOrDefault(); var _var2 = item?.Category?.Number; var _var3 = item?.BusinessUnit?.Number; existingItem.Category = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.Category>((c) => c.Number == _var2 && c.BusinessUnit.Number == _var3)?.FirstOrDefault(); var _var4 = item?.SubCategory?.Number; var _var5 = existingItem?.Category?.Id; existingItem.SubCategory = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.SubCategory>((sc) => sc.Number == _var4 && sc.Category.Id == _var5)?.FirstOrDefault(); var _var6 = item?.BaseUnit?.Number; var _var7 = existingItem?.SubCategory?.Id; existingItem.BaseUnit = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.BaseUnit>((bu) => bu.Number == _var6 && bu.SubCategory.Id == _var7)?.FirstOrDefault(); existingItem.Description = (item?.Description ?? ""); existingItem.UPC = (item?.UPC ?? ""); existingItem.PalletSize = (item?.PalletSize ?? 0); existingItem.SupplierPackSize = (item?.SupplierPackSize ?? 0); existingItem.InnerPackSize = (item?.InnerPackSize ?? 0); existingItem.PalletType = (item?.PalletType ?? ""); existingItem.PalTI = (item?.PalTI ?? 0); existingItem.PalHI = (item?.PalHI ?? 0); existingItem.UOM = (item?.UOM ?? ""); new DSS1_RetailerDriverStockOptimisation.DAL.Repository().Save <DSS1_RetailerDriverStockOptimisation.BO.Item>(existingItem); } else { zAppDev.DotNet.Framework.Utilities.DebugHelper.Log(zAppDev.DotNet.Framework.Utilities.DebugMessageType.Info, "API", DSS1_RetailerDriverStockOptimisation.Hubs.EventsHub.RaiseDebugMessage, "***** New Item imported with SKU: " + (item?.SKU ?? "")); DSS1_RetailerDriverStockOptimisation.BO.Item newItem = new DSS1_RetailerDriverStockOptimisation.BO.Item(); newItem.SKU = (item?.SKU ?? ""); var _var8 = item?.Supplier?.Code; newItem.Supplier = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.Supplier>((a) => a.Code == _var8)?.FirstOrDefault(); var _var9 = item?.BusinessUnit?.Number; newItem.BusinessUnit = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.BusinessUnit>((b) => b.Number == _var9)?.FirstOrDefault(); var _var10 = item?.Category?.Number; newItem.Category = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.Category>((c) => c.Number == _var10)?.FirstOrDefault(); var _var11 = item?.SubCategory?.Number; var _var12 = item?.Category?.Id; newItem.SubCategory = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.SubCategory>((sc) => sc.Number == _var11 && sc.Category.Id == _var12)?.FirstOrDefault(); var _var13 = item?.BaseUnit?.Number; var _var14 = item?.SubCategory?.Id; newItem.BaseUnit = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <DSS1_RetailerDriverStockOptimisation.BO.BaseUnit>((bu) => bu.Number == _var13 && bu.SubCategory.Id == _var14)?.FirstOrDefault(); newItem.Description = (item?.Description ?? ""); newItem.UPC = (item?.UPC ?? ""); newItem.PalletSize = (item?.PalletSize ?? 0); newItem.SupplierPackSize = (item?.SupplierPackSize ?? 0); newItem.InnerPackSize = (item?.InnerPackSize ?? 0); newItem.PalletType = (item?.PalletType ?? ""); newItem.PalTI = (item?.PalTI ?? 0); newItem.PalHI = (item?.PalHI ?? 0); newItem.UOM = (item?.UOM ?? ""); new DSS1_RetailerDriverStockOptimisation.DAL.Repository().Save <DSS1_RetailerDriverStockOptimisation.BO.Item>(newItem); } } return(DSS1_RetailerDriverStockOptimisation.BO.ResponseExtensions.GenerateResponse("Succeed", "All items imported successfully.", "", "1")); }
public void OrderForecastDetails_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _orderproposal_warehouse_replenishmentcycle = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _orderproposal_item_replenishmentcycle = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "68e95eb3-1f57-4e61-82ab-c5eeff2484acItem_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 9931, SupplierPackSize = 8703, InnerPackSize = 8448, PalletType = "Item_PalletType", PalTI = 3011, PalHI = 5370, UOM = "Item_UOM", }; var _orderproposal_orderforecast_orderforecastdetails = new DSS1_RetailerDriverStockOptimisation.BO.OrderForecast { ImportId = 9967, Status = "OrderForecast_Status", CreatedBy = "OrderForecast_CreatedBy", CreatedOn = now, StartDate = now, EndDate = now, State = "OrderForecast_State", }; var _orderproposal_notification_orderforecastdetails = new DSS1_RetailerDriverStockOptimisation.BO.Notification { Message = "Notification_Message", TotalSupplierStock = 8630, OrderForecastQuantity = 3921, Diff = 1087, SalesForecastDate = now, CreatedBy = "Notification_CreatedBy", }; var _orderproposal_comments_orderforecastdetails = new DSS1_RetailerDriverStockOptimisation.BO.Comment { Text = "Comment_Text", AddedBy = "Comment_AddedBy", }; var _orderproposal_comments_orderforecastdetails2 = new DSS1_RetailerDriverStockOptimisation.BO.Comment { Text = "Comment_Text", AddedBy = "Comment_AddedBy", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.OrderForecastDetails>(Session) .CheckProperty(p => p.ReplenishmentCycle, 8054) .CheckProperty(p => p.AutomatedForecast, 8786) .CheckProperty(p => p.Quantity, 2222222222.22222M) .CheckProperty(p => p.RecommendedOrderDate, now) .CheckProperty(p => p.SalesForecastDate, now) .CheckProperty(p => p.SupplierCanDeliver, true) .CheckProperty(p => p.SupplierMaxQuantity, 2222222222.22222M) .CheckProperty(p => p.SupplierCoverageDays, 9995) .CheckProperty(p => p.ItemCoverageDays, 1553) .CheckProperty(p => p.InitialStockLevel, 6286) .CheckProperty(p => p.SupplierAvailableQuantity, 6124) .CheckProperty(p => p.SupplierSharesStock, true) .CheckProperty(p => p.CreatedOn, now) .CheckProperty(p => p.Status, "OrderForecastDetails_Status") .CheckReference(p => p.Warehouse, _orderproposal_warehouse_replenishmentcycle) .CheckReference(p => p.Item, _orderproposal_item_replenishmentcycle) .CheckReference(p => p.OrderForecast, _orderproposal_orderforecast_orderforecastdetails) .CheckReference(p => p.Notification, _orderproposal_notification_orderforecastdetails) .CheckBag(p => p.Comments, (new List <DSS1_RetailerDriverStockOptimisation.BO.Comment> { _orderproposal_comments_orderforecastdetails, _orderproposal_comments_orderforecastdetails2 })) .VerifyTheMappings(); }
public void Agreement_persistence_test() { DateTime now = DateTime.Now; // Get datetime without milliseconds now = new DateTime(now.Ticks - (now.Ticks % TimeSpan.TicksPerSecond), now.Kind); var _agreement_agreementstatuses_agreement = new DSS1_RetailerDriverStockOptimisation.BO.AgreementStatus { IssuedBy = "AgreementStatus_IssuedBy", Status = "AgreementStatus_Status", DateIssued = now, ApprovedBySonae = true, ApprovedBySupplier = true, InProgress = true, Active = true, UnderRevision = true, }; var _agreement_agreementstatuses_agreement2 = new DSS1_RetailerDriverStockOptimisation.BO.AgreementStatus { IssuedBy = "AgreementStatus_IssuedBy", Status = "AgreementStatus_Status", DateIssued = now, ApprovedBySonae = true, ApprovedBySupplier = true, InProgress = true, Active = true, UnderRevision = true, }; var _agreement_items_agreements = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "85c41988-a9ba-4eda-9414-d5e910f388a2Item_SKU", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 5412, SupplierPackSize = 2461, InnerPackSize = 5128, PalletType = "Item_PalletType", PalTI = 965, PalHI = 4274, UOM = "Item_UOM", }; var _agreement_items_agreements2 = new DSS1_RetailerDriverStockOptimisation.BO.Item { SKU = "1111", Description = "Item_Description", UPC = "Item_UPC", AvgDailyDemand = 222222.22M, PalletSize = 2720, SupplierPackSize = 6994, InnerPackSize = 6127, PalletType = "Item_PalletType", PalTI = 161, PalHI = 6362, UOM = "Item_UOM", }; var _agreement_supplier_agreements = new DSS1_RetailerDriverStockOptimisation.BO.Supplier { Code = "Supplier_Code", Name = "Supplier_Name", }; var _agreement_warehouses_agreements = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _agreement_warehouses_agreements2 = new DSS1_RetailerDriverStockOptimisation.BO.Warehouse { Code = "Warehouse_Code", Description = "Warehouse_Description", FlowType = "Warehouse_FlowType", }; var _agreement_stockonhands_agreement = new DSS1_RetailerDriverStockOptimisation.BO.StockOnHand { Units = 3710, CurrentInventoryDays = 222222.22M, StockOnHandDate = now, LeadTime = "StockOnHand_LeadTime", TargetInventoryDays = 222222.22M, FullTrackLoad = true, WDDays = true, }; var _agreement_stockonhands_agreement2 = new DSS1_RetailerDriverStockOptimisation.BO.StockOnHand { Units = 1751, CurrentInventoryDays = 222222.22M, StockOnHandDate = now, LeadTime = "StockOnHand_LeadTime", TargetInventoryDays = 222222.22M, FullTrackLoad = true, WDDays = true, }; var _agreement_transportuncaps_agreement = new DSS1_RetailerDriverStockOptimisation.BO.TransportUnCap { UOP = "TransportUnCap_UOP", PercRound = 2222222222.22222M, Tuc1 = 2222222222.22222M, SplitOcInd = "TransportUnCap_SplitOcInd", Status = "TransportUnCap_Status", }; var _agreement_transportuncaps_agreement2 = new DSS1_RetailerDriverStockOptimisation.BO.TransportUnCap { UOP = "TransportUnCap_UOP", PercRound = 2222222222.22222M, Tuc1 = 2222222222.22222M, SplitOcInd = "TransportUnCap_SplitOcInd", Status = "TransportUnCap_Status", }; new PersistenceSpecification <DSS1_RetailerDriverStockOptimisation.BO.Agreement>(Session) .CheckProperty(p => p.FullTruckLoad, true) .CheckProperty(p => p.AgreementDocument, "Agreement_AgreementDocument") .CheckProperty(p => p.LeadTime, "Agreement_LeadTime") .CheckProperty(p => p.DateCreated, now) .CheckProperty(p => p.WDDeliveries, true) .CheckProperty(p => p.TargetInventoryDays, 6622) .CheckProperty(p => p.Profile, "Agreement_Profile") .CheckBag(p => p.AgreementStatuses, (new List <DSS1_RetailerDriverStockOptimisation.BO.AgreementStatus> { _agreement_agreementstatuses_agreement, _agreement_agreementstatuses_agreement2 })) .CheckBag(p => p.Items, (new List <DSS1_RetailerDriverStockOptimisation.BO.Item> { _agreement_items_agreements, _agreement_items_agreements2 })) .CheckReference(p => p.Supplier, _agreement_supplier_agreements) .CheckBag(p => p.Warehouses, (new List <DSS1_RetailerDriverStockOptimisation.BO.Warehouse> { _agreement_warehouses_agreements, _agreement_warehouses_agreements2 })) .CheckBag(p => p.StockOnHands, (new List <DSS1_RetailerDriverStockOptimisation.BO.StockOnHand> { _agreement_stockonhands_agreement, _agreement_stockonhands_agreement2 })) .CheckBag(p => p.TransportUnCaps, (new List <DSS1_RetailerDriverStockOptimisation.BO.TransportUnCap> { _agreement_transportuncaps_agreement, _agreement_transportuncaps_agreement2 })) .VerifyTheMappings(); }