public Course getCourseByTitle(string title) { MySqlCommand command = connection().CreateCommand(); command.CommandText = "select * FROM course WHERE title = '" + title + "' "; MySqlDataReader dr = command.ExecuteReader(); Course course = null; CourseData data = new CourseData(); while (dr.Read()) { data.setTitle(title); data.setDescription(dr["description"].ToString()); data.setSuitable(dr["suitable"].ToString()); data.setPrice(dr["price"].ToString()); data.setNotice(dr["notice"].ToString()); data.setOther(dr["other"].ToString()); } course = courseMapper.CourseDataTransformToCourse(data); connection().Close(); return(course); }
public CourseData CourseTransformToCourseData(Course course) { CourseData data = new CourseData(); data.setTitle(course.getTitle()); data.setDescription(course.getDescription()); data.setSuitable(course.getSuitable()); data.setPrice(course.getPrice()); data.setNotice(course.getNotice()); data.setOther(course.getOther()); return(data); }
public Course getCourseByTitle(string title) { DataRow[] selectedCourse = DataHelper.courseTable.Select("課程名稱 ='" + title + "'"); Course course = null; CourseData data = new CourseData(); foreach (DataRow row in selectedCourse) { data.setTitle(row["課程名稱"].ToString()); data.setDescription(row["課程說明"].ToString()); data.setSuitable(row["適合對象"].ToString()); data.setPrice(row["定價"].ToString()); data.setNotice(row["注意事項"].ToString()); data.setOther(row["備註"].ToString()); } course = courseMapper.CourseDataTransformToCourse(data); return(course); }
public Course getCourseByTitle(string title) { DataTable dt = readAllCourse(); DataRow[] selectedCourse = dt.Select("Title ='" + title + "'"); Course course = null; CourseData data = new CourseData(); foreach (DataRow row in selectedCourse) { data.setTitle(row["Title"].ToString()); data.setDescription(row["Description"].ToString()); data.setSuitable(row["Suitable"].ToString()); data.setPrice(row["Price"].ToString()); data.setNotice(row["Notice"].ToString()); data.setOther(row["Other"].ToString()); } course = courseMapper.CourseDataTransformToCourse(data); return(course); }