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);
}
