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