namespace Butterfly.HabboHotel.Habbo.Guilds
{
    using Butterfly;
    using Database_Manager.Database.Session_Details.Interfaces;
    using System;
    using System.Collections.Generic;
    using System.Data;

    internal class GuildsPartsData
    {
        internal static List<GuildsPartsData> BaseBadges;
        internal static List<GuildsPartsData> ColorBadges1;
        internal static List<GuildsPartsData> ColorBadges2;
        internal static List<GuildsPartsData> ColorBadges3;
        internal string ExtraData1;
        internal string ExtraData2;
        internal int Id;
        internal static List<GuildsPartsData> SymbolBadges;

        internal static void InitGroups()
        {
            BaseBadges = new List<GuildsPartsData>();
            SymbolBadges = new List<GuildsPartsData>();
            ColorBadges1 = new List<GuildsPartsData>();
            ColorBadges2 = new List<GuildsPartsData>();
            ColorBadges3 = new List<GuildsPartsData>();
            using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
            {
                adapter.setQuery("SELECT * FROM groups_elements");
                DataTable table = adapter.getTable();
                foreach (DataRow row in table.Rows)
                {
                    GuildsPartsData data;
                    if (row["Type"].ToString() == "Base")
                    {
                        data = new GuildsPartsData {
                            Id = (int) row["Id"],
                            ExtraData1 = (string) row["ExtraData1"],
                            ExtraData2 = (string) row["ExtraData2"]
                        };
                        BaseBadges.Add(data);
                    }
                    else if (row["ExtraData1"].ToString().StartsWith("symbol_"))
                    {
                        data = new GuildsPartsData {
                            Id = (int) row["Id"],
                            ExtraData1 = (string) row["ExtraData1"],
                            ExtraData2 = (string) row["ExtraData2"]
                        };
                        SymbolBadges.Add(data);
                    }
                    else if (row["Type"].ToString() == "Color1")
                    {
                        data = new GuildsPartsData {
                            Id = (int) row["Id"],
                            ExtraData1 = (string) row["ExtraData1"]
                        };
                        ColorBadges1.Add(data);
                    }
                    else if (row["Type"].ToString() == "Color2")
                    {
                        data = new GuildsPartsData {
                            Id = (int) row["Id"],
                            ExtraData1 = (string) row["ExtraData1"]
                        };
                        ColorBadges2.Add(data);
                    }
                    else if (row["Type"].ToString() == "Color3")
                    {
                        data = new GuildsPartsData {
                            Id = (int) row["Id"],
                            ExtraData1 = (string) row["ExtraData1"]
                        };
                        ColorBadges3.Add(data);
                    }
                }
            }
        }
    }
}