/// <summary> /// Update a Lecturer in the database /// </summary> /// <param name="lecturers">The updated Lecturer</param> private void updateLecturer(Lecturer lecturer) { string sql; sql = "UPDATE Lecturer"; sql += "Lec_Name='" + lecturer.getName() + "', "; sql += "Initials='" + lecturer.getInitials() + "', "; sql += "Email='" + lecturer.getEmail() + "', "; sql += "MaxHours=" + lecturer.getMaxHours() + ", "; sql += "MaxConsecHours=" + lecturer.getMaxConsecHours() + ", "; sql += "MinSlotsPerDay=" + lecturer.getMinSlotsPerDay() + ", "; sql += "SlotsOff='" + lecturer.getSlotsOff() + "' "; sql += "WHERE ID LIKE '" + lecturer.getId() + "'"; excuteNonQuery(sql); }
/// <summary> /// Add a new Lecturer to the database /// </summary> /// <param name="lecturer">The new Lecturer</param> private void insertLecturer(Lecturer lecturer) { string sql; sql = "INSERT INTO Lecturer (Lec_Name, Initials, Email, MaxHours, MaxConsecHours, MinSlotsPerDay, SlotsOff, Deleted) VALUES("; sql += "'" + lecturer.getName() + "', "; sql += "'" + lecturer.getInitials() + "', "; sql += "'" + lecturer.getEmail() + "', "; sql += lecturer.getMaxHours() + ", "; sql += lecturer.getMaxConsecHours() + ", "; sql += lecturer.getMinSlotsPerDay() + ", "; sql += "'" + lecturer.getSlotsOff() + "', false)"; excuteNonQuery(sql); }