/// <summary> /// 获取一周课表 /// </summary> /// <param name="classTable"></param> private void GetWeekCourse(ClassTable classTable) { if (classTable == null || classTable.ClassTableItems == null) { return; } CourseViewList.Clear(); CourseList.Clear(); for (var i = 1; i < 6; i++) { for (var j = 1; j < 9; j++) { var course = new Course() { CurriculumNumber = j, WeekId = i, CourseName = "-" }; var exsitCourse = classTable.ClassTableItems.FirstOrDefault(o => o.CurriculumNumber == j && o.WeekId == i); CourseList.Add(exsitCourse ?? course); } } for (var i = 1; i < 9; i++) { var cvm = GetCourseView(i); CourseViewList.Add(cvm); } }
async Task ExecuteLoadItemsCommand() { if (IsBusy) { return; } IsBusy = true; try { CourseList.Clear(); var items = await App.Database.GetCoursesAsync(Term); foreach (var item in items) { CourseList.Add(item); } } catch (Exception ex) { Debug.WriteLine(ex); } finally { IsBusy = false; } }
private void DoFilter(object o) { string instructor = o.ToString(); var course = CourseAll; if (instructor != "All") { course = CourseAll.Where(c => c.CourseInstructors.Exists(e => e == instructor)).ToList(); } CourseList.Clear(); foreach (var item in course) { CourseList.Add(item); } }
private void DoFilter(object o) { string teacher = o.ToString(); List <CourseModel> temp = courseAll; if (teacher != "全部") { temp = courseAll.Where(c => c.Teachers.Exists(e => e == teacher)).ToList(); } CourseList.Clear(); foreach (var item in temp) { CourseList.Add(item); } }
async Task ExecuteLoadCourses() { if (IsBusy) { return; } IsBusy = true; try { CourseList.Clear(); var courses = await App.DB.ShowCourses(Term); foreach (var course in courses) { CourseList.Add(course); } } catch (Exception exception) { } finally { IsBusy = false; } }
private void InitCourseList() { for (int i = 0; i < 10; i++) { CourseList.Add(new CourseModel { IsShowSkeleton = true }); } Task.Run(new Action(async() => { courseAll = LocalDataAccess.GetInstance().GetCourses(); await Task.Delay(4000); Application.Current.Dispatcher.Invoke(new Action(() => { CourseList.Clear(); foreach (var item in courseAll) { CourseList.Add(item); } })); })); }
public static void ClearCourseList() { CourseList.Clear(); }
private void ExecuteSearch(object parameter) { String QueryBaseAddition = ""; String dynamic_query_part = ""; foreach (var v in text_criteria) { if (v.isChecked) { if (dynamic_query_part == "") { dynamic_query_part = dynamic_query_part + v.representation + " LIKE '%" + v.input + "%'"; } else { dynamic_query_part = dynamic_query_part + " AND " + v.representation + " LIKE '%" + v.input + "%'"; } } } foreach (var v in list_criteria) { if (v.isChecked) { bool used = false; if (v.representation == "Läsperiod" && v.Selected != "") { QueryBaseAddition += "JOIN Läsperioder USING (Kurskod) "; used = true; } if (v.representation == "Specialisering" && v.Selected != "") { QueryBaseAddition += "JOIN Specialiseringar USING (Kurskod) "; used = true; } if (dynamic_query_part == "" && used) { dynamic_query_part = dynamic_query_part + v.representation + " LIKE '%" + v.Selected + "%'"; } else if (used || v.representation == "Poängtyp") { dynamic_query_part = dynamic_query_part + " AND " + v.representation + " LIKE '%" + v.Selected + "%'"; } } } foreach (var v in Interval_criteria) { if (v.isChecked) { String lower = v.LowerBounds.ToString().Replace(',', '.'); String upper = v.UpperBounds.ToString().Replace(',', '.'); if (dynamic_query_part == "") { dynamic_query_part = dynamic_query_part + v.representation + " >= " + lower + " AND " + v.representation + " <= " + upper; } else { dynamic_query_part = dynamic_query_part + " AND " + v.representation + " >= " + lower + " AND " + v.representation + " <= " + upper; } } } CourseList.Clear(); String query = "SELECT DISTINCT Kurskod, Antal_poäng, Poängtyp, Kursnamn, Beskrivning, Representant_email FROM spec_course_info " + QueryBaseAddition + " WHERE " + dynamic_query_part + ";"; if (dynamic_query_part != "") { foreach (var v in PerformDatabaseCourseAccess(query)) { CourseList.Add(v); } } }