namespace CAPI.Custom.Data
{
    using CAPI.Custom.Entities;
    using framework_library;
    using System;
    using System.Collections.Generic;
    using System.Linq;

    /// <summary>
    /// Summary description for QuotesContext_QuoteItemsFinal
    /// </summary>
    public partial class QuotesContext
	{
        public Dictionary<string, List<QuoteItemsFinal>> QuoteItemsFinal_GetByQuote(int quoteId)
        {
            return QuoteItemsFinal
                .Where(p =>
                    p.isActive.Value
                    && p.ParentSurfaceItemId == quoteId
                ).GroupBy(p => p.Supplier).OrderBy(p => p.Key).ToDictionary(p => p.Key, p => p.ToList());
        }
    }
}