Exemplo n.º 1
0
        internal static IEnumerable <ChartWareVM> GetTradeOperation(string userName)
        {
            using var db = new DBContext();
            var result = (from t in db.TradeOperations
                          join w in db.Wares on t.ItemSoldId equals w.WareID into joinedWares
                          from trade in joinedWares.DefaultIfEmpty()
                          select new TradeOperationVM()
            {
                Time = t.Time,
                ItemSoldId = t.ItemSoldId,
                Quantity = t.Quantity,
                Money = t.Money,
                WareMarketAveragePrice = trade.MarketAveragePrice,
                WareTransportTypeContainer = trade.TransportType == "Container"
            }).ToList()         //todo use iqueryable until the end for perf
                         .GroupBy(x =>
                                  x.TimeRounded
                                  )
                         .Select(x => new ChartWareVM
            {
                TimeRounded = x.Key.ToString("D3"),
                //Ware = x.Key.Ware,
                EstimatedProfit = x.Sum(s => s.EstimatedProfit),
                Quantity        = x.Sum(s => s.Quantity),
                Money           = x.Sum(s => s.CorrectedMoney)
            });

            return(result.ToList());
        }
Exemplo n.º 2
0
        internal static void UpdateShip(ShipSummaryVM model)
        {
            using var db = new DBContext();
            Ship s;

            s = db.Ships.Single(u => u.ShipID == model.OurShipId);

            s.Actif = model.Actif;
            db.SaveChanges();
        }
Exemplo n.º 3
0
        internal static DataSourceResult GetWorstShips([DataSourceRequest] DataSourceRequest request)
        {
            using (var db = new DBContext())
            {
                List <FilterDescriptor> filters = GetFilters(request.Filters).Select(x => (FilterDescriptor)x).ToList();

                var filterLastActivity = int.Parse(filters
                                                   .FirstOrDefault(x =>
                                                                   (x).Member == "LastActivity")?.Value
                                                   .ToString()
                                                   ?.Trim() ?? "2");    //DEFAULT 2 HOURS
                var lastActivity = db.TradeOperations.Max(x => x.Time);

                var wares  = db.Wares.Select(x => x);
                var source = db.TradeOperations.Where(x =>
                                                      x.Time >= lastActivity - filterLastActivity * 60 * 60 && x.Money != 0 && x.Quantity != 0);
                var shipList = db.Ships;

                var filterWare = filters
                                 .FirstOrDefault(x => (x).Member == "ItemSoldId")?.Value.ToString() ?? string.Empty;
                if (!string.IsNullOrWhiteSpace(filterWare))
                {
                    source = source.Where(x => x.ItemSoldId == filterWare);
                }
                var filterSector = filters.FirstOrDefault(x => (x).Member == "Sector")
                                   ?.Value.ToString() ?? string.Empty;
                if (!string.IsNullOrWhiteSpace(filterSector))
                {
                    source = source.Where(x => x.Sector == filterSector);
                }

                return((from allShips in shipList
                        join worstShips in source
                        on allShips.ShipID equals worstShips.OurShipId into joinedShips
                        from worstShip in joinedShips.DefaultIfEmpty()
                        join w in wares on worstShip.ItemSoldId equals w.WareID into joinedWares
                        from worstShipWares in joinedWares.DefaultIfEmpty()
                        group new { worstShip, worstShipWares, allShips } by allShips.ShipID into g
                        select new ShipSummaryVM
                {
                    Sector = filterSector,
                    ItemSoldId = filterWare,
                    LastActivity = filterLastActivity,
                    OurShipId = g.Key,
                    Quantity = g.Sum(s => s.worstShip.Quantity),
                    EstimatedProfit = g.Sum(s =>
                                            s.worstShip.Money / 100 - (s.worstShipWares.TransportType == "container" ? s.worstShipWares.MarketAveragePrice * s.worstShip.Quantity : 0)),
                    Actif = g.Max(s => s.allShips.Actif)
                }).ToDataSourceResult(request));
            }
        }