public InfoCoche(ConectorSQLite conector, string bastidor)
{
InitializeComponent();
SQLiteCommand consulta = conector.DameComando();
SQLiteDataReader reader;
consulta.CommandText = "SELECT * FROM Coche WHERE N_Bastidor='" + bastidor + "'";
reader = consulta.ExecuteReader();
while (reader.Read())
{
txtBastidor.Text = reader.GetString(0);
txtMarca.Text = reader.GetString(1);
txtModelo.Text = reader.GetString(2);
txtMotor.Text = reader.GetString(3);
txtCV.Text = reader.GetInt16(4).ToString();
txtTipo.Text = reader.GetString(5);
txtColor.Text = reader.GetString(6);
txtPrecio.Text = reader.GetFloat(7).ToString();
try
{
byte[] imageBytes = (System.Byte[])reader["Img"];
MemoryStream ms = new MemoryStream(imageBytes);
pImagen.Image = Image.FromStream(ms, true);
}
catch (Exception ex)
{ }
}
reader.Close();
}
public TablaVentas(ConectorSQLite con)
{
conector = con;
InitializeComponent();
string sql;
sql = "SELECT * FROM Venta";
iniciar_datagrid(sql);
}
public TablaCoches(ConectorSQLite con)
{
conector = con;
InitializeComponent();
string sql;
sql = "SELECT * FROM Coche";
iniciar_datagrid(sql);
TablaVentas = new TablaVentas();
TablaRevisiones = new TablaRevisiones();
}
public FormMain()
{
InitializeComponent();
con = new ConectorSQLite();
tablaCoches = this.iniciar_coches();
tablaVentas = this.iniciar_ventas();
tablaRevisiones = this.iniciar_revisiones();
tablaClientes = this.iniciar_clientes();
rellenarComboMarcas();
ventana_informe = new FormInforme();
//Abro la tabla de los coches cuando inicio el programa
this.abrir_hijo(0);
}
public void rellenarComboDni()
{
ConectorSQLite conector = new ConectorSQLite();
SQLiteCommand consulta3 = conector.DameComando();
consulta3.CommandText = "SELECT Dni FROM Cliente";
SQLiteDataReader reader2 = consulta3.ExecuteReader();
this.autoComplete2.Clear();
while (reader2.Read())
{
autoComplete2.Add(reader2.GetString(0));
}
reader2.Close();
}
public void rellenarComboBastidor()
{
ConectorSQLite conector = new ConectorSQLite();
SQLiteCommand consulta2 = conector.DameComando();
consulta2.CommandText = "SELECT N_Bastidor FROM Coche";
SQLiteDataReader reader = consulta2.ExecuteReader();
this.autoComplete.Clear();
while (reader.Read())
{
this.autoComplete.Add(reader.GetString(0));
}
reader.Close();
}
private void dataGridView1_CellEndEdit_1(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.CurrentRow.Cells[0].Value.ToString() != "")
{
string bastidor = dataGridView1.CurrentRow.Cells[0].Value.ToString();
ConectorSQLite c = new ConectorSQLite();
SQLiteCommand consulta = c.DameComando();
consulta.CommandText = "SELECT Precio FROM Coche WHERE N_Bastidor = '" + bastidor + "'";
SQLiteDataReader reader = consulta.ExecuteReader();
while (reader.Read())
{
dataGridView1.CurrentRow.Cells[3].Value = reader.GetFloat(0).ToString();
}
reader.Close();
}
}
public InfoVenta(ConectorSQLite conector, string bastidor, string dni)
{
InitializeComponent();
SQLiteCommand consulta = conector.DameComando();
SQLiteDataReader reader;
consulta.CommandText = "SELECT * FROM Venta WHERE N_Bastidor='" + bastidor + "' AND Dni='" + dni + "'";
reader = consulta.ExecuteReader();
while (reader.Read())
{
txtCoche.Text = reader.GetString(0);
txtCliente.Text = reader.GetString(1);
txtFecha.Text = reader.GetString(2);
txtPrecio.Text = reader.GetFloat(3).ToString();
}
reader.Close();
}
public InfoCliente(ConectorSQLite conector, string dni)
{
InitializeComponent();
SQLiteCommand consulta = conector.DameComando();
SQLiteDataReader reader;
consulta.CommandText = "SELECT * FROM Cliente WHERE Dni='" + dni + "'";
reader = consulta.ExecuteReader();
while (reader.Read())
{
txtDni.Text = reader.GetString(0);
txtNombre.Text = reader.GetString(1);
txtApellidos.Text = reader.GetString(2);
txtTelefono.Text = reader.GetString(3);
txtDireccion.Text = reader.GetString(4);
}
reader.Close();
}
public InfoRevision(ConectorSQLite conector, object id)
{
InitializeComponent();
int nrevision = Convert.ToInt16(id);
string frenos = null;
string aceite = null;
string filtro = null;
SQLiteCommand consulta = conector.DameComando();
SQLiteDataReader reader;
consulta.CommandText = "SELECT * FROM Revision WHERE N_Revision=" + nrevision;
reader = consulta.ExecuteReader();
while (reader.Read())
{
txtId.Text = reader.GetInt16(0).ToString();
txtFecha.Text = reader.GetString(1);
frenos = reader.GetString(2);
aceite = reader.GetString(3);
filtro = reader.GetString(4);
txtBastidor.Text = reader.GetString(5);
}
reader.Close();
if (frenos == "Sí")
{
chkFrenos.Checked = true;
}
else
{
chkFrenos.Checked = false;
}
if (aceite == "Sí")
{
chkAceite.Checked = true;
}
else
{
chkAceite.Checked = false;
}
if (filtro == "Sí")
{
chkFiltro.Checked = true;
}
else
{
chkFiltro.Checked = false;
}
string bastidor = txtBastidor.Text;
SQLiteCommand consulta2 = conector.DameComando();
SQLiteDataReader reader2;
consulta2.CommandText = "SELECT Marca, Modelo FROM Coche WHERE N_Bastidor='" + bastidor + "'";
reader2 = consulta2.ExecuteReader();
while (reader2.Read())
{
txtMarca.Text = reader2.GetString(0);
txtModelo.Text = reader2.GetString(1);
}
reader2.Close();
}
