/*************************************************************************************************************************************************************/
/*************************************************************************************************************************************************************/
/*************************************************************************************************************************************************************/
public Form_event(Connector conn, Form_main formMain, String directorshipName, string eventCreator)
{
InitializeComponent();
this.conn = conn;
this.formMain = formMain;
this.eventCreator = eventCreator;
this.SelectedItems = true;
clearRegistryForm();
toolTip.SetToolTip(btnBorrarCampos, "Borrar Campos");
toolTip.SetToolTip(btnRegistro, "Registrar Evento");
toolTip.SetToolTip(btnConsulta, "Consultar Evento");
this.directorshipName = directorshipName;
if (directorshipName == "CONSEJERO")
{
btnRegistro.Visible = false;
btnConsulta.Location = new Point(250, 4);
}
fillComboBox(this.cmbTipoC, "select * from [SACMEDB].[dbo].[eventType]", "name");
fillComboBox(this.cmbTipoR, "select * from [SACMEDB].[dbo].[eventType]", "name");
fillComboBox(this.cmbRamaEncargadaR, "select * from [SACMEDB].[dbo].[branch]", "name");
}
public Form_modifyEvent(string idEvento, Form_main formMain, Form_event formEvent, SqlDataReader DR, Connector conn)
{
InitializeComponent();
this.idEvento = idEvento;
this.formMain = formMain;
this.formEvent = formEvent;
this.DR = DR;
this.conn = conn;
this.sqlString = null;
this.eventoBase = new ArrayList();
this.eventoForm = new ArrayList();
if (idEvento.Length > 0)
{
sqlString = "select * from SACMEDB.dbo.event where id = '" + idEvento + "'";
fillArrayList(eventoBase, sqlString);
sqlString = "SELECT [id] as 'ID', [name] as 'NOMBRE DE EVENTO',[description] as 'DESCRIPCION',(SELECT SACMEDB.dbo.users.name + ' ' + SACMEDB.dbo.users.lastname from SACMEDB.dbo.users where id = responsible) as 'RESPONSABLE',[duration] as 'DURACION',[start] as 'FECHA DE INICIO',(select name from [SACMEDB].[dbo].[eventType] where id=eventTypeId) as 'TIPO DE EVENTO',(select name from [SACMEDB].[dbo].[branch] where id=branchId) as 'RAMA ENCARGADA',[created] as 'FECHA DE CREACION',(SELECT SACMEDB.dbo.users.name + ' ' + SACMEDB.dbo.users.lastname from SACMEDB.dbo.users where id = createdBy) as 'CREADO POR' FROM [SACMEDB].[dbo].[event] where id = '" + idEvento + "'";
fillArrayList(eventoForm, sqlString);
SqlManager.executeQuery("delete from organizersTmp", conn);
sqlString = "INSERT INTO [SACMEDB].[dbo].[organizersTmp]([name],[institution]) select name,institution from [SACMEDB].[dbo].[organizers] where id = any (select organizerId from [SACMEDB].[dbo].[eventOrganizer] where eventOrganizer.eventId = '" + idEvento + "')";
SqlManager.executeQuery(sqlString, conn);
SqlManager.executeQuery("delete from usersTmp", conn);
sqlString = "INSERT INTO [SACMEDB].[dbo].[usersTmp] select * from [SACMEDB].[dbo].[users] where id = any(select userId from eventParticipant where eventId = '" + idEvento + "')";
SqlManager.executeQuery(sqlString, conn);
actualizarDataGrids();
/*
* 0)id___________________int
* 1)nombre
* 2)descripcion
* 3)encargado
* 4)duracion
* 5)fecha de inicio______date
* 6)tipo de evento_______int
* 7)id de rama___________int
* 8)fecha de creacion____date
* 9)creado por
*/
this.txtNombreM.Text = eventoForm[1].ToString();
this.txtDescripcionM.Text = eventoForm[2].ToString();
this.txtEncargadoM.Text = eventoForm[3].ToString();
this.txtDuracionM.Text = eventoForm[4].ToString();
this.dateFechaInicioM.Text = eventoForm[5].ToString(); fechaInicioOriginal = eventoForm[5].ToString();
this.txtTipoM.Text = eventoForm[6].ToString();
this.txtRamaEncargadaM.Text = eventoForm[7].ToString();
}
}
public Form_genericAddRemove(Connector conn, string titulo, string sqlStringAdd, string sqlStringRemove, UltraComboEditor comboBox, UltraComboEditor idParticipants, Form_main formMain, Form_modifyEvent formModify, bool b)
{
InitializeComponent();
this.Text = titulo;
this.conn = conn;
this.sqlStringAdd = sqlStringAdd;
this.sqlStringRemove = sqlStringRemove;
this.comboBox = comboBox;
this.idParticipants = idParticipants;
this.formMain = formMain;
this.formModify = formModify;
this.b = b;
formMain.Enabled = false;
}
private void ultraButton_Ingresar_Click(object sender, EventArgs e)
{
usuario = ultraTextEditor_Usuario.Text;
contrasenia = ultraTextEditor_Contrasenia.Text;
if (ultraCheckEditor_PrimeraVez.Checked)
{
DirectorioEspol.directorioEspolSoapClient wservice = new DirectorioEspol.directorioEspolSoapClient();
if (wservice.autenticacion(usuario, contrasenia))
{
MessageBox.Show("Es un usuario espol");
}
else
{
MessageBox.Show("NO ES, vayase");
}
}
Form_main formmain = new Form_main(this, sacmeDbConn);
this.Hide();
formmain.Show();
}
private void ultraButton_Guardar_Click(object sender, EventArgs e)
{
pass = ultraTextEditor_Contrasenia.Text;
confirPass = ultraTextEditor_ConfirmContrasenia.Text;
if (pass == "" || confirPass == "")
{
MessageBox.Show("Ingrese correctamente los valores correspondientes");
}
else if (pass != confirPass)
{
MessageBox.Show("Contraseñas no coinciden");
}
else
{
this.query = "UPDATE users SET password='******' WHERE username='******';";
if (SqlManager.executeQuery(query, conn))
{
Form_main formmain = new Form_main(ini, conn, user);
this.Hide();
formmain.Show();
}
}
}
private void ultraButton_Ingresar_Click(object sender, EventArgs e)
{
int flag = 0;
String query = "";
SqlDataReader user = null;
Form_usersPassword fm;
this.usuario = ultraTextEditor_Usuario.Text;
this.contrasenia = ultraTextEditor_Contrasenia.Text;
if (this.usuario == "" || this.contrasenia == "")
{
MessageBox.Show("Ingrese correctamente sus datos");
}
else
{
query = "SELECT id FROM users WHERE username='******';";
user = SqlManager.getQuery(query, sacmeDbConn);
if (!user.HasRows)
{
MessageBox.Show("Ud no pertenece al Sistema");
user.Close();
}
else
{
user.Close();
if (ultraCheckEditor_PrimeraVez.Checked)
{
DirectorioEspol.directorioEspolSoapClient wservice = new DirectorioEspol.directorioEspolSoapClient();
if (wservice.autenticacion(usuario, contrasenia))
{
flag = 1;
}
else
{
MessageBox.Show("Ud no pertenece a la ESPOL, no podrá ingresar a SACME");
}
}
else
{
query = "SELECT id FROM users WHERE username='******' AND password='******';";
user = SqlManager.getQuery(query, sacmeDbConn);
if (!user.HasRows)
{
MessageBox.Show("El usuario o contraseña es inválido. Intente nuevamente");
user.Close();
}
else
{
user.Close();
Form_main formmain = new Form_main(this, sacmeDbConn, this.usuario);
this.Hide();
formmain.Show();
}
user.Close();
}
if (flag == 1)
{
fm = new Form_usersPassword(ultraTextEditor_Usuario.Text, sacmeDbConn, this);
this.Hide();
fm.Show();
}
}
}
}