protected void btnSave_ServerClick(object sender, EventArgs e)
{
string studentid = divStuentID.InnerText;
DbContext db = new DbContext();
db.BeginTransaction();
//OracleCommand cmd = new OracleCommand("DELETE FROM sc_courseenrollments WHERE student_id= :v_student_id");
//OracleParameter para = new OracleParameter("v_student_id ", studentid);
//cmd.Parameters.Add(para);
//db.AddCommand(cmd);
foreach (ListItem item in cblCourses.Items)
{
OracleCommand cmd2 = new OracleCommand("update_courseenrollments_sp");
cmd2.CommandType = CommandType.StoredProcedure;
OracleParameter para1 = new OracleParameter("v_student_id", studentid);
cmd2.Parameters.Add(para1);
OracleParameter para2 = new OracleParameter("v_course_id", item.Value);
cmd2.Parameters.Add(para2);
OracleParameter para3 = new OracleParameter("v_selected", item.Selected ? 1 : 0);
cmd2.Parameters.Add(para3);
db.AddCommand(cmd2);
}
db.Commit();
ListView1.DataBind();
divMessage.Attributes.Remove("class");
divMessage.Attributes.Add("class", "alert alert-success");
divMessage.InnerText = "Courses for the student were saved successfully.";
}
