public ActionResult InventoryDetails(int id) { ViewData["AssetsManagement"] = "active"; var viewModel = new InventoryDetailsViewModel() { Inventory = assetsManagementService.GetSiteInventory(id), InventoryItems = assetsManagementService.GetSiteInventoryItemsByInventoryId(id) }; return(View(viewModel)); }
public ActionResult Inventory() { var repo = CarMasterRepoFactory.Create(); var vehicles = repo.GetVehiclesForSale(); var newVehicleList = vehicles.Where(x => x.VehicleType.TypeDescription.Equals("New")); var usedVehicleList = vehicles.Where(x => x.VehicleType.TypeDescription.Equals("Used")); //Set inventoryVM lists to new list of detailVM InventoryViewModel viewModel = new InventoryViewModel(); viewModel.NewVehicles = new List <InventoryDetailsViewModel>(); viewModel.UsedVehicles = new List <InventoryDetailsViewModel>(); //List of new vehicles foreach (var vehicle in newVehicleList) { InventoryDetailsViewModel view = new InventoryDetailsViewModel(); view.Year = vehicle.Year; view.Make = vehicle.Model.Make.MakeDescription; view.Model = vehicle.Model.ModelDescription; view.Count = newVehicleList.Count(); view.StockValue = newVehicleList.Select(x => x.MSRP).Sum(); viewModel.NewVehicles.Add(view); } //List of used vehicles foreach (var vehicle in usedVehicleList) { InventoryDetailsViewModel view = new InventoryDetailsViewModel(); view.Year = vehicle.Year; view.Make = vehicle.Model.Make.MakeDescription; view.Model = vehicle.Model.ModelDescription; view.Count = usedVehicleList.Count(); view.StockValue = usedVehicleList.Select(x => x.MSRP).Sum(); viewModel.UsedVehicles.Add(view); } //Send list of new and used to view return(View(viewModel)); }
public dynamic GetDetailsViewModels() { using (var context = _entities.GetDbContext(database)) { return(((IEnumerable <dynamic>)context.InventoryDetails).Select(x => { dynamic newItem = new InventoryDetailsViewModel(); newItem.LongDescription = x.LongDescription; newItem.Alias = x.Alias; newItem.Version = x.Version; newItem.RevisionDate = x.RevisionDate; newItem.RevisionReason = x.RevisionReason; newItem.Predecessor = x.Predecessor; newItem.InventoryTypeID = x.InventoryTypeID; newItem.DocumentType = x.DocumentType; newItem.FormOwner = x.FormOwner; newItem.FormCostCenter = x.FormCostCenter; newItem.ProductCategory = x.ProductCategory; newItem.ProductNumber = x.ProductNumber; newItem.Channel = x.Channel; newItem.Viewability = x.Viewability; newItem.CanBackorder = x.CanBackorder; newItem.IsFulfillment = x.IsFulfillment; newItem.IsMarketing = x.IsMarketing; newItem.IsUserKitContainer = x.IsUserKitContainer; newItem.IsBulkOrder = x.IsBulkOrder; newItem.SpecialMessage = x.SpecialMessage; newItem.SpecialMessageActivationDate = x.SpecialMessageActivationDate; newItem.SpecialMessageDeactivationDate = x.SpecialMessageDeactivationDate; newItem.InventoryPricingTypeID = x.InventoryPricingTypeID; newItem.IsPrintCostApproved = x.IsPrintCostApproved; newItem.NoCostItem = x.NoCostItem; newItem.PricingType = x.PricingType; newItem.PrintCost = x.PrintCost; newItem.FulfillmentCost = x.FulfillmentCost; newItem.ChargebackCost = x.ChargebackCost; newItem.OrderQtyMin = x.OrderQtyMin; newItem.OrderQtyMax = x.OrderQtyMax; newItem.OrderQtyMax = x.OrderQtyMax; newItem.ReplaceDate = x.ReplaceDate; newItem.ReplacePart = x.ReplacePart; newItem.ReplaceReason = x.ReplaceReason; newItem.EffectiveDate = x.EffectiveDate; newItem.ObsoleteDate = x.ObsoleteDate; newItem.IsObsoleted = x.IsObsoleted; newItem.IsReplaced = x.IsReplaced; newItem.IncludeState = x.IncludeState; newItem.ExcludeState = x.ExcludeState; newItem.Popularity = x.Popularity; newItem.PageflexJobName = x.PageflexJobName; newItem.CalculatedMaxOrderQty = x.CalculatedMaxOrderQty; newItem.BusinessOwnerRoleID = x.BusinessOwnerRoleID; newItem.OrderQtyMaxFrequency = x.OrderQtyMaxFrequency; newItem.CreateDate = x.CreateDate; newItem.CreateUser = x.CreateUser; newItem.ModDate = x.ModDate; newItem.ModUser = x.ModUser; newItem.IsAppBuilder = x.IsAppBuilder; newItem.AppBuilderSort = x.AppBuilderSort; newItem.CanRemoveDuplicates = x.CanRemoveDuplicates; newItem.PersonalizeFillableFields = x.PersonalizeFillableFields; newItem.ServiceProductIds = x.ServiceProductIds; return newItem; }).ToList()); } }
public void Test3() { //make sure different entities can have different properties using (var context = _entities.GetDbContext(Databases.ABC)) { var item = ((IEnumerable <dynamic>)context.InventoryDetails).Where(x => x.MultimediaURL != null).Select( x => { dynamic newItem = new InventoryDetailsViewModel(); newItem.LongDescription = x.LongDescription; newItem.Alias = x.Alias; newItem.Version = x.Version; newItem.RevisionDate = x.RevisionDate; newItem.RevisionReason = x.RevisionReason; newItem.Predecessor = x.Predecessor; newItem.InventoryTypeID = x.InventoryTypeID; newItem.DocumentType = x.DocumentType; newItem.FormOwner = x.FormOwner; newItem.FormCostCenter = x.FormCostCenter; newItem.ProductCategory = x.ProductCategory; newItem.ProductNumber = x.ProductNumber; newItem.Program = x.Program; newItem.Viewability = x.Viewability; newItem.CanBackorder = x.CanBackorder; newItem.IsFulfillment = x.IsFulfillment; newItem.IsMarketing = x.IsMarketing; newItem.IsUserKitContainer = x.IsUserKitContainer; newItem.IsBulkOrder = x.IsBulkOrder; newItem.SpecialMessage = x.SpecialMessage; newItem.SpecialMessageActivationDate = x.SpecialMessageActivationDate; newItem.SpecialMessageDeactivationDate = x.SpecialMessageDeactivationDate; newItem.InventoryPricingTypeID = x.InventoryPricingTypeID; newItem.IsPrintCostApproved = x.IsPrintCostApproved; newItem.NoCostItem = x.NoCostItem; newItem.PricingType = x.PricingType; newItem.PrintCost = x.PrintCost; newItem.FulfillmentCost = x.FulfillmentCost; newItem.ChargebackCost = x.ChargebackCost; newItem.OrderQtyMin = x.OrderQtyMin; newItem.OrderQtyMax = x.OrderQtyMax; newItem.OrderQtyMax = x.OrderQtyMax; newItem.ReplaceDate = x.ReplaceDate; newItem.ReplacePart = x.ReplacePart; newItem.ReplaceReason = x.ReplaceReason; newItem.EffectiveDate = x.EffectiveDate; newItem.ObsoleteDate = x.ObsoleteDate; newItem.IsObsoleted = x.IsObsoleted; newItem.IsReplaced = x.IsReplaced; newItem.IncludeState = x.IncludeState; newItem.ExcludeState = x.ExcludeState; newItem.Popularity = x.Popularity; newItem.PageflexJobName = x.PageflexJobName; newItem.CalculatedMaxOrderQty = x.CalculatedMaxOrderQty; newItem.BusinessOwnerRoleID = x.BusinessOwnerRoleID; newItem.OrderQtyMaxFrequency = x.OrderQtyMaxFrequency; newItem.CreateDate = x.CreateDate; newItem.CreateUser = x.CreateUser; newItem.ModDate = x.ModDate; newItem.ModUser = x.ModUser; newItem.IsAppBuilder = x.IsAppBuilder; newItem.AppBuilderSort = x.AppBuilderSort; newItem.CanRemoveDuplicates = x.CanRemoveDuplicates; newItem.MultimediaURL = x.MultimediaURL; return(newItem); }).FirstOrDefault(); Assert.IsTrue(item.MultimediaURL == "Testing"); } using (var context = _entities.GetDbContext(Databases.Standard)) { var item = ((IEnumerable <dynamic>)context.InventoryDetails).Where(x => x.ServiceProductIds != null) .Select(x => { dynamic newItem = new InventoryDetailsViewModel(); newItem.LongDescription = x.LongDescription; newItem.Alias = x.Alias; newItem.Version = x.Version; newItem.RevisionDate = x.RevisionDate; newItem.RevisionReason = x.RevisionReason; newItem.Predecessor = x.Predecessor; newItem.InventoryTypeID = x.InventoryTypeID; newItem.DocumentType = x.DocumentType; newItem.FormOwner = x.FormOwner; newItem.FormCostCenter = x.FormCostCenter; newItem.ProductCategory = x.ProductCategory; newItem.ProductNumber = x.ProductNumber; newItem.Channel = x.Channel; newItem.Viewability = x.Viewability; newItem.CanBackorder = x.CanBackorder; newItem.IsFulfillment = x.IsFulfillment; newItem.IsMarketing = x.IsMarketing; newItem.IsUserKitContainer = x.IsUserKitContainer; newItem.IsBulkOrder = x.IsBulkOrder; newItem.SpecialMessage = x.SpecialMessage; newItem.SpecialMessageActivationDate = x.SpecialMessageActivationDate; newItem.SpecialMessageDeactivationDate = x.SpecialMessageDeactivationDate; newItem.InventoryPricingTypeID = x.InventoryPricingTypeID; newItem.IsPrintCostApproved = x.IsPrintCostApproved; newItem.NoCostItem = x.NoCostItem; newItem.PricingType = x.PricingType; newItem.PrintCost = x.PrintCost; newItem.FulfillmentCost = x.FulfillmentCost; newItem.ChargebackCost = x.ChargebackCost; newItem.OrderQtyMin = x.OrderQtyMin; newItem.OrderQtyMax = x.OrderQtyMax; newItem.OrderQtyMax = x.OrderQtyMax; newItem.ReplaceDate = x.ReplaceDate; newItem.ReplacePart = x.ReplacePart; newItem.ReplaceReason = x.ReplaceReason; newItem.EffectiveDate = x.EffectiveDate; newItem.ObsoleteDate = x.ObsoleteDate; newItem.IsObsoleted = x.IsObsoleted; newItem.IsReplaced = x.IsReplaced; newItem.IncludeState = x.IncludeState; newItem.ExcludeState = x.ExcludeState; newItem.Popularity = x.Popularity; newItem.PageflexJobName = x.PageflexJobName; newItem.CalculatedMaxOrderQty = x.CalculatedMaxOrderQty; newItem.BusinessOwnerRoleID = x.BusinessOwnerRoleID; newItem.OrderQtyMaxFrequency = x.OrderQtyMaxFrequency; newItem.CreateDate = x.CreateDate; newItem.CreateUser = x.CreateUser; newItem.ModDate = x.ModDate; newItem.ModUser = x.ModUser; newItem.IsAppBuilder = x.IsAppBuilder; newItem.AppBuilderSort = x.AppBuilderSort; newItem.CanRemoveDuplicates = x.CanRemoveDuplicates; newItem.PersonalizeFillableFields = x.PersonalizeFillableFields; newItem.ServiceProductIds = x.ServiceProductIds; return(newItem); }).FirstOrDefault(); Assert.IsTrue(item.ServiceProductIds == "Testing"); } }