using CAPI.Custom.Data;
using CAPI.Custom.Data.Repositories;
using CAPI.Custom.Entities;
using System;
using System.Linq;

namespace CAPI.Custom.Repositories
{
    public class CustomerRepository : SurfaceEntityRepository<Customer>
    {
        public IQueryable<Customer> GetActive() =>
            Entities.Where(p => "ACTIVE".Equals(p.Status, StringComparison.OrdinalIgnoreCase));

        public Customer GetByCustomerCode(string customerCode) =>
            Entities.FirstOrDefault(p => customerCode.Equals(p.Code, StringComparison.OrdinalIgnoreCase));

        public IQueryable<Contact> GetContacts(int customerId) =>
            db.Set<Contact>().GetQueryItemByParentId<Contact>(customerId);
    }
}