//public static bool UpdatePages() { // var pages = Unity.Work.Repository<tbl_dummy_page>().GetAll().ToList(); // int i = 3; // foreach (var page in pages) // { // page.page_name = "Page"; // page.page_number = i; // i++; // Unity.Work.Repository<tbl_dummy_page>().Update(page); // } // Unity.Work.Save(); // return true; //} public static FolioLoadViewModel CreateDummyFolio(FolioViewMode folio, int pub_id, int iss_id) { using (ClientDataContext context = new ClientDataContext()) { var newfolio = new tbl_dummy_folio { dummy_page_dimension_id = context.lu_dummy_page_dimension.Where(x => x.pub_id == pub_id).FirstOrDefault().dummy_page_dimension_id, total_page = folio.total_page, start_page_number = folio.start_page_number, iss_id = iss_id, page_sequence = folio.start_page_number, is_deleted = folio.is_deleted, folio_name = folio.folio_name }; context.tbl_dummy_folio.Add(newfolio); // UpdateFolioSequence(newfolio, folio.insertAt, folio.folioAt, context); context.SaveChanges(); var result = new FolioLoadViewModel(); result.pages = new List <DummyPageViewModel>(); result.pages = CreatePages(folio.total_page.GetValueOrDefault(), folio.start_page_number.GetValueOrDefault(), newfolio.dummy_folio_id, folio.page_desc).Select(pl => new DummyPageViewModel { dummy_page_id = pl.dummy_page_id, page_number = pl.page_number.GetValueOrDefault(), page_name = pl.page_name, page_note = pl.page_note, page_status = pl.page_status, is_deleted = pl.is_deleted.GetValueOrDefault() }).ToList(); result.folio_id = newfolio.dummy_folio_id; result.folio_name = newfolio.folio_name; result.folio_sequence = newfolio.page_sequence.GetValueOrDefault(); return(result); } }
public HttpResponseMessage LoadFolioPages(HttpRequestMessage request, int iss_id, string filter) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; //Delete all inactive ads from pages CleanPages(); var Folios = new List <FolioLoadViewModel>(); var currentIssue = _issueRepository.GetSingle(iss_id); if (filter == "previous") { currentIssue = _issueRepository.GetAll().Where(x => x.pub_id == currentIssue.pub_id && x.iss_dt < currentIssue.iss_dt).First(); } else if (filter == "next") { currentIssue = _issueRepository.GetAll().Where(x => x.pub_id == currentIssue.pub_id && x.iss_dt > currentIssue.iss_dt).First(); } var folios = _dummyFolioRepository.GetAll().Where(x => x.iss_id == currentIssue.iss_id); var foliosVM = Mapper.Map <IEnumerable <tbl_dummy_folio>, List <FolioViewMode> >(folios); foreach (var folio in foliosVM) { var item = new FolioLoadViewModel(); item.pages = GetPagesByFolioId(folio.dummy_folio_id); item.folio_name = folio.folio_name; item.folio_id = folio.dummy_folio_id; item.folio_sequence = folio.page_sequence.GetValueOrDefault(); item.iss_id = currentIssue.iss_id; Folios.Add(item); } response = request.CreateResponse(HttpStatusCode.OK, Folios); return response; })); }
public static List <FolioLoadViewModel> GetPubIssueData(int pub_id, int iss_id) { var pubIssueData = new PubIssueData(); // pubIssueData.Folios = new List<FolioLoadViewModel>(); var Folios = new List <FolioLoadViewModel>(); using (ClientDataContext context = new ClientDataContext()) { var folios = context.tbl_dummy_folio.Where(x => x.iss_id == iss_id).Select(fo => new FolioViewMode { folio_name = fo.folio_name, page_sequence = fo.page_sequence, dummy_folio_id = fo.dummy_folio_id, total_page = fo.total_page }); foreach (var folio in folios) { var item = new FolioLoadViewModel(); //item.folio = folio; item.pages = GetPagesByFolioId(folio.dummy_folio_id); item.folio_name = folio.folio_name; item.folio_id = folio.dummy_folio_id; item.folio_sequence = folio.page_sequence.GetValueOrDefault(); Folios.Add(item); } } return(Folios); }
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; })); }