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

namespace Neo.LegitimateLicences.Data.Models
{
    public partial class LegitimateDatabase 
    {
        #region GetRoutePurificationCounts
        public Pr_Purification_RouteCounts_Result GetRoutePurificationCounts(long userID)
        {
            return Context.Pr_Purification_RouteCounts(userID).FirstOrDefault();
        }
        #endregion

        #region GetRoutePurification_RouteAwaitingRouteDescriptionChecksList
        public List<Pr_Purification_RouteAwaitingRouteDescriptionChecks_Result> GetRoutePurification_RouteAwaitingRouteDescriptionChecksList(int top, long userID)
        {
            return Context.Pr_Purification_RouteAwaitingRouteDescriptionChecks(userID).Take(top).ToList();
        }
        #endregion

        #region GetRoutePurification_DuplicateNationalRouteNumbersList
        public List<Pr_Purification_RouteDuplicateNationalRouteNumbers_Result> GetRoutePurification_DuplicateNationalRouteNumbersList(int top, long userID)
        {
            return Context.Pr_Purification_RouteDuplicateNationalRouteNumbers(userID).Take(top).ToList();
        }
        #endregion

        #region GetRoutePurification_DuplicateBoardRouteNumbersList
        public List<Pr_Purification_RouteDuplicateBoardRouteNumbers_Result> GetRoutePurification_DuplicateBoardRouteNumbersList(int top, long userID)
        {
            return Context.Pr_Purification_RouteDuplicateBoardRouteNumbers(userID).Take(top).ToList();
        }
        #endregion

        #region GetRoutePurification_DuplicatePlacesList
        public List<Pr_Purification_RouteDuplicatePlaces_Result> GetRoutePurification_DuplicatePlacesList(int top, long userID)
        {
            return Context.Pr_Purification_RouteDuplicatePlaces(userID).Take(top).ToList();
        }
        #endregion

        #region UpdateVerifiedRouteDescriptionFromPurification
        public void UpdateVerifiedRouteDescriptionFromPurification(long routeID, long originPlaceID, long destinationPlaceID, string description, int routeTypeID, long? timeTableDocumentID, long? fareScheduleDocumentID,  long userID)
        {
            Context.Pr_Purification_RouteDescriptionUpdate(routeID, originPlaceID, destinationPlaceID, description, routeTypeID, timeTableDocumentID, fareScheduleDocumentID, userID);
        }
        #endregion

        #region DeleteVerifiedRouteFromPurification
        public void DeleteVerifiedRouteFromPurification(long routeID, long userID)
        {
            Context.Pr_Purification_RouteDelete(routeID, userID);
        }
        #endregion

        #region GetDuplicateNationalRouteNumberDetails
        public List<Pr_Purification_RouteDuplicateNationalRouteNumberDetails_Result> GetDuplicateNationalRouteNumberDetails(string nationalRouteNumber, long userID)
        {
            return Context.Pr_Purification_RouteDuplicateNationalRouteNumberDetails(nationalRouteNumber, userID).ToList();
        }
        #endregion

        #region MergeRoute
        public void MergeRoutes(long mergeWithRouteID, long obsoleteRouteID, long userID)
        {
            Context.Pr_RouteMerge(mergeWithRouteID, obsoleteRouteID, userID);
        }
        #endregion

        #region GetDuplicateBoardRouteNumberDetails
        public List<Pr_Purification_RouteDuplicateBoardRouteNumberDetails_Result> GetDuplicateBoardRouteNumberDetails(string boardRouteNumber, long userID)
        {
            return Context.Pr_Purification_RouteDuplicateBoardRouteNumberDetails(boardRouteNumber, userID).ToList();
        }
        #endregion

        #region GetPotentialOLASRouteChangeList
        public List<Pr_Purification_RoutesWithPotentialChangesFromOLAS_Result> GetPotentialOLASRouteChangeList(int top, long userID)
        {
            return Context.Pr_Purification_RoutesWithPotentialChangesFromOLAS(userID).Take(top).ToList();
        }
        #endregion

