//adds a event/holiday to the db public void AddEvent(Models.Course course) { if (course.Type == "VE") { sql.AddEvent(course.Title, course.Desc, course.StartCourse.ToString("yyyy-MM-dd") + course.StartTime.ToString(" HH:mm:ss"), course.EndCourse.ToString("yyyy-MM-dd") + course.EndTime.ToString(" HH:mm:ss"), true, false); } else if (course.Type == "F") { sql.AddEvent(course.Title, course.Desc, course.StartCourse.ToString("yyyy-MM-dd"), course.EndCourse.ToString("yyyy-MM-dd") + " 23:59:59", false, true); } else { sql.AddEvent(course.Title, course.Desc, course.StartCourse.ToString("yyyy-MM-dd") + course.StartTime.ToString(" HH:mm:ss"), course.EndCourse.ToString("yyyy-MM-dd") + course.EndTime.ToString(" HH:mm:ss"), false, false); } }