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

namespace Neo.Afx.Services.Security
{
    ///<summary>
    /// Afx admin database
    ///</summary>
    public class SecurityDatabase : Database<SecurityContext>
    {
        ///<summary>
        /// Constructor
        ///</summary>
        public SecurityDatabase()
            : base(new SecurityContext())
        {
        }

        #region GetUser
        /// <summary>
        /// GetUser
        /// </summary>
        /// <returns>Users</returns>
        public Vw_User GetUser(string email)
        {
            return Context.Vw_Users.Where(g => g.Email == email && g.UserStatusID == 1 /*active*/).FirstOrDefault();                
        }

         /// <summary>
        /// GetUser
        /// </summary>
        /// <returns>Users</returns>
        public Vw_User GetUser(long userID)
        {
            return Context.Vw_Users.Where(g => g.UserID == userID && g.UserStatusID == 1 /*active*/).FirstOrDefault();                
        }
        #endregion

        #region GetUsers
        /// <summary>
        /// User Lookup
        /// </summary>
        /// <returns>IEmumarable List of Users</returns>
        public IEnumerable<Vw_User> GetUsers()
        {
            return (from g in Context.Vw_Users
                    select g).Where(a => a.UserID != 1 /*system user*/).OrderBy(a => a.KnownAs).ToList();
        }
        #endregion

        #region GetUserFingerprintTemplates
        /// <summary>
        /// Get all the user fingerprint templates
        /// </summary>
        /// <returns>IEmumarable List of Users</returns>
        public List<Pr_GetUserFingerprintTemplates_Result> GetUserFingerprintTemplates()
        {
            return Context.Pr_GetUserFingerprintTemplates().ToList();            
        }
        #endregion

        #region CreateDesktopInterfaceToken
        /// <summary>
        /// CreateDesktopInterfaceToken
        /// </summary>
        /// <returns>Users</returns>
        public string CreateDesktopInterfaceToken(long userID)
        {
            return Context.Pr_CreateUserDesktopInterfaceToken(userID).FirstOrDefault();
        }
        #endregion

        #region GetUserByDesktopInterfaceToken
        /// <summary>
        /// GetUserByDesktopInterfaceToken
        /// </summary>
        /// <returns>User</returns>
        public Vw_User GetUserByDesktopInterfaceToken(string token)
        {
            return Context.Pr_GetUserByDesktopInterfaceToken(token).FirstOrDefault();
        }
        #endregion
    }
}