public ActionResult ViewMaterialByCurso(Int32 cursoid) { GestorCursoMaterial GestorCursoMaterial = new GestorCursoMaterial(); BeCursoMaterial objCursoMaterial = GestorCursoMaterial.ObtenerListadoMaterialPorCurso(cursoid); ViewBag.cursoid = cursoid; ViewBag.CursoMaterial = objCursoMaterial; return(View()); }
public BeCursoMaterial ObtenerListadoMaterialPorCurso(Int32 cursoid) { BeCursoMaterial obj = new BeCursoMaterial(); obj.lstMaterial = new List <BeMaterial>(); DatabaseHelper helper = null; SqlDataReader reader = null; try { helper = new DatabaseHelper(DalConexion.getConexion()); helper.AddParameter("@P_CURSOID", cursoid); reader = (SqlDataReader)helper.ExecuteReader("spr_ObtenerListadoMaterialPorCurso", System.Data.CommandType.StoredProcedure); while (reader.Read()) { BeCurso objCurso = new BeCurso(); objCurso.id = Validacion.DBToInt32(ref reader, "cursoid"); objCurso.descripcion = Validacion.DBToString(ref reader, "desc_curso"); BeMaterial objMaterial = new BeMaterial(); objMaterial.id = Validacion.DBToInt32(ref reader, "materialid"); objMaterial.descripcion = Validacion.DBToString(ref reader, "desc_material"); objMaterial.curso = new BeCurso() { id = Validacion.DBToInt32(ref reader, "cursoid") }; obj.curso = objCurso; obj.lstMaterial.Add(objMaterial); } } catch (Exception ex) { clsException localException = new clsException(ex, "DalCursoMaterial -> ObtenerListadoMaterialPorCurso()"); } finally { if (helper != null) { helper.Dispose(); } } return(obj); }