public int GetProductionOrderStatusID(ProductionOrderStatus oProductionOrderStatus) { var iProductionOrderStatusID = 0; var sCacheItemKey = "ProductionOrderStatus-" + oProductionOrderStatus.ToString(); if (HttpContext.Current.Cache[sCacheItemKey] == null) { iProductionOrderStatusID = GetProductionOrderStatusFromDB(oProductionOrderStatus).IAProductionOrderStatusID; HttpContext.Current.Cache.Add(sCacheItemKey, iProductionOrderStatusID, null, DateTime.Now.AddSeconds(3600), TimeSpan.Zero, CacheItemPriority.Normal, null); } else { iProductionOrderStatusID = (int) HttpContext.Current.Cache[sCacheItemKey]; } return iProductionOrderStatusID; }
public static StatusOption GetStatusOption(ProductionOrderStatus status, DataAccessDataContext context) { return StatusService.GetStatuses(context)[StatusType.ProductionOrderStatus].Where(s => s.SystemName == status.ToString()).SingleOrDefault(); }
/// <summary> /// Retreives the apporpirate ProductionOrderStatus object from the DB based on the enum value passed in /// </summary> /// <param name="oProductionOrderStatus"></param> /// <returns></returns> private IAProductionOrderStatus GetProductionOrderStatusFromDB(ProductionOrderStatus oProductionOrderStatus) { IAProductionOrderStatus oIAProductionOrderStatus = null; switch (oProductionOrderStatus) { case ProductionOrderStatus.Incomplete: oIAProductionOrderStatus = DataAccess.IAProductionOrderStatus.SingleOrDefault(row => row.Name == "Incomplete"); break; case ProductionOrderStatus.Complete: oIAProductionOrderStatus = DataAccess.IAProductionOrderStatus.SingleOrDefault(row => row.Name == "Complete"); break; default: throw new ApplicationException(string.Format("Production Order status is undefined or doesn't exist: {0}", oProductionOrderStatus.ToString())); } return oIAProductionOrderStatus; }