private bool HasAReservation(int current_row, int current_column) { var reservation_values = SourceReaderHelper.GetValuesForTitlePosition( new CellPosition() { Row = current_row, Column = current_column }, ReservationsStartPos, ReservationsEndPos, _work_sheet); bool reserveration_found = false; foreach (var value in reservation_values) { if (value == "") { continue; } int out_value = 0; if (int.TryParse(value, out out_value)) { if (out_value > 0) { reserveration_found = true; break; } } } return(reserveration_found); }
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); }