public static List <Campaign> QueryLatestCampaigns(int amount) { try { List <Campaign> camps = new List <Campaign>(); SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(CampaignModel.campaignsSiteUrl, CampaignModel.sayfalarListName, CampaignModel.campaignsCamlQueryForHomePage); 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 = "../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); } }