private void ApplyHeader(BMUSheet.BulkMaterialUsageSheetService proxySheet, BMUSheet.OperationContext opSheet, BMUSheet.BulkMaterialUsageSheetDTO requestSheet, int currentRow, int currentHeader) { try { var replySheet = proxySheet.apply(opSheet, requestSheet); if (replySheet.errors.Length > 0) { foreach (var t in replySheet.errors) { _cells.GetCell(ResultColumn, currentRow).Value += " - " + t.messageText; } _cells.GetRange(1, currentHeader, ResultColumn - 1, currentRow).Style = _cells.GetStyle(StyleConstants.Error); DeleteHeader(proxySheet, opSheet, requestSheet, currentHeader, currentRow); } else { _cells.GetRange(1, currentHeader, ResultColumn - 1, currentRow).Style = _cells.GetStyle(StyleConstants.Success); _cells.GetRange(1, currentHeader, 6, currentRow).Select(); } } catch (Exception) { DeleteHeader(proxySheet, opSheet, requestSheet, currentHeader, currentRow); } }
private void ItemListAdd(int currentRow, BMUSheet.BulkMaterialUsageSheetDTO requestSheet, List<BMUSheetItem.BulkMaterialUsageSheetItemDTO> requestItemList, List<BMUSheetItem.BulkMaterialUsageSheetItemDTO> allRequestItemList, Worksheet excelSheet) { _cells.GetCell(1, currentRow).Select(); _cells.GetCell(1, currentRow).Value = requestSheet.bulkMaterialUsageSheetId; var requestItem = new BMUSheetItem.BulkMaterialUsageSheetItemDTO { bulkMaterialUsageSheetId = requestSheet.bulkMaterialUsageSheetId, equipmentReference = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(8, currentRow).Value), componentCode = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(9, currentRow).Value), modifier = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(10, currentRow).Value), bulkMaterialTypeId = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(11, currentRow).Value), conditionMonitoringAction = (_cells.GetEmptyIfNull(_cells.GetCell(12, currentRow).Value) == "Fuel/Diesel") || (_cells.GetNullIfTrimmedEmpty(_cells.GetCell(12, currentRow).Value) == null) ? null : _cells.GetCell(12, currentRow).Value.ToString().Substring(0, 1), quantity = decimal.Round(Convert.ToDecimal(_cells.GetCell(13, currentRow).Value)), quantitySpecified = (_cells.GetNullIfTrimmedEmpty(_cells.GetEmptyIfNull(_cells.GetCell(13, currentRow).Value)) != null), usageDate = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(14, currentRow).Value), usageTime = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(15, currentRow).Value), operationStatisticType = _cells.GetNullIfTrimmedEmpty(_cells.GetCell(16, currentRow).Value), meterReading = Convert.ToDecimal(_cells.GetCell(17, currentRow).Value), meterReadingSpecified = (_cells.GetNullIfTrimmedEmpty(_cells.GetEmptyIfNull(_cells.GetCell(17, currentRow).Value)) != null), }; //consulta la base de datos y obtiene la capacidad maxima de combustible a cargar al equipo, si no tiene coloca 0. try { _cells.GetCell(8, currentRow).Select(); allRequestItemList.Add(requestItem); var profile = GetFuelCapacity(requestItem.equipmentReference, requestItem.bulkMaterialTypeId); if (requestItem.bulkMaterialTypeId == profile.FuelType && requestItem.quantity > profile.capacity) { _cells.GetCell(ResultColumn, currentRow).Value = "Este valor supera la capacidad del Equipo!"; _cells.GetRange(8, currentRow, 13, currentRow).Style = _cells.GetStyle(StyleConstants.Error); } else { //agrega el item a la coleccion requestItemList.Add(requestItem); _cells.GetRange(8, currentRow, 13, currentRow).Style = _cells.GetStyle(StyleConstants.Success); } } catch (Exception error) { _cells.GetCell(ResultColumn, currentRow).Value = error.Message; _cells.GetCell(13, currentRow).Style = _cells.GetStyle(StyleConstants.Error); _cells.GetCell(13, currentRow).Select(); } }
private void DeleteHeader(BMUSheet.BulkMaterialUsageSheetService proxySheet, BMUSheet.OperationContext opSheet, BMUSheet.BulkMaterialUsageSheetDTO requestSheet, int currentHeader, int currentRow) { try { var replySheet = proxySheet.delete(opSheet, requestSheet); if (replySheet.errors.Length > 0) { foreach (var t in replySheet.errors) { _cells.GetCell(ResultColumn, (currentHeader + t.fieldIndex)).Value += " - " + t.messageText; } } else { _cells.GetCell(ResultColumn, currentRow).Value += " - Hoja " + replySheet.bulkMaterialUsageSheetDTO.bulkMaterialUsageSheetId + " Borrada"; _cells.GetRange(1, currentHeader, ResultColumn - 1, currentRow).Style = _cells.GetStyle(StyleConstants.Error); } } catch (Exception err) { _cells.GetCell(ResultColumn, currentRow).Value += err.Message; } }