private async Task ExecuteLoadCoursesCommand() { if (IsBusy) { return; } IsBusy = true; try { CourseCollection.Clear(); var courses = await DataStore.GetItemsAsync(true); foreach (var item in courses) { CourseCollection.Add(item); } } catch (Exception e) { Debug.WriteLine(e); throw; } finally { IsBusy = false; } }
private void UpdateCombobx() { for (int i = 0; i < checkedListBox1.Items.Count; i++) { if (checkedListBox1.GetItemChecked(i)) { clChecked.Add(courses[i]); checkedListBox1.Items.RemoveAt(i); } checkedListBox1 = new CheckedListBox(); reFillCheckList(); } }
public static CourseCollection GetCourses(params string[] courseList) { DSResponse rsp = QueryCourse.GetCourseById(courseList); CourseCollection courses = new CourseCollection(); foreach (XmlElement each in rsp.GetContent().GetElements("Course")) { Course course = new Course(each); courses.Add(course.Identity, course); } return(courses); }
private void Delete_Click(object sender, EventArgs e) { clChecked = new CourseCollection(); for (int i = 0; i < checkedListBox1.Items.Count; i++) { if (checkedListBox1.GetItemChecked(i)) { clChecked.Add(courses[i]); checkedListBox1.Items.RemoveAt(i); } } CourseDAL.DeleteSomeids(clChecked); UpdateCombobx(); }
public static CourseCollection SelectAll() { DataTable dt = database.DBLayer.ExecuteQuery("select * from Course"); CourseCollection result = new CourseCollection(); for (int i = 0; i < dt.Rows.Count; i++) { int courseId = Convert.ToInt32(dt.Rows[i]["id"]); string courseName = dt.Rows[i]["course_Name"].ToString(); int deptid = int.Parse(dt.Rows[i]["FK_department"].ToString()); Course c = new Course(courseId, courseName, deptid); result.Add(c); } return(result); }
public static CourseCollection GetCourses(string sUrl) { var courseCollection = new CourseCollection(); var htmlWeb = new HtmlWeb(); HtmlNode docNode = null; for (int i = 0; i < 3; i++) { try { docNode = htmlWeb.Load(sUrl).DocumentNode; break; } catch { if (i == 2) { throw new Exception("获取信息失败,这可能是由于网站访问量太大导致。"); } } } if (docNode != null) { foreach (var node in docNode.SelectNodes("//div[@class='s-r-list']")) { var course = new Course { 称 = node.FirstChild.NextSibling.FirstChild.NextSibling.FirstChild.NextSibling.FirstChild.InnerText, 老师 = node.FirstChild.FirstChild.NextSibling.InnerText, 课地点 = node.FirstChild.NextSibling.FirstChild.NextSibling.FirstChild.NextSibling.NextSibling .NextSibling.NextSibling.NextSibling.InnerText, 课时间 = node.FirstChild.NextSibling.FirstChild.NextSibling.FirstChild.NextSibling.NextSibling .NextSibling.NextSibling.FirstChild.NextSibling.InnerText, 学科 = node.FirstChild.NextSibling.FirstChild.NextSibling.FirstChild.NextSibling.NextSibling .NextSibling.FirstChild.InnerText, 剩余 = node.FirstChild.NextSibling.FirstChild.NextSibling.NextSibling.FirstChild.FirstChild.InnerText }; courseCollection.Add(course); } } return(courseCollection); }
protected override Entity OnAdd() { var newItem = new Course(); using (var frm = new frmCourse_Add()) { frm.ItemData = newItem; if (frm.ShowDialog() != DialogResult.OK) { return(null); } } App.LogAction("School Year.Course", "Created Course : " + newItem.CourseCode); ItemDataCollection.Add(newItem); return(newItem); }
public CourseCollection GetCoursesByDegreeProgram(string degreeProgramName) { if (degreeProgramName == null) { throw new Exception("Degree name cannot be null"); } MySqlConnection dbConnection = DbConnection.GetConnection(); CourseCollection coursesRequired = new CourseCollection(); using (dbConnection) { dbConnection.Open(); var selectQuery = "SELECT * FROM degree_requires_courses, degree_programs, courses WHERE degree_programs.degree_id = degree_requires_courses.degree_id AND degree_programs.name = @degree_program_name AND degree_programs.name = courses.course_name"; using (MySqlCommand cmd = new MySqlCommand(selectQuery, dbConnection)) { cmd.Parameters.AddWithValue("@degree_program_name", degreeProgramName); using (MySqlDataReader queryResultReader = cmd.ExecuteReader()) { int CRNOrdinal = queryResultReader.GetOrdinal("CRN"); while (queryResultReader.Read()) { int crn = queryResultReader[CRNOrdinal] == DBNull.Value ? default(int) : queryResultReader.GetInt32(CRNOrdinal); CourseDAL courseDal = new CourseDAL(); Course courseRequired = courseDal.GetCourseByCRN(crn); coursesRequired.Add(courseRequired); } return(coursesRequired); } } } }