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

namespace Neo.Afx.Admin.Audit
{
    ///<summary>
    /// Afx admin database
    ///</summary>
    public class AfxAdminAuditDatabase : Database<AfxAdminAuditContext>
    {
        ///<summary>
        /// Constructor
        ///</summary>
        public AfxAdminAuditDatabase()
            : base(new AfxAdminAuditContext())
        {
        }

        #region History

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<object> SearchAuditHistory(short sourceID, short actionID, short entityID, long itemID, bool? isCritical, bool? isException, long createdByID, DateTime startDate, DateTime endDate)
        {
            return Context.Pr_AuditHistorySearch(sourceID, actionID, entityID, itemID, isCritical, isException, createdByID, startDate, endDate).ToList();
        }

        #endregion

        #region SystemLog

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<object> SearchAuditSystemLog(string tableName, long? tableKey, string tableOperation, long? createdByID, DateTime? startDate, DateTime? endDate)
        {
            return Context.Pr_AuditSystemLogSearch(tableName, tableKey, tableOperation, createdByID, startDate, endDate).ToList();
        }

        #endregion

        #region GetSources

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<Source> GetSources()
        {
            return (from item in Context.Sources
                    where item.IsCancelled == false
                    orderby item.Name ascending
                    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<Source> GetSources(int count)
        {
            return (from item in Context.Sources
                    where item.IsCancelled == false
                    orderby item.Name ascending
                    select item).Take(count).ToList();
        }

        #endregion

        #region GetActions

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<Action> GetActions()
        {
            return (from item in Context.Actions
                    where item.IsCancelled == false
                    orderby item.Name ascending
                    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<Action> GetActions(int count)
        {
            return (from item in Context.Actions
                    where item.IsCancelled == false
                    orderby item.Name ascending
                    select item).Take(count).ToList();
        }

        #endregion
    }
}