protected void ListarSoftware()
{
// read previously chosen items from database
con.Open();
SqlCommand cmd = new SqlCommand("uspSEL_LISTAR_RECURSOS_ASIGNADOS", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("ID_DETALLE_REQUERIMIENTO_PERSONAL", SqlDbType.Int).Value = Convert.ToInt32(Session["Requerimiento"].ToString());
cmd.Parameters.Add("DES_DESCRIPCION", SqlDbType.VarChar, 100).Value = "SOFTWARE";
cmd.Parameters.Add("DES_TABLA", SqlDbType.VarChar, 100).Value = "ASIGNACION_DETALLE";
SqlDataReader reader = cmd.ExecuteReader();
// iterate through saved entries and add to Hashtable
Hashtable savedEntries = new Hashtable();
while (reader.Read())
{
string hobbyID = reader["IDE_RECURSO"].ToString();
savedEntries[hobbyID] = true;
}
con.Close();
// check the corresponding boxes
CheckSoftware.DataBind();
//cblHobbies.DataBind();
foreach (ListItem li in CheckSoftware.Items)
{
if (savedEntries.ContainsKey(li.Value))
{
li.Selected = true;
}
}
}
protected void Software()
{
BL_PERSONAL obj = new BL_PERSONAL();
DataTable dtResultado = new DataTable();
CheckSoftware.DataSource = obj.ListarParametros("SOFTWARE", "ASIGNACION_DETALLE");
CheckSoftware.DataTextField = "DES_ASUNTO";
CheckSoftware.DataValueField = "ID_PARAMETRO";
CheckSoftware.DataBind();
}