/// <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);
}
