private void ParseScheduleDeterminants(Prism867Context context, string[] marketFields)
{
var current = context.Current;
if (current == null || current.ModelType != Type867Types.Header)
{
throw new InvalidOperationException();
}
var header = current as Type867Header;
if (header == null)
{
throw new InvalidOperationException();
}
var model = new Type867ScheduleDeterminants
{
CapacityObligation = marketFields.AtIndex(2),
TransmissionObligation = marketFields.AtIndex(3),
LoadProfile = marketFields.AtIndex(4),
LDCRateClass = marketFields.AtIndex(5),
SpecialMeterConfig = marketFields.AtIndex(12),
MaximumGeneration = marketFields.AtIndex(13),
LDCRateSubClass = marketFields.AtIndex(14)
};
header.AddScheduledDeterminant(model);
}
public Type867ScheduleDeterminants ParseScheduledDeterminant(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type867ScheduleDeterminants
{
CapacityObligation = element.GetChildText(empty + "CapacityObligation"),
TransmissionObligation = element.GetChildText(empty + "TransmissionObligation"),
LoadProfile = element.GetChildText(empty + "LoadProfile"),
LDCRateClass = element.GetChildText(empty + "LDCRateClass"),
Zone = element.GetChildText(empty + "Zone"),
BillCycle = element.GetChildText(empty + "BillCycle"),
MeterNumber = element.GetChildText(empty + "MeterNumber"),
EffectiveDate = element.GetChildText(empty + "EffectiveDate"),
LossFactor = element.GetChildText(empty + "LossFactor"),
ServiceVoltage = element.GetChildText(empty + "ServiceVoltage"),
SpecialMeterConfig = element.GetChildText(empty + "SpecialMeterConfig"),
MaximumGeneration = element.GetChildText(empty + "MaximumGeneration"),
LDCRateSubClass = element.GetChildText(empty + "LDCRateSubClass")
};
return(model);
}
public int InsertScheduleDeterminants(Type867ScheduleDeterminants model)
{
using (var connection = new SqlConnection(_connectionString))
using (var command = connection.CreateCommand("csp867ScheduleDeterminantsInsert"))
{
SqlParameter keyParameter;
command.AddWithValue("@867_Key", model.HeaderKey)
.AddWithValue("@Capacity_Obligation", model.CapacityObligation)
.AddWithValue("@Transmission_Obligation", model.TransmissionObligation)
.AddWithValue("@Load_Profile", model.LoadProfile)
.AddWithValue("@LDC_Rate_Class", model.LDCRateClass)
.AddWithValue("@Zone", model.Zone)
.AddWithValue("@BillCycle", model.BillCycle)
.AddWithValue("@MeterNumber", model.MeterNumber)
.AddWithValue("@EffectiveDate", model.EffectiveDate)
.AddWithValue("@LossFactor", model.LossFactor)
.AddWithValue("@ServiceVoltage", model.ServiceVoltage)
.AddWithValue("@SpecialMeterConfig", model.SpecialMeterConfig)
.AddWithValue("@MaximumGeneration", model.MaximumGeneration)
.AddWithValue("@LDC_Rate_Sub_Class", model.LDCRateSubClass)
.AddOutParameter("@ScheduleDeterminants_Key", SqlDbType.Int, out keyParameter);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
if (keyParameter.Value == null)
{
throw new Exception();
}
var key = (int)keyParameter.Value;
model.ScheduleDeterminantsKey = key;
return(key);
}
}