Files

99 lines
3.2 KiB
C#

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using DataServer.Data;
using DataServer.Data.Entities;
namespace GameServices.Admin.Pages.Recipes;
public class IndexModel : AdminPageModel
{
private readonly GameDbContext _db;
public IndexModel(GameDbContext db)
{
_db = db;
}
public List<DungeonCraftingRecipe> Recipes { get; set; } = new();
[FromQuery(Name = "search")]
public string? Search { get; set; }
[FromQuery(Name = "skill")]
public CraftingSkillType? SkillFilter { get; set; }
[FromQuery(Name = "page")]
public int CurrentPage { get; set; } = 1;
public int PageSize { get; set; } = 20;
public int TotalCount { get; set; }
public int TotalPages => (int)Math.Ceiling(TotalCount / (double)PageSize);
public string CdnBaseUrl { get; set; } = "https://assets.aeternalisgames.com";
public string GetPageUrl(int page)
{
var parts = new List<string> { $"page={page}" };
if (!string.IsNullOrEmpty(Search)) parts.Add($"search={Uri.EscapeDataString(Search)}");
if (SkillFilter.HasValue) parts.Add($"skill={SkillFilter}");
return "/admin/recipes?" + string.Join("&", parts);
}
public async Task OnGetAsync()
{
if (CurrentPage < 1) CurrentPage = 1;
var cdnUrl = Environment.GetEnvironmentVariable("CDN_BASE_URL");
if (!string.IsNullOrEmpty(cdnUrl)) CdnBaseUrl = cdnUrl;
var query = _db.DungeonCraftingRecipes
.Include(r => r.OutputItem)
.Include(r => r.Ingredients)
.AsQueryable();
if (!string.IsNullOrWhiteSpace(Search))
query = query.Where(r => r.Name.Contains(Search) || r.Description.Contains(Search));
if (SkillFilter.HasValue)
query = query.Where(r => r.SkillType == SkillFilter.Value);
TotalCount = await query.CountAsync();
Recipes = await query
.OrderBy(r => r.SkillType)
.ThenBy(r => r.RequiredLevel)
.ThenBy(r => r.Id)
.Skip((CurrentPage - 1) * PageSize)
.Take(PageSize)
.ToListAsync();
}
public async Task<IActionResult> OnPostDeleteAsync(int id)
{
var recipe = await _db.DungeonCraftingRecipes
.Include(r => r.Ingredients)
.FirstOrDefaultAsync(r => r.Id == id);
if (recipe != null)
{
// Remove ingredients
_db.DungeonCraftingRecipeIngredients.RemoveRange(recipe.Ingredients);
// Remove any character known recipes referencing this
var knownRecipes = await _db.DungeonCharacterKnownRecipes
.Where(kr => kr.RecipeId == id)
.ToListAsync();
_db.DungeonCharacterKnownRecipes.RemoveRange(knownRecipes);
// Remove any recipe scrolls referencing this
var scrolls = await _db.DungeonRecipeScrolls
.Where(s => s.RecipeId == id)
.ToListAsync();
_db.DungeonRecipeScrolls.RemoveRange(scrolls);
_db.DungeonCraftingRecipes.Remove(recipe);
await _db.SaveChangesAsync();
}
return RedirectToPage();
}
}