public Task <List <ExportStory> > GetStoryAsync(StorySeriesSearch model)
{
var exports = _context.ExportStory
.AsNoTracking()
.ToListAsync();
return(exports);
}
public async Task <IActionResult> GetReportAsync([FromQuery] StorySeriesSearch storySearch)
{
var export = await _exportBooksService.GetExportAsync(storySearch);
if (export == null)
{
return(NotFound());
}
return(Ok(export));
}
public Task <List <ExportBook> > GetAsync(StorySeriesSearch model)
{
var exports = from storySeries in _context.StorySeries
where (!model.Active.HasValue || storySeries.Deleted == model.Active.Value) &&
(model.Filter == null ||
model.Filter.Length == 0 ||
storySeries.StoryName.ToLower().Contains(model.Filter.ToLower())
)
orderby storySeries.StoryName,
storySeries.StoryNumber,
storySeries.StoryType,
storySeries.Issue,
storySeries.IssueTitle,
storySeries.StoryId,
storySeries.BookId,
storySeries.SeriesId
select new ExportBook
{
StoryId = storySeries.StoryId,
BookId = storySeries.BookId,
SeriesId = storySeries.SeriesId,
/*
* CodeId = storySeries.CodeId,
* MinSeriesOrder = storySeries.MinSeriesOrder,
* MaxSeriesOrder = storySeries.MaxSeriesOrder,
*/
Title = storySeries.StoryName,
OriginalTitle = storySeries.OriginalStoryName,
StoryNumber = storySeries.StoryNumber,
ExtraInfo = storySeries.ExtraInfo,
StoryType = storySeries.StoryType,
BookType = storySeries.BookType,
Character = storySeries.CharacterName,
StoryCode = storySeries.StoryCode,
Artist = storySeries.ArtistName,
/*ArtistType = storySeries.ArtistType is null ? ArtistType.translator : storySeries.ArtistType,*/
Issue = storySeries.Issue,
IssueTitle = storySeries.IssueTitle,
Language = storySeries.Language,
Series = storySeries.SeriesName,
Publisher = storySeries.PublisherName,
Year = storySeries.Year,
PurchaseDate = storySeries.PurchaseDate,
Notes = storySeries.ExtraInfo,
Deleted = storySeries.Deleted
};
return(exports
.ToListAsync());
}
public async Task <ICollection <ExportBooksOutputModel> > GetAsync(StorySeriesSearch searchModel)
{
var exportBooks = await _exportBooksRepository.GetAsync(searchModel);
try
{
var exportBooksOutput = _mapper.Map <ICollection <ExportBooksOutputModel> >(exportBooks);
return(exportBooksOutput);
}
catch (Exception)
{
return(null);
}
}
public Task <List <ExportBook> > GetAsync(StorySeriesSearch model)
{
var exports = _context.ExportBooks
.Where(s => (!model.Active.HasValue || s.Deleted == model.Active.Value) &&
(model.Filter == null || model.Filter.Length == 0 || s.Title.ToLower().Contains(model.Filter.ToLower())))
.OrderBy(e => e.Title)
.ThenBy(e => e.StoryNumber)
.ThenBy(e => e.StoryType)
.ThenBy(e => e.Issue)
.ThenBy(e => e.IssueTitle)
.ThenBy(e => e.StoryId)
.ThenBy(e => e.BookId)
.ThenBy(e => e.SeriesId)
.AsNoTracking()
.ToListAsync();
return(exports);
}
public async Task <string> GetExportAsync(StorySeriesSearch searchModel)
{
return(Reports.Reports.DataExport(await _exportBooksRepository.GetAsync(searchModel)));
}
public async Task <IActionResult> GetAsync([FromQuery] StorySeriesSearch storySearch)
{
var result = await _exportBooksService.GetAsync(storySearch);
return(Ok(result));
}