protected void cmbKAM_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
#region Desbloqueos y más
if (cmbKAM.Text.Equals(String.Empty) || cmbKAM.SelectedValue.Equals(String.Empty))
{
RadAjaxManager1.ResponseScripts.Add(String.Format("alert('Seleccion invalida, seleccione un KAM de la lista.');"));
btEditar.Enabled = false;
return;
}
btEditar.Enabled = true;
lbxCuentasFuente.Items.Clear();
lbxCuentasDestino.Items.Clear();
#endregion
valoresInicio = new List<string>();
Connection conexion = new Connection();
string query = String.Format("SELECT KAM_NAME, KAM_MAIL, KAM_ACTIVE, RECEIVE_MAIL FROM KAM WHERE KAM_ID = '{0}'", cmbKAM.SelectedValue);
DataTable Kaminfo = conexion.getGridDataSource(query);
//Carga los controles con la info del KAM devuleta por el query
txtNombreKAM.Text = Kaminfo.Rows[0]["KAM_NAME"].ToString();
txtCorreo.Text = Kaminfo.Rows[0]["KAM_MAIL"].ToString();
chkHabilitarKam.Checked = Convert.ToBoolean(Kaminfo.Rows[0]["KAM_ACTIVE"].ToString());
chkHabilitarCorreo.Checked = Convert.ToBoolean(Kaminfo.Rows[0]["RECEIVE_MAIL"].ToString());
cargarCuentasDisponibles(conexion);
query = String.Format("SELECT CK.CLIENT_ID, CK.CLIENT_NAME FROM CLIENTES_KC AS CK JOIN CUENTAS_KAM AS C ON CK.CLIENT_ID = C.CLIENT_ID WHERE C.KAM_ID = '{0}'",
cmbKAM.SelectedValue);
Kaminfo = conexion.getGridDataSource(query);
foreach (DataRow fila in Kaminfo.Rows)
{
RadListBoxItem item = new RadListBoxItem();
valoresInicio.Add(fila["CLIENT_ID"].ToString());
item.Text = fila["CLIENT_NAME"].ToString();
item.Value = fila["CLIENT_ID"].ToString();
item.DataBind();
lbxCuentasDestino.Items.Add(item);
}
}
catch (Exception error)
{
RadAjaxManager1.ResponseScripts.Add(String.Format("errorEnvio('{0}');", error.Message));
}
}
private void cargarCuentasDisponibles(Connection conexion)
{
try
{
string query = String.Format("select ckc.CLIENT_ID, ckc.CLIENT_NAME from CLIENTES_KC as ckc where ckc.COUNTRY = '{0}' and ckc.DIRECT_CUSTOMER = 0 and 0 = (select COUNT(ck.KAM_ID) from CUENTAS_KAM as ck where ck.CLIENT_ID = ckc.CLIENT_ID)",
conexion.getUserCountry(Session.Contents["userid"].ToString()));
DataTable resultset = conexion.getGridDataSource(query);
foreach (DataRow fila in resultset.Rows)
{
RadListBoxItem item = new RadListBoxItem();
item.Text = fila["CLIENT_NAME"].ToString();
item.Value = fila["CLIENT_ID"].ToString();
item.DataBind();
lbxCuentasFuente.Items.Add(item);
}
}
catch (Exception error)
{
RadAjaxManager1.ResponseScripts.Add(String.Format("errorEnvio('{0}');", error.Message));
}
}