using System.Collections.Generic;
using System.Linq;

namespace Neo.LegitimateLicences.Data.Models
{
    public partial class LegitimateDatabase 
    {
        #region LinkAssociationToRoute
        public void LinkAssociationToRoute(long associationID, long routeID, long userID)
        {
            Context.Pr_AssociationRouteAdd(associationID, routeID, userID);
        }
        #endregion

        #region DelinkAssociationFromRoute
        public void DelinkAssociationFromRoute(long associationID, long routeID, long userID)
        {
            Context.Pr_AssociationRouteRemove(associationID, routeID, userID);
        }
        #endregion

        #region IssueLicenceWithoutPrint
        public void IssueLicenceWithoutPrint(long licenceID, string reason, long userID)
        {
            Context.Pr_LicenceIssueWithoutPrint(licenceID, reason, userID);
        }
        #endregion

        #region GetVerifiedLicenceXml
        public string GetVerifiedLicenceXml(string olNumber, string idNumber, string registrationNumber, string chassisNumber)
        {
            return Context.Pr_VerifiedLicenceXmlGet(olNumber, idNumber, registrationNumber, chassisNumber).FirstOrDefault();
        }
        #endregion

        #region GetVerifiedMember
        public Pr_MemberGet_Result GetVerifiedMember(long memberID, long userID)
        {
            return Context.Pr_MemberGet(memberID, "", userID).FirstOrDefault();
        }

        public Pr_MemberGet_Result GetVerifiedMember(string memberIDNumberOrBusinessRegistrationNumber, long userID)
        {
            return Context.Pr_MemberGet(null, memberIDNumberOrBusinessRegistrationNumber, userID).FirstOrDefault();
        }

        ////public VerifiedMember GetVerifiedMember(long memberID)
        ////{
        ////    return Context.VerifiedMembers.Include("Status").Where(a => a.MemberID == memberID).FirstOrDefault();
        ////}

        ////public VerifiedMember GetVerifiedMember(string idNumber)
        ////{
        ////    if (!string.IsNullOrEmpty(idNumber))
        ////    {
        ////        return Context.VerifiedMembers.Include("Status").Where(a => a.IDNumberOrBusinessRegistrationNo.ToLower() == idNumber.ToLower()).FirstOrDefault();
        ////    }
        ////    else
        ////    {
        ////        return null;
        ////    }
        ////}
        #endregion

    }
}