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 void create(Course course)
{
CourseData data = courseMapper.CourseTransformToCourseData(course);
string[] _course =
{
data.getTitle(),
data.getDescription(),
data.getSuitable(),
data.getPrice(),
data.getNotice(),
data.getOther()
};
MySqlCommand command = connection().CreateCommand();
command.CommandText = "Insert into course(title,description,suitable,price,notice,other) " + "values('"
+ data.getTitle() + "','"
+ data.getDescription() + "','"
+ data.getSuitable() + "','"
+ data.getPrice() + "'" + ",'"
+ data.getNotice() + "','"
+ data.getOther() + "')";
command.ExecuteNonQuery();
connection().Close();
}
public Course CourseDataTransformToCourse(CourseData courseData)
{
Course course = new Course();
course.setTitle(courseData.getTitle());
course.setDescription(courseData.getDescription());
course.setSuitable(courseData.getSuitable());
course.setPrice(courseData.getPrice());
course.setNotice(courseData.getNotice());
course.setOther(courseData.getOther());
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 void create(Course course)
{
CourseData data = courseMapper.CourseTransformToCourseData(course);
string[] _course =
{
data.getTitle(),
data.getDescription(),
data.getSuitable(),
data.getPrice(),
data.getNotice(),
data.getOther()
};
DataHelper.courseTable.Rows.Add(_course);
DataSet ds = new DataSet("course");
ds.Tables.Add(DataHelper.courseTable.Copy());
ds.WriteXml(@path);
}
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 void update(string oldTitle, Course course)
{
CourseData data = courseMapper.CourseTransformToCourseData(course);
DataRow[] _course = DataHelper.courseTable.Select("課程名稱 ='" + oldTitle + "'");
foreach (DataRow row in _course)
{
row["課程名稱"] = data.getTitle();
row["課程說明"] = data.getDescription();
row["適合對象"] = data.getSuitable();
row["定價"] = data.getPrice();
row["注意事項"] = data.getNotice();
row["備註"] = data.getOther();
}
DataSet ds = new DataSet("course");
ds.Tables.Add(DataHelper.courseTable.Copy());
ds.WriteXml(@path);
}
public void update(string oldTitle, Course course)
{
CourseData data = courseMapper.CourseTransformToCourseData(course);
DataTable dt = readAllCourse();
DataRow[] _course = dt.Select("Title ='" + oldTitle + "'");
foreach (DataRow row in _course)
{
row["Title"] = data.getTitle();
row["Description"] = data.getDescription();
row["Suitable"] = data.getSuitable();
row["Price"] = data.getPrice();
row["Notice"] = data.getNotice();
row["Other"] = data.getOther();
}
DataSet ds = new DataSet("course");
ds.Tables.Add(dt.Copy());
ds.WriteXml(@path);
}
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);
}
