public void InsertIntervalSummaryQty(Type867IntervalSummaryQty model) { using (var connection = new SqlConnection(_connectionString)) using (var command = connection.CreateCommand("csp867IntervalSummaryQtyInsert")) { command.AddWithValue("@IntervalSummary_Key", model.IntervalSummaryKey) .AddIfNotEmptyOrDbNull("@Qualifier", model.Qualifier) .AddIfNotEmptyOrDbNull("@Quantity", model.Quantity) .AddIfNotEmptyOrDbNull("@MeasurementCode", model.MeasurementCode) .AddIfNotEmptyOrDbNull("@CompositeUOM", model.CompositeUom) .AddIfNotEmptyOrDbNull("@UOM", model.Uom) .AddIfNotEmptyOrDbNull("@BeginRead", model.BeginRead) .AddIfNotEmptyOrDbNull("@EndRead", model.EndRead) .AddIfNotEmptyOrDbNull("@MeasurementSignificanceCode", model.MeasurementSignificanceCode) .AddIfNotEmptyOrDbNull("@TransformerLossFactor", model.TransformerLossFactor) .AddIfNotEmptyOrDbNull("@MeterMultiplier", model.MeterMultiplier) .AddIfNotEmptyOrDbNull("@PowerFactor", model.PowerFactor) .AddWithValue("@RangeMin", model.RangeMin) .AddWithValue("@RangeMax", model.RangeMax) .AddWithValue("@ThermFactor", model.ThermFactor) .AddWithValue("@DegreeDayFactor", model.DegreeDayFactor); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); } }
public Type867IntervalSummaryQty ParseIntervalSummaryQty(XElement element, IDictionary <string, XNamespace> namespaces) { XNamespace empty; if (!namespaces.TryGetValue(string.Empty, out empty)) { empty = XNamespace.None; } var model = new Type867IntervalSummaryQty { Qualifier = element.GetChildText(empty + "Qualifier"), Quantity = element.GetChildText(empty + "Quantity"), MeasurementCode = element.GetChildText(empty + "MeasurementCode"), CompositeUom = element.GetChildText(empty + "CompositeUOM"), Uom = element.GetChildText(empty + "UOM"), BeginRead = element.GetChildText(empty + "BeginRead"), EndRead = element.GetChildText(empty + "EndRead"), MeasurementSignificanceCode = element.GetChildText(empty + "MeasurementSignificanceCode"), TransformerLossFactor = element.GetChildText(empty + "TransformerLossFactor"), MeterMultiplier = element.GetChildText(empty + "MeterMultiplier"), PowerFactor = element.GetChildText(empty + "PowerFactor"), RangeMin = element.GetChildText(empty + "RangeMin"), RangeMax = element.GetChildText(empty + "RangeMax"), ThermFactor = element.GetChildText(empty + "ThermFactor"), DegreeDayFactor = element.GetChildText(empty + "DegreeDayFactor") }; return(model); }
private void ParseIntervalSummaryQty(Prism867Context context, string[] marketFields) { var current = context.Current; if (current == null || current.ModelType != Type867Types.IntervalSummary) { throw new InvalidOperationException(); } var detail = current as Type867IntervalSummary; if (detail == null) { throw new InvalidOperationException(); } var model = new Type867IntervalSummaryQty { Qualifier = marketFields.AtIndex(2), Quantity = marketFields.AtIndex(3), Uom = marketFields.AtIndex(4), }; if (marketFields.AtIndex(0) == "08") { model.MeasurementSignificanceCode = "51"; model.MeterMultiplier = "1"; } else { model.MeasurementCode = marketFields.AtIndex(6); model.MeasurementSignificanceCode = marketFields.AtIndex(7); model.BeginRead = marketFields.AtIndex(8); model.EndRead = marketFields.AtIndex(9); model.MeterMultiplier = marketFields.AtIndex(10); model.PowerFactor = marketFields.AtIndex(11); model.TransformerLossFactor = marketFields.AtIndex(12); } detail.AddQuantity(model); }