public static object[] GetPriceSheetMeterLineItemFields(PriceSheetMeter lineItem)
{
List <object> fields = new List <object>();
fields.Add(lineItem.id);
fields.Add(lineItem.billingPeriodId);
fields.Add(lineItem.meterId);
fields.Add(lineItem.meterName);
fields.Add(lineItem.meterRegion);
fields.Add(lineItem.unitOfMeasure);
fields.Add(lineItem.includedQuantity);
fields.Add(lineItem.partNumber);
fields.Add(lineItem.unitPrice);
fields.Add(lineItem.currencyCode);
return(fields.ToArray());
}
public static void WritePriceSheetMeterLineItem(int startColumnNumber, int rowNumber, PriceSheetMeter meterItem, int numberOfColumns, Microsoft.Office.Interop.Excel.Worksheet activeWorksheet)
{
Microsoft.Office.Interop.Excel.Range c1 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber];
Microsoft.Office.Interop.Excel.Range c2 = (Microsoft.Office.Interop.Excel.Range)activeWorksheet.Cells[rowNumber, startColumnNumber + numberOfColumns - 1];
Microsoft.Office.Interop.Excel.Range currentRow = activeWorksheet.get_Range(c1, c2);
currentRow.Value2 = BillingUtils.GetPriceSheetMeterLineItemFields(meterItem);
}
