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);
}
