using CAPI.Custom.Data.Repositories;
using CAPI.Custom.Entities;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CAPI.Custom.Repositories
{
    public class SurfaceLookupRepository : EntityRepository<SurfaceLookup>
    {
        public IQueryable<SurfaceLookupCategory> Categories => db.SurfaceLookupCategories;

        public IQueryable<SurfaceLookup> GetByCategoryId(int categoryId) => Entities
            .Where(p => p.isActive.Value && p.categoryId == categoryId)
            .OrderBy(p => p.sequence);

        public SurfaceLookupCategory GetCategoryById(int categoryId) => Categories
            .FirstOrDefault(p => p.recId == categoryId);

        public IQueryable<SurfaceLookup> GetByCategoryName(string categoryName) => Entities
            .Where(p =>
                p.isActive.Value && p.LookupCategory.lookupCategory.Equals(categoryName,
                StringComparison.OrdinalIgnoreCase))
            .OrderBy(p => p.sequence);

        public IQueryable<SurfaceLookup> QuoteStatuses => GetByCategoryName("Quote Status");

        public IQueryable<SurfaceLookup> BuyoutStatuses => GetByCategoryName("Buyout Status");

        public IQueryable<SurfaceLookup> BuyoutTypes => GetByCategoryName("Quote Buyout Type");
    }
}