public void InsertGasProfileFactorSample(Type867GasProfileFactorSample model)
{
using (var connection = new SqlConnection(_connectionString))
using (var command = connection.CreateCommand("esp_867GasProfileFactorSampleInsert"))
{
command.AddWithValue("@867_Key", model.HeaderKey)
.AddIfNotEmptyOrDbNull("@ReportMonth", model.ReportMonth)
.AddIfNotEmptyOrDbNull("@AnnualPeriod", model.AnnualPeriod)
.AddIfNotEmptyOrDbNull("@NormProjectedUsageQty", model.NormProjectedUsageQty)
.AddIfNotEmptyOrDbNull("@WeatherNormUsageProjectedQty", model.WeatherNormUsageProjectedQty)
.AddIfNotEmptyOrDbNull("@NormProjectedDeliveryQty", model.NormProjectedDeliveryQty)
.AddIfNotEmptyOrDbNull("@WeatherNormProjectedDeliveryQty", model.WeatherNormProjectedDeliveryQty)
.AddIfNotEmptyOrDbNull("@ProjectedDailyDeliveryQty", model.ProjectedDailyDeliveryQty)
.AddIfNotEmptyOrDbNull("@DesignProjectedUsageQty", model.DesignProjectedUsageQty)
.AddIfNotEmptyOrDbNull("@DesignProjectedDeliveryQty", model.DesignProjectedDeliveryQty)
.AddIfNotEmptyOrDbNull("@ProjectedBalancingUseQty", model.ProjectedBalancingUseQty)
.AddIfNotEmptyOrDbNull("@ProjectedSwingChargeAmt", model.ProjectedSwingChargeAmt);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
}
}
public Type867GasProfileFactorSample ParseGasProfileFactorSample(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type867GasProfileFactorSample
{
ReportMonth = element.GetChildText(empty + "ReportMonth"),
AnnualPeriod = element.GetChildText(empty + "AnnualPeriod"),
NormProjectedUsageQty = element.GetChildText(empty + "NormProjectedUsageQty"),
WeatherNormUsageProjectedQty = element.GetChildText(empty + "WeatherNormUsageProjectedQty"),
NormProjectedDeliveryQty = element.GetChildText(empty + "NormProjectedDeliveryQty"),
WeatherNormProjectedDeliveryQty = element.GetChildText(empty + "WeatherNormProjectedDeliveryQty"),
ProjectedDailyDeliveryQty = element.GetChildText(empty + "ProjectedDailyDeliveryQty"),
DesignProjectedUsageQty = element.GetChildText(empty + "DesignProjectedUsageQty"),
DesignProjectedDeliveryQty = element.GetChildText(empty + "DesignProjectedDeliveryQty"),
ProjectedBalancingUseQty = element.GetChildText(empty + "ProjectedBalancingUseQty"),
ProjectedSwingChargeAmt = element.GetChildText(empty + "ProjectedSwingChargeAmt")
};
return(model);
}
public void InsertGasProfileFactorSample(Type867GasProfileFactorSample model)
{
}
