Exemple #1
0
        public IList <LugBulkReservation> GetReservations()
        {
            if (_reservations != null)
            {
                return(_reservations);
            }

            _reservations = new List <LugBulkReservation>();

            GetBuyers();
            GetElements();

            var reservation_pos_list = SourceReaderHelper.GetCrossRangePositions
                                           (_buyers_span, _element_id_span);

            foreach (var reservation_pos in reservation_pos_list)
            {
                var reservation_amount = 0;

                // Skip if not a number
                if (!int.TryParse(_work_sheet.Cell(reservation_pos.Row, reservation_pos.Column)
                                  .Value.ToString(), out reservation_amount))
                {
                    continue;
                }

                // Skip 0 and less
                if (reservation_amount <= 0)
                {
                    continue;
                }

                var element_id_pos = SourceReaderHelper.GetTitlePositionForValuePosition
                                         (reservation_pos, _element_id_span);
                var buyer_name_pos = SourceReaderHelper.GetTitlePositionForValuePosition
                                         (reservation_pos, _buyers_span);

                var element_id = _work_sheet.Cell(element_id_pos.Row, element_id_pos.Column)
                                 .Value.ToString().Trim();
                var buyer_name = _work_sheet.Cell(buyer_name_pos.Row, buyer_name_pos.Column)
                                 .Value.ToString().Trim();

                var reservation = new LugBulkReservation()
                {
                    Element = _elements.Where(x => x.ElementID == element_id).First(),
                    Buyer   = _buyers.Where(x => x.Name == buyer_name).First(),
                    Amount  = reservation_amount,
                };

                _reservations.Add(reservation);
            }

            return(_reservations);
        }
        private void ParseOrders(List <string> orders)
        {
            _orders = new List <LugBulkReservation>();

            foreach (var line in orders)
            {
                var parts = line.Split(',');

                if (parts[0] == "Nickname")
                {
                    continue;
                }

                if (parts.Length != 4)
                {
                    throw new Exception("Line doesn't have 4 parts: " + line);
                }

                var amount = 0;

                if (!int.TryParse(parts[3], out amount))
                {
                    throw new Exception("Line missing valid amount: " + line);
                }

                var buyer = _buyers.FirstOrDefault(x => x.Name == parts[0]);

                if (buyer == null)
                {
                    throw new Exception("Line missing valid buyer: " + line);
                }

                var element = _elements.FirstOrDefault(x => x.ElementID == parts[2]);

                if (element == null)
                {
                    throw new Exception("Line missing valid element: " + line);
                }

                var new_order = new LugBulkReservation()
                {
                    Element = element,
                    Buyer   = buyer,
                    Amount  = amount,
                };

                _orders.Add(new_order);
            }
        }