public static News QueryNewsDetails(int newsId)
{
try
{
News news = new News();
Microsoft.SharePoint.Client.ListItemCollection coll = DAT.DataQuery.QueryListItems(NewsModel.newsSiteUrl, NewsModel.sayfalarListName, string.Format(NewsModel.newsDetailCamlQuery, newsId));
SP.ListItem item = coll[0];
news.ID = newsId;
news.Modified = Convert.ToDateTime(item["Modified"]);
news.Title = item["Title"].ToString();
string[] metaInfo = item["MetaInfo"].ToString().Split('\n');
foreach (var i in metaInfo)
{
if (i.Contains("vti_cachedcustomprops"))
{
continue;
}
if (i.Contains("PublishingPageContent:SW"))
{
news.PublishingPageContent = HLP.TransformHtmlString(i.Split('|')[1].Replace("\r", ""));
}
}
return(news);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static List <News> QueryLatestNews()
{
try
{
List <News> newss = new List <News>();
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(NewsModel.newsSiteUrl, NewsModel.sayfalarListName, NewsModel.newsCamlQuery);
if (coll.Count > 0)
{
foreach (SP.ListItem item in coll)
{
News news = new News();
news.ID = Convert.ToInt32(item["ID"]);
news.Created = Convert.ToDateTime(item["Created"]);
news.Title = item["Title"].ToString();
news.ListImage = HLP.TransformHtmlString(item["ListImage"].ToString());
newss.Add(news);
}
}
return(newss);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static List <Announcement> QueryLatestAnnouncements(int amount)
{
try
{
List <Announcement> anns = new List <Announcement>();
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(AnnouncementModel.announcementsSiteUrl, AnnouncementModel.sayfalarListName, string.Format(AnnouncementModel.announcementsCamlQuery, amount));
if (coll.Count > 0)
{
foreach (SP.ListItem item in coll)
{
Announcement ann = new Announcement();
ann.ID = Convert.ToInt32(item["ID"]);
ann.Created = Convert.ToDateTime(item["Created"]);
ann.Title = item["Title"].ToString();
//string imgUrl = HLP.GetImageUrlFromImgTag(item["ListImage"].ToString());
//string imgFileName = HLP.SaveFileToTempFolder(HLP.GetNetworkCredential(), DAT.DataStatics.saportHostURL+ imgUrl, System.Web.HttpContext.Current.Session.SessionID);
//ann.ListImage = HLP.CreateImgTag(imgFileName);
ann.ListImage = HLP.TransformHtmlString(item["ListImage"].ToString());
anns.Add(ann);
}
}
return(anns);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static List <Campaign> QueryLatestCampaigns()
{
try
{
List <Campaign> camps = new List <Campaign>();
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(CampaignModel.campaignsSiteUrl, CampaignModel.sayfalarListName, CampaignModel.campaignsCamlQuery);
if (coll.Count > 0)
{
foreach (SP.ListItem item in coll)
{
Campaign camp = new Campaign();
string[] metaInfo = item["MetaInfo"].ToString().Split('\n');
foreach (var i in metaInfo)
{
if (i.Contains("vti_cachedcustomprops"))
{
continue;
}
if (i.Contains("CampaignEndDate"))
{
camp.CampaignEndDate = Convert.ToDateTime(i.Split('|')[1].Replace("\r", ""));
}
if (i.Contains("ListImage"))
{
if (camp.CampaignEndDate != null && camp.CampaignEndDate >= DateTime.Now)
{
camp.ListImage = HLP.TransformHtmlString(i.Split('|')[1].Replace("\r", ""));
break;
}
}
}
if (camp.CampaignEndDate >= DateTime.Now)
{
camp.ID = Convert.ToInt32(item["ID"]);
camp.Title = item["Title"].ToString();
camps.Add(camp);
}
}
}
return(camps);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static Announcement QueryAnnouncementDetails(int announcementId)
{
try
{
Announcement ann = new Announcement();
Microsoft.SharePoint.Client.ListItemCollection coll = DAT.DataQuery.QueryListItems(AnnouncementModel.announcementsSiteUrl, AnnouncementModel.sayfalarListName, string.Format(AnnouncementModel.announcementDetailCamlQuery, announcementId));
SP.ListItem item = coll[0];
ann.ID = announcementId;
ann.Created = Convert.ToDateTime(item["Created"]);
ann.Title = item["Title"].ToString();
ann.PublishingPageContent = HLP.TransformHtmlString(item["PublishingPageContent"].ToString());
return(ann);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static Campaign QueryCampaignDetails(int campaignId)
{
try
{
System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); }; // To avouid SSL Security - Certificate Error
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(CampaignModel.campaignsSiteUrl, CampaignModel.sayfalarListName, string.Format(CampaignModel.campaignDetailCamlQuery, campaignId));
SP.ListItem item = coll[0];
Campaign camp = new Campaign();
string[] metaInfo = item["MetaInfo"].ToString().Split('\n');
foreach (var i in metaInfo)
{
if (i.Contains("vti_cachedcustomprops"))
{
continue;
}
if (i.Contains("PublishingPageContent:SW"))
{
camp.PublishingPageContent = HLP.TransformHtmlString(i.Split('|')[1].Replace("\r", ""));
}
if (i.Contains("CampaignEndDate:SW"))
{
camp.CampaignEndDate = Convert.ToDateTime(i.Split('|')[1].Replace("\r", ""));
}
if (i.Contains("CampaignStartDate:SW"))
{
camp.CampaignStartDate = Convert.ToDateTime(i.Split('|')[1].Replace("\r", ""));
}
}
camp.ID = Convert.ToInt32(item["ID"]);
camp.Title = item["Title"].ToString();
camp.PublishingPageContent = HttpUtility.HtmlDecode(camp.PublishingPageContent);
return(camp);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static Post QueryPostDetail(int postId, string category)
{
try
{
Post post = new Post();
Microsoft.SharePoint.Client.ListItemCollection coll = DAT.DataQuery.QueryListItems(string.Format(PostModel.postsSiteUrl, category), PostModel.postsListName, string.Format(PostModel.postDetailCamlQuery, postId));
if (coll.Count > 0 && coll[0] != null)
{
SP.ListItem item = coll[0];
post.Id = postId;
SP.FieldUserValue author = (SP.FieldUserValue)item["Author"];
post.Author = author.LookupValue.ToString();
post.Title = item["Title"].ToString().Replace("\\", "");
post.Body = HLP.TransformHtmlString(item["Body"].ToString());
post.PublishedDate = Convert.ToDateTime(item["PublishedDate"]);
post.CategoryName = category;
}
return(post);
}
catch (Exception)
{
throw;
}
}