        #region GetBlockedLicences
        public List<Pr_ApplicationBlockedLicencesGet_Result> GetBlockedLicences()
        {
            return Context.Pr_ApplicationBlockedLicencesGet().ToList();
        }
        #endregion

        #region CreateBlockedLicence
        public void CreateBlockedLicence(string operatingLicenceNumber, string reason, long userID)
        {
            Context.Pr_ApplicationBlockedLicenceCreate(operatingLicenceNumber, reason, userID);
        }
        #endregion

        #region DeleteBlockedLicence
        public void DeleteBlockedLicence(string operatingLicenceNumber, long userID)
        {
            Context.Pr_ApplicationBlockedLicenceDelete(operatingLicenceNumber, userID);
        }
        #endregion

        #region Purification_GetApplicationVehicleType
        public Pr_SearchApplicationLicenceVehicleType_Result Purification_GetApplicationVehicleType(string applicationLicenceReferenceNumber, long userID)
        {
            return Context.Pr_SearchApplicationLicenceVehicleType(applicationLicenceReferenceNumber, userID).FirstOrDefault();
        }
        #endregion

        #region Purification_GetApplicationServiceType
        public List<Pr_SearchApplicationServiceTypes_Result> Purification_GetApplicationServiceType(string applicationLicenceReferenceNumber, long userID)
        {
            return Context.Pr_SearchApplicationServiceTypes(applicationLicenceReferenceNumber, userID).ToList();
        }
        #endregion

        #region Purification_GetLicenceVehicleType
        public Pr_SearchApplicationServiceTypes_Result Purification_GetLicenceVehicleType(string lgNumber, long userID)
        {
            return Context.Pr_SearchApplicationServiceTypes(lgNumber, userID).FirstOrDefault();
        }
        #endregion

        #region Purification_SearchLicenceServiceTypes
        public List<Pr_SearchLicenceServiceTypes_Result> Purification_SearchLicenceServiceTypes(string applicationLicenceReferenceNumber, long userID)
        {
            return Context.Pr_SearchLicenceServiceTypes(applicationLicenceReferenceNumber, userID).ToList();
        }
        #endregion

        #region Purification_GetApplicationServiceTypes
        public List<Pr_Purification_SearchApplicationServiceTypes_Result> Purification_GetApplicationServiceTypes(string appReferenceNumber, long userID)
        {
            return Context.Pr_Purification_SearchApplicationServiceTypes(appReferenceNumber, userID).ToList();
        }
        #endregion

        #region Purification_VerifiedLicenceServiceTypesGet
        public List<Pr_VerifiedLicenceServiceTypesGet_Result> Purification_VerifiedLicenceServiceTypesGet(long licenceID, long userID)
        {
            return Context.Pr_VerifiedLicenceServiceTypesGet(licenceID, userID).ToList();
        }
        #endregion        

        #region Purification_GetApplicationRoutes
        public List<Pr_SearchApplicationRoutes_Result> Purification_GetApplicationRoutes(string appReferenceNumber, long userID)
        {
            return Context.Pr_SearchApplicationRoutes(appReferenceNumber, userID).ToList();
        }
        #endregion

        #region Purification_UpdateApplicationLicenceVehicleType
        public void Purification_UpdateApplicationLicenceVehicleType(long applicationDetailID, long applicationLicenceID, short newVehicleTypeID, long userID)
        {
            Context.Pr_ApplicationLicenceVehicleTypeUpdate(applicationDetailID, applicationLicenceID, newVehicleTypeID, userID).ToList();
        }
        #endregion        

        #region Purification_GetLicenceRoutes
        public List<Pr_SearchLicenceRoutes_Result> Purification_GetLicenceRoutes(string lirReferenceNumber, long userID)
        {
            return Context.Pr_SearchLicenceRoutes(lirReferenceNumber, userID).ToList();
        }
        #endregion

        #region Purification_GetItemIDFromReferenceNumber
        public long? Purification_GetItemIDFromReferenceNumber(string referenceNumber)
        {
            return Context.Pw_GetItemIDFromReference(referenceNumber).FirstOrDefault();
        }
        #endregion        

