private void pedirTurnosToolStripMenuItem_Click(object sender, EventArgs e)
{
ConnectorClass con = ConnectorClass.Instance;
String validacion2 = "select r.ROL_NOMBRE from BUGDEVELOPING.ROL r, BUGDEVELOPING.USUARIO_ROL ur, BUGDEVELOPING.USUARIO u where u.USUARIO_USERNAME = '******' and u.USUARIO_ID = ur.USUARIO_ID and r.ROL_ID = ur.ROL_ID";
DataTable data2 = new DataTable();
data2 = con.executeQuery(validacion2);
if (data2.Rows[0][0].ToString() == "Administrador del Sistema")
{
Clinica_Frba.Pedir_Turno.PedidoDeTurno ventanaPedirTurno = new Clinica_Frba.Pedir_Turno.PedidoDeTurno();
ventanaPedirTurno.Show();
this.Hide();
}
if (data2.Rows[0][0].ToString() == "Afiliado")
{
String pattern = "SELECT PA_NAFILIADO FROM BUGDEVELOPING.PERSONA JOIN BUGDEVELOPING.PACIENTE ON (PE_ID = PA_PERSONA) WHERE PE_USUARIO_ID = {0}";
String query = String.Format(pattern, userId);
System.Diagnostics.Debug.WriteLine(query);
Clinica_Frba.Pedir_Turno.PedidoDeTurno ventanaPedirTurno = new Clinica_Frba.Pedir_Turno.PedidoDeTurno((long)con.executeQueryEscalar(query));
ventanaPedirTurno.Show();
this.Hide();
}
}
private void pedirTurnosToolStripMenuItem_Click(object sender, EventArgs e)
{
ConnectorClass con = ConnectorClass.Instance;
String validacion2 = "select r.ROL_NOMBRE from BUGDEVELOPING.ROL r, BUGDEVELOPING.USUARIO_ROL ur, BUGDEVELOPING.USUARIO u where u.USUARIO_USERNAME = '******' and u.USUARIO_ID = ur.USUARIO_ID and r.ROL_ID = ur.ROL_ID";
DataTable data2 = new DataTable();
data2 = con.executeQuery(validacion2);
if (data2.Rows[0][0].ToString() == "Administrador del Sistema")
{
Clinica_Frba.Pedir_Turno.PedidoDeTurno ventanaPedirTurno = new Clinica_Frba.Pedir_Turno.PedidoDeTurno();
ventanaPedirTurno.Show();
this.Hide();
}
if (data2.Rows[0][0].ToString() == "Afiliado")
{
String pattern = "SELECT PA_NAFILIADO FROM BUGDEVELOPING.PERSONA JOIN BUGDEVELOPING.PACIENTE ON (PE_ID = PA_PERSONA) WHERE PE_USUARIO_ID = {0}";
String query = String.Format(pattern, userId);
System.Diagnostics.Debug.WriteLine(query);
Clinica_Frba.Pedir_Turno.PedidoDeTurno ventanaPedirTurno = new Clinica_Frba.Pedir_Turno.PedidoDeTurno((long)con.executeQueryEscalar(query));
ventanaPedirTurno.Show();
this.Hide();
}
}
