public void InsertGasProfileFactorEvaluation(Type867GasProfileFactorEvaluation model)
{
using (var connection = new SqlConnection(_connectionString))
using (var command = connection.CreateCommand("esp_867GasProfileFactorEvaluationInsert"))
{
command.AddWithValue("@867_Key", model.HeaderKey)
.AddIfNotEmptyOrDbNull("@ProfilePeriodStartDate", model.ProfilePeriodStartDate)
.AddIfNotEmptyOrDbNull("@CustomerServiceInitdate", model.CustomerServiceInitDate)
.AddIfNotEmptyOrDbNull("@UtilityRateServiceClass", model.UtilityRateServiceClass)
.AddIfNotEmptyOrDbNull("@RateSubClass", model.RateSubClass)
.AddIfNotEmptyOrDbNull("@NonHeatLoadFactorQty", model.NonHeatLoadFactorQty)
.AddIfNotEmptyOrDbNull("@WeatherNormLoadFactorQty", model.WeatherNormLoadFactorQty)
.AddIfNotEmptyOrDbNull("@LoadFactorRatio", model.LoadFactorRatio)
.AddIfNotEmptyOrDbNull("@UFGRatePct", model.UFGRatePct)
.AddIfNotEmptyOrDbNull("@MaximumDeliveryQty", model.MaximumDeliveryQty);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
}
}
public Type867GasProfileFactorEvaluation ParseGasProfileFactorEvaluation(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type867GasProfileFactorEvaluation
{
ProfilePeriodStartDate = element.GetChildText(empty + "ProfilePeriodStartDate"),
CustomerServiceInitDate = element.GetChildText(empty + "CustomerServiceInitdate"),
UtilityRateServiceClass = element.GetChildText(empty + "UtilityRateServiceClass"),
RateSubClass = element.GetChildText(empty + "RateSubClass"),
NonHeatLoadFactorQty = element.GetChildText(empty + "NonHeatLoadFactorQty"),
WeatherNormLoadFactorQty = element.GetChildText(empty + "WeatherNormLoadFactorQty"),
LoadFactorRatio = element.GetChildText(empty + "LoadFactorRatio"),
UFGRatePct = element.GetChildText(empty + "UFGRatePct"),
MaximumDeliveryQty = element.GetChildText(empty + "MaximumDeliveryQty")
};
return(model);
}
public void InsertGasProfileFactorEvaluation(Type867GasProfileFactorEvaluation model)
{
}
