//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;
}));
}
