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

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

        #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 GetUsers
        /// <summary>
        /// User Lookup
        /// </summary>
        /// <returns>IEmumarable List of Users</returns>
        public IEnumerable<Vw_User> GetUsers(short roleID)
        {
            return Context.Pr_GetUsersInRoles(roleID.ToString());
        }
        #endregion

        #region ResetUserPassword

        /// <summary>
        /// Resets the user password.
        /// </summary>
        /// <param name="userId">The user id.</param>
        /// <param name="userName">Name of the user.</param>
        /// <param name="newPassword">The new password.</param>
        /// <returns></returns>
        public bool ResetUserPassword(long userId, string userName, string newPassword)
        {
            try
            {
                Context.Pr_SaveUserPassword(userId, userId, userName, "Forms", newPassword, false);
            }
            catch
            {
                return false;
            }

            return true;
        }

        #endregion

        #region GetApplications

        /// <summary>
        /// Applications Lookup
        /// </summary>
        /// <returns>IEmumarable List of Applications</returns>
        public IEnumerable<Application> GetApplications()
        {
            return (from r in Context.Applications
                    select r).ToList();
        }

        #endregion

        #region GetUserStatus

        /// <summary>
        /// UserStates Lookup
        /// </summary>
        /// <returns>IEmumarable List of User States</returns>
        public IEnumerable<UserStatus> GetUserStatus()
        {
            return (from s in Context.UserStatus
                    select s).ToList();
        }

        #endregion

        #region GetRoles

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public List<Role> GetRoles()
        {
            return (from item in Context.Roles
                    where item.IsCancelled == false
                    select item).ToList();
        }

        /// <summary>
        /// Get data from table based on count.
        /// </summary>
        /// <param name="count">Restricts amount returned items in the collection.</param>
        /// <returns>List of objects.</returns>
        public IEnumerable<Role> GetRoles(int count)
        {
            return (from item in Context.Roles
                    where item.IsCancelled == false
                    select item).Take(count).ToList();
        }

        #endregion

        #region GetUserRoles

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public List<Role> GetUserRoles(long userID)
        {
            var user = Context.Users.Include("Roles").Where(a => a.UserID == userID).FirstOrDefault();
            return user.Roles.ToList();
        }
        #endregion

        #region GetUserSettings

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public List<UserSetting> GetUserSettings(long userID)
        {
            var temp = (from item in Context.UserSettings
                        where item.IsCancelled == false
                        && item.UserID == userID
                        select item).ToList();
            return temp;            
        }
        #endregion

        #region ClearUserSettings

        /// <summary>
        /// Clears the user settings.
        /// </summary>
        /// <param name="userID">The user ID.</param>
        public void ClearUserSettings(long userID)
        {
            Context.Pr_ClearUserSettings(userID);
        }
        #endregion

        #region GetSecurables

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<Securable> GetSecurables()
        {
            return (from item in Context.Securables
                    where item.IsCancelled == false
                    select item).ToList();
        }

        /// <summary>
        /// Get a list of all securables linked to a specific role
        /// </summary>
        /// <param name="roleID"></param>
        /// <returns></returns>
        public IEnumerable<RoleSecurable> GetRoleSecurables(short roleID)
        {
            return Context.Pr_GetRoleSecurables(roleID).ToList();
        }

        /// <summary>
        /// Get data from table based on count.
        /// </summary>
        /// <param name="count">Restricts amount returned items in the collection.</param>
        /// <returns>List of objects.</returns>
        public IEnumerable<Securable> Securables(int count)
        {
            return (from item in Context.Securables
                    where item.IsCancelled == false
                    select item).Take(count).ToList();
        }

        #endregion

        #region Get Objects With Related Object Collections

        /// <summary>
        /// Get User and Roles
        /// </summary>
        /// <returns>User Object With Roles Collection, based on parsed "userID"</returns>
        public User GetUserByID(long? userID)
        {
            if(!userID.HasValue)
            {
                return null;
            }

            return (from s in Context.Users
                        .Include("Roles")
                        .Include("UserSettings")
                    where s.UserID == userID.Value
                    select s).FirstOrDefault();
        }

        /// <summary>
        /// Get User and Roles
        /// </summary>
        /// <returns>Role Object With Securables Collection, based on parsed "roleID"</returns>
        public Role GetRoleByID(long roleID)
        {
            return (from s in Context.Roles.Include("RoleSecurables")
                    where s.RoleID == roleID
                    select s).ToList()[0];
        }

        #endregion

        #region GetActiveUsers
        /// <summary>
        /// Get a list of all active users
        /// </summary>
        /// <param name="userID"></param>
        /// <returns></returns>
        public List<Vw_User> GetActiveUsers(long userID)
        {
            return Context.Pr_GetActiveUsers(userID).ToList();
        }
        #endregion        

        #region GetUser
        /// <summary>
        /// Get a full user object
        /// </summary>
        /// <param name="returnUserID"></param>
        /// <param name="userID"></param>
        /// <returns></returns>
        public User GetUser(long returnUserID, long userID)
        {
            if (returnUserID == -1)
            {
                return new User()
                {
                    UserID = -1,
                    UserStatusID = 1 /*active*/
                };
            }
            else
            {
                return Context.Pr_GetUser(returnUserID, userID).FirstOrDefault();
            }
        }
        #endregion        

        #region GetUserViewOnly
        /// <summary>
        /// Get a view with basic user details
        /// </summary>
        /// <param name="returnUserID"></param>
        /// <returns></returns>
        public Vw_User GetUserViewOnly(long returnUserID)
        {
            return Context.Vw_Users.Where(a => a.UserID == returnUserID).FirstOrDefault();
        }
        #endregion

        #region SaveUser        
        /// <summary>
        /// Saves a user's details
        /// </summary>
        /// <param name="userID"></param>
        /// <param name="knownAs"></param>
        /// <param name="lastName"></param>
        /// <param name="firstName"></param>
        /// <param name="email"></param>
        /// <param name="cell"></param>
        /// <param name="officeLocationID"></param>
        /// <param name="ntAccount"></param>
        /// <param name="userProfileDocID"></param>
        /// <param name="updatedByID"></param>
        public void SaveUser(long userID, string knownAs, string lastName, string firstName, string email, string ntAccount, string cell, long officeLocationID, long? userProfileDocID, long updatedByID)
        {
            Context.Pr_SaveUser(userID, knownAs, lastName, firstName, email, ntAccount, cell, officeLocationID, userProfileDocID, updatedByID);
        }
        #endregion        

        #region UpdateUserStatus       
        /// <summary>
        /// Updates a user's status
        /// </summary>
        /// <param name="updatedByID"></param>
        /// <param name="comments"></param>
        /// <param name="userID"></param>
        /// <param name="userStatusID"></param>
        public void UpdateUserStatus(long updatedByID, string comments, long userID, short userStatusID)
        {
            Context.Pr_UserStatusUpdate(updatedByID, comments, userID, userStatusID);
        }
        #endregion        

        #region SaveUserRoles       
        /// <summary>
        /// Updates a user's security roles
        /// </summary>        
        public void SaveUserRoles(long userID, string rolesCsv, long updatedByID)
        {
            Context.Pr_SaveUserRoles(userID, rolesCsv, updatedByID);
        }
        #endregion        

        #region SaveUserSetting      
        /// <summary>
        /// Updates a user's settings
        /// </summary>        
        public void SaveUserSetting(List<UserSetting> settings, long userID, long updatedByID)
        {
            foreach (var setting in settings)
            {
                Context.Pr_SaveUserSettings(userID, setting.SettingName, setting.SettingValue, updatedByID);
            }
        }
        #endregion 

        #region SaveUserFingerPrint      
        /// <summary>
        /// Updates a user's fingerprint
        /// </summary>        
        public void SaveUserFingerPrint(byte[] fingerPrint, long userID, long updatedByID)
        {
            Context.Pr_SaveUserFingerprint(userID, fingerPrint, updatedByID);
        }
        #endregion 

        #region SaveUserFingerPrintRequest      
        /// <summary>
        /// Save token details on finger print request
        /// </summary>        
        public void SaveUserFingerPrintRequest(long userID, bool createToken, long updatedByID)
        {
            Context.Pr_SaveUserFingerPrintRequestToken(userID, createToken, updatedByID);
        }
        #endregion 

        #region SaveUserFingerPrintRequest      
        /// <summary>
        /// Save token details on finger print request
        /// </summary>        
        public string ValidateFingerPrintRequest(string token)
        {
            return Context.Pr_ValidateFingerPrintRequestToken(token).FirstOrDefault();
        }
        #endregion 

        #region SaveUserFingerPrintRequest      
        /// <summary>
        /// Get user record by token
        /// </summary>        
        public User GetUserByRequestToken(string token)
        {
            return Context.Pr_GetUserByFingerPrintRequestToken(token).FirstOrDefault();
        }
        #endregion 


        #region GetUserWorkflowBuddies      
        /// <summary>
        /// Gets a list of workflow buddies for a user
        /// </summary>        
        public List<Pr_GetUserWorkflowBuddies_Result> GetUserWorkflowBuddies(long userID)
        {
            return Context.Pr_GetUserWorkflowBuddies(userID).ToList();
        }
        #endregion 

        #region DeleteUserWorkflowBuddy       
        /// <summary>
        /// Deletes a workflow buddy for a user
        /// </summary>        
        public void DeleteUserWorkflowBuddy(long workflowID, long userID, long buddyUserID, long updatedByID)
        {
            Context.Pr_DeleteUserWorkflowBuddy(workflowID, userID, buddyUserID, updatedByID);
        }
        #endregion        

        #region SaveUserWorkflowBuddy       
        /// <summary>
        /// Deletes a workflow buddy for a user
        /// </summary>        
        public void SaveUserWorkflowBuddy(long workflowID, long userID, long buddyUserID, long updatedByID)
        {
            Context.Pr_SaveUserWorkflowBuddy(workflowID, userID, buddyUserID, updatedByID);
        }
        #endregion    

        #region SaveRoleSecurables       
        /// <summary>
        /// Save a role's list of securables
        /// </summary>        
        public void SaveRoleSecurables(short roleID, string securables, long userID)
        {
            Context.Pr_SaveRoleSecurables(roleID, securables, userID);
        }
        #endregion    

    }
}