        #region Purification_UpdateLicenceMode
        public void Purification_UpdateLicenceMode(long licenceID, short modeID, long userID)
        {
            Context.Pr_PurificationLicenceModeUpdate(licenceID, modeID, userID);
        }
        #endregion

        #region Purification_ApplicationServiceTypeAdd
        public void Purification_ApplicationServiceTypeAdd(long applicationDetailID, long applicationLicenceID, short serviceTypeID, string serviceTypeDescription, long userID)
        {
            Context.Pr_ApplicationServiceTypeAdd(applicationDetailID, applicationLicenceID, serviceTypeID, serviceTypeDescription, userID);
        }
        #endregion

        #region Purification_ApplicationServiceTypeRemove
        public void Purification_ApplicationServiceTypeRemove(long applicationDetailID, long applicationLicenceID, long applicationLicenceServiceDetailID, long userID)
        {
            Context.Pr_ApplicationServiceTypeRemove(applicationDetailID, applicationLicenceID, applicationLicenceServiceDetailID, userID);
        }
        #endregion

        #region Purification_ApplicationServiceTypeUpdate
        public void Purification_ApplicationServiceTypeUpdate(long applicationDetailID, long applicationLicenceID, long applicationLicenceServiceDetailID, short newServiceTypeID, long userID)
        {
            Context.Pr_ApplicationServiceTypeUpdate(applicationDetailID, applicationLicenceID, applicationLicenceServiceDetailID, newServiceTypeID, userID);
        }
        #endregion

        #region Purification_AddLicenceServiceType
        public void Purification_AddLicenceServiceType(long licenceID, short serviceTypeID, string serviceTypeDescription, long userID)
        {
            Context.Pr_PurificationLicenceServiceTypeAdd(licenceID, serviceTypeID, serviceTypeDescription, userID);
        }
        #endregion        

        #region Purification_RemoveLicenceServiceType
        public void Purification_RemoveLicenceServiceType(long licenceID, long licenceServcieDetailID, long userID)
        {
            Context.Pr_PurificationLicenceServiceTypeRemove(licenceID, licenceServcieDetailID, userID);
        }
        #endregion

        #region Purification_AddApplicationRoute
        public void Purification_AddApplicationRoute(long applicationLicenceID, short serviceTypeID, string nationalRouteNumber, string boardRouteNumber, long userID)
        {
            Context.Pr_ApplicationRouteAdd(applicationLicenceID, serviceTypeID, nationalRouteNumber, boardRouteNumber, userID);
        }
        #endregion

        #region Purification_AddLicenceRoute
        public void Purification_AddLicenceRoute(long licenceIssueDetailID, short serviceTypeID, string nationalRouteNumber, string boardRouteNumber, long userID)
        {
            Context.Pr_PurificationLicenceRouteAdd(licenceIssueDetailID, serviceTypeID, nationalRouteNumber, boardRouteNumber, userID);
        }
        #endregion

        #region Purification_RemoveApplicationRoute
        public void Purification_RemoveApplicationRoute(long applicationLicenceID, long? verifedRouteID, string nationalRouteNumber, string boardRouteNumber, long userID)
        {
            Context.Pr_ApplicationRouteRemove(applicationLicenceID, verifedRouteID, nationalRouteNumber, boardRouteNumber, userID);
        }
        #endregion

        #region Purification_GetApplicationLicense
        public Pr_ApplicationLicenseGet_Result Purification_GetApplicationLicense(string referenceNumber, long userID)
        {
            return Context.Pr_ApplicationLicenseGet(referenceNumber, userID).FirstOrDefault();
        }
        #endregion


        #region Purification_SearchApplicationLicense
        public List<Pr_ApplicationLicenseSearch_Result> Purification_SearchApplicationLicense(string referenceNumber, long userID)
        {
            return Context.Pr_ApplicationLicenseSearch(referenceNumber, userID).ToList();
        }
        #endregion

