public async ValueTask <Manga> GetManga(long mangaId, long userId)
{
using var context = Context;
var mangaService = new MangaService(context);
var chapterService = new ChapterService(context);
var mangaTagMappingService = new MangaTagMappingService(context);
var favoriteService = new FavoriteService(context);
var readProgressService = new ReadProgressService(context);
var commentProgressService = new CommentService(context);
var manga = await mangaService.GetSingleAsync(it => it.ObjectId == mangaId);
manga.Chapters = (await chapterService
.GetListAsync(it => it.MangaId == mangaId))
.OrderBy(it => it.Order)
.ToList();
manga.Tags = await mangaTagMappingService.GetTagByMangaId(mangaId);
if (userId <= 0)
{
return(manga);
}
manga.IsFavorite = await favoriteService.IsAnyAsync(it => it.EntityId == mangaId && it.UserId == userId);
manga.ReadProgresses = await readProgressService.GetListAsync(it => it.MangaId == mangaId && it.UserId == userId);
manga.Comment = await commentProgressService.GetSingleAsync(it => it.EntityId == mangaId && it.UserId == userId);
return(manga);
}
public async ValueTask <bool> Update(Manga manga, bool updateChapters)
{
using var context = Context;
var mangaService = new MangaService(context);
try
{
context.BeginTran();
if ((await mangaService.GetSingleAsync(it => it.ObjectId == manga.ObjectId)).Version >= manga.Version)
{
context.RollbackTran();
return(false);
}
manga.UpdateTime = DateTime.Now;
if (updateChapters && manga.Chapters != null && manga.Chapters.Count != 0)
{
var chapterService = new ChapterService(context);
var imageService = new ImageService(context);
var result = await chapterService.Upsert(manga.Chapters);
if (result.InsertList.Count != 0)
{
foreach (var storageableMessage in result.InsertList)
{
DataFormatter.Format(storageableMessage.Item);
await imageService.Upsert(storageableMessage.Item.Images);
}
}
}
if (manga.Tags != null)
{
var mangaTagMappingService = new MangaTagMappingService(context);
await mangaTagMappingService.DeleteTagByMangaId(manga.ObjectId);
var mangaTagMappings = manga.Tags.Select(tag => new MangaTagMapping()
{
MangaId = manga.ObjectId,
TagId = tag.Key
}).ToList();
if (mangaTagMappings.Count > 0)
{
await mangaTagMappingService.Insert(mangaTagMappings);
}
}
await mangaService.Upsert(manga);
FtsIndexService.UpdateFtsIndex(manga);
context.CommitTran();
return(true);
}
catch (Exception e)
{
context.RollbackTran();
throw;
}
}
public async ValueTask <Manga> GetManga(long pathId)
{
using var context = Context;
var mangaService = new MangaService(context);
var chapterService = new ChapterService(context);
var mangaTagMappingService = new MangaTagMappingService(context);
var manga = await mangaService.GetSingleAsync(it => it.PathId == pathId);
manga.Chapters = await chapterService.GetListAsync(it => it.MangaId == manga.ObjectId);
manga.Tags = await mangaTagMappingService.GetTagByMangaId(manga.ObjectId);
return(manga);
}
public async ValueTask <bool> Insert(Manga manga)
{
if (!DataFormatter.Format(manga))
{
return(false);
}
using var context = Context;
try
{
context.BeginTran();
var mangaService = new MangaService(context);
await mangaService.Upsert(manga);
var chapterService = new ChapterService(context);
await chapterService.Upsert(manga.Chapters);
var imageService = new ImageService(context);
var images = manga.Chapters.SelectMany(it => it.Images).ToList();
images.Add(manga.Cover);
await imageService.Upsert(images);
if (manga.Tags != null && manga.Tags.Count > 0)
{
var mangaTagMappingService = new MangaTagMappingService(context);
var mappings = manga.Tags.Select(it => new MangaTagMapping()
{
MangaId = manga.ObjectId, TagId = it.Key
}).ToList();
await mangaTagMappingService.Insert(mappings);
}
FtsIndexService.CreateFtsIndex(new List <Manga>()
{
manga
});
context.CommitTran();
return(true);
}
catch (Exception e)
{
context.RollbackTran();
throw;
}
}
public async ValueTask <bool> Upsert(ReadProgress readProgress)
{
using var context = Context;
try
{
context.BeginTran();
readProgress.ReadTime = DateTime.Now;
var chapterService = new ChapterService(context);
readProgress.MangaId = (await chapterService.GetSingleAsync(it => it.ObjectId == readProgress.ChapterId)).MangaId;
var readProgressService = new ReadProgressService(context);
var result = readProgressService.Upsert(readProgress);
context.CommitTran();
return(true);
}
catch (Exception e)
{
context.RollbackTran();
throw;
}
}
public async ValueTask <bool> DeleteManga(long mangaId)
{
using var context = Context;
var mangaService = new MangaService(context);
var chapterService = new ChapterService(context);
var imageService = new ImageService(context);
var mangaTagMappingService = new MangaTagMappingService(context);
var favoriteService = new FavoriteService(context);
var readProgressService = new ReadProgressService(context);
context.BeginTran();
try
{
var chapters = await chapterService.GetListAsync(it => it.MangaId == mangaId);
var chapterIds = chapters.Select(it => it.ObjectId).ToList();
await mangaService.DeleteAsync(it => it.ObjectId == mangaId);
await mangaTagMappingService.DeleteAsync(it => it.MangaId == mangaId);
await chapterService.DeleteAsync(it => it.MangaId == mangaId);
await imageService.DeleteAsync(it => chapterIds.Contains(it.ChapterId));
await favoriteService.DeleteAsync(it => it.EntityId == mangaId);
await readProgressService.DeleteAsync(it => it.MangaId == mangaId);
context.CommitTran();
FtsIndexService.DeleteMangaFtxIndex(mangaId);
return(true);
}
catch (Exception e)
{
context.RollbackTran();
throw;
}
}
public async ValueTask <Chapter> GetChapter(long chapterId, long userId)
{
using var context = Context;
var chapterService = new ChapterService(context);
var imageService = new ImageService(context);
var readProgressService = new ReadProgressService(context);
var chapter = await chapterService.GetSingleAsync(it => it.ObjectId == chapterId);
chapter.ReadProgress =
await readProgressService.GetSingleAsync(it => it.ChapterId == chapterId && it.UserId == userId);
chapter.Images = await imageService.GetListAsync(it => it.ChapterId == chapterId);
var uncheckedImage = chapter.Images.Where(it => it.Height == 0).ToList();
if (uncheckedImage.Count == 0)
{
return(chapter);
}
foreach (var image in uncheckedImage)
{
await using var file = LibraryManager.GeFileTreeNode(image.PathId).OpenRead();
var(result, width, height) = await ImageUtils.GetMetadata(file);
file.Close();
image.Height = height;
image.Width = width;
}
context.BeginTran();
await imageService.Upsert(uncheckedImage);
context.CommitTran();
return(chapter);
}
