private void ParseUnmeterDetailQty(Prism867Context context, string[] marketFields) { var current = context.Current; if (current == null || current.ModelType != Type867Types.UnMeterDetail) { throw new InvalidOperationException(); } var detail = current as Type867UnMeterDetail; if (detail == null) { throw new InvalidOperationException(); } var model = new Type867UnMeterDetailQty { Qualifier = marketFields.AtIndex(2), Quantity = marketFields.AtIndex(3), CompositeUom = marketFields.AtIndex(15), NumberOfDevices = marketFields.AtIndex(5), ConsumptionPerDevice = marketFields.AtIndex(16) }; detail.AddQuantity(model); }
public void InsertUnMeterDetailQty(Type867UnMeterDetailQty model) { using (var connection = new SqlConnection(_connectionString)) using (var command = connection.CreateCommand("csp867UnmeterDetailQtyInsert")) { command.AddWithValue("@UnmeterDetail_Key", model.UnMeterDetailKey) .AddIfNotEmptyOrDbNull("@Qualifier", model.Qualifier) .AddIfNotEmptyOrDbNull("@Quantity", model.Quantity) .AddIfNotEmptyOrDbNull("@CompositeUOM", model.CompositeUom) .AddIfNotEmptyOrDbNull("@UOM", model.Uom) .AddIfNotEmptyOrDbNull("@NumberOfDevices", model.NumberOfDevices) .AddIfNotEmptyOrDbNull("@ConsumptionPerDevice", model.ConsumptionPerDevice); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); } }
public Type867UnMeterDetailQty ParseUnMeterDetailQty(XElement element, IDictionary <string, XNamespace> namespaces) { XNamespace empty; if (!namespaces.TryGetValue(string.Empty, out empty)) { empty = XNamespace.None; } var model = new Type867UnMeterDetailQty { Qualifier = element.GetChildText(empty + "Qualifier"), Quantity = element.GetChildText(empty + "Quantity"), CompositeUom = element.GetChildText(empty + "CompositeUOM"), Uom = element.GetChildText(empty + "UOM"), NumberOfDevices = element.GetChildText(empty + "NumberOfDevices"), ConsumptionPerDevice = element.GetChildText(empty + "ConsumptionPerDevice"), BackoutCredit = element.GetChildText(empty + "BackoutCredit"), }; return(model); }