public static void DeleteFromRegistrationTables() { SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeletePathwayResults, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteAssessmentPathway, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteAssessmentSpecialism, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteRegistrationSpecialism, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteRegistrationPathway, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteRegistrationProfile, ConnectionString); }
public static void DeleteAddress() { var deletePrintCertificate = "delete pc from PrintCertificate pc join PrintBatchItem pb on pc.PrintBatchItemId = pb.BatchId"; var deletePrintBatchItem = "delete pb from PrintBatchItem pb join TlProviderAddress pa on pb.TlProviderAddressId=pa.Id"; var deleteAddress = "Delete pa from TlProviderAddress pa join TlProvider tp on pa.TlProviderId = tp.Id where tp.Name ='Barnsley College'"; SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(deletePrintCertificate, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(deletePrintBatchItem, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(deleteAddress, ConnectionString); }
public void ClearProviderTable() { String DeleteProviderQuery = "Delete FROM Provider"; SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteProviderQuery, Configurator.GetConfiguratorInstance().GetMatchingServiceConnectionString()); //Confirm theProvider table is cleared down: String ProviderRecordCount = "Select Count(*) FROM Provider"; var result = SqlDatabaseConncetionHelper.ReadDataFromDataBase(ProviderRecordCount, Configurator.GetConfiguratorInstance().GetMatchingServiceConnectionString()); Assert.AreEqual(result[0][0], 0); }
public static void DeleteRegistrationFromTables(string uln) { string DeletePathwayResults = "Delete pr from TqPathwayResult pr join TqPathwayAssessment pa on pr.TqPathwayAssessmentId = pa.Id join TqRegistrationPathway rw ON pa.TqRegistrationPathwayId = rw.Id join TqRegistrationProfile rp on rw.TqRegistrationProfileId = rp.Id where UniqueLearnerNumber = '" + uln + "'"; string DeleteRegSpecialism = "Delete rs from TqRegistrationSpecialism rs join TqRegistrationPathway rw ON rs.TqRegistrationPathwayId = rw.Id join TqRegistrationProfile rp on rw.TqRegistrationProfileId =rp.Id where UniqueLearnerNumber = '" + uln + "'"; string DeleteRegPathway = "Delete from TqRegistrationPathway where TqRegistrationProfileId In (select Id from TqRegistrationProfile where UniqueLearnerNumber= '" + uln + "')"; string DeleteRegProfile = "Delete from TqRegistrationProfile where UniqueLearnerNumber = '" + uln + "'"; string DeleteAssPathway = "Delete pa from TqPathwayAssessment pa join TqRegistrationPathway rw ON pa.TqRegistrationPathwayId = rw.Id join TqRegistrationProfile rp on rw.TqRegistrationProfileId =rp.Id where UniqueLearnerNumber= '" + uln + "'"; string DeleteAssSpecialism = "Delete sa from TqSpecialismAssessment sa join TqRegistrationSpecialism rs ON sa.TqRegistrationSpecialismId = rs.Id join TqRegistrationPathway rp on rs.TqRegistrationPathwayId=rp.Id join TqRegistrationProfile tr on rp.TqRegistrationProfileId =tr.Id where UniqueLearnerNumber= '" + uln + "'"; SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeletePathwayResults, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteAssPathway, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteAssSpecialism, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteRegSpecialism, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteRegPathway, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteRegProfile, ConnectionString); }
public static void DeleteFromAssessmentTables() { SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteAssessmentPathway, ConnectionString); SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(DeleteAssessmentSpecialism, ConnectionString); }
public void DeleteTlevelFromDB() { SqlDatabaseConncetionHelper.ExecuteDeleteSqlCommand(SQLDeleteProviderTlevel, ConnectionString); }