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

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

            return(packagingData);
        }
        public static CatalogMaster_Auto GetCatalog(string identityName, DateTime anyTimeAfter)
        {
            List <CatalogMaster_Auto> catalogEntities = null;

            using (ChannelCatalogProdEntities entities = new ChannelCatalogProdEntities())
            {
                catalogEntities = (from c in entities.CatalogMaster_Auto
                                   where c.User_Name == identityName &&
                                   c.CreateDate > anyTimeAfter
                                   select c).ToList();
            }

            return(catalogEntities.FirstOrDefault());
        }