public void InsertCourseRecord(USTTI.Base.Course course)
{
string sql = "INSERT INTO courses VALUES(" + course.CourseID + ",'" + course.Code + "','" + course.Title + "','','" + course.Location +
"','" + course.Coordinator + "','" + course.StartDate + "','" + course.EndDate + "','" + course.Comments + "','" +
course.Slots + "','" + course.SponsorList + "','" + course.MoreSponsor + "','" + course.Year + "')";
ExecuteNonQuery(sql);
}
public void UpdateCourseRecord(USTTI.Base.Course course)
{
string sql = "UPDATE courses SET crsetitle1='" + course.Title + "',location='" + course.Location +
"',coordinator='" + course.Coordinator + "',trainfrom='" + course.StartDate + "',trainto='" + course.EndDate + "',comments='" + course.Comments + "',slots='" + course.Slots +
"',prisponsid='" + course.SID + "',morespons='" + course.MoreSponsor + "',courseyear='" + course.Year +
"' WHERE courseid='" + course.CourseID + "'";
ExecuteNonQuery(sql);
}
