public PricePoolS[] GetPricePools()
        {
            using (MasterDBDataContext db = new MasterDBDataContext())
            {
                var pricePools = db.PricePool.ToArray();

                if (pricePools != null)
                {
                    PricePoolS[] result = new PricePoolS[pricePools.Length];

                    for (int i = 0; i < pricePools.Length; i++)
                    {
                        result[i] = new PricePoolS()
                        {
                            id = pricePools[i].idPricePool,
                            eventId = (int) pricePools[i].idEvent,
                            priceId = (int) pricePools[i].idPrice,
                            placeRangeMax = pricePools[i].placeRangeMax,
                            placeRangeMin = pricePools[i].placeRangeMin,
                            placePercent = (float) pricePools[i].placePurcent
                        };
                    }
                    return result;
                }
                return null;
            }
        }
        public PricePoolS[] GetPricePool(int eventId)
        {
            using (MasterDBDataContext db = new MasterDBDataContext())
            {
                var pricePools = db.PricePool.Where(pp => pp.idEvent == eventId);

                if (pricePools != null)
                {
                    PricePoolS[] result = new PricePoolS[pricePools.ToArray().Length];
                    PricePool[] temp = pricePools.ToArray();

                    for (int i = 0; i < temp.Length; i++)
                    {
                        result[i] = new PricePoolS()
                        {
                            id = temp[i].idPricePool,
                            eventId = (int)temp[i].idEvent,
                            priceId = (int)temp[i].idPrice,
                            placeRangeMin = temp[i].placeRangeMin,
                            placeRangeMax = temp[i].placeRangeMax,
                            placePercent = (float)temp[i].placePurcent
                        };
                    }

                    return result;
                }
                else
                    return null;
            }
        }