public static List <Advert> QueryAdvertDetailForService(int id, string category)
{
try
{
List <Advert> adverts = new List <Advert>();
SP.ListItemCollection coll = DAT.DataQuery.QueryListItems(BillBoardModel.advertsSiteUrl, BillBoardModel.sayfalarListName, string.Format(BillBoardModel.advertDetailForServiceCamlQuery, category, id));
if (coll.Count > 0)
{
var item = coll[0];
Advert adv = new Advert();
adv.Category = category;
adv.ID = id;
adv.Title = item["Title"].ToString();
adv.Price = Convert.ToDecimal(item["Price"]);
adv.Created = Convert.ToDateTime(item["Created"]);
adv.Description = item["GenericDescription"].ToString();
adv.Detail = item["GenericDetail"].ToString();
// Retrieve Images
List <string> imageServerUrls = DAT.DataQuery.QueryFolderFileUrls(BillBoardModel.advertsSiteUrl, BillBoardModel.goruntulerListName, id.ToString());
if (imageServerUrls.Count > 0)
{
List <string> urlPaths = new List <string>();
foreach (var imgUrl in imageServerUrls)
{
urlPaths.Add(HLP.ResizeAndSaveRemoteImageToLocalForService(imgUrl, 200, 100, 14, adv.GetType().Name.ToString() + id));
}
adv.ImageUrls = urlPaths;
}
adverts.Add(adv);
}
return(adverts);
}
catch (Exception ex)
{
EXP.RedirectToErrorPage(ex.Message);
return(null);
}
}