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