using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using Neo.Legitimate.Common;
using Pilotfish.Afx.ComponentModel;
using Pilotfish.Afx.Security;
using Neo.Legitimate.Common.Helpers;
using System.Threading;
using System.Data.Entity;

namespace Neo.Legitimate.Data.Models.Ltps
{
    public partial class LtpsEntities
    {
        public LtpsEntities(string connectionString)
            : base(connectionString)
        {
        }
    }

    public partial class LtpsDatabase : Database<LtpsEntities>
    {
        public LtpsDatabase()
            : base(new LtpsEntities())
        {

        }

        /// <summary>
        /// Constructor for use by Windows service
        /// </summary>
        /// <param name="connectionString"></param>
        public LtpsDatabase(string connectionString)
            : base(new LtpsEntities(connectionString))
        {

        }

        public List<LtpsData> ManuallyAddedLtpsPermits()
        {
            return Context.LtpsData.Where(a => a.RecordAddedManually).ToList();
        }

        public void InsertLtpsPermit(string applicationNumber, string applicationDate, string applicationType, string receiptNumber, string iDNumber, string firstName, string lastName, string initials, string permitNumber, string startDate, string endDate, long userID)
        {
            Context.Pr_LtpsDataInsert(applicationNumber, applicationDate, applicationType, receiptNumber, iDNumber, firstName, lastName, initials, permitNumber, startDate, endDate, userID);
        }

    }
}