public CourseAssignToTeacherModel GetSingleCourseAssignToTeacherModel(int courseAssignId)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM courseAssignToTeacher_tbl WHERE id='" + courseAssignId + "'";
SqlCommand command = new SqlCommand(query, connection);
// command.Parameters.AddWithValue("@deptId", DeptId);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
CourseAssignToTeacherModel aCourseAssignToTeacherModel = new CourseAssignToTeacherModel();
while (reader.Read())
{
aCourseAssignToTeacherModel.CourseAssignToTeacherId = Convert.ToInt32(reader["id"].ToString());
aCourseAssignToTeacherModel.DepartmentId = int.Parse(reader["departmentId"].ToString());
aCourseAssignToTeacherModel.CourseId = Convert.ToInt32(reader["courseId"].ToString());
aCourseAssignToTeacherModel.TeacherId = int.Parse(reader["teacherId"].ToString());
}
aCourseAssignToTeacherModel.Department = aCourseAssignManager.GetSingleDepartmentByDeptId(aCourseAssignToTeacherModel.DepartmentId);
aCourseAssignToTeacherModel.Teacher = aCourseAssignManager.GetSingleTeacherByTeacherId(aCourseAssignToTeacherModel.TeacherId);
aCourseAssignToTeacherModel.Course = aCourseAssignManager.GetSingleCourseByCourseId(aCourseAssignToTeacherModel.CourseId);
connection.Close();
return(aCourseAssignToTeacherModel);
}