public void EliminarChofer(E_autobuses chofer)
{
SqlCommand cmd = new SqlCommand("SP_ELIMINARAUTOBUS", conexion);
cmd.CommandType = CommandType.StoredProcedure;
conexion.Open();
cmd.Parameters.AddWithValue("@ID", chofer.ID);
cmd.ExecuteNonQuery();
conexion.Close();
}
public void insertarChofer(E_autobuses chofer)
{
SqlCommand cmd = new SqlCommand("SP_GUARDARAUTOBUS", conexion);
cmd.CommandType = CommandType.StoredProcedure;
conexion.Open();
cmd.Parameters.AddWithValue("@IDCHOFER", chofer.IDCHOFER);
cmd.Parameters.AddWithValue("@MARCA", chofer.MARCA);
cmd.Parameters.AddWithValue("@MODELO", chofer.MODELO);
cmd.Parameters.AddWithValue("@PLACA", chofer.PLACA);
cmd.Parameters.AddWithValue("@COLOR", chofer.COLOR);
cmd.Parameters.AddWithValue("@ANO", chofer.ANO);
cmd.ExecuteNonQuery();
conexion.Close();
}
public void EditandoCategoria(E_autobuses choferes)
{
objDato.EditarChofer(choferes);
}
public void EliminandoCategoria(E_autobuses choferes)
{
objDato.EliminarChofer(choferes);
}
public void InsertandoCategoria(E_autobuses choferes)
{
objDato.insertarChofer(choferes);
}
