public DataTable Mostrar()
{
comando.Connection = conexion.AbrirConexion();
comando.CommandText = "MostrarConductores";
comando.CommandType = CommandType.StoredProcedure;
leer = comando.ExecuteReader();
tabla.Load(leer);
conexion.CerrarConexion();
return(tabla);
}
public void insertar(/*string placa, int color, int marca, int capacidad, string caracteristicas*/)
{
SqlCommand comando = new SqlCommand("insertarBus", conexion.AbrirConexion());
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@placa", this.placa);
comando.Parameters.AddWithValue("@color", this.color);
comando.Parameters.AddWithValue("@marca", this.marca);
comando.Parameters.AddWithValue("@capacidad", this.capacidad);
comando.Parameters.AddWithValue("@caracteristicas", this.caracteristicas);
comando.ExecuteNonQuery();
comando.Parameters.Clear();
}
public List <CDCargos> mostrar()
{
List <CDCargos> leer2 = new List <CDCargos>();
SqlCommand comando = new SqlCommand("psMostrarCargos", conexion.AbrirConexion());
comando.CommandType = CommandType.StoredProcedure;
//comando.Parameters.AddWithValue("@var", this.var1);
//comando.Parameters.AddWithValue("@var2", this.var2);
//Si se desea insertar, modificar o eliminar cambiar la siguiente linea
//por comando.ExecuteQuery()
leer = comando.ExecuteReader();
comando.Parameters.Clear();
CDCargos crg;
while (leer.Read())
{
crg = new CDCargos();
crg.Id = leer.GetInt32(0);
crg.Cargo = leer.GetString(1);
leer2.Add(crg);
}
return(leer2);
}
public void cargarColor(ComboBox comboBox1)
{
comboBox1.ToString();
CDConexion conexion = new CDConexion();
DataTable dt = new DataTable();
using (conexion.AbrirConexion())
{
string query = "select * from coloresBuses order by color";
SqlCommand cmd = new SqlCommand(query, conexion.AbrirConexion());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
comboBox1.DisplayMember = "color";
comboBox1.ValueMember = "id";
comboBox1.DataSource = dt;
conexion.CerrarConexion();
}
public SqlDataReader logearse()
{
SqlCommand comando = new SqlCommand("logearse", conexion.AbrirConexion());
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@email", this.email);
comando.Parameters.AddWithValue("@pass", this.contrasenia);
leer = comando.ExecuteReader();
comando.Parameters.Clear();
return(leer);
}