using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace DtabaseConnect.CRUD
{
    public class IEnumTable
    {
        Context.DigitalServiceContext digitalServiceContext = new Context.DigitalServiceContext();
        //User Role
        public IEnumerable<Service.Entity.User_role> IEnumUser_role { get; set; }
        public IEnumerable<Service.Entity.Log_user_role> IEnumLog_user_role { get; set; }
        //Users
        public IEnumerable<Service.Entity.Users> IEnumUsers { get; set; }
        public IEnumerable<Service.Entity.Log_users> IEnumLog_Users { get; set; }
        //Game addition request
        public IEnumerable<Service.Entity.Game_addition_request> IEnumGame_addition_request { get; set; }
        public IEnumerable<Service.Entity.Log_game_addition_request> IEnumLog_game_addition_request { get; set; }
        //Acount money
        public IEnumerable<Service.Entity.Account_money> IEnumAccount_money { get; set; }
        public IEnumerable<Service.Entity.Log_account_money> IEnumLog_account_money { get; set; }
        //Complaints on users
        public IEnumerable<Service.Entity.Complaints_on_users> IEnumComplaints_on_users { get; set; }
        public IEnumerable<Service.Entity.Log_complaints_on_users> IEnumLog_complaints_on_users { get; set; }
        //Complaints on game
        public IEnumerable<Service.Entity.Complaints_on_game> IEnumComplaints_on_game { get; set; }
        public IEnumerable<Service.Entity.Log_complaints_on_game> IEnumLog_complaints_on_game { get; set; }
        //Developers
        public IEnumerable<Service.Entity.Developers> IEnumdevelopers { get; set; }
        public IEnumerable<Service.Entity.Log_developers> IEnumLog_developers { get; set; }
        //Payment games
        public IEnumerable<Service.Entity.Payment_games> IEnumpayment_games { get; set; }
        public IEnumerable<Service.Entity.Log_payment_games> IEnumLog_payment_games { get; set; }
        //Release games
        public IEnumerable<Service.Entity.Release_games> IEnumrelease_games { get; set; }
        public IEnumerable<Service.Entity.Log_release_games> IEnumLog_release_games { get; set; }
        //Statistics
        public IEnumerable<Service.Entity.Statistics> IEnumstatistics { get; set; }
        public IEnumerable<Service.Entity.Log_statistics> IEnumLog_statistics { get; set; }
        //Users are friends
        public IEnumerable<Service.Entity.Users_are_friends> IEnumusers_are_friends { get; set; }
        public IEnumerable<Service.Entity.Log_users_are_friends> IEnumLog_users_are_friends { get; set; }

        public IEnumTable ReturnAllTable()
        {
            IEnumTable model = new IEnumTable
            {
                IEnumUser_role = digitalServiceContext.DbUser_roles.ToList(),
                IEnumLog_user_role = digitalServiceContext.DbLog_user_roles.ToList(),
                IEnumUsers = digitalServiceContext.DbUsers.ToList(),
                IEnumLog_Users = digitalServiceContext.DbLog_Users.ToList(),
                IEnumGame_addition_request = digitalServiceContext.Dbgame_addition_request.ToList(),
                IEnumLog_game_addition_request = digitalServiceContext.DbLog_game_addition_request.ToList(),
                IEnumAccount_money = digitalServiceContext.DbAccount_money.ToList(),
                IEnumLog_account_money = digitalServiceContext.DbLog_account_money.ToList(),
                IEnumdevelopers = digitalServiceContext.Dbdevelopers.ToList(),
                IEnumLog_developers = digitalServiceContext.DbLog_developers.ToList(),
                IEnumpayment_games = digitalServiceContext.Dbpayment_games.ToList(),
                IEnumLog_payment_games = digitalServiceContext.DbLog_payment_games.ToList(),
                IEnumrelease_games = digitalServiceContext.Dbrelease_games.ToList(),
                IEnumLog_release_games = digitalServiceContext.DbLog_release_games.ToList(),
                IEnumusers_are_friends = digitalServiceContext.Dbusers_are_friends.ToList(),
                IEnumLog_users_are_friends = digitalServiceContext.DbLog_users_are_friends.ToList()
            };
            return model;
        }
    }
}