        #region Purification_RemoveLicenceRoute
        public void Purification_RemoveLicenceRoute(long licenceIssueDetailID, long? verifedRouteID, string licenceNationalRouteNumber, string licenceBoardRouteNumber, long userID)
        {
            Context.Pr_PurificationLicenceRouteRemove(licenceIssueDetailID, verifedRouteID, licenceNationalRouteNumber, licenceBoardRouteNumber, userID);
        }
        #endregion

        #region Purification_FindMember
        public Pr_FindMember_Result Purification_FindMember(string idNumber, long userID)
        {
            return Context.Pr_FindMember(idNumber, userID).FirstOrDefault();
        }
        #endregion

        #region Purification_UpdateMember

        public void Purification_UpdateMember(string idNumber, string surname, string firstNames, string tradeName, string postalAddress, string postalAddressCode, string physicalAddress, string physicalAddressCode, string telPhone, string telCell, string telFax, string email, string sarsIncomeTaxNumber, long? businessTypeID, long userID)
        {
            Context.Pr_UpdateMember(idNumber, surname, firstNames, postalAddress, postalAddressCode, physicalAddress, physicalAddressCode, telPhone, telCell, telFax, email, sarsIncomeTaxNumber, tradeName, businessTypeID, userID);
        }
        #endregion

        #region GetBlockedIDNumbers
        public List<Pr_ApplicationBlockedIDNumbersGet_Result> GetBlockedIDNumbers()
        {
            return Context.Pr_ApplicationBlockedIDNumbersGet().ToList();
        }
        #endregion

        #region CreateBlockedIDNumber
        public void CreateBlockedIDNumber(string IDNumberNumber, string reason, long userID)
        {
            Context.Pr_ApplicationBlockedIDNumberCreate(IDNumberNumber, reason, userID);
        }
        #endregion

        #region DeleteBlockedIDNumber
        public void DeleteBlockedIDNumber(string IDNumberNumber, long userID)
        {
            Context.Pr_ApplicationBlockedIDNumberDelete(IDNumberNumber, userID);
        }
        #endregion

        #region GetSourceData
        public List<Fn_GetSourceApplicationRecordsFromSourceSystem_Result>  GetSourceXml(string olPermitNumber, short sourceApplicationID, short modeID, bool includeActiveOnly, bool includeLastExpiredIfNoActiveFound)
        {
            return new List<Fn_GetSourceApplicationRecordsFromSourceSystem_Result>(); //Context.Fn_GetSourceApplicationRecordsFromSourceSystem(olPermitNumber, sourceApplicationID, modeID, includeActiveOnly, includeLastExpiredIfNoActiveFound).ToList();
        }
        #endregion

        #region Purification_GetApplicationTypesForConversion
        public List<Pr_GetApplicationTypesForConversion_Result> Purification_GetApplicationTypesForConversion(string applicationNumber, long userID)
        {
            return Context.Pr_GetApplicationTypesForConversion(applicationNumber, userID).ToList();
        }
        #endregion

        #region Purification_ConvertApplicationType

        public void Purification_ConvertApplicationType(long applicationDetailID, short newApplicationRequestTypeID, string reason, long userID)
        {
            Context.Pr_ApplicationConversionChangeType(applicationDetailID, newApplicationRequestTypeID, reason, userID);
        }
        #endregion

       
        #region Purification_GetUserDataOnIdSearch
        public List<Pr_Purification_GetUserDataOnIdSearch_Result> Purification_GetUserDataOnIdSearch(string oldIdNumber, string newIdNumber, long userID)
        {
            return Context.Pr_Purification_GetUserDataOnIdSearch(oldIdNumber, newIdNumber, userID).ToList();
        }
        #endregion

        #region Purification_UpdateIdNumber
        public void Purification_UpdateIdNumber(string oldIdNumber, string newIdNumber, long userID)
        {
            Context.Pr_UpdateIdNumber(oldIdNumber, newIdNumber, userID);
        }
        #endregion

        #region Purification_UpdateIdNumber
        public List<Pr_LicenceServiceTypesGet_Result> Purification_GetLicenceServiceTypes(long applicationLicenceID, long userID)
        {
            return Context.Pr_LicenceServiceTypesGet(applicationLicenceID, userID).ToList();
        }
        #endregion
    }
}