using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using DiscordAdventure.Database;


//Add UserName check if false update the DB with the new username....


namespace DiscordAdventure.Data
{
    public static class Data
    {
        public static async Task UpdateUser(ulong UserId, string UserName)
        {
            using (var DbContext = new SQLiteDbContext())
            {
                User user = DbContext.Users.Find(UserId);
                if (user == null)
                {
                    return;
                }
                user.Username = UserName;
                DbContext.Update(user);
                await DbContext.SaveChangesAsync();
            }
        }

        public static string GetUserInventory(ulong UserId)
        {
            using (var DbContext = new SQLiteDbContext())
            {
                var userItems = DbContext.ItemUsers.Where(x => x.User_Id == UserId).ToList();
                var GetUserInventoryOutput = "";

                foreach (ItemUser item in userItems) {
                    Item dbItem = DbContext.Items.Find(item.Item_Id);
                    ulong index = Convert.ToUInt32(dbItem.Id);
                    var itemdes = DbContext.Items.Where(x => x.Id == index).ToString();
                    string description = DbContext.Items.Where(x => x.Id == dbItem.Id).Select(x => x.Description).FirstOrDefault();
                    GetUserInventoryOutput += dbItem.Name + ": " + item.Amount + "\nDescription: "
                        + description + "\nID (Used to sell Items): "+ index +"\n \n";
                }
                return GetUserInventoryOutput;
            }
        }

        public static int GetUser(ulong UserId)
        {
            using (var DbContext = new SQLiteDbContext())
            {
                if (DbContext.Users.Where(x => x.UserId == UserId).Count() < 1)
                    return 0;
                Console.WriteLine("Successfully catched data from the Database!");
                return DbContext.Users.Where(x => x.UserId == UserId).Select(x => x.Money).FirstOrDefault();

            }
        }
        public static string GetHouse(ulong UserId)
        {
            using (var DbContext = new SQLiteDbContext())
            {
                if (DbContext.Users.Where(x => x.UserId == UserId).Count() < 1)
                    return "";
                Console.WriteLine("Successfully catched data from the Database!");
                return DbContext.Users.Where(x => x.UserId == UserId).Select(x => x.House).FirstOrDefault();

            }
        }


        public static async Task SaveUser(ulong UserId, int Amount, string UserName)
        {
            using (var DbContext = new SQLiteDbContext())
            {
                if (DbContext.Users.Where(x => x.UserId == UserId).Count() < 1) {
                    //Create a User in the DB
                    DbContext.Users.Add(new User
                    {
                        UserId = UserId,
                        Money = 100 + Amount,
                        Username = UserName,
                        House = null
                    });

                    DbContext.ItemUsers.Add(new ItemUser {
                        User_Id = UserId,
                        Item_Id = 1,
                        Amount = 1
                    });
                }
                else
                {
                    User Current = DbContext.Users.Where(x => x.UserId == UserId).FirstOrDefault();
                    Current.Money += Amount;
                    DbContext.Users.Update(Current);
                    Console.WriteLine("Successfully modified the Database!");
                }
                await DbContext.SaveChangesAsync();
            }
        }
        public static async Task JoinHouse(ulong UserId, string HouseSet, string UserName)
        {
            using (var DbContext = new SQLiteDbContext())
            {
                if (DbContext.Users.Where(x => x.UserId == UserId).Count() < 1)
                {
                    //Create a User in the DB
                    DbContext.Users.Add(new User
                    {
                        UserId = UserId,
                        Money = 100,
                        Username = UserName,
                        House = HouseSet
                    });

                    DbContext.ItemUsers.Add(new ItemUser
                    {
                        User_Id = UserId,
                        Item_Id = 1,
                        Amount = 1
                    });
                }
                else
                {
                    User Current = DbContext.Users.Where(x => x.UserId == UserId).FirstOrDefault();
                    Current.House = HouseSet;
                    DbContext.Users.Update(Current);
                    Console.WriteLine("Successfully modified the Database!");
                }
                await DbContext.SaveChangesAsync();
            }
        }
    }
}