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()); }