void loadCourseType(ComboBox cb)
{
List <CourseType> courseTypes = CourseTypeData.GetInstance().loadCourseType();
cb.DataSource = courseTypes;
cb.DisplayMember = "CourseTypeName";
}
private void btnEditCourse_Click(object sender, EventArgs e)
{
string id = txtCourseID.Text;
string name = txtCourseName.Text;
string type = cbCourseType.Text;
string idType = CourseTypeData.GetInstance().GetCourseTypeIdByCourseType(type);
if (CourseData.GetInstance().EditCoursẹ(id, name, idType))
{
MessageBox.Show("Edit Successful");
loadCourseData();
}
else
{
MessageBox.Show("Edit Fail");
}
}
public CourseTypeData getCourseType(string coursetype_code)
{
CourseTypeData coursetype_data = new CourseTypeData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From COURSE_TYPE Where COURSE_TYPE_CODE='" + coursetype_code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
coursetype_data.CourseType_Code = rowData["COURSE_TYPE_CODE"].ToString();
coursetype_data.CourseType_Thainame = rowData["COURSE_TYPE_THAINAME"].ToString();
coursetype_data.CourseType_Engname = rowData["COURSE_TYPE_ENGNAME"].ToString();
}
return(coursetype_data);
}
private void btnAddCourse_Click(object sender, EventArgs e)
{
if (!(String.IsNullOrEmpty(txtCourseID.Text) || String.IsNullOrEmpty(txtCourseName.Text)))
{
string id = txtCourseID.Text;
string name = txtCourseName.Text;
string type = cbCourseType.Text;
string idType = CourseTypeData.GetInstance().GetCourseTypeIdByCourseType(type);
if (CourseData.GetInstance().InsertCourse(id, name, idType))
{
MessageBox.Show("Add Successful");
loadCourseData();
loadCourseIDInComboBox(cbCourseID);
}
else
{
MessageBox.Show("Add Fail");
}
}
}
public List <CourseTypeData> getCourseType()
{
List <CourseTypeData> coursetypeData = new List <CourseTypeData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From COURSE_TYPE Order By COURSE_TYPE_CODE";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
CourseTypeData coursetype_data = new CourseTypeData();
coursetype_data.CourseType_Code = rowData["COURSE_TYPE_CODE"].ToString();
coursetype_data.CourseType_Thainame = rowData["COURSE_TYPE_THAINAME"].ToString();
coursetype_data.CourseType_Engname = rowData["COURSE_TYPE_ENGNAME"].ToString();
coursetypeData.Add(coursetype_data);
}
return(coursetypeData);
}
