public void eliminartipoProveeduria(Proveeduria prove)
{
string query;
query = "delete from tipoProveedurias where idtipoProveeduria = '" + prove.IdProveeduria + "' ";
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
try
{
databaseConnection.Open();
MySqlDataReader myReader = commandDatabase.ExecuteReader();
commandDatabase.CommandTimeout = 60;
MessageBox.Show("Proveedor eliminado");
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Hubo un error:" + ex.StackTrace);
databaseConnection.Close();
}
finally
{
databaseConnection.Close();
}
}
public void altatipoProveeduria(Proveeduria prove)
{
string query;
query = "Insert into tipoProveedurias values(" +
"'" + prove.IdProveeduria + "','" + prove.TipoProveeduria + "')";
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
try
{
databaseConnection.Open();
MySqlDataReader myReader = commandDatabase.ExecuteReader();
commandDatabase.CommandTimeout = 60;
MessageBox.Show("Proveedoria dado de alta");
databaseConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Hubo un error:" + ex.StackTrace);
databaseConnection.Close();
}
finally
{
databaseConnection.Close();
}
}
