namespace Holo.marketManager
{
    using Holo;
    using Holo.Catalogue.Marketplace;
    using Ion.Storage;
    using System;
    using System.Collections.Generic;
    using System.Data;

    public static class MarketManager
    {
        private static Holo.Catalogue.Marketplace.Marketplace Catalog = new Holo.Catalogue.Marketplace.Marketplace();

        public static void AddItem(int itemID, int userID, int Cost)
        {
            using (DatabaseClient client = frmMain.dbManager.GetClient())
            {
                client.AddParamWithValue("@itemid", itemID);
                client.AddParamWithValue("@owner", userID);
                client.AddParamWithValue("@price", Cost);
                int val = client.getInt("SELECT tid FROM furniture WHERE id = @itemid AND ownerid = @owner ");
                client.AddParamWithValue("@itemtid", val);
                client.AddParamWithValue("@expires", DateTime.Now.AddHours(48.0));
                client.runQuery("DELETE FROM furniture WHERE id = @itemid AND ownerid = @owner");
                client.runQuery("INSERT INTO marketplace (userid,itemid,itemtid,price,expires) VALUES (@owner,@itemid,@itemtid,@price,@expires)");
            }
        }

        public static List<Holo.Catalogue.Marketplace.Marketplace> MarketItem(int userID)
        {
            using (DatabaseClient client = frmMain.dbManager.GetClient())
            {
                List<Holo.Catalogue.Marketplace.Marketplace> list = new List<Holo.Catalogue.Marketplace.Marketplace>();
                client.AddParamWithValue("@userid", userID);
                DataTable table = client.getDataSet("SELECT * FROM marketplace WHERE userid = @userid").Tables[0];
                foreach (DataRow row in table.Rows)
                {
                    Holo.Catalogue.Marketplace.Marketplace item = Catalog.getItem(Catalog.getRowForTemplateID(int.Parse(row["itemtid"].ToString())));
                    item.ID = int.Parse(row["itemid"].ToString());
                    item.Cost_Credits = int.Parse(row["price"].ToString());
                    item.ExpiresDate = DateTime.Parse(row["expires"].ToString());
                    item.SpriteID = client.getInt("SELECT id FROM furniture_data WHERE sprite = '" + item.CCTName + "'");
                    list.Add(item);
                }
                return list;
            }
        }

        public static List<Holo.Catalogue.Marketplace.Marketplace> MarketItems(int MinCost)
        {
            using (DatabaseClient client = frmMain.dbManager.GetClient())
            {
                List<Holo.Catalogue.Marketplace.Marketplace> list = new List<Holo.Catalogue.Marketplace.Marketplace>();
                client.AddParamWithValue("@price", MinCost);
                DataTable table = client.getDataSet("SELECT * FROM marketplace WHERE price >= @price LIMIT 100").Tables[0];
                foreach (DataRow row in table.Rows)
                {
                    Holo.Catalogue.Marketplace.Marketplace item = Catalog.getItem(Catalog.getRowForTemplateID(int.Parse(row["itemtid"].ToString())));
                    item.ID = client.getInt("SELECT itemid FROM marketplace WHERE itemtid = '" + item.TemplateID + "'");
                    item.Cost_Credits = client.getInt("SELECT price FROM marketplace WHERE itemtid = '" + item.TemplateID + "'");
                    item.SpriteID = client.getInt("SELECT id FROM furniture_data WHERE sprite = '" + item.CCTName + "'");
                    if (item != null)
                    {
                        list.Add(item);
                    }
                }
                return list;
            }
        }

        public static void RemoveItem(int itemID, int userID)
        {
            using (DatabaseClient client = frmMain.dbManager.GetClient())
            {
                client.AddParamWithValue("@itemid", itemID);
                client.AddParamWithValue("@owner", userID);
                DataRow row = client.getRow("SELECT * FROM marketplace WHERE itemid = @itemid AND userid = @owner");
                client.AddParamWithValue("@tid", row["itemtid"]);
                client.runQuery("DELETE FROM marketplace WHERE itemid = @itemid AND userid = @owner");
                client.runQuery("INSERT INTO furniture(tid,ownerid,roomid) VALUES (@tid,@owner,'0')");
            }
        }
    }
}