public void InsertUnMeterSummaryQty(Type867UnMeterSummaryQty model)
{
using (var connection = new SqlConnection(_connectionString))
using (var command = connection.CreateCommand("csp867UnmeterSummaryQtyInsert"))
{
command.AddWithValue("@UnmeterSummary_Key", model.UnMeterSummaryKey)
.AddIfNotEmptyOrDbNull("@Qualifier", model.Qualifier)
.AddIfNotEmptyOrDbNull("@Quantity", model.Quantity)
.AddIfNotEmptyOrDbNull("@MeasurementSignificanceCode", model.MeasurementSignificanceCode)
.AddIfNotEmptyOrDbNull("@ServicePeriodStart", model.ServicePeriodStart)
.AddIfNotEmptyOrDbNull("@ServicePeriodEnd", model.ServicePeriodEnd);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
}
}
public Type867UnMeterSummaryQty ParseUnMeterSummaryQty(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type867UnMeterSummaryQty
{
Qualifier = element.GetChildText(empty + "Qualifier"),
Quantity = element.GetChildText(empty + "Quantity"),
MeasurementSignificanceCode = element.GetChildText(empty + "MeasurementSignificanceCode"),
ServicePeriodStart = element.GetChildText(empty + "ServicePeriodStart"),
ServicePeriodEnd = element.GetChildText(empty + "ServicePeriodEnd")
};
return(model);
}
public void InsertUnMeterSummaryQty(Type867UnMeterSummaryQty model)
{
}
