public clsMessage updateStudentCourseRegistrationBulk(clsManageInstitute InstObject, List <string> CourseIDList, string action = "insert")
{
clsMessage rm = new clsMessage();
try
{
DataTable CourseTable = new DataTable();
CourseTable.Columns.Add("CourseID");
foreach (string course in CourseIDList)
{
CourseTable.Rows.Add(course);
}
using (SqlConnection conn = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdateStudentCourseRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentCourseRegID", StudentCourseRegID);
cmd.Parameters.AddWithValue("@UID", UID);
cmd.Parameters.AddWithValue("@ACYR", InstObject.AcademicYear);
cmd.Parameters.AddWithValue("@DepartmentID", InstObject.DepartmentID);
cmd.Parameters.AddWithValue("@SemesterID", InstObject.SemesterID);
cmd.Parameters.AddWithValue("@SectionID", InstObject.SectionID);
cmd.Parameters.AddWithValue("@RollNo", RollNo);
cmd.Parameters.AddWithValue("@ProfEMail", ProfEMailID);
cmd.Parameters.AddWithValue("@TyCourse", CourseTable);
cmd.Parameters.AddWithValue("@CurrentStatus", CurrentStatus);
cmd.Parameters.AddWithValue("@DepartmentID", RegistrationStatus);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.SuccessMessage = (string)cmd.Parameters["@rvalue"].Value;
rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
public clsMessage UpdateStudentCourseRegistrationBulk(clsStudentCourseRegistration studCourseReg, clsManageInstitute Inst, List <string> pCourseList, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = studCourseReg.updateStudentCourseRegistrationBulk(Inst, pCourseList, action);
return(rm);
}
