public void InsertarAdminCentro(string nombre, string apellido, int cedula, string nombreCentro, string contrasena)
{
SqlConnection cn = new SqlConnection(conexion.conexion());
SqlCommand command = new SqlCommand("actualizarOInsertarADMINCENTRO", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Nombre", SqlDbType.VarChar, 50).Value = nombre;
command.Parameters.Add("@Apellido", SqlDbType.VarChar, 50).Value = apellido;
command.Parameters.Add("@Cedula", SqlDbType.Int).Value = cedula;
command.Parameters.Add("@Contrasena", SqlDbType.Int).Value = contrasena;
command.Parameters.Add("@NombreCentro", SqlDbType.VarChar, 50).Value = nombreCentro;
cn.Open();
try
{
command.ExecuteNonQuery();
cn.Open();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
cn.Close();
}
}
public DataTable MostrarCentros()
{
DataTable Paciente = new DataTable();
SqlConnection cn = new SqlConnection(con.conexion());
SqlCommand command = new SqlCommand("MostrarCentros", cn);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ejecutar = new SqlDataAdapter(command);
cn.Open();
try
{
command.ExecuteNonQuery();
ejecutar.Fill(Paciente);
cn.Close();
return(Paciente);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
cn.Close();
}
}
public DataTable MostrarPaciente(int cedula, string nombreEps)
{
DataTable Paciente = new DataTable();
SqlConnection cn = new SqlConnection(con.conexion());
SqlCommand command = new SqlCommand("MostrarPacienteXCedula", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@cedula", SqlDbType.Int).Value = cedula;
command.Parameters.Add("@nombreEps", SqlDbType.VarChar, 50).Value = nombreEps;
SqlDataAdapter ejecutar = new SqlDataAdapter(command);
cn.Open();
command.ExecuteNonQuery();
ejecutar.Fill(Paciente);
cn.Close();
return(Paciente);
}
public DataTable ObtenerInfoCita(string nombre)
{
SqlConnection cn = new SqlConnection(con.conexion());
DataTable Paciente = new DataTable();
SqlCommand command = new SqlCommand("ObtenerCitas", cn);
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add("@cedula", SqlDbType.Int).Value = cedula;
command.Parameters.Add("@nombreCentro", SqlDbType.VarChar, 50).Value = nombre;
SqlDataAdapter ejecutar = new SqlDataAdapter(command);
cn.Open();
command.ExecuteNonQuery();
ejecutar.Fill(Paciente);
cn.Close();
return(Paciente);
}
public bool ValidarMedico(int usuario, string contrasena)
{
bool Paciente = false;
SqlConnection cn = new SqlConnection(con.conexion());
SqlCommand command = new SqlCommand("ValidarCMedico", cn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@usuario", SqlDbType.Int).Value = usuario;
command.Parameters.Add("@contrasena", SqlDbType.VarChar, 50).Value = contrasena;
cn.Open();
SqlDataReader reg = null;
try
{
reg = command.ExecuteReader();
if (reg.Read())
{
Paciente = true;
}
else
{
Paciente = false;
}
reg.Close();
cn.Close();
return(Paciente);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
cn.Close();
}
}
