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(); } }