Example #1
0
        public static object[] GetCspRateCardMeterLineItemFields(CspMeter lineItem)
        {
            List <object> fields = new List <object>();

            fields.Add(lineItem.id);
            fields.Add(lineItem.name);
            fields.Add(lineItem.category);
            fields.Add(lineItem.subcategory);
            fields.Add(lineItem.unit);
            fields.Add(lineItem.region);

            if (lineItem.rates != null)
            {
                fields.Add(string.Join(";", lineItem.rates.Select(x => x.Key + "=" + x.Value)));
                fields.Add(lineItem.rates.FirstOrDefault().Value);
            }
            else
            {
                fields.Add(string.Empty);
                fields.Add(string.Empty);
            }

            if (lineItem.tags != null)
            {
                fields.Add(string.Join(";", lineItem.tags));
            }
            else
            {
                fields.Add(string.Empty);
            }

            fields.Add(lineItem.effectiveDate);
            fields.Add(lineItem.includedQuantity);
            fields.Add(lineItem.status);

            return(fields.ToArray());
        }
Example #2
0
        public static void WriteCspRateCardMeterLineItem(int startColumnNumber, int rowNumber, CspMeter 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.GetCspRateCardMeterLineItemFields(meterItem);
        }