public AdvertisementViewMode GetAdViewById(int ad_id)
{
var token = HttpContext.Current.User.Identity.Name;
var repo = new SecurityRepository();
var luClient = repo.GetClient(token);
var ad = _mediaPageNumberRepository.GetAll().Where(x => x.media_page_number == ad_id).FirstOrDefault();
var adView = DesignDummyRepository.BuildAdViewModel(ad, luClient);
var mediaTrim = _adsizeMediaTrimRepository.GetAll().ToList()
.Where(x => x.adsize_id == adView.adsize_id && x.pub_id == adView.pub_id && (adView.ad_shape_id == (x.lu_adsize_trim != null ? x.lu_adsize_trim.ad_shape_id.GetValueOrDefault() : 0))).FirstOrDefault();
if (mediaTrim != null && mediaTrim.lu_adsize_trim != null)
{
adView.adsize_trim_desc = mediaTrim.lu_adsize_trim.adsize_trim_desc;
adView.AdSizeType = DesignDummyRepository.GetAdSizeType(mediaTrim.lu_adsize_trim.adsize_trim_desc);
}
if (mediaTrim.lu_adsize_trim.lu_dummy_coordinate != null)
{
adView.coordinates = Mapper.Map <lu_dummy_coordinate, CoordinatesViewMode>(mediaTrim.lu_adsize_trim.lu_dummy_coordinate);
}
return(adView);
}
public IEnumerable <AdvertisementViewMode> AllAds(int pub_id, int iss_id)
{
var token = HttpContext.Current.User.Identity.Name;
var repo = new SecurityRepository();
var luClient = repo.GetClient(token);
var mediaTrim = _adsizeMediaTrimRepository.GetAll().ToList();
var result = _mediaPageNumberRepository.GetAll().Where(x => x.pub_id == pub_id && x.iss_id == iss_id && x.tbl_io_detail.lu_ad_rate.pagination_req == 0).ToList().Select(ad => DesignDummyRepository.BuildAdViewModel(ad, luClient));
var test = result.Join(
mediaTrim,
mediaPage => new { mediaPage.adsize_id, mediaPage.pub_id },
trim => new { trim.adsize_id, trim.pub_id },
(t1, t2) => new { t1, t2 })
.Where(o => o.t2.lu_adsize_trim != null && o.t1.ad_shape_id == o.t2.lu_adsize_trim.ad_shape_id.GetValueOrDefault())
.Select(o => new { o.t1, o.t2.lu_adsize_trim.adsize_trim_desc, o.t2.lu_adsize_trim.lu_dummy_coordinate });
var adsList = new List <AdvertisementViewMode>();
foreach (var i in test)
{
i.t1.adsize_trim_desc = i.adsize_trim_desc;
if (i.lu_dummy_coordinate != null)
{
i.t1.coordinates = Mapper.Map <lu_dummy_coordinate, CoordinatesViewMode>(i.lu_dummy_coordinate);
}
adsList.Add(i.t1);
}
var uniquPlacedAds = _dummyPagePlacementRepository.GetAll().ToList().Select(x => x.media_page_number_id).Distinct();
return(adsList.Where(x => !uniquPlacedAds.Contains(x.ad_id) && x.adsize_trim_desc != null && x.status).OrderBy(x => x.company_name).Distinct());
}