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

namespace Neo.LegitimateLicences.AccreditationCancelRequest.Models.Database
{
    public class AccreditationCancelDatabase : Database<AccreditationCancelContext>
    {
        #region AccreditationCancelRequest
        public AccreditationCancelDatabase()
            : base(new AccreditationCancelContext())
        {

        }
        #endregion

        #region GetAccreditationCancelForm
        public AccreditationCancelDetail GetAccreditationCancelForm(long accreditationCancelDetailID, long userID)
        {
            var details = (from q in Context.AccreditationCancelDetails
                            .Include("Accreditation")
                            .Include("Accreditation.AccreditationStatu")
                           where q.AccreditationCancelDetailID == accreditationCancelDetailID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region GetAccreditation
        public Accreditation GetAccreditation(long accreditationID, long userID)
        {
            var details = (from q in Context.Accreditations
                            .Include("AccreditationStatu")
                           where q.AccreditationID == accreditationID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region GetAccreditationCancel
        public AccreditationCancelDetail GetAccreditationCancel(long accreditationCancelDetailID, long userID)
        {
            var details = (from q in Context.AccreditationCancelDetails
                           where q.AccreditationCancelDetailID == accreditationCancelDetailID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region CreateAccreditationCancelRequest
        public Vw_AccreditationCancelDetails CreateAccreditationCancelRequest(long verifiedAccreditationID, long userID)
        {
            return Context.Pr_AccreditationCancelRequestCreate(verifiedAccreditationID, userID).FirstOrDefault();
        }
        #endregion
    }
}