/*************************************************************************************************************************************************************/
private void cmbOrganizadorR_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
sqlStringAdd = "select name as'NOMBRE DE ORGANIZADOR', institution as 'INSTITUCION' from organizers where not exists (select name, institution from organizersTmp where name =SACMEDB.dbo.organizers.name)";
sqlStringRemove = "select name as'NOMBRE DE ORGANIZADOR', institution as 'INSTITUCION' from organizersTmp";
Form_genericAddRemove g = new Form_genericAddRemove(conn, "Agregar/Remover Organizador(es)", sqlStringAdd, sqlStringRemove, this.cmbOrganizadorR, idParticipants, formMain, formModify, true);
g.fillDatagridAgregar();
g.fillDatagridRemover();
g.Show();
}
/*************************************************************************************************************************************************************/
private void cmbParticipantesR_EditorButtonClick(object sender, EditorButtonEventArgs e)
{
sqlStringAdd = "select name + ' ' + lastname as 'NOMBRES',id as 'CEDULA', registrationNumber as 'MATRICULA', emailPersonal as 'CORREO' from users where not exists( select id from usersTmp where id = SACMEDB.dbo.users.id)";
sqlStringRemove = "select name + ' ' + lastname as 'NOMBRES',id as 'CEDULA', registrationNumber as 'MATRICULA', emailPersonal as 'CORREO' from usersTmp";
Form_genericAddRemove g = new Form_genericAddRemove(conn, "Agregar/Remover Participante(s)", sqlStringAdd, sqlStringRemove, this.cmbParticipantesR, idParticipants, formMain, formModify, false);
g.fillDatagridAgregar();
g.fillDatagridRemover();
g.Show();
}
private void btnAgregar_Click(object sender, EventArgs e)
{
this.Enabled = false;
if (this.ultraTabDataGrids.SelectedTab.Index == 0)
{
string sqlStringAdd = "select name as'NOMBRE DE ORGANIZADOR', institution as 'INSTITUCION' from organizers where not exists (select name, institution from organizersTmp where name =SACMEDB.dbo.organizers.name)";
string sqlStringRemove = "select name as'NOMBRE DE ORGANIZADOR', institution as 'INSTITUCION' from organizersTmp";
UltraComboEditor u = new UltraComboEditor();
Form_genericAddRemove g = new Form_genericAddRemove(conn, "Agregar/Remover Organizador(es)", sqlStringAdd, sqlStringRemove, cmbOrganizadoresM, cmbIdParticipantesM, formMain, this, true);
g.fillDatagridAgregar();
g.fillDatagridRemover();
g.Show();
}
else if (this.ultraTabDataGrids.SelectedTab.Index == 1)
{
string sqlStringAdd = "select name + ' ' + lastname as 'NOMBRES',id as 'CEDULA', registrationNumber as 'MATRICULA', emailPersonal as 'CORREO' from users where not exists( select id from usersTmp where id = SACMEDB.dbo.users.id)";
string sqlStringRemove = "select name + ' ' + lastname as 'NOMBRES',id as 'CEDULA', registrationNumber as 'MATRICULA', emailPersonal as 'CORREO' from usersTmp";
UltraComboEditor u = new UltraComboEditor();
Form_genericAddRemove g = new Form_genericAddRemove(conn, "Agregar/Remover Participante(s)", sqlStringAdd, sqlStringRemove, cmbParticipantesM, cmbIdParticipantesM, formMain, this, false);
g.fillDatagridAgregar();
g.fillDatagridRemover();
g.Show();
}
}
