public static Channel_Catalog_PackagingData GetPackagingDetails(string orderCode)
        {
            Channel_Catalog_PackagingData packagingData = null;

            using (ChannelCatalogPrevEntities entities = new ChannelCatalogPrevEntities())
            {
                packagingData = (from c in entities.Channel_Catalog_PackagingData
                                 where c.OrderCode == orderCode
                                 select c).First();
            }

            return(packagingData);
        }
        public static IEnumerable <CatalogMaster_Auto> GetCatalog(Guid identityGuid, DateTime anyTimeAfter)
        {
            IEnumerable <CatalogMaster_Auto> catalogEntities = null;

            using (ChannelCatalogPrevEntities entities = new ChannelCatalogPrevEntities())
            {
                catalogEntities = (from c in entities.CatalogMaster_Auto
                                   where c.IdentityId == identityGuid &&
                                   c.CreateDate > anyTimeAfter
                                   select c);
            }

            return(catalogEntities);
        }