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