private void button1_Click_1(object sender, EventArgs e) { this.Hide(); Searching_Filtering_Practices_Form f = new Searching_Filtering_Practices_Form(); f.ShowDialog(); this.Show(); }
public void TestFilterPractice() { Searching_Filtering_Practices_Form form = new Searching_Filtering_Practices_Form(); SqlWorker.GetDataSet("INSERT INTO TeachingExercises(StartTime,EndTime,Class,Practitioner,type,CourseName,Day,AmountOfStudents) VALUES('" + startTime + "','" + endTime + "','" + Class + "','" + practitioner + "','" + type + "','" + CourseName + "','" + day + "','" + amoOfStud + "')"); DataSet data = SqlWorker.GetDataSet("SELECT ID FROM TeachingExercises WHERE StartTime LIKE '" + startTime + "' AND EndTime LIKE '" + endTime + "' AND Class LIKE '" + Class + "' AND Practitioner LIKE '" + practitioner + "' AND type LIKE '" + type + "' AND CourseName LIKE '" + CourseName + "' AND Day LIKE '" + day + "' AND AmountOfStudents LIKE '" + amoOfStud + "'"); try { Assert.IsTrue(form.searchPractice(startTime, endTime, Class, practitioner, type, data.Tables[0].Rows[0][0].ToString()).Tables[0].Rows.Count == 1); } catch { Assert.Fail(); } SqlWorker.GetDataSet("DELETE FROM TeachingExercises WHERE ID LIKE '" + data.Tables[0].Rows[0][0].ToString() + "'"); }