本文整理汇总了C#中DatabaseWrapper类的典型用法代码示例。如果您正苦于以下问题:C#DatabaseWrapper类的具体用法?C#DatabaseWrapper怎么用?C#DatabaseWrapper使用的例子?这里精选的类代码示例或许可以为您提供帮助。
示例1:Execute_HappyPath_ReturnsProducerEeeDataHistory
publicasyncTaskExecute_HappyPath_ReturnsProducerEeeDataHistory()
{
using(DatabaseWrapperdb=newDatabaseWrapper())
{
//Arrange
ModelHelperhelper=newModelHelper(db.Model);
varscheme1=helper.CreateScheme();
scheme1.ApprovalNumber="WEE/TE0000ST/SCH";
varmemberUpload1=helper.CreateSubmittedMemberUpload(scheme1);
memberUpload1.ComplianceYear=2000;
varproducer1=helper.CreateProducerAsCompany(memberUpload1,"PRN123");
producer1.ObligationType="B2B";
vardataReturnVersion1=helper.CreateDataReturnVersion(scheme1,2000,1);
dataReturnVersion1.SubmittedDate=newDateTime(2015,1,6);
vardataReturnVersion2=helper.CreateDataReturnVersion(scheme1,2000,2);
dataReturnVersion2.SubmittedDate=newDateTime(2015,1,8);
helper.CreateEeeOutputAmount(dataReturnVersion1,producer1.RegisteredProducer,"B2B",1,100);
helper.CreateEeeOutputAmount(dataReturnVersion2,producer1.RegisteredProducer,"B2B",2,200);
varscheme2=helper.CreateScheme();
scheme2.ApprovalNumber="WEE/TE0000S1/SCH";
varmemberUpload2=helper.CreateSubmittedMemberUpload(scheme2);
memberUpload2.ComplianceYear=2000;
varproducer2=helper.CreateProducerAsCompany(memberUpload2,"PRN123");
producer2.ObligationType="B2C";
vardataReturnVersion3=helper.CreateDataReturnVersion(scheme2,2000,1);
dataReturnVersion1.SubmittedDate=newDateTime(2015,1,9);
vardataReturnVersion4=helper.CreateDataReturnVersion(scheme2,2000,2);
dataReturnVersion4.SubmittedDate=newDateTime(2015,1,10);
helper.CreateEeeOutputAmount(dataReturnVersion3,producer2.RegisteredProducer,"B2C",1,40);
helper.CreateEeeOutputAmount(dataReturnVersion4,producer2.RegisteredProducer,"B2C",2,1000);
db.Model.SaveChanges();
//Act
varresults=awaitdb.StoredProcedures.SpgProducerEeeHistoryCsvData("PRN123");
//Assert
Assert.NotNull(results);
ProducerEeeHistoryCsvData.ProducerInReturnsResultb2cProducer=results.ProducerReturnsHistoryData.Find(x=>(x.ApprovalNumber=="WEE/TE0000S1/SCH"));
Assert.NotNull(b2cProducer);
Assert.Equal(2000,b2cProducer.ComplianceYear);
Assert.Equal(1000,b2cProducer.Cat2B2C);
Assert.Equal("Yes",b2cProducer.LatestData);
ProducerEeeHistoryCsvData.ProducerInReturnsResultb2bProducer=results.ProducerReturnsHistoryData.Find(x=>(x.ApprovalNumber=="WEE/TE0000ST/SCH"));
Assert.NotNull(b2bProducer);
Assert.Equal(2000,b2bProducer.ComplianceYear);
Assert.Equal(200,b2bProducer.Cat2B2B);
Assert.Null(b2bProducer.Cat2B2C);
Assert.Equal("Yes",b2bProducer.LatestData);
Assert.Equal(4,results.ProducerReturnsHistoryData.Count);
}
}
原文链接:
http://www.jxszl.com/biancheng/C/556846.html