public void InsertIntervalSummaryAcrossMetersQty(Type867IntervalSummaryAcrossMetersQty model) { using (var connection = new SqlConnection(_connectionString)) using (var command = connection.CreateCommand("csp867IntervalSummaryAcrossMetersQtyInsert")) { command.AddWithValue("@IntervalSummaryAcrossMeters_Key", model.IntervalSummaryAcrossMetersKey) .AddIfNotEmptyOrDbNull("@Qualifier", model.Qualifier) .AddIfNotEmptyOrDbNull("@Quantity", model.Quantity) .AddIfNotEmptyOrDbNull("@IntervalEndDate", model.IntervalEndDate) .AddIfNotEmptyOrDbNull("@IntervalEndTime", model.IntervalEndTime); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); } }
public Type867IntervalSummaryAcrossMetersQty ParseIntervalSummaryAcrossMetersQty(XElement element, IDictionary <string, XNamespace> namespaces) { XNamespace empty; if (!namespaces.TryGetValue(string.Empty, out empty)) { empty = XNamespace.None; } var model = new Type867IntervalSummaryAcrossMetersQty { Qualifier = element.GetChildText(empty + "Qualifier"), Quantity = element.GetChildText(empty + "Quantity"), IntervalEndDate = element.GetChildText(empty + "IntervalEndDate"), IntervalEndTime = element.GetChildText(empty + "IntervalEndTime") }; return(model); }
private void ParseIntervalSummaryAcrossMetersQty(Prism867Context context, string[] marketFields) { context.RecordType = GetRecordType(context, marketFields, 0); switch (context.RecordType) { case "PP": break; default: logger.DebugFormat("Record Usage Type not found: {0}. Transaction Number \"{1}\".", context.RecordType, context.TransactionNumber); return; } var current = context.Current; if (current == null || current.ModelType != Type867Types.IntervalSummaryAcrossMeters) { throw new InvalidOperationException(); } var detail = current as Type867IntervalSummaryAcrossMeters; if (detail == null) { throw new InvalidOperationException(); } var model = new Type867IntervalSummaryAcrossMetersQty { Qualifier = marketFields.AtIndex(2), Quantity = marketFields.AtIndex(3), IntervalEndDate = marketFields.AtIndex(5), IntervalEndTime = marketFields.AtIndex(6) }; detail.AddQuantity(model); }