public string GetEnviromentSetting(string code)
{
using (var context = _entities.GetDbContext(database))
{
return(((IEnumerable <dynamic>)context.EnvironmentSettings).Where(x => x.Code == code)
.Select(x => x.Value).FirstOrDefault());
}
}
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.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;
return newItem;
}).ToList());
}
}