using System;
using System.Collections.Generic;
using System.Linq;
using Neo.Afx.ComponentModel;

namespace Neo.Afx.Services
{
    public class ServiceDatabase : Database<ServiceContext>
    {
        public ServiceDatabase()
            : base(new ServiceContext())
        {
        }

        #region GetSystemUserID

        public long GetSystemUserID()
        {
            return long.Parse(GetByID<Setting>("SystemUserID").SettingValue);
        }

        #endregion

        #region GetSystemUserEmail

        public string GetSystemUserEmail()
        {
            return GetByID<Setting>("SystemEmail").SettingValue;
        }

        #endregion

        #region GetServices

        public IEnumerable<Service> GetServices()
        {
            return from q in Context.Services.Include("ServiceSettings")
                   where !q.IsCancelled
                   orderby q.ServiceName
                   select q;
        }

        #endregion

        #region UpdateRunStatus

        /// <summary>
        /// Updates the service run status.
        /// </summary>
        /// <param name="serviceID">The service ID; may be <code>null</code>.</param>
        /// <param name="runDate">The run date.</param>
        /// <param name="updatedByID">The ID of the user performing the update.</param>
        /// <param name="traceInfo">The trace info; may be <code>null</code>.</param>
        /// <param name="auditInfo">The audit info; may be <code>null</code> - if not <code>null</code> then an error has occurred.</param>
        public void UpdateRunStatus(int? serviceID, DateTime runDate, long updatedByID, string traceInfo, string auditInfo)
        {
            Context.Pr_ServiceUpdateStatus(serviceID, runDate, updatedByID, traceInfo, auditInfo);
        }

        #endregion
    }
}