private BindingSource llenarComboTO()
{
Clases.C_Telemarketing tele = new Clases.C_Telemarketing();
DataTable table = new DataTable();
table.Columns.Add("id");
table.Columns.Add("nomnbre");
table.Columns.Add("apellido");
foreach (var item in tele.listarTelemarketing())
{
DataRow row = table.NewRow();
row[0] = item.id_telemarketing;
row[1] = item.nombre;
row[2] = item.codigo;
table.Rows.Add(row);
}
DataRowCollection rows = table.Rows;
object[] cell;
Dictionary <int, string> dic = new Dictionary <int, string>();
BindingSource binding = new BindingSource();
foreach (DataRow item in rows)
{
cell = item.ItemArray;
dic.Add(Convert.ToInt32(cell[0]), cell[2].ToString());
cell = null;
}
binding.DataSource = dic;
return(binding);
}
public List <C_Telemarketing> listarTelemarketing()
{
List <C_Telemarketing> telemarketing = new List <C_Telemarketing>();
if (con == null)
{
con = new conexion();
}
con.conectar();
SqlCommand cmd = new SqlCommand("_sp_listarTelemarketing", con.cnxn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
C_Telemarketing tele = new C_Telemarketing();
tele.id_telemarketing = dr.GetInt32(0);
tele.doc_iden = dr.GetString(1).Trim(new char[] { ' ' });
tele.nombre = dr.GetString(2).Trim(new char[] { ' ' });
tele.apellido = dr.GetString(3).Trim(new char[] { ' ' });
tele.telefono = dr.GetString(4).Trim(new char[] { ' ' });
tele.correo = dr.GetString(5).Trim(new char[] { ' ' });
tele.C_TipoDocumento = new C_TipoDocumento();
tele.C_TipoDocumento.descripcion = dr.GetString(6).Trim(new char[] { ' ' });
tele.id_td = dr.GetInt32(7);
tele.codigo = dr.GetString(8).Trim(new char[] { ' ' });
telemarketing.Add(tele);
}
}
con.desconectar();
return(telemarketing);
}