private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
modificar_button.Enabled = true;
guardar_button.Enabled = false;
generar_codigo_button.Enabled = false;
foreach (DataGridViewRow row in this.dataGridView1.SelectedRows)
{
Codigos_generados cust = row.DataBoundItem as Codigos_generados;
if (cust != null)
{
codigoActual.codigo = cust.codigo;
codigoActual.descripcion = cust.descripcion;
codigoActual.ruta = cust.ruta;
}
}
}
public void InsertCodigoGenerado(Codigos_generados codigo)
{
SqlCeConnection conn = null;
try
{
conn = new SqlCeConnection(@"Data Source=|DataDirectory|\DB\DB_local.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO codigosGenerados ([codigo],[descripcion],[ruta]) Values('" + codigo.codigo + "','" + codigo.descripcion + "','" + codigo.ruta + "')";
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
public void ModificarCodigo(Codigos_generados codigo)
{
SqlCeConnection conn = null;
try
{
conn = new SqlCeConnection(@"Data Source=|DataDirectory|\DB\DB_local.sdf");
conn.Open();
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE codigosGenerados SET descripcion='" + codigo.descripcion + "' WHERE codigo ='" + codigo.codigo + "'";
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
public Codigos_generados GetCodigo(Codigos_generados temp)
{
Codigos_generados codigo = new Codigos_generados();
SqlCeConnection conn = new SqlCeConnection(@"Data Source=|DataDirectory|\DB\DB_local.sdf");
conn.Open();
//commands represent a query or a stored procedure
SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM codigosGenerados WHERE codigo='" + temp.codigo + "' AND descripcion='" + temp.descripcion + "';";
SqlCeDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
codigo = new Codigos_generados(
reader["codigo"].ToString(),
reader["descripcion"].ToString(),
reader["ruta"].ToString());
}
return(codigo);
}
