Example #1
0
        public EVFitting SelectFitSummaryByPublicID(string fittingPublicId, IImageResolver imageResolver, int tradeHubID)
        {
            EveShoppingContext contexto = new EveShoppingContext();

            EVFitting fit =
                (from f in contexto.eshFittings
                 join it in contexto.invTypes on f.shipTypeID equals it.typeID
                 join p in contexto.eshPrices on new { tradeHubID = tradeHubID, it.typeID } equals new { tradeHubID = tradeHubID, p.typeID }
                 where f.publicID == fittingPublicId
                 select new EVFitting
            {
                Description = f.description,
                ItemID = f.fittingID,
                Name = f.name,
                ShipID = f.shipTypeID.Value,
                ShipName = f.invType.typeName,
                ShipVolume = f.shipVolume,
                Units = 1,
                ShipPrice = p.avg,
                TotalPrice = p.avg,
                Volume = f.shipVolume,
                PublicID = f.publicID
            }).FirstOrDefault();

            fit.ImageUrl32 = imageResolver.GetImageURL(fit.ShipID);

            LogicaFittings logicaFits = new LogicaFittings();

            logicaFits.AddFittingHardwaresToFitting(contexto, imageResolver, tradeHubID, fit);

            //AddFittingHardwareToFittingSummary(imageResolver, contexto, fit);

            return(fit);
        }
Example #2
0
        public IEnumerable <EVFitting> SelectFitsInShoppingList(string publicID, IImageResolver imageResolver)
        {
            EveShoppingContext contexto =
                new EveShoppingContext();
            List <EVFitting>       fittings  = new List <EVFitting>();
            IEnumerable <QFitting> qfittings =
                (from sl in contexto.eshShoppingLists
                 join slf in contexto.eshShoppingListFittings on sl.shoppingListID equals slf.shoppingListID
                 join f in contexto.eshFittings on slf.fittingID equals f.fittingID
                 join it in contexto.invTypes on f.shipTypeID equals it.typeID
                 join p in contexto.eshPrices on new { sl.tradeHubID, it.typeID } equals new { tradeHubID = p.solarSystemID, p.typeID }
                 where sl.publicID == publicID
                 select new QFitting
            {
                Description = f.description,
                PublicID = f.publicID,
                FittingID = f.fittingID,
                Name = f.name,
                ShipID = f.shipTypeID.Value,
                ShipName = f.invType.typeName,
                ShipVolume = f.shipVolume,
                Units = slf.units,
                ShipPrice = p.avg,
                Price = p.avg * slf.units,
                Volume = f.shipVolume * slf.units,
                InvType = it
            });
            int tradeHubID = contexto.eshShoppingLists.Where(s => s.publicID == publicID).FirstOrDefault().tradeHubID;

            LogicaFittings logicaFittings = new LogicaFittings();

            return(logicaFittings.MountFittingCommon(contexto, qfittings, imageResolver, tradeHubID));
        }
Example #3
0
        public EVFitting SelectFitSummary(string publicID, int fittingID, IImageResolver imageResolver)
        {
            EveShoppingContext contexto = new EveShoppingContext();

            eshShoppingList shlist = contexto.eshShoppingLists.Where(s => s.publicID == publicID).FirstOrDefault();

            EVFitting fit =
                (from slf in contexto.eshShoppingListFittings
                 join f in contexto.eshFittings on slf.fittingID equals f.fittingID
                 join it in contexto.invTypes on f.shipTypeID equals it.typeID
                 join p in contexto.eshPrices on new { tradeHubID = slf.eshShoppingList.tradeHubID, it.typeID } equals new { tradeHubID = p.solarSystemID, p.typeID }
                 where slf.eshShoppingList.publicID == publicID && slf.fittingID == fittingID
                 select new EVFitting
            {
                Description = f.description,
                ItemID = f.fittingID,
                Name = f.name,
                ShipID = f.shipTypeID.Value,
                ShipName = f.invType.typeName,
                ShipVolume = f.shipVolume,
                Units = slf.units,
                ShipPrice = p.avg,
                TotalPrice = p.avg * slf.units,
                Volume = f.shipVolume * slf.units,
                PublicID = f.publicID
            }).FirstOrDefault();

            fit.ImageUrl32 = imageResolver.GetImageURL(fit.ShipID);

            //AddFittingHardwareToFittingSummary(imageResolver, contexto, fit);
            LogicaFittings logicafit = new LogicaFittings();

            logicafit.AddFittingHardwaresToFitting(contexto, imageResolver, shlist.tradeHubID, fit);

            return(fit);
        }