using System.Data;
using Neo.Afx.ComponentModel;
using System.Linq;
using System.Collections.Generic;
using Neo.LegitimateLicences.Common;
using System;

namespace Neo.LegitimateLicences.LicenceCancelRequest.Models.Database
{
    public class LicenceCancelDatabase : Database<LicenceCancelContext>
    {
        #region LicenceCancelDatabase
        public LicenceCancelDatabase()
            : base(new LicenceCancelContext())
        {

        }
        #endregion

        #region GetLicenceCancelForm
        public LicenceCancelDetail GetLicenceCancelForm(long licenceCancelDetailID, long userID)
        {
            var details = (from q in Context.LicenceCancelDetails
                            .Include("Licence")
                            .Include("Licence.LicenceStatu")                            
                           where q.LicenceCancelDetailID == licenceCancelDetailID
                           select q).FirstOrDefault();            

            return details;
        }
        #endregion

        #region GetLicence
        public Licence GetLicence(long licenceID, long userID)
        {
            var details = (from q in Context.Licences
                            .Include("LicenceStatu")
                           where q.LicenceID == licenceID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region GetLicenceCancel
        public LicenceCancelDetail GetLicenceCancel(long licenceCancelDetailID, long userID)
        {
            var details = (from q in Context.LicenceCancelDetails                            
                           where q.LicenceCancelDetailID == licenceCancelDetailID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region CreateLicenceCancelRequest
        public Vw_LicenceCancelDetails CreateLicenceCancelRequest(long verifiedLicenceID, long userID)
        {
            return Context.Pr_LicenceCancelRequestCreate(verifiedLicenceID, userID).FirstOrDefault();
        }
        #endregion
    }
}