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