public HttpResponseMessage AddFolio(HttpRequestMessage request, FolioData folioData) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; if (!ModelState.IsValid) { response = request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } else { //var folioData = request.DeserializeObject<FolioData>("folio"); var folio = folioData.folio; var result = new FolioLoadViewModel(); if (folio != null) { var newfolio = folioData.folio.ToEntity(); newfolio.lu_dummy_page_dimension = _dummyPageDimentionRepository.GetAll().Where(x => x.pub_id == folioData.pub_id).FirstOrDefault(); newfolio.iss_id = folioData.iss_id; _dummyFolioRepository.Add(newfolio); DesignDummyRepository.UpdateFolioSequence(newfolio, folio.insertAt, folio.folioAt.GetValueOrDefault(), _dummyFolioRepository); _unitOfWork.Commit(); for (var page = 0; page < folio.total_page; page++) { _dummyPageRepository.Add(new tbl_dummy_page { page_name = folio.page_desc, page_number = (page + folio.start_page_number), tbl_dummy_folio = newfolio }); } _unitOfWork.Commit(); var pages = _dummyPageRepository.GetAll().Where(x => x.dummy_folio_id == newfolio.dummy_folio_id); result.pages = Mapper.Map <IEnumerable <tbl_dummy_page>, List <DummyPageViewModel> >(pages); result.folio_id = newfolio.dummy_folio_id; result.folio_name = newfolio.folio_name; result.folio_sequence = newfolio.page_sequence.GetValueOrDefault(); response = request.CreateResponse(HttpStatusCode.Created, result); } else { response = request.CreateResponse(HttpStatusCode.BadRequest); } } return response; })); }
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()); }