public void T2_Call_FindStudent_Proc(string param, int success, string[] arraySuccess) { using (SqlConnection connection = new SqlConnection(DbInit.GetDbConnectionString())) { connection.Open(); List <string> results = DbStoredProcedures.FindStudent(param, connection).ToList(); results.Count.Should().Be(success); if (success > 0) { foreach (string suc in arraySuccess) { Assert.Contains(suc, results); } } } }
public void T1_Create_Proc_FindStudent_With_Specific_String_In_Their_Name() { using (SqlConnection connection = new SqlConnection(DbInit.GetConnectionString())) { connection.Open(); ScriptExecutor exe = new ScriptExecutor(); exe.ScriptExe(DbStoredProcedures.StoredProceduresFindStudent(), connection); string cmdText = @"USE itiSchoolDB IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'FindStudent') SELECT 1 ELSE SELECT 0"; SqlCommand DateCheck = new SqlCommand(cmdText, connection); int x = Convert.ToInt32(DateCheck.ExecuteScalar()); x.Should().Be(1); // Check if already Exist exe.ScriptExe(DbStoredProcedures.StoredProceduresFindStudent(), connection); } }
public void T4_Call_UpStudent_Programmatically(string[] redoublants, int nbValidated, string[] validatedNames, int sizeTable) { using (SqlConnection connection = new SqlConnection(DbInit.GetDbConnectionString())) { connection.Open(); ResetTable(connection); var results = DbStoredProcedures.UpStudent(redoublants, connection).ToList(); results.Count.Should().Be(nbValidated); foreach (string suc in validatedNames) { Assert.Contains(suc, results); } // Check if validated students have been deleted ScriptExecutor exe = new ScriptExecutor(); exe.ScriptReader("use itiSchoolDB SELECT * from Student", connection, "Name").Count().Should().Be(sizeTable); } }
public void T3_Create_Proc_UpStudent(string[] redoublants, int nbValidated, string[] validatedNames, int sizeTable) { using (SqlConnection connection = new SqlConnection(DbInit.GetConnectionString())) { connection.Open(); ScriptExecutor exe = new ScriptExecutor(); exe.ScriptExe(DbStoredProcedures.StoredProceduresUpStudent(), connection); string cmdText = @"USE itiSchoolDB IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'UpStudent') SELECT 1 ELSE SELECT 0"; SqlCommand DateCheck = new SqlCommand(cmdText, connection); int x = Convert.ToInt32(DateCheck.ExecuteScalar()); x.Should().Be(1); // Check if already Exist exe.ScriptExe(DbStoredProcedures.StoredProceduresUpStudent(), connection); ResetTable(connection); // Test if proc is working StringBuilder str = new StringBuilder("use itiSchoolDB"); str.Append(" DECLARE @Students AS StudentList"); for (int i = 0; i < redoublants.Length; i++) { str.Append(" INSERT INTO @Students VALUES ('" + redoublants[i] + "')"); } str.Append(" EXEC UpStudent @Students"); List <string> results = exe.ScriptReader(str.ToString(), connection, "Name").ToList(); results.Count.Should().Be(nbValidated); foreach (string suc in validatedNames) { Assert.Contains(suc, results); } // Check if validated students have been deleted exe.ScriptReader("use itiSchoolDB SELECT * from Student", connection, "Name").Count().Should().Be(sizeTable); } }