public void ParseCharge(Prism810Context context, string[] marketFields) { var current = context.Current; if (current == null || current.ModelType != Type810Types.DetailItem) { throw new InvalidOperationException(); } var detailItem = current as Type810DetailItem; if (detailItem == null) { throw new InvalidOperationException(); } var amount = (marketFields.AtIndexDecimal(6) * 100); var model = new Type810DetailItemCharge { ChargeIndicator = marketFields.AtIndex(3), AgencyCode = "EU", ChargeCode = marketFields.AtIndex(5), Amount = amount.ToString("0"), Rate = marketFields.AtIndex(7), UOM = marketFields.AtIndex(8), Quantity = marketFields.AtIndex(9), Description = marketFields.AtIndex(11), }; detailItem.AddCharge(model); }
public int InsertDetailItemCharge(Type810DetailItemCharge model) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("csp810DetailItemChargeInsert")) { command.AddWithValue("@Item_Key", model.ItemKey) .AddIfNotEmptyOrDbNull("@ChargeIndicator", model.ChargeIndicator) .AddIfNotEmptyOrDbNull("@AgencyCode", model.AgencyCode) .AddIfNotEmptyOrDbNull("@ChargeCode", model.ChargeCode) .AddIfNotEmptyOrDbNull("@Amount", model.Amount) .AddIfNotEmptyOrDbNull("@Rate", model.Rate) .AddIfNotEmptyOrDbNull("@UOM", model.UOM) .AddIfNotEmptyOrDbNull("@Quantity", model.Quantity) .AddIfNotEmptyOrDbNull("@Description", model.Description); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); model.ChargeKey = 1; return(1); } }
public Type810DetailItemCharge ParseDetailItemCharge(XElement element, IDictionary <string, XNamespace> namespaces) { XNamespace empty; if (!namespaces.TryGetValue(string.Empty, out empty)) { empty = XNamespace.None; } var model = new Type810DetailItemCharge { ChargeIndicator = element.GetChildText(empty + "ChargeIndicator"), AgencyCode = element.GetChildText(empty + "AgencyCode"), ChargeCode = element.GetChildText(empty + "ChargeCode"), Amount = element.GetChildText(empty + "Amount"), Rate = element.GetChildText(empty + "Rate"), UOM = element.GetChildText(empty + "UOM"), Quantity = element.GetChildText(empty + "Quantity"), Description = element.GetChildText(empty + "Description"), PrintSeqId = element.GetChildText(empty + "PrintSeqId"), EnergyCharges = element.GetChildText(empty + "EnergyCharges"), }; return(model); }
public Type810DetailItemCharge[] ListDetailItemCharges(int detailItemKey) { using (var connection = new SqlConnection(connectionString)) using (var command = connection.CreateCommand("esp_810DetailItemChargeList")) { command.AddWithValue("@ItemKey", detailItemKey); if (connection.State != ConnectionState.Open) { connection.Open(); } var collection = new List <Type810DetailItemCharge>(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var item = new Type810DetailItemCharge { ItemKey = detailItemKey, ChargeKey = reader.GetInt32("Charge_Key"), }; reader.TryGetString("ChargeIndicator", x => item.ChargeIndicator = x); reader.TryGetString("AgencyCode", x => item.AgencyCode = x); reader.TryGetString("ChargeCode", x => item.ChargeCode = x); reader.TryGetString("Amount", x => item.Amount = x); reader.TryGetString("Rate", x => item.Rate = x); reader.TryGetString("UOM", x => item.UOM = x); reader.TryGetString("Quantity", x => item.Quantity = x); reader.TryGetString("Description", x => item.Description = x); reader.TryGetString("PrintSeqId", x => item.PrintSeqId = x); collection.Add(item); } return(collection.ToArray()); } } }