public static List <News> QueryLatestNewsForXml(int amount)
{
try
{
List <News> newss = new List <News>();
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(NewsModel.newsSiteUrl, NewsModel.sayfalarListName, string.Format(NewsModel.newsLimitedCamlQuery, amount));
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().Replace("\u0003", " ");
news.ListImage = HLP.TransformImgHtmlStringAndGetBase64(item["ListImage"].ToString());
newss.Add(news);
}
}
return(newss.Take(amount).ToList());
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
public static List <Campaign> QueryLatestCampaignsForXml(int amount)
{
try
{
List <Campaign> camps = new List <Campaign>();
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(CampaignModel.campaignsSiteUrl, CampaignModel.sayfalarListName, string.Format(CampaignModel.campaignsLimitedCamlQuery, amount * 3));
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.TransformImgHtmlStringAndGetBase64(i.Split('|')[1].Replace("\r", ""));
//camp.ListImage = "../temp/" + HLP.TransformHtmlStringAndGetFileName(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.Take(amount).ToList());
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}
