static public List <CONTENT> GetRelatedArticle(string uid, string siteid)
{
DateTime dt = DateTime.Now;
List <CONTENT> contentitems = new List <CONTENT>();
using (livee_11Entities database = new livee_11Entities())
{
var query = from CONTENT_GROUP in database.CONTENT_GROUP
join CONTENT_ITEM_CONTENT_GROUP in database.CONTENT_ITEM_CONTENT_GROUP on CONTENT_GROUP.CONTENT_GROUP_UID equals CONTENT_ITEM_CONTENT_GROUP.CONTENT_GROUP_UID
where CONTENT_ITEM_CONTENT_GROUP.CONTENT_ITEM_UID.Equals(uid) && CONTENT_ITEM_CONTENT_GROUP.SITE_UID.Equals(siteid) && CONTENT_GROUP.CONTENT_GROUP_TYPE_UCODE.Equals("PACKAGE")
select new { CONTENT_ITEM_CONTENT_GROUP.CONTENT_GROUP_UID, CONTENT_GROUP.GROUP_NAME };
foreach (var v in query)
{
string groupuid = v.CONTENT_GROUP_UID;
var query2 = from CONTENT_ITEM in database.CONTENT_ITEM
join CONTENT_ITEM_CONTENT_GROUP in database.CONTENT_ITEM_CONTENT_GROUP on CONTENT_ITEM.CONTENT_ITEM_UID equals CONTENT_ITEM_CONTENT_GROUP.CONTENT_ITEM_UID
where CONTENT_ITEM_CONTENT_GROUP.CONTENT_GROUP_UID.Equals(groupuid) && CONTENT_ITEM_CONTENT_GROUP.SITE_UID.Equals(siteid) && CONTENT_ITEM.STATE_UCODE.Equals("PRODDEPLOY") &&
(CONTENT_ITEM.CONTENT_TYPE_UID.Equals(102) || CONTENT_ITEM.CONTENT_TYPE_UID.Equals(127)) && CONTENT_ITEM_CONTENT_GROUP.DISPLAY_START_DATE < dt
select new { CONTENT_ITEM.CONTENT_ITEM_UID };
foreach (var vv in query2)
{
CONTENT c = new CONTENT();
c.uid = vv.CONTENT_ITEM_UID;
contentitems.Add(c);
}
}
}
return(contentitems.Take(10).ToList());
} // GetRelatedArticle
} // GetContentItemContentGroup
static public List <ARTICLE> GetArticle(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var articles = from ART in database.ARTICLEs
where ART.CONTENT_ITEM_UID.Equals(uid)
select ART;
return(articles.ToList());
}
} // GetArticle
} // ListRelatedContent
static public List <PDF_VIEW> GetPdfItems(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var pdfItems = from PDF_VIEW in database.PDF_VIEW
where PDF_VIEW.CONTENT_ITEM_UID.Equals(uid)
select PDF_VIEW;
return(pdfItems.ToList());
}
} // ListPdfs
} // ListRelatedContent
static public List <FREEFORM> GetFreeFormItems(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var FreeformItems = from FREEFORM in database.FREEFORMs
where FREEFORM.CONTENT_ITEM_UID.Equals(uid)
select FREEFORM;
return(FreeformItems.ToList());
}
} // ListRelatedContent
} // ListRelatedContent
static public List <CONTENT_ITEM> GetContentItemsAll(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var ContentItems = from CONTENT_ITEM in database.CONTENT_ITEM
where CONTENT_ITEM.CONTENT_ITEM_UID.Equals(uid)
select CONTENT_ITEM;
return(ContentItems.ToList());
}
} // ListRelatedContent
static public List <CONTENT_ITEM_CONTENT_GROUP> GetContentItemContentGroups(string uid, string siteid)
{
using (livee_11Entities database = new livee_11Entities())
{
var ContentItemContentGroups = from CONTENT_ITEM_CONTENT_GROUP in database.CONTENT_ITEM_CONTENT_GROUP
where CONTENT_ITEM_CONTENT_GROUP.CONTENT_ITEM_UID.Equals(uid) && CONTENT_ITEM_CONTENT_GROUP.SITE_UID.Equals(siteid)
select CONTENT_ITEM_CONTENT_GROUP;
return(ContentItemContentGroups.ToList());
}
} // GetContentItemContentGroup
} // GetContentItemContentGroup
static public List <CONTENT_GROUP> GetContentGroup(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var ContentGroup = from CONTENT_GROUP in database.CONTENT_GROUP
where CONTENT_GROUP.CONTENT_GROUP_UID.Equals(uid)
select CONTENT_GROUP;
return(ContentGroup.ToList());
}
} // GetContentItemContentGroup
static public List <IMAGE> GetImageItems(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var ImageItems = from IMAGE in database.IMAGEs
where IMAGE.CONTENT_ITEM_UID.Equals(uid)
select IMAGE;
return(ImageItems.ToList());
}
}
}// ListRelatedContent
static private List <CONTENT_ITEM> ListContentItems(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var ContentItems = from CONTENT_ITEM in database.CONTENT_ITEM
where CONTENT_ITEM.CONTENT_ITEM_UID.Equals(uid) && CONTENT_ITEM.STATE_UCODE.Equals("PRODDEPLOY")
select CONTENT_ITEM;
return(ContentItems.ToList());
}
}// ListRelatedContent
static private List <CONTENT_ITEM_REL> ListRelatedContentItems(string uid)
{
using (livee_11Entities database = new livee_11Entities())
{
var RelatedContentItems = from CONTENT_ITEM_REL in database.CONTENT_ITEM_REL
where CONTENT_ITEM_REL.CONTENT_ITEM_UID.Equals(uid)
select CONTENT_ITEM_REL;
return(RelatedContentItems.ToList());
}
}// ListRelatedContent
} // GetFreeforms
static public List <CONTENT_ITEM> GetContentItems(string siteid, int content_type, DateTime startdate, DateTime enddate)
{
// SELECT CONTENT_ITEM_UID, VIEWABLE_TYPE_UCODE, SCHEDULE_UID, SITE_UID, SHARE_GLOBAL_FLAG, SHAREABLE_FLAG, EXPORTABLE_FLAG, COPYABLE_FLAG, STATE_UCODE, STATE_SET_DATE, KEYWORD, SOURCE_TYPE_UCODE, ORIG_CONTENT_ITEM_UID, CONTENT_TYPE_UID, START_DATE, END_DATE, UPDATE_DATE, UPDATE_PERSON_UID, CREATE_DATE, CREATE_PERSON_UID, CONTENT_TITLE, CONTENT_DESC, VIGNETTE_CONTENT_GUID, CPS_UID, VERSION, LAUNCHED_DATE, DISPLAY_DATE, SHARE_ASSOC_MEDIA_FLAG, DEPLOYED_FLAG, EXPORTED_DATE, EXPORTED_STATUS, NO_THUMBNAIL, KEEP_INDEFINITE_FLAG, THIRDPARTY_ID, THIRDPARTY_VERSION, THIRDPARTY_PUBLISHING_STATUS, FIRST_PUBLICATION_TIMESTAMP, ORIGINATING_SOURCE, ICON_TYPE_UCODE, SHOW_MAP_FLAG, THIRDPARTY_PROVIDER_ID, PREMIUM_START_DATE, CONTENT_LICENSE_UID, SECTION_ANCHOR_UID, SEO_DESCRIPTIVE_TEXT, MANUAL_SEO_DESCRIPTIVE_TEXT_FLAG FROM NGPS.CONTENT_ITEM where site_uid = ? and content_type_uid = ? and start_date >= ? and start_date <= ? and ( state_ucode = 'PRODDEPLOY') order by start_date
using (livee_11Entities database = new livee_11Entities())
{
var ContentItems = from CONTENT_ITEM in database.CONTENT_ITEM
where CONTENT_ITEM.SITE_UID.Equals(siteid) && CONTENT_ITEM.CONTENT_TYPE_UID.Equals(content_type) && CONTENT_ITEM.START_DATE >= startdate && CONTENT_ITEM.START_DATE <= enddate && CONTENT_ITEM.STATE_UCODE.Equals("PRODDEPLOY")
orderby CONTENT_ITEM.START_DATE ascending
select CONTENT_ITEM;
return(ContentItems.ToList());
}
}
static public List <CONTENT_ITEM_REL> GetRelatedContentitems(string uid)
{
var ContentItems = new List <CONTENT_ITEM_REL>();
using (livee_11Entities database = new livee_11Entities())
{
try
{
var RelatedContentItems = from CONTENT_ITEM_REL in database.CONTENT_ITEM_REL
where CONTENT_ITEM_REL.CONTENT_ITEM_UID.Equals(uid)
select CONTENT_ITEM_REL;
return(RelatedContentItems.ToList());
}
catch (System.Exception e) {
}
return(ContentItems.ToList());
}
} // ListRelatedContent
} // GetFreeforms
static public List <CONTENT_ITEM> GetContentItems(string siteid, int content_type, DateTime startdate, DateTime enddate)
{
var ContentItems = new List <CONTENT_ITEM>();
try
{
using (livee_11Entities database = new livee_11Entities())
{
database.Connection.Open();
database.CommandTimeout = 180;
var InnerContentItems = from CONTENT_ITEM in database.CONTENT_ITEM
where CONTENT_ITEM.SITE_UID.Equals(siteid) && CONTENT_ITEM.CONTENT_TYPE_UID.Equals(content_type) && CONTENT_ITEM.START_DATE >= startdate && CONTENT_ITEM.START_DATE <= enddate && CONTENT_ITEM.STATE_UCODE.Equals("PRODDEPLOY")
orderby CONTENT_ITEM.START_DATE ascending
select CONTENT_ITEM;
return(InnerContentItems.ToList());
}
}
catch (System.Exception e)
{
}
return(ContentItems.ToList());
}
