public Type814ServiceMeterTou[] ListServiceMeterTous(int meterKey)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("esp_814ServiceMeterTOUList"))
{
command.AddWithValue("@Meter_Key", meterKey);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var collection = new List <Type814ServiceMeterTou>();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var item = new Type814ServiceMeterTou
{
TouKey = reader.GetInt32("TOU_Key"),
MeterKey = meterKey,
};
reader.TryGetString("TOUCode", x => item.TouCode = x);
reader.TryGetString("MeasurementType", x => item.MeasurementType = x);
collection.Add(item);
}
return(collection.ToArray());
}
}
}
public Type814ServiceMeterTou ParseServiceMeterTou(XElement element, IDictionary <string, XNamespace> namespaces)
{
XNamespace empty;
if (!namespaces.TryGetValue(string.Empty, out empty))
{
empty = XNamespace.None;
}
var model = new Type814ServiceMeterTou
{
TouCode = element.GetChildText(empty + "TOUCode"),
MeasurementType = element.GetChildText(empty + "MeasurementType"),
};
return(model);
}
public int InsertServiceMeterTou(Type814ServiceMeterTou model)
{
using (var connection = new SqlConnection(connectionString))
using (var command = connection.CreateCommand("csp814ServiceMeterTOUInsert"))
{
command.AddWithValue("@Meter_Key", model.MeterKey)
.AddWithValue("@TOUCode", model.TouCode)
.AddWithValue("@MeasurementType", model.MeasurementType);
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
command.ExecuteNonQuery();
model.TouKey = 1;
return(1);
}
}
public void When_Saving_Header_With_Any_Service_Meter_TOUs_Then_Insert_Service_Meter_Tou_Is_Called()
{
// arrange
const int serviceMeterKey = 2;
var tou = new Type814ServiceMeterTou {
TouCode = "mock"
};
var meter = new Type814ServiceMeter();
meter.AddTou(tou);
var service = new Type814Service();
service.AddMeter(meter);
var header = new Type814Header();
header.AddService(service);
dataAccess.Stub(x => x.InsertHeader(Arg.Is(header)))
.Return(1);
dataAccess.Stub(x => x.InsertService(Arg.Is(service)))
.Return(1);
dataAccess.Stub(x => x.InsertServiceMeter(Arg.Is(meter)))
.Return(serviceMeterKey);
dataAccess.Expect(x => x.InsertServiceMeterTou(Arg.Is(tou)))
.Return(1);
// act
concern.SaveHeader(header);
// assert
Assert.AreEqual(serviceMeterKey, tou.MeterKey);
dataAccess.VerifyAllExpectations();
}
