public void AddModuleToCourse(AddRemoveModules addModule)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
vCourseId = addModule.txAddCourseId.Text;
vModuleId = addModule.ddAddModuleName.SelectedItem.Value;
string sqlInsertCmd = "INSERT INTO CourseContainModules VALUES('" + vCourseId + "', '" + vModuleId + "')";
SqlCommand cmd = new SqlCommand(sqlInsertCmd, DatabaseConnection.dbConnection);
cmd.ExecuteNonQuery();
DB.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
public void RemoveModuleFromCourse(AddRemoveModules removeModule)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
vCourseId = removeModule.GridViewCourses.SelectedRow.Cells[1].Text;
vModuleId = removeModule.GridViewModules.SelectedRow.Cells[1].Text;
string sqlDeleteCmd = "DELETE FROM CourseContainModules WHERE containCourseId = '" + vCourseId + "' AND containModuleId = '" + vModuleId + "'";
SqlCommand cmd = new SqlCommand(sqlDeleteCmd, DatabaseConnection.dbConnection);
cmd.ExecuteNonQuery();
DB.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
public void LoadCourseModules(AddRemoveModules module)
{
try
{
DatabaseConnection DB = new DatabaseConnection();
DB.openConnection();
string vSelectedCourseId = module.GridViewCourses.SelectedRow.Cells[1].Text;
string sqlViewcmd = "SELECT t1.moduleId, t1.moduleName FROM Modules as t1 RIGHT JOIN CourseContainModules AS t2 ON t1.moduleId = t2.containModuleId WHERE t2.containCourseId='" + vSelectedCourseId + "'";
var dataAdapter = new SqlDataAdapter(sqlViewcmd, DatabaseConnection.dbConnection);
var DS = new DataSet();
dataAdapter.Fill(DS);
module.GridViewModules.DataSource = DS.Tables[0];
module.GridViewModules.DataBind();
DB.closeConnection();
}
catch (Exception e)
{
MessageBox.Show("Error" + e);
}
}
