Ejemplo n.º 1
0
        public bool Input(IGenericObject obj)
        {
            if (obj.IsComplex)
            {
                try
                {
                    var query = "INSERT INTO " + obj.GetTableName() + " " + obj.GetInsertColumns() + " VALUES " + obj.GetInsertValues();
                    _command = new OleDbCommand(query, _connection, _transaction);
                    _command.ExecuteNonQuery();

                    foreach (var childObj in obj.ChildObjects)
                    {
                        var query2 = "INSERT INTO " + childObj.GetTableName() + " " + childObj.GetInsertColumns() + " VALUES " + childObj.GetInsertValues();
                        _command = new OleDbCommand(query2, _connection, _transaction);
                        _command.ExecuteNonQuery();
                    }

                    return(true);
                }
                catch
                {
                    return(false);
                }
            }
            try
            {
                var query = "INSERT INTO " + obj.GetTableName() + " " + obj.GetInsertColumns() + " VALUES " + obj.GetInsertValues();
                _command = new OleDbCommand(query, _connection, _transaction);
                _command.ExecuteNonQuery();
                return(true);
            }
            catch
            {
                return(false);
            }
        }