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);
}
