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

namespace Neo.Afx.Admin.Sys
{
    ///<summary>
    /// Afx admin database
    ///</summary>
    public class AfxAdminSysDatabase : Database<AfxAdminSysContext>
    {
        ///<summary>
        /// Constructor
        ///</summary>
        public AfxAdminSysDatabase()
            : base(new AfxAdminSysContext())
        {
        }

        #region GetEntities

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

        #endregion

        #region GetAuthenticationTypes

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<AuthType> GetAuthenticationTypes()
        {
            return (from item in Context.AuthTypes
                    select item).ToList();
        }

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<AuthType> GetAuthenticationTypes(int count)
        {
            return (from item in Context.AuthTypes
                    select item).Take(count).ToList();
        }

        #endregion

        #region GetAuthTypes

        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<AuthType> GetAuthTypes()
        {
            return (from item in Context.AuthTypes
                    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<AuthType> GetAuthTypes(int count)
        {
            return (from item in Context.AuthTypes
                    select item).Take(count).ToList();
        }

        #endregion

        #region SmsDeliveryMethods
        /// <summary>
        /// Get all data from table.
        /// </summary>
        /// <returns>List of objects</returns>
        public IEnumerable<SmsDeliveryMethod> GetSmsDeliveryMethod()
        {
            return (from item in Context.SmsDeliveryMethods
                    select item).ToList();
        }
        #endregion

        #region GetObjectColumns

        /// <summary>
        /// Get Object Columns By The Name of the Object
        /// </summary>
        /// <param name="objectName">objectName 'String'</param>
        /// <returns>Object collection</returns>
        public IEnumerable<object> GetObjectColumns(string objectName)
        {
            return Context.Pr_GetSchemaColumns(objectName);
        }

        #endregion

    }
}