public int CheckIfLectureAlreadyExists(Models.BU.Lecture lecture) { Models.Database db = new Models.Database(); string query = "SELECT LectureId FROM Lecture WHERE TeacherId = '" + lecture.teacher.UserID + "' AND Period = '" + lecture.period + "' AND Week = '" + lecture.week + "'" + "AND Day = '" + lecture.day + "' AND StartHour = '" + lecture.startHour + "' AND StartMinute = '" + lecture.startMinute + "'" + "AND EndHour = '" + lecture.endHour + "' AND EndMinute = '" + lecture.endMinute + "'"; return(db.CheckIfLectureAlreadyExists(query)); }