using System;
using System.Data.Entity.Core.Objects;
using System.Linq;
using Pilotfish.Afx.ComponentModel;
using System.Threading;

namespace Neo.Legitimate.WinService.SystemTriggers
{
    public class SystemTriggerDatabase : Database<SystemTriggerContext>
    {
        public SystemTriggerDatabase(string connectionString)
            : base(new SystemTriggerContext(connectionString))
        {
        }

        #region DequeueSystemTrigger

        public Pr_SystemTriggerDequeue_Result DequeueSystemTrigger()
        {
            return Context.Pr_SystemTriggerDequeue().FirstOrDefault();
        }
        #endregion

        #region UpdateSystemTriggerStatus
        public void UpdateSystemTriggerStatus(long systemTriggerID, short systemTriggerStatusID)
        {
            Context.Pr_SystemTriggerStatusUpdate(systemTriggerID, systemTriggerStatusID);
        }
        #endregion

        #region GetInnermostMessage
        public string GetInnermostMessage(Exception ex)
        {
            if (ex.InnerException == null)
            {
                return ex.Message;
            }
            else
            {
                return GetInnermostMessage(ex.InnerException);
            }
        }
        #endregion

        #region GetVerificationTaskDetail

        public Pr_VerificationTasksGet_Result GetVerificationTaskDetail(long verificationTaskID, long userID)
        {
            return Context.Pr_VerificationTasksGet(verificationTaskID, userID).FirstOrDefault();
        }
        #endregion
    }
}