public void CheckColumnsPayment_Types()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("Payment_Id", 1, false),
ExpectedColumn.CreateNvarChar("PaymentName", 2, false),
ExpectedColumn.CreateBit("FM36", 3, false),
ExpectedColumn.CreateNvarChar("PaymentTypeDescription", 4, true),
ExpectedColumn.CreateInt("FundingLineId", 5, true),
ExpectedColumn.CreateInt("AdjustmentTypeId", 6, true),
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "Payment_Types", expectedColumns, true);
}
public void CheckColumnsEASSubmission()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateUniqueIdentifier("Submission_Id", 1, false),
ExpectedColumn.CreateNvarChar("UKPRN", 2, false),
ExpectedColumn.CreateInt("CollectionPeriod", 3, false),
ExpectedColumn.CreateNvarChar("ProviderName", 4, false),
ExpectedColumn.CreateDateTime("UpdatedOn", 5, false),
ExpectedColumn.CreateBit("DeclarationChecked", 6, false),
ExpectedColumn.CreateBit("NilReturn", 7, false),
ExpectedColumn.CreateNvarChar("UpdatedBy", 8, true),
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "EAS_Submission", expectedColumns, true);
}
public void CheckColumnFileDetails()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateBigInt("ID", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateNvarChar("Filename", 3, true, 50),
ExpectedColumn.CreateBigInt("FileSizeKb", 4, true),
ExpectedColumn.CreateInt("TotalLearnersSubmitted", 5, true),
ExpectedColumn.CreateInt("TotalValidLearnersSubmitted", 6, true),
ExpectedColumn.CreateInt("TotalInvalidLearnersSubmitted", 7, true),
ExpectedColumn.CreateInt("TotalErrorCount", 8, true),
ExpectedColumn.CreateInt("TotalWarningCount", 9, true),
ExpectedColumn.CreateDateTime("SubmittedTime", 10, true),
ExpectedColumn.CreateBit("Success", 11, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "FileDetails", expectedColumns, true);
}
