using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Neo.Legitimate.Common;
using Pilotfish.Afx.ComponentModel;
using System.Linq;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System;

namespace Neo.Legitimate.LicenceIssueRequest.Models
{
    public class LicenceIssueDatabase : Database<LicenceIssueContext>
    {
        #region LicenceIssueDatabase
        public LicenceIssueDatabase()
            : base(new LicenceIssueContext())
        {

        } 
        #endregion

        #region GetLicenceIssueRequest
        public LicenceIssueDetail GetLicenceIssueRequest(long licenceIssueDetailID, long userID)
        {
            var details = (from q in Context.LicenceIssueDetails.Include("Licence").Include("Vehicle").Include("Documents").Include("Documents.DocumentType").Include("Licence.Exceptions").Include("Licence.Routes").Include("Licence.Routes.RouteType").Include("Licence.Member").Include("Licence.Routes.Origin").Include("Licence.Routes.Destination").Include("Inspection").Include("ApplicationRequestDetail").Include("ApplicationRequestDetail.ApplicationVehicle")
                           where q.LicenceIssueDetailID == licenceIssueDetailID
                           select q).FirstOrDefault();

            if (details.Vehicle == null)
            {
                details.Vehicle = new Vehicle() { VehicleID =-1, VehicleStatusID=1};
            }

            return details;
        }
        #endregion

        #region GetLicencesLinkedByVIN
        public string GetLicencesLinkedByVIN(string VIN)
        {
            return Context.Pr_VehicleGetLinkedByVIN(VIN).FirstOrDefault();
        }
        #endregion        

        #region CheckSecurity
        public void CheckSecurity(long licenceIssueDetailID, string action, long userID)
        {
            Context.Pr_LicenceIssueCheckSecurity(licenceIssueDetailID, action, userID);
        }
        #endregion

        #region CleanseUnusedVehicleData
        public void CleanseUnusedVehicleData()
        {
            Context.Pr_CleanseUnusedVehicleData();
        }
        #endregion
    }
}