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

namespace Neo.Legitimate.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_GetApplicationMode
        public Pr_Purification_SearchApplicationMode_Result Purification_GetApplicationMode(string appReferenceNumber)
        {
            return Context.Pr_Purification_SearchApplicationMode(appReferenceNumber).FirstOrDefault();
        }
        #endregion

        #region Purification_GetLicenceMode
        public Pr_Purification_SearchLicenceMode_Result Purification_GetLicenceMode(string lgNumber)
        {
            return Context.Pr_Purification_SearchLicenceMode(lgNumber).FirstOrDefault();
        }
        #endregion

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

        #region Purification_GetLicenceServiceTypes
        public List<Pr_Purification_SearchLicenceServiceTypes_Result> Purification_GetLicenceServiceTypes(string lgNumber)
        {
            return Context.Pr_Purification_SearchLicenceServiceTypes(lgNumber).ToList();
        }
        #endregion

        #region Purification_GetApplicationRoutes
        public List<Pr_Purification_SearchApplicationRoutes_Result> Purification_GetApplicationRoutes(string appReferenceNumber)
        {
            return Context.Pr_Purification_SearchApplicationRoutes(appReferenceNumber).ToList();
        }
        #endregion

        #region Purification_GetLicenceRoutes
        public List<Pr_Purification_SearchLicenceRoutes_Result> Purification_GetLicenceRoutes(string lirReferenceNumber)
        {
            return Context.Pr_Purification_SearchLicenceRoutes(lirReferenceNumber).ToList();
        }
        #endregion

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

        #region Purification_UpdateApplicationMode
        public void Purification_UpdateApplicationMode(long applicationRequestDetailID, short modeID, long userID)
        {
            Context.Pr_PurificationApplicationModeUpdate(applicationRequestDetailID, modeID, userID);
        }
        #endregion

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

        #region Purification_AddApplicationServiceType
        public void Purification_AddApplicationServiceType(long applicationRequestDetailID, short serviceTypeID, string serviceTypeDescription, long userID)
        {
            Context.Pr_PurificationApplicationServiceTypeAdd(applicationRequestDetailID, serviceTypeID, serviceTypeDescription, 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_RemoveApplicationServiceType
        public void Purification_RemoveApplicationServiceType(long applicationRequestDetailID, long applicationServiceDetailID, long userID)
        {
            Context.Pr_PurificationApplicationServiceTypeRemove(applicationRequestDetailID, applicationServiceDetailID, 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 applicationRequestDetailID, string nationalRouteNumber, string boardRouteNumber, string reason, long userID)
        {
            Context.Pr_PurificationApplicationRouteAdd(applicationRequestDetailID, nationalRouteNumber, boardRouteNumber, reason, userID);
        }
        #endregion

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

        #region Purification_RemoveApplicationRoute
        public void Purification_RemoveApplicationRoute(long applicationRequestDetailID, string applicationNationalRouteNumber, string applicationBoardRouteNumber, string reason, long userID)
        {
            Context.Pr_PurificationApplicationRouteRemove(applicationRequestDetailID, applicationNationalRouteNumber, applicationBoardRouteNumber, reason, userID);
        }
        #endregion

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

        #region Purification_FindMember
        public Pr_Purification_FindMember_Result Purification_FindMember(string idNumber, long userID)
        {
            return Context.Pr_Purification_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, string sarsReasonIfNoTaxNumber, long? businessTypeID, long userID)
        {
            Context.Pr_Purification_UpdateMember(idNumber, surname, firstNames, postalAddress, postalAddressCode, physicalAddress, physicalAddressCode, telPhone, telCell, telFax, email, sarsIncomeTaxNumber, sarsReasonIfNoTaxNumber, 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 Context.Fn_GetSourceApplicationRecordsFromSourceSystem(olPermitNumber, sourceApplicationID, modeID, includeActiveOnly, includeLastExpiredIfNoActiveFound).ToList();
        }
        #endregion

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

        #region Purification_ConvertApplicationType

        public void Purification_ConvertApplicationType(long? ApplicationRequestDetailID, int NewApplicationRequestTypeID, string Reason)
        {
            Context.Pr_ApplicationConversionChangeType(ApplicationRequestDetailID, NewApplicationRequestTypeID, Reason);
        }
        #endregion

        #region Purification_GetReceipt
        public Pr_GetReceipt_Result Purification_GetReceipt(string receiptNumber)
        {
            return Context.Pr_GetReceipt(receiptNumber).FirstOrDefault();
        }
        #endregion

        #region Purification_SetReceiptToZero
        public void  Purification_SetReceiptToZero(long? receiptDetailID, string reason, long userID)
        {
            Context.Pr_SetReceiptToZero(receiptDetailID, reason, userID);
        }
        #endregion

        #region AddReceiptToApplication
        public void AddReceiptToApplication(long? receiptDetailID, string applicationReferenceNumber, string reason, long userID)
        {
            Context.Pr_AddReceiptToApplication(receiptDetailID, applicationReferenceNumber, reason, userID);
        }
        #endregion

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

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

        #region Purification_UpdateApplicationRouteChangeType
        public void Purification_UpdateApplicationRouteChangeType(long applicationRouteDetailID, short newRouteChangeTypeID, string reason, long userID)
        {
            Context.Pr_Purification_ApplicationRouteChangeUpdate(applicationRouteDetailID, newRouteChangeTypeID, reason, userID);
        }
        #endregion
    }